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