sybase mobilink synchronization issue

[former_member1290501]

We have 2 different databases, sybase central sql anywhere 12 and oracle 11G (hosted in separate servers), with 2 common tables autodispath and autodispatchlbl.

The data in these tables needs to be synchronized, but is not working now.

We have checked the services in the database and all of them are running:

SQL Anywhere 12 had 2 services- a personal db server and a mobilink relay server

Mobilink 12 had a relay server

There are 2 synchronization subscriptions in the database for the 2 tables to be synchronized.

PFB the error from application log side:

2019-02-18 07:08:24,386 [RemoteServer_Worker-1] DEBUG Quartz.Core.JobRunShell [(null)] - Trigger instruction : NoInstruction

2019-02-18 07:09:18,812 [RemoteServer_QuartzSchedulerThread] DEBUG Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job 'default.SyncLblJob', class=AutoDispathWeb.SyncLblJob

2019-02-18 07:09:18,812 [RemoteServer_Worker-1] DEBUG Quartz.Core.JobRunShell [(null)] - Calling Execute on job default.SyncLblJob

2019-02-18 07:09:18,812 [RemoteServer_Worker-1] DEBUG AutoDispathWeb.Dao [(null)] - SQL: SYNCHRONIZE PROFILE AutoDispathLblSyncProfile VERBOSITY HIGH

2019-02-18 07:09:23,648 [RemoteServer_Worker-1] ERROR AutoDispathWeb.BaseJob [(null)] - Exception: Synchronization failed. Check the results of the call to sp_get_last_synchronize_result( 87 ) for more information.

iAnywhere.Data.SQLAnywhere.SAException: Synchronization failed. Check the results of the call to sp_get_last_synchronize_result( 87 ) for more information.

at iAnywhere.Data.SQLAnywhere.SACommand.ExecuteNonQuery()

at AutoDispathWeb.Dao.ExecuteQuery(String queryStr, Object[] parameters)

at AutoDispathWeb.Dao.ExecuteQuery(String queryStr)

Upon checking results for sp_get_last_synchronize_result(), as given in log, we can see below:

237,87,2019-02-18 07:09:20.668,Subscription 'AutoDispath' - Not Synchronizing - Log offset 0182076852 - Last download time 2018-06-22 01:01:03.0.

238,87,2019-02-18 07:09:20.684,Log scan starting at offset 0186461538

239,87,2019-02-18 07:09:20.7, Processing transaction logs from directory "E:\\xxxxxx\\AutoDispatch\\database\\db\\"

240,87,2019-02-18 07:09:20.7, Processing transactions from active transaction log

241,87,2019-02-18 07:09:22.868,0

242,87,2019-02-18 07:09:22.868,No log operation at offset of 0186461538 in the current transaction log

243,87,2019-02-18 07:09:22.883,Upload aborted at offset 0186461538

244,87,2019-02-18 07:09:22.883,Disconnecting from MobiLink server

[chris_keating]

Can you elaborate on how you manage your transaction logs?

The message ",No log operation at offset of 0186461538 in the current transaction log" means that Synchronization is looking for an operation in the available transaction logs that is not found. This can happen if you are managing the transaction log with dbbackup for example. You will need to provide the "OfflineDirectory" extended option referencing the location of the offline logs for the sync environment.