Symptom
With a high number of concurrent registrations, SAP Mobile Platform 3.0 returns HTTP 500 errors. Errors in log:
2015 12 03 16:15:56#0-200#ERROR#com.sap.odata.offline.util.NativeLogger###Thread-389####dffc05b8-99e9-11e5-8000-f35315c0c63c####<13375> [-10225] User exception: |
2015 12 03 16:15:56#0-200#ERROR#com.sap.odata.offline.util.NativeLogger###Thread-389####dffc05b8-99e9-11e5-8000-f35315c0c63c####<13375> [-10225] Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 122) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. |
2015 12 03 16:15:56#0-200#ERROR#com.sap.odata.offline.util.NativeLogger###Thread-389####dffc05b8-99e9-11e5-8000-f35315c0c63c####<13375> [-10225] Error Code: 1205 |
2015 12 03 16:15:56#0-200#ERROR#com.sap.odata.offline.util.NativeLogger###Thread-389####dffc05b8-99e9-11e5-8000-f35315c0c63c####<13375> [-10225] Call: SELECT REQUEST_ID, CHANGE_ID, OWNER_ID, BACKEND_DELTA_LINK, CHANGES, RECEIVED, SYNC_TIME FROM ML_CHANGE_LOG WHERE ((((OWNER_ID = ?) AND (REQUEST_ID = ?)) AND (CHANGE_ID <= ?)) AND ((RECEIVED = ?) OR (CHANGE_ID = ?))) ORDER BY OWNER_ID, REQUEST_ID, CHANG |
Read more...
Environment
- SAP Mobile Platform 3.0 SP09 PL04
- SAP Mobile Platform SDK 3.0 SP10 PL07
Product
Keywords
- deadlock
- 500
- load test
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview