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

asked 26 Jan '10, 19:22

Bill%20Aumen's gravatar image

Bill Aumen
2.0k294573
accept rate: 16%

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).

(27 Jan '10, 09:35) Breck Carter

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 :)

(27 Jan '10, 09:38) Breck Carter

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.

(27 Jan '10, 22:25) Bill Aumen

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.

permanent link

answered 09 Feb '10, 04:19

Bill%20Aumen's gravatar image

Bill Aumen
2.0k294573
accept rate: 16%

1

OK... share! (bugs in triggers are some of the hardest to find, and the engineer in me wants to know the details)

(09 Feb '10, 08:04) Breck Carter

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.

(09 Feb '10, 16:29) Bill Aumen
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×290
×27

question asked: 26 Jan '10, 19:22

question was seen: 1,040 times

last updated: 09 Feb '10, 04:19