I have a local database(sql anywhere 12) and a consolidated database (Oracle) I use mobilink to synchronize data.
We have a strange situation where 1 local database keeps getting some records deleted after inserting them (with mobilink synchronization) (the records should not be deleted since they are available on the consolidated database)
I know the records are deleted since I check the transaction log of the local database and I see them getting inserted and a litle later they are deleted....
Now, I have 2 questions...
Q1: Has anyone seen anything like this before???
Q2: After all the inserts there is a internal sored procedure called =>
and right after this procedure, a few delete statements are called and some of the inserted records are deleted.
Now, I am wondering if the deletes are part of the synchronization or are they performed After the synchronization? (since I would assume that the sa_sync_sub procedure is called after everything is synchronized... or am I completely wrong about this?)...
Thank you !
asked 06 Mar '15, 06:02
Do these rows violate referential integrity on the remote? If so, the MobiLink client may be silently removing them.
answered 06 Mar '15, 07:57