|
Home > Archive > SQL Anywhere Mobile > July 2005 > unexpected error when synchronizing a table with lots of doubles
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
unexpected error when synchronizing a table with lots of doubles
|
|
|
| I am synchronizing a table from ultralite to an ASA 9 database. One
table has 45 records, one record causes a -158 error.
I have no idea what this means since there are lots of records that look
very identical (having 0 on same fields) and are not causing this error.
Here is a print of the synch log:
I. 07/14 18:00:31. <1.5> [tb]: Inserted row:
I. 07/14 18:00:31. <1.5> [tb]: 14315125997598
I. 07/14 18:00:31. <1.5> [tb]: 2005-07-14 15:38:27.000000
I. 07/14 18:00:31. <1.5> [tb]: .823429324130717635
I. 07/14 18:00:31. <1.5> [tb]: .148681079230072081
I. 07/14 18:00:31. <1.5> [tb]: 494
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 247
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 741
I. 07/14 18:00:31. <1.5> [tb]: NULL
E. 07/14 18:00:31. <1.5> [tb]: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Value 0 out of range for destination
(ODBC State = 22003, Native error code = -158)
I. 07/14 18:00:31. <1.5> [tb]: upload_insert WayPoint (close)
W. 07/14 18:00:31. <1.5> [tb]: Warning: [10039] Error detected while
using multi-row cursor -- retrying with single row cursor
after that it restarts inserting records and then comes up again with
the following error:
I. 07/14 18:00:31. <1.5> [tb]: Inserted row:
I. 07/14 18:00:31. <1.5> [tb]: 14315125997597
I. 07/14 18:00:31. <1.5> [tb]: 2005-07-14 14:52:14.000000
I. 07/14 18:00:31. <1.5> [tb]: .823427549712644815
I. 07/14 18:00:31. <1.5> [tb]: .148680439276013017
I. 07/14 18:00:31. <1.5> [tb]: 486
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 486
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: NULL
E. 07/14 18:00:31. <1.5> [tb]: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Value 0 out of range for destination
(ODBC State = 22003, Native error code = -158)
E. 07/14 18:00:31. <1.5> [tb]: Error: Unable to insert into table
'WayPoint' using upload_insert
I. 07/14 18:00:31. <1.5> [tb]: Error Context:
I. 07/14 18:00:31. <1.5> [tb]: User Name: tb
I. 07/14 18:00:31. <1.5> [tb]: Modified User Name: tb
I. 07/14 18:00:31. <1.5> [tb]: Transaction: upload
I. 07/14 18:00:31. <1.5> [tb]: Table Name: WayPoint
I. 07/14 18:00:31. <1.5> [tb]: Insert Row:
I. 07/14 18:00:31. <1.5> [tb]: 14315125997597
I. 07/14 18:00:31. <1.5> [tb]: 2005-07-14 14:52:14.000000
I. 07/14 18:00:31. <1.5> [tb]: .823427549712644815
I. 07/14 18:00:31. <1.5> [tb]: .148680439276013017
I. 07/14 18:00:31. <1.5> [tb]: 486
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 486
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: 0
I. 07/14 18:00:31. <1.5> [tb]: NULL
I. 07/14 18:00:31. <1.5> [tb]: Script Version: ul_default
I. 07/14 18:00:31. <1.5> [tb]: Script: INSERT INTO "WayPoint" (
"WayPointId", "Time", "Latitude", "Longitude", "Altitude",
"CourseOverGnd", "LastWayPointId", " DistanceToLastWaypoi
nt",
"AvgSpeedOverGnd", "AvgCourseOverGnd", "AvgAltitude",
" DeviationSpeedOverGn
d", " DeviationCourseOverG
nd", "DeviationAltitude",
"TripID" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
I. 07/14 18:00:31. <1.5> [tb]: End of Error Context
I. 07/14 18:00:31. <1.5> [tb]: handle_error <connection>
call ULHandleError(?,?,?,?,?)
I. 07/14 18:00:31. <1.5> [tb]: The handle_error script returned 1000
I wrote an error handler which ignores -158. All other records
synchronize without a problem.
Does anybody know what could cause this problem??
Many thanks for your help.
Tom
| |
| Graham Hurst 2005-07-15, 8:25 pm |
| Tom wrote:
> I am synchronizing a table from ultralite to an ASA 9 database. One
> table has 45 records, one record causes a -158 error.
The log snippets you gave show that two different records cause the same
error. In one, the second last column (DeviationAltitude) is zero but it
isn't in the other.
> I have no idea what this means since there are lots of records that look
> very identical (having 0 on same fields) and are not causing this error.
Are you sure? You didn't include the log section for a row that worked,
or the table definition, so there's not much other help we can provide.
I would carefully check the columns for problem rows against the table
definition.
Cheers,
Graham
|
|
|
|
|