API Import Error : There was an issue with your file upload: 500

We had to reset index count of a list after which we imported data using Postman into the module.
Airflow DAG for the process which uploads data in the above module/list have been failing since that day when they run for the first time. However, when re-triggered they run without any errors.

What will be the solution for this problem? Please find below the error screenshot.

Thanks in advance

Accepted answers

All comments

andrewtye

Hi @Akshay07 - we've also got the same issue. We have a ticket raised, if you want to link in with @riyazpasha he'll keep you updated.

JaredDolich

@Akshay07

This looks like a Python issue. Are you running a python script in Postman? Anyway, the error seems unrelated to the re-indexing of the list. Maybe if I understood the process better.

To be candid, there are only a small number of exceptions why you should need to re-index a list. Typically, I see this when a list is completely dropped and reloaded (Delete and Insert) often. A more efficient process would be to upsert (UPDATE and INSERT). So, a way you can avoid this error is to prevent having to reindex the list.

Well, just a thought for you. Happy to discuss further if you have more details.

Akshay07

Thanks @andrewtye .

@riyazpasha - Can you please share if you have any updates ?

Akshay07

Hi @JaredDolich ,

We used postman to manually hit an API on the day we reset the index count. The screenshot is from databricks notebook.

riyazpasha

Hi @Akshay07 ,

My issue is some what similar. I'm trying to scrap the model size across the workspace and it use to work but suddenly I'm getting the internal error 500. There are lot of reason for internal 500 error below I have listed it.

Internal 500 error reasons:

Browser Cache.
Incorrect database login credentials.
Corrupted database.
Corrupted files
Issues with your database server.
Corrupted .htaccess file and PHP memory limit.
Issues with third-party plugins and themes.
PHP timing out or fatal PHP errors with third-party plugins.
Wrong file and folder permissions.
Exhausted PHP memory limit on your server
Corrupted or broken .htaccess file.
Errors in CGI and Perl script.

In your case looks like the file is getting uploaded to the Anaplan server but when you are running the action it throws 500 error. Could you please let me know what is the status code for file upload and actions status code?

I have raised the ticket with Support team and they are trying to schedule a call to understand the issue. If I hear anything from them I keep you posted.

Thanks

Akshay07

@riyazpasha

We are getting an error while uploading the file.

Status code for file upload is 500.

ben_speight

Status code 500 can have a whole multitude of different causes - for Anaplan's API it is almost certainly something outside the above list. Does the error occur intermittently (and if so what proportion), or every time? And do the chunk PUTs succeed but the /complete POST fail, or do chunk PUTs fail?

Akshay07

@ben_speight

This has been happening everyday. The chunk puts is failing. We are getting this error while uploading the file and the. When we re-trigger it manually then it works fine.

riyazpasha

Hi @Akshay07 ,

Can I look into your scripts.

Quick Links

Can you help?

Unanswered questions

Can Please explain the difference between a general list,a module,and action in Anaplan.
Can please explain why we create a general list ,a module,and Action ,and what purpose each one serves.🙂
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…