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

Bose
31557
accept rate: 0%


-196 looks like a SQLCODE. The description is (from http://dcx.sybase.com/index.html#1201/en/saerrors/errm196.html):

"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

RussC_FromSAP
1.3k11030
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

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:

×86
×77

question asked: 11 Jan '12, 03:25

question was seen: 1,439 times

last updated: 11 Jan '12, 14:40