HI, we have observed that most of the time the remote DB get corrupted if there is a connection failure ( line down ) back to console server. is there any way to prevent this ? we have set the sync interval from every 2 min to 10 min depends on the publication respectively. the corruption happening in all the version of Sql anywhere ( ver 10,11 and 12). TIA vhm asked 12 Feb '13, 20:37 vhm |
Without knowing exactly what you mean by "corruption" I can only guess that you might be doing implicit or explicit COMMITs in your synchronization scripts, which breaks MobiLink's built-in recovery from dropped connections. As stated in the Mobilink documentation:
answered 13 Feb '13, 12:14 Graham Hurst |
What is the exact symptom (messages, etc) for the "corrupted" condition?
Exact client software type (UL, SA or ULJ) and versions and build numbers will also be required.
Client software type is SA and version 10,11 and 12 and the message displayed is "missing Log files" .
Which build numbers are you using?
version 10.0.1 build 3415 version 11.0.1 build 2044
If the error is "missing log files", we'll need to know some more information :
1)Where are you storing the database file and active transaction log?
2) What is the start line for the dbeng12/dbsrv12 process that starts the database engine at the remote site?
3) What is the start line for the dbmlsync process at the remote site?
4) Do you perform any backups that rename,restart or delete the active transaction log?
Thanks, Reg