RE: Uploading a Sales Order with 1,700 lines times out

I have a few of SOs with between 1,100 and 1,700 lines, containing a total of a few thousand items. We upload them with the status “Pending Approval”, but when we go to approve them, the approval times out.  After several minutes and we get a generic “Error: An unexpected error occurred”. Occasionally we’ll get a webserver-style “The gateway request timed out”.

I’ve opened a case, but the answers don’t make sense. The initial answer I got was “The limit for a CSV is 5000 lines”, but I’m clearly well under that. When I asked for clarification, I was told “The limit is 5000 lines for uploading, but if you want to approve a big CSV via the web, the limit is really 500″.

They suggested we try and upload the same ~1,700 line CSV with the status “Pending Fulfillment”. When we do that, we get a different error:


Error;int ID;Status

An unexpected SuiteScript error has occurred;5387598;Pending Fulfillment

Any suggestions?

Thanks!

Chris

bitpushr Rookie Asked on December 4, 2019 in Billing.
Add Comment
5 Answers

I’ve done some more work in our sandbox, trying to find the source of the problem. If I upload the .csv with 1 line, it succeeds. 499 lines, succeeds. 501 lines, succeeds. 1001 lines, succeeds.

It fails at 1501 lines, and also fails at 1499 lines. I guess I can try and go back and bracket where the actual problem is, but it’s pretty frustrating given it’s taking ~16 minutes to import (and then fail) on 1499 lines.

Rookie Answered on December 5, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.