Welcome to SQLA Beta

Question

0

SQL Anywhere 11.0.1.2376 Oracle 10g

we have a sync environment running successfully... except for one table: - Inserts appear to always work fine - Updates randomly shift contents by 1 or 2 columns - appears to only affect CLOB columns - appears to only occur after preceeding NULL column content - we have compared our Publication, Insert and Update scripts (retrieved from ml_scripts table on the Oracle database) and believe they match as expected. (and... the shifting does not occur consistently) - we have verified we are using "iAnywhere Solutions Oracle - 11" ODBC driver on the MobiLink server connection to Oracle - this is a IIS Relay Server setup - the MlServer log file (running with -v cfhnpstur) shows the data content in the correct columns

Not sure what else to look for??

Thanks, Bill

flag	asked Jan 26 at 19:22 Bill 71●3

	Offhand, I'd say this needs hand-on and/or real-time study... perhaps it's time to grab a cuppa and call tech support. One thing you might try in the interim, is to determine if you can repeat the symptom using ordinary INSERT statements via SQL*PLUS, or not, thus proving it is definitely the fault of Oracle or likely the fault of the synchronization process (note the words definitely and likely... if the INSERTs work it could still be the fault of Oracle). – Breck Carter Jan 27 at 9:35
	FWIW it's really really really really really unlikely to be the fault of Oracle, so don't read past the "call tech support" part of my previous comment :) – Breck Carter Jan 27 at 9:38
	The Inserts work correctly, only the updates are screwy. After we just poured over our setup one more time, we have just opened a Support Incident. Will post the solution when we get it figured out. Thanks Breck. – Bill Jan 27 at 22:25

Bill · Answer 1 · 2010-02-09 04:19:10Z UTC

2

after Tech Support spent quite a bit of time working on this for us, it turned out to be unexpected behaviour (double speak for a "Bug") in our own AFTER UPDATE trigger.

answered Feb 9 at 4:19

Bill
71●3

	OK... share! (bugs in triggers are some of the hardest to find, and the engineer in me wants to know the details) – Breck Carter Feb 9 at 8:04
	Will do... we disabled the trigger for the time being as Lia is off for a few days and the trigger functionality is not really needed yet. – Bill Feb 9 at 16:29

Mobilink to Oracle 10g shifting column content

1 Answer