Page 1 of 2
500 Error - Could not process your request. Please contact support.
Posted: Wed May 05, 2021 2:07 am
by Alantod17
Hi
We are using API to integrate our product with SimPro. but start from 3rd May 2021. we keep receive 500 errors for one of our client but not others .
We are using following endpoint with header "If-Modified-Since"
"companies/{companyId}/vendorOrders/?pageSize=250&page{page}&columns=ID,Type,Stage,Status,AssignedTo,DateIssued,Vendor,Totals,DateModified"
The Full error message as following
System.Exception: StatusCode: 500, ReasonPhrase: 'Internal Server Error', Version: 1.1, Content: System.Net.Http.StreamContent, Headers:
{
Strict-Transport-Security: max-age=15768000; includeSubdomains
Access-Control-Allow-Origin: *
Link:
Connection: close
Transfer-Encoding: chunked
Date: Wed, 05 May 2021 01:46:31 GMT
Server: lighttpd
Content-Type: application/json; charset=utf-8
}|||{"errors":[{"path":null,"message":"Could not process your request. Please contact support.","value":null}]}
The client has the pronlem is
https://melrayelectric.simprosuite.com
the client work fine is
https://feisst.simprosuite.com
above clients sharing same code base and hosting instanse. only difference is the api configuration info such as client id, secret etc.
Please help
Re: 500 Error - Could not process your request. Please contact support.
Posted: Wed May 05, 2021 2:17 am
by Muqeet
The recent issue has been resolved from our end, please let us know if you are still getting 500 error.
Re: 500 Error - Could not process your request. Please contact support.
Posted: Wed May 05, 2021 3:32 am
by Alantod17
Muqeet wrote: ↑Wed May 05, 2021 2:17 am
The recent issue has been resolved from our end, please let us know if you are still getting 500 error.
Hi Muqeet
We still got 500 error at our end for
https://melrayelectric.simprosuite.com.
https://feisst.simprosuite.com is working fine
Following is the error message we have
StatusCode: 500, ReasonPhrase: 'Internal Server Error', Version: 1.1, Content: System.Net.Http.StreamContent, Headers:
{
Strict-Transport-Security: max-age=15768000; includeSubdomains
Access-Control-Allow-Origin: *
Link:
Connection: close
Transfer-Encoding: chunked
Date: Wed, 05 May 2021 03:29:16 GMT
Server: lighttpd
Content-Type: application/json; charset=utf-8
}|||{"errors":[{"path":null,"message":"Could not process your request. Please contact support.","value":null}]}
Re: 500 Error - Could not process your request. Please contact support.
Posted: Wed May 05, 2021 3:35 am
by Muqeet
I couldn't reproduce the issue on your build with provided endpoint.
Please send me the full endpoint including complete query parameters with request headers (format of the date) in a private message.
Re: 500 Error - Could not process your request. Please contact support.
Posted: Wed May 05, 2021 10:15 pm
by Alantod17
Muqeet wrote: ↑Wed May 05, 2021 3:35 am
I couldn't reproduce the issue on your build with provided endpoint.
Please send me the full endpoint including complete query parameters with request headers (format of the date) in a private message.
Hi following is a postman export for the endpoint test. I removed Token. We have another client running the same request which does not have problem.
{
"info": {
"_postman_id": "4598b557-e8c6-45c5-a4ab-64eaa50c2947",
"name": "Temp",
"schema": "
https://schema.getpostman.com/json/coll ... ction.json"
},
"item": [
{
"name": "
https://melrayelectric.simprosuite.com/ ... ectManager",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "XXX",
"type": "string"
}
]
},
"method": "GET",
"header": [
{
"key": "If-Modified-Since",
"value": "Wed, 05 May 2021 18:29:09 GMT",
"type": "text"
}
],
"url": {
"raw": "
https://melrayelectric.simprosuite.com/ ... ectManager",
"protocol": "https",
"host": [
"melrayelectric",
"simprosuite",
"com"
],
"path": [
"api",
"v1.0",
"companies",
"0",
"jobs",
""
],
"query": [
{
"key": "pageSize",
"value": "250"
},
{
"key": "page",
"value": "1"
},
{
"key": "columns",
"value": "ID,Stage,Site,Status,ProjectManager"
}
]
}
},
"response": []
},
{
"name": "
https://melrayelectric.simprosuite.com/ ... teModified",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "XXX",
"type": "string"
}
]
},
"method": "GET",
"header": [
{
"key": "If-Modified-Since",
"value": "Wed, 05 May 2021 18:29:09 GMT",
"type": "text"
}
],
"url": {
"raw": "
https://melrayelectric.simprosuite.com/ ... teModified",
"protocol": "https",
"host": [
"melrayelectric",
"simprosuite",
"com"
],
"path": [
"api",
"v1.0",
"companies",
"0",
"vendorOrders",
""
],
"query": [
{
"key": "pageSize",
"value": "250"
},
{
"key": "page",
"value": "1"
},
{
"key": "columns",
"value": "ID,Type,Stage,Status,AssignedTo,DateIssued,Vendor,Totals,DateModified"
}
]
}
},
"response": []
}
]
}
Re: 500 Error - Could not process your request. Please contact support.
Posted: Thu May 06, 2021 1:12 am
by robbertcha
Hi Alantod17,
The response seems correct on your last post, but it return empty record as the if-Modified-Since date is newer than all records, We have duplicated your build and set if-Modified-Since as "Wed, 3 May 2021 00:00:00 GMT", it return 65 records
/*** Response Header ***/
access-control-allow-origin: *
content-type: application/json;charset=utf-8
access-control-allow-headers: *
resource-base-uri: /api/v1.0/companies/0/vendorOrders/
result-total: 65
result-pages: 1
result-count: 65
x-response-time: 2235.999ms
content-length: 25193
date: Thu, 06 May 2021 01:00:45 GMT
server: lighttpd
/*** Request Header ***/
Authorization: Bearer xxx
Content-Type: application/json
If-Modified-Since: Wed, 3 May 2021 00:00:00 GMT
Re: 500 Error - Could not process your request. Please contact support.
Posted: Thu May 06, 2021 1:34 am
by Alantod17
robbertcha wrote: ↑Thu May 06, 2021 1:12 am
Hi Alantod17,
The response seems correct on your last post, but it return empty record as the if-Modified-Since date is newer than all records, We have duplicated your build and set if-Modified-Since as "Wed, 3 May 2021 00:00:00 GMT", it return 65 records
/*** Response Header ***/
access-control-allow-origin: *
content-type: application/json;charset=utf-8
access-control-allow-headers: *
resource-base-uri: /api/v1.0/companies/0/vendorOrders/
result-total: 65
result-pages: 1
result-count: 65
x-response-time: 2235.999ms
content-length: 25193
date: Thu, 06 May 2021 01:00:45 GMT
server: lighttpd
/*** Request Header ***/
Authorization: Bearer xxx
Content-Type: application/json
If-Modified-Since: Wed, 3 May 2021 00:00:00 GMT
Hi. I tried with the header you have still not working and "Wed, 3 May 2021 00:00:00 GMT" is not even validte date. 3rd May is Mon. and 500 should not be the code returned when the result set is empty.
I also made a video to demo the problem. pls help
https://www.loom.com/share/7f078faefdcb ... 996ad14dac
Re: 500 Error - Could not process your request. Please contact support.
Posted: Thu May 06, 2021 1:43 am
by robbertcha
Hi Alantod17,
Sorry for my typo, please refer to
https://developer.mozilla.org/en-US/doc ... fied-Since for the date format.
Could you please send us your video link via private message, thank you
Re: 500 Error - Could not process your request. Please contact support.
Posted: Thu May 06, 2021 1:45 am
by Alantod17
Hi I sent the link to you and the link is also in the end of last post I made. cheers
Re: 500 Error - Could not process your request. Please contact support.
Posted: Thu May 06, 2021 1:53 am
by AndyRees
Hi all,
Thanks Alantod17 for raising this issue. To piggy back off this thread, we are encountering the exact same issue.
What seems to be the issue based on our testing is that the error is caused when the If-Modified-Since header is supplied with the request. When omitted, data seems to be returned OK. We have confirmed that we are using the correct syntax for the header, so that is not the problem.
Are we able to get an ETA on when this might be addressed? It's obviously not ideal to have to query the whole data set for each endpoint which it's looking like we might have to do until the issue is resolved.