The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

Mobilink to iPad sync. Upload & download successful but separately. When doing both at a time, using the same scrips, its throwing error at the client side: "Sync failed: -196 (ERROR)". Mobilink console isn't detecting any, though. Showing "Sync completed" & being able to fetch the upload.

asked 11 Jan '12, 03:25

Bose's gravatar image

accept rate: 0%

-196 looks like a SQLCODE. The description is (from

"You attempted to insert or update a row that has the same value as another row in some column, and there is a constraint that does not allow two rows to have the same value in that column."

It looks like you downloaded values incompatible with your schema. In ML server, you can use the -vr option to see row values going down. Your investigation can start there.

permanent link

answered 11 Jan '12, 09:55

RussC_FromSAP's gravatar image

accept rate: 18%

The MobiLink server compares upload rows and download rows to filter away redundant download rows. If that isn't working, eg. because the consolidated database uses null-padded character columns or a different timestamp precision, it could cause the error.

What type of consolidated database are you using? (The null-padding problem wouldn't happen with a SQL Anywhere consolidated database.)

(11 Jan '12, 14:40) Graham Hurst
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 11 Jan '12, 03:25

question was seen: 1,634 times

last updated: 11 Jan '12, 14:40