Arun,
I believe the issue is related to dbmlsync not being able to obtain the
proper locks for synchronization. To resolve this issue set the
LockTables option to OFF.
MobiLink - Client Administration >
MobiLink SQL Anywhere Client Extended Options
LockTables (lt) extended option
Online:
http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2Fhtml%2Fdbmnen10%2Fmn-mc-syncclient-s-608170621a9.html
--
Joshua Savill
Sybase iAnywhere - Product Manager
arun.nara@gmail.com wrote:
> I started getting the following when I would do a synchronization
> which said it was
> unable to lock tables for synchronization. My synchronization
> had been working fine up to this point (but we did have some
> changes to some hibernate and spring jars.) Do you know what
> causes it to be unable to lock tables?
>
>
> This is the message that I get when there's no -d option put in. For
> some reason, its unable to obtain
> a lock on the table.
>
> I. 2008-09-17 09:08:29. Options in database for subscription to
> 'checkout' for 'aaa':
> I. 2008-09-17 09:08:29. sa=on;
> I. 2008-09-17 09:08:29. Begin synchronizing 'checkout' for MobiLink
> user 'aaa'
> I. 2008-09-17 09:08:29. Options for this synchronization:
> I. 2008-09-17 09:08:29.
> SCN=YES,V=YES,SA=YES,CTP=TCPIP,ADR='host=localhost'
> E. 2008-09-17 09:08:29. Unable to lock tables for synchronization.
> I. 2008-09-17 09:08:29. Complete log scan required.
>
> Version/build number is 10.0.1.3415
>
> Thanks,
> Arun
>
|