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.