Page 1 of 1

[Intermittent] REST Api - 500 - Internal Server Error

Posted: Wed May 05, 2021 1:17 am
by rob_marklands
Good day,

We have started experiencing an 500 - Internal Server Error returned occasionally from Simpro for various requests, but not every time.

I have sent a private message to Muqeet with the build URL

Example of requests with the return data below:

Code: Select all

<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"
         \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">
 <head>
  <title>500 - Internal Server Error</title>
 </head>
 <body>
  <h1>500 - Internal Server Error</h1>
 </body>
</html>

Examples of requests that sometimes return that error:

Code: Select all


[2021-05-05 07:25:42]
"GET","/api/v1.0/companies/0/quotes/28180?columns=ID,Type,Status,Description,Notes,Customer,Site,Total,Sections&display=all"

[2021-05-05 09:25:24]
"GET","/api/v1.0/companies/0/quotes/28159/sections/31476/costCenters/31507?columns=ID,ItemsLocked"

[2021-05-05 08:53:59]
"POST","/api/v1.0/companies/0/quotes/28155/sections/31472/costCenters/31503/catalogs/multiple/"

[2021-05-05 10:25:17]
"GET","/api/v1.0/companies/0/quotes/28162/sections/31479/costCenters/31510?columns=ID,ItemsLocked"

[2021-05-05 10:51:50]
"GET","/api/v1.0/companies/0/quotes/28160/attachments/files/?columns=ID,Filename,Folder,FileSizeBytes&pageSize=200"


Re: REST Api - 500 - Internal Server Error

Posted: Wed May 05, 2021 2:02 am
by Muqeet
Hello Rob,

The issue has been resolved. Please let us know if you encounter the error again.

Re: REST Api - 500 - Internal Server Error

Posted: Wed May 05, 2021 2:04 am
by rob_marklands
Muqeet wrote: ↑Wed May 05, 2021 2:02 am Hello Rob,

The issue has been resolved. Please let us know if you encounter the error again.
Confirming that the issue is resolved. Thank you for quick response

Re: [Resolved] REST Api - 500 - Internal Server Error

Posted: Tue May 11, 2021 4:58 pm
by sathish
Hi Team,

Again getting 500 Error. Please fix asap & let us know the reason for the error.
simpro_error.png
simpro_error.png (89.47 KiB) Viewed 7735 times
Regards,
Sathish Kumar

Re: [Resolved] REST Api - 500 - Internal Server Error

Posted: Tue May 11, 2021 8:52 pm
by gavynj
I've been getting a lot of 500 errors overnight too. The API requests will sometimes come back ok, but not consistently. Seems to be getting more unstable lately.

Re: [Resolved] REST Api - 500 - Internal Server Error

Posted: Tue May 11, 2021 8:58 pm
by wildhart
I am also getting these 500 Internal Server Errors since yesterday:

Code: Select all

error 500 - "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\"\n \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\" lang=\"en\">\n <head>\n <title>500 - Internal Server Error</title>\n </head>\n <body>\n <h1>500 - Internal Server Error</h1>\n </body>\n</html>\n" { 
uri: 'https://allcleargroup.simprosuite.com/api/v1.0/companies/0/customers/1234/contacts/', 
method: 'GET', 
json: true, 
resolveWithFullResponse: true, 
auth: { bearer: '26a0f5318xxxaac2f7b67' }, 
Plus sometimes, when fetching a page of customers/contacts I receive an incomplete JSON string which can't be parsed. This isn't consistent, happens on random pages, different pages each time:

Code: Select all

not an array! result.body.length 72136 type string https://allcleargroup.simprosuite.com/api/v1.0/companies/0/customers/ { 
pageSize: 100, 
page: 23, 
columns: 'ID,_href,CompanyName,Phone,Email,GivenName,FamilyName,Address,BillingAddress,DateCreated,DateModified,Profile' 
} 
error parsing json 
SyntaxError: Unexpected end of JSON input 
at JSON.parse (<anonymous>) 

Re: [Resolved] REST Api - 500 - Internal Server Error

Posted: Tue May 11, 2021 9:45 pm
by iconone
Is this resolved?

I've been getting intermittent 500 errors on API requests this morning.

Re: [Resolved] REST Api - 500 - Internal Server Error

Posted: Tue May 11, 2021 9:47 pm
by Khurram
Hi SimPRO team,

We are still getting the same error randomly and its affecting our production system.

Can you please provide and ETA when this will be fixed?

Need urgent action on this please ...

Thanks.

Re: [Intermittent] REST Api - 500 - Internal Server Error

Posted: Tue May 11, 2021 11:54 pm
by Muqeet
@all

The issue is intermittent and we are tracking it closely. The api at the moment is stable and you guys would not be getting those 500s for now. Please leave a message here if its not the case for any one of you.