1899340 - Error "... User '<account>' has the row in 'ml_database' locked ..." - SQL Anywhere | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1899340 - Error "... User '<account>' has the row in 'ml_database' locked ..." - SQL Anywhere

Symptom

Issue with a MobiLink installation, where synchronizations are sometimes blocked with the error message "... User 'DBA' has the row in 'ml_database' locked ...". An example for such an error can be found in the following MobiLink server log file.

=== MobiLink log ===
:
I. 2011-12-14 11:31:00. <3> Request from "Dbmlsync 12.0.1.3505" for: remote ID: ed0cde3b-848f-45d7-9da2-4bbb2e46a89f, user name: UserA, version: synctab
W. 2011-12-14 11:31:00. <3> [10050] ODBC: [Sybase][ODBC Driver][SQL Anywhere]User 'DBA' has the row in 'ml_database' locked (ODBC State = 40001, Native error code = -210)
W. 2011-12-14 11:31:00. <3> [10106] Unable to lock the remote ID 'ed0cde3b-848f-45d7-9da2-4bbb2e46a89f', will try again
:


Read ' has the row in 'ml_database' locked ..." - SQL Anywhere">more...

Environment

  • SAP SQL Anywhere - all versions
  • SAP Mobilink

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

interrupted, synchronization, failed, mobilink, ML, error, database, db, locked, user, sync, row, , KBA , BC-SYB-SQA-ML , SQL Anywhere - MobiLink , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.