500 Error - Could not process your request. Please contact support.

[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

[Muqeet]

The recent issue has been resolved from our end, please let us know if you are still getting 500 error.

[Alantod17]

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}]}

[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.

[Alantod17]

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": []
}
]
}

[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

[Alantod17]

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

[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

[Alantod17]

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

Hi I sent the link to you and the link is also in the end of last post I made. cheers

[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.