Sometimes during mobilink synchronization we get the following errors in the log:
W. 2013-09-27 16:00:06. <172>  ODBC: [Sybase][ODBC Driver][SQL Anywhere]User 'DBA' has the row in 'ml_database' locked (ODBC State = 40001, Native error code = -210) W. 2013-09-27 16:00:06. <172>  Unable to lock the remote ID '5ec6af40-1c44-11e3-8000-db904231408e', will try again
After this message the synchronization hangs and the only workaround is to restart ML server. What can cause this and how to get rid of this error?
SA: 18.104.22.16897 Mobilink: 22.214.171.12497 Ultralite client: 126.96.36.19997
asked 26 Nov '13, 07:24
The MobiLink server is reporting that there is a row already locked in the 'ml_database' MobiLink system table, indicating that the lock cannot be obtained in order to allow the current remote ID to synchronize. To the MobiLink server, this means that the older synchronization request is still 'active' and hasn't been timed out yet on the consolidated server.
Are you running multiple MobiLink servers? If a synchronization request arrives on one server, drops the network connection and re-synchronizes on the other MobiLink server before the old request times out, this is an easy way to see this message.
For more information, see SAP KBA #1899340.
answered 26 Nov '13, 11:30