We are using SQL Anywhere v12.01.3537 on Win Server 2008R2 with a mix of v10/12 MobiLink clients.

We are seeing where data from one table is uploaded, but not from another. I think it is due to a record lock in the consolidated database. There is no indication that this data is not getting uploaded and the system does not try to upload it on future synchronizations.

Please help lead me in the right direction on this one as I am getting some frustrated users over this. I know the obvious answer is to avoid the record locks, but this is sometimes easier said than done. I am thinking the system should not "assume" data has been sent if it encountered a record lock.

Is there a switch on the server or client that governs this behsviour?

Server Start Line: mlsrv12.exe -c "dsn=central Database;dbn=central01;eng=central01;uid=xxx;pwd=xxx;commlinks=tcpip" -x tcpip{port=2440} -zs "MLServer" -ot c:bersysmlserver12.mls -os 20m -zf -zu+ -v cnpus -dl -q -e c:bersysmlerrors12.txt -w 40 -wu 20 -cm 4g -r 1000000

Client Start Line: dbmlsync -c "dsn=local database;dbn=local;eng-local;uid=xxx;pwd=xxx" -k -x -vno -e "LockTables=OFF;FT=off;sv=sales17;adr='host=192.168.0.4;port=2440' -n "pub_ml_sales" -uo -o c:bersysmlclient.txt c:bersys