|
Home > Archive > SQL Anywhere Mobile > July 2005 > Syntax error during explicit conversion
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 |
Syntax error during explicit conversion
|
|
|
| Hi,
I am syncing between ASA9.0.2.3131 and ASE1253 through
Mobilink 9.0.2.3131. When Mobilink executes upload_update, I
receive the following error:
E. 07/27 13:36:32. <1.5> [shirad]: Error: [-10002] ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL
Server]Syntax error during explicit conversion of CHAR
value 'some_col_data' to a NUMERIC field
some_col_data is a VARCHAR(100) with arabic characters on
both databases.
Mobilink uses iAnywhere Solutions 9 - Sybase ASE ODBC driver
version 4.20.00.63 (WQASE19.DLL) to connect to ASE.
This is my upload_update script:
update sc_house set
financial_no = convert(numeric(8, 0), ?),
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'some_user'
Where addr is the column data from where the error is
generated.
Any suggestion?!! (Urgent pls)
rgds,
SS
| |
| David Fishburn 2005-07-27, 7:27 am |
| SS wrote in news:42e77044.404b.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
S> I am syncing between ASA9.0.2.3131 and ASE1253 through
S> Mobilink 9.0.2.3131. When Mobilink executes upload_update, I
S> receive the following error:
S>
S> E. 07/27 13:36:32. <1.5> [shirad]: Error: [-10002] ODBC:
S> [DataDirect][ODBC Sybase Wire Protocol driver][SQL
S> Server]Syntax error during explicit conversion of CHAR
S> value 'some_col_data' to a NUMERIC field
S>
S> some_col_data is a VARCHAR(100) with arabic characters on
S> both databases.
S>
S> Mobilink uses iAnywhere Solutions 9 - Sybase ASE ODBC driver
S> version 4.20.00.63 (WQASE19.DLL) to connect to ASE.
S>
S> This is my upload_update script:
S>
S> update sc_house set
S> financial_no = convert(numeric(8, 0), ?),
S> addr = convert(varchar(100)
, ?),
S> street = convert(varchar(50),
?),
S> area_no = convert(numeric(3, 0), ?),
S> bldg_no = convert(numeric(4, 0), ?),
S> city = convert(varchar(50),
?),
S> user_id = convert(varchar(10),
?)
S> where user_id = 'some_user'
S>
S> Where addr is the column data from where the error is
S> generated.
Anytime I see a conversion error I assume the column order is wrong.
Please start ML using -v+ -ot ml.txt and post the full output after a
sync.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
|
| Hi David,
Those are my ASE and ASA DDLs:
1. ASE (Generated from Sybase Central - ASE plugin)
create table sc_house
(
financial_no numeric(8,0) not null ,
addr varchar(100) not null ,
street varchar(50) not null ,
area_no numeric(3,0) not null ,
bldg_no numeric(4,0) not null ,
city varchar(50) not null ,
user_id varchar(10) not null
)
2. ASA (Generated using PowerDesigner 11)
create table DBA.sc_house
(
financial_no numeric(8) not
null,
addr varchar(100) not
null,
street varchar(50) not
null,
area_no numeric(3) not
null,
bldg_no numeric(4) not
null,
city varchar(50) not
null,
user_id varchar(10) not
null,
constraint ASA82 primary key (financial_no)
)
This is the content of the Mobilink log file after
synchrozation failed:
I. 07/27 17:10:05. <Main>: MobiLink server started
I. 07/27 17:10:05. <Main>: Option 1: -c
I. 07/27 17:10:05. <Main>: Option 2:
dsn=3dGlobalDB_ASE12
53;uid=3dsa;pwd=3d**
******
I. 07/27 17:10:05. <Main>: Option 3: -v+
I. 07/27 17:10:05. <Main>: Option 4: -za
I. 07/27 17:10:05. <Main>: Option 5: -ze
I. 07/27 17:10:05. <Main>: Option 6: -e
I. 07/27 17:10:05. <Main>: Option 7: SendColumnNames=3don
I. 07/27 17:10:05. <Main>: Verbose logging: show row values
I. 07/27 17:10:05. <Main>: Verbose logging: show script
names when invoked
I. 07/27 17:10:05. <Main>: Verbose logging: show script
contents when invoked
I. 07/27 17:10:05. <Main>: Verbose logging: show schema for
each table
I. 07/27 17:10:05. <Main>: Verbose logging: show an error
when the first read of a synchronization fails
I. 07/27 17:10:05. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 07/27 17:10:05. <Main>: Verbose logging: show rowcount
values
I. 07/27 17:10:05. <Main>: Individual database connections
will be closed after synchronization errors.
I. 07/27 17:10:05. <Main>: BLOB cache size: 524288
I. 07/27 17:10:05. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 07/27 17:10:05. <Main>: Maximum number of database
connections: 6
I. 07/27 17:10:05. <Main>: Maximum number of deadlock
retries: 10
I. 07/27 17:10:05. <Main>: Timeout for inactive database
connections: 60 minutes
I. 07/27 17:10:05. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 07/27 17:10:05. <Main>: Rowset size: 10
I. 07/27 17:10:05. <Main>: Upload cache size: 524288 bytes
I. 07/27 17:10:05. <Main>: Download cache memory size:
1048576 bytes
I. 07/27 17:10:05. <Main>: Download cache directory size:
10485760 bytes
I. 07/27 17:10:05. <Main>: Number of worker threads: 5
I. 07/27 17:10:05. <Main>: Maximum number of threads
uploading concurrently: 5
I. 07/27 17:10:05. <Main>: Unknown users will be rejected
(when there is no authenticate_user script).
I. 07/27 17:10:05. <Main>: Warning: Example scripts may be
automatically generated and activated for unknown versions.
I. 07/27 17:10:05. <Main>: Local file for remote
synchronization logs: 'SendColumnNames=3do
n'
I. 07/27 17:10:05. <Main>: Stream specifier 1: TCPIP
I. 07/27 17:10:06. <Main>: ODBC DBMS Name: SQL Server
I. 07/27 17:10:06. <Main>: ODBC DBMS Version: 12.50.0000
I. 07/27 17:10:06. <Main>: ODBC DBMS Driver Version:
04.20.0063 (B0061, U0057)
I. 07/27 17:10:06. <Main>: ODBC Version supported by the
driver: 3.52
I. 07/27 17:10:06. <Main>: ODBC isolation set to: Read
Committed
I. 07/27 17:10:06. <Main>: Connected
I. 07/27 17:10:06. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 07/27 17:10:06. <thread 1.1>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.2>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.3>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.4>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.5>: Ready to handle requests
I. 07/27 17:10:49. <thread 1.5>: Working on a request
I. 07/27 17:10:49. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 07/27 17:10:49. <thread 1.5>: ml_scripts_modified last
modified at: 2005-07-27 13:36:01.483
I. 07/27 17:10:50. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version
WHERE name =3d ?
I. 07/27 17:10:50. <thread 1.5>: ASA synchronization request
from: ss (version: default)
I. 07/27 17:10:50. <1.5> [ss]: ODBC isolation set to: Read
Committed
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT t1.event, t2.script_language,
t2.script FROM ml_connection_script
t1, ml_script t2 WHERE
t1.version_id =3d ? AND t1.script_id =3d t2.script_id
I. 07/27 17:10:50. <1.5> [ss]: begin_connection <connection>
(no script)
I. 07/27 17:10:50. <1.5> [ss]: COMMIT Transaction:
begin_connection
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name =3d ?
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
=3d ?
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10017] The
consolidated and remote databases have different timestamp
precisions. Consolidated database timestamps are precise to
2 digit(s) in the fractional second while the remote
database timestamps are precise to 6 digit(s)
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10018] The
timestamp precision mismatch may be resolved by setting the
DEFAULT_TIMESTAMP_IN
CREMENT option on the remote database to
10000 and TRUNCATE_TIMESTAMP_V
ALUES to 'On'
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10020] The
timestamp precision mismatch may affect upload conflict
detection. Use the -zp option to cause the MobiLink
synchronization server to use the lowest timestamp precision
for conflict detection purposes
I. 07/27 17:10:50. <1.5> [ss]: Publication #1: sc_pub,
subscription id: 6, last download time: 2005-07-27
12:51:38.200000
I. 07/27 17:10:50. <1.5> [ss]: Table #1: sc_house, 7 columns
I. 07/27 17:10:50. <1.5> [ss]: Column #1: numeric(8,0) NOT
NULL PRIMARY KEY
I. 07/27 17:10:50. <1.5> [ss]: Column #2: varchar(100) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #3: varchar(50) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #4: numeric(3,0) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #5: numeric(4,0) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #6: varchar(50) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #7: varchar(10) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 07/27 17:10:50. <1.5> [ss]: Progress offsets for the
publications that are explicitly involved in the current
synchronization
I. 07/27 17:10:50. <1.5> [ss]: Subscription id 6:
consolidated progress 451807 and remote progress 451807
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
UPDATE ml_subscription SET
last_download_time =3d ?, publication_name =3d ? WHERE
user_id =3d ? AND subscription_id =3d ?
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 07/27 17:10:50. <1.5> [ss]: begin_synchronizatio
n
<connection> (no script)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT t1.event, t2.script_language,
t2.script FROM ml_table_script t1, ml_script t2 WHERE
t1.table_id =3d ? AND t1.version_id =3d ? AND t1.script_id
=3d t2.script_id
I. 07/27 17:10:50. <1.5> [ss]: begin_synchronizatio
n
sc_house (no script)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id =3d ? AND subscription_id =3d
?
I. 07/27 17:10:50. <1.5> [ss]: Last upload time for
subscription id 6: 2005-07-27 12:51:38.106000
I. 07/27 17:10:50. <1.5> [ss]: begin_publication
<connection> (no script)
I. 07/27 17:10:50. <1.5> [ss]: COMMIT Transaction:
begin_synchronizatio
n
I. 07/27 17:10:50. <1.5> [ss]: begin_upload <connection> (no
script)
I. 07/27 17:10:50. <1.5> [ss]: begin_upload sc_house (no
script)
I. 07/27 17:10:50. <1.5> [ss]: begin_upload_rows sc_house
(no script)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
save tran it0
I. 07/27 17:10:50. <1.5> [ss]: Updated row (new values):
I. 07/27 17:10:50. <1.5> [ss]: 123456
I. 07/27 17:10:50. <1.5> [ss]:
=c3=a3=c3=9e=c3=87=c
3=88=c3=a1
=c3=a3=c3=93=c3=8a=c
3=94=c3=9d=c3=ac
I. 07/27 17:10:50. <1.5> [ss]: =c3=94=c3=87=c3=91=c
3=9a
=c3=8e=c3=a1=c3=ad=c
3=9d=c3=89
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: =c3=83=c3=88=c3=a6
=c3=99=c3=88=c3=ad
I. 07/27 17:10:50. <1.5> [ss]: ss
I. 07/27 17:10:50. <1.5> [ss]: upload_update sc_house (open
for write):
update sc_house set
financial_no =3d convert(numeric(8, 0),
?),
addr =3d convert(varchar(100)
, ?),
street =3d convert(varchar(50),
?),
area_no =3d convert(numeric(3, 0), ?),
bldg_no =3d convert(numeric(4, 0), ?),
city =3d convert(varchar(50),
?),
user_id =3d convert(varchar(10),
?)
where user_id =3d 'ss'
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
update sc_house set
financial_no =3d convert(numeric(8, 0),
?),
addr =3d convert(varchar(100)
, ?),
street =3d convert(varchar(50),
?),
area_no =3d convert(numeric(3, 0), ?),
bldg_no =3d convert(numeric(4, 0), ?),
city =3d convert(varchar(50),
?),
user_id =3d convert(varchar(10),
?)
where user_id =3d 'ss'
E. 07/27 17:10:50. <1.5> [ss]: Error: [-10002] ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL
Server]Syntax error during explicit conversion of CHAR value
'=c3=a3=c3=9e=c3=87=
c3=88=c3=a1
=c3=a3=c3=93=c3=8a=c
3=94=c3=9d=c3=ac' to a NUMERIC field.
(ODBC State =3d HY000, Native error code
=3d 249)
I. 07/27 17:10:50. <1.5> [ss]: upload_update sc_house
(close)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
rollback tran it0
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10039] Error
detected while using multi-row cursor -- retrying with
single row cursor
I. 07/27 17:10:50. <1.5> [ss]: Updated row (new values):
I. 07/27 17:10:50. <1.5> [ss]: 123456
I. 07/27 17:10:50. <1.5> [ss]:
=c3=a3=c3=9e=c3=87=c
3=88=c3=a1
=c3=a3=c3=93=c3=8a=c
3=94=c3=9d=c3=ac
I. 07/27 17:10:50. <1.5> [ss]: =c3=94=c3=87=c3=91=c
3=9a
=c3=8e=c3=a1=c3=ad=c
3=9d=c3=89
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: =c3=83=c3=88=c3=a6
=c3=99=c3=88=c3=ad
I. 07/27 17:10:50. <1.5> [ss]: ss
I. 07/27 17:10:50. <1.5> [ss]: upload_update sc_house (open
for write):
update sc_house set
financial_no =3d convert(numeric(8, 0),
?),
addr =3d convert(varchar(100)
, ?),
street =3d convert(varchar(50),
?),
area_no =3d convert(numeric(3, 0), ?),
bldg_no =3d convert(numeric(4, 0), ?),
city =3d convert(varchar(50),
?),
user_id =3d convert(varchar(10),
?)
where user_id =3d 'ss'
I. 07/27 17:10:50. <1.5> [ss]: Cached ODBC statement:
update sc_house set
financial_no =3d convert(numeric(8, 0),
?),
addr =3d convert(varchar(100)
, ?),
street =3d convert(varchar(50),
?),
area_no =3d convert(numeric(3, 0), ?),
bldg_no =3d convert(numeric(4, 0), ?),
city =3d convert(varchar(50),
?),
user_id =3d convert(varchar(10),
?)
where user_id =3d 'ss'
E. 07/27 17:10:50. <1.5> [ss]: Error: [-10002] ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL
Server]Syntax error during explicit conversion of CHAR value
'=c3=a3=c3=9e=c3=87=
c3=88=c3=a1
=c3=a3=c3=93=c3=8a=c
3=94=c3=9d=c3=ac' to a NUMERIC field.
(ODBC State =3d HY000, Native error code
=3d 249)
E. 07/27 17:10:50. <1.5> [ss]: Error: Unable to update table
'sc_house' using upload_update
I. 07/27 17:10:50. <1.5> [ss]: Error Context:
I. 07/27 17:10:50. <1.5> [ss]: User Name: ss
I. 07/27 17:10:50. <1.5> [ss]: Modified User Name: ss
I. 07/27 17:10:50. <1.5> [ss]: Transaction: upload
I. 07/27 17:10:50. <1.5> [ss]: Table Name: sc_house
I. 07/27 17:10:50. <1.5> [ss]: Update Row:
I. 07/27 17:10:50. <1.5> [ss]: 123456
I. 07/27 17:10:50. <1.5> [ss]:
=c3=a3=c3=9e=c3=87=c
3=88=c3=a1
=c3=a3=c3=93=c3=8a=c
3=94=c3=9d=c3=ac
I. 07/27 17:10:50. <1.5> [ss]: =c3=94=c3=87=c3=91=c
3=9a
=c3=8e=c3=a1=c3=ad=c
3=9d=c3=89
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: =c3=83=c3=88=c3=a6
=c3=99=c3=88=c3=ad
I. 07/27 17:10:50. <1.5> [ss]: ss
I. 07/27 17:10:50. <1.5> [ss]: Script Version: default
I. 07/27 17:10:50. <1.5> [ss]: Script: update sc_house set
financial_no =3d convert(numeric(8, 0),
?),
addr =3d convert(varchar(100)
, ?),
street =3d convert(varchar(50),
?),
area_no =3d convert(numeric(3, 0), ?),
bldg_no =3d convert(numeric(4, 0), ?),
city =3d convert(varchar(50),
?),
user_id =3d convert(varchar(10),
?)
where user_id =3d 'ss'
I. 07/27 17:10:50. <1.5> [ss]: End of Error Context
W. 07/27 17:10:51. <1.5> [ss]: Warning: [10010] No
handle_error script is defined. The default action code
(3000) will decide the error behavior
I. 07/27 17:10:51. <1.5> [ss]: An error occurred while
uploading an updated row into table 'sc_house'. The updated
column values are as follows:
I. 07/27 17:10:51. <1.5> [ss]: 123456
I. 07/27 17:10:51. <1.5> [ss]:
=c3=a3=c3=9e=c3=87=c
3=88=c3=a1
=c3=a3=c3=93=c3=8a=c
3=94=c3=9d=c3=ac
I. 07/27 17:10:51. <1.5> [ss]: =c3=94=c3=87=c3=91=c
3=9a
=c3=8e=c3=a1=c3=ad=c
3=9d=c3=89
I. 07/27 17:10:51. <1.5> [ss]: 2
I. 07/27 17:10:51. <1.5> [ss]: 2
I. 07/27 17:10:51. <1.5> [ss]: =c3=83=c3=88=c3=a6
=c3=99=c3=88=c3=ad
I. 07/27 17:10:51. <1.5> [ss]: ss
I. 07/27 17:10:51. <1.5> [ss]: upload_update sc_house
(close)
I. 07/27 17:10:51. <1.5> [ss]: ROLLBACK Transaction:
end_upload
I. 07/27 17:10:51. <1.5> [ss]: end_publication <connection>
(no script)
I. 07/27 17:10:51. <1.5> [ss]: end_synchronization sc_house
(no script)
I. 07/27 17:10:51. <1.5> [ss]: end_synchronization
<connection> (no script)
I. 07/27 17:10:51. <1.5> [ss]: end_connection <connection>
(no script)
I. 07/27 17:10:51. <1.5> [ss]: COMMIT Transaction:
end_connection
I. 07/27 17:10:51. <1.5> [ss]: Disconnected from
consolidated database
I. 07/27 17:10:51. <1.5> [ss]: Synchronization failed
Awaiting your response,
Shirad
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-07-27, 9:24 am |
| financial_no is the primary key of the table, so it should be mentioned only
ONCE, as the last parameter in the upload_update script.
update sc_house set
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'ss'
and financial_no = convert(numeric(8, 0),?);
See the docs for the upload_update script, and pay special attention to the
order of the parameters.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SS> wrote in message news:42e789da.2582.1681692777@sybase.com...
Hi David,
Those are my ASE and ASA DDLs:
1. ASE (Generated from Sybase Central - ASE plugin)
create table sc_house
(
financial_no numeric(8,0) not null ,
addr varchar(100) not null ,
street varchar(50) not null ,
area_no numeric(3,0) not null ,
bldg_no numeric(4,0) not null ,
city varchar(50) not null ,
user_id varchar(10) not null
)
2. ASA (Generated using PowerDesigner 11)
create table DBA.sc_house
(
financial_no numeric(8) not
null,
addr varchar(100) not
null,
street varchar(50) not
null,
area_no numeric(3) not
null,
bldg_no numeric(4) not
null,
city varchar(50) not
null,
user_id varchar(10) not
null,
constraint ASA82 primary key (financial_no)
)
This is the content of the Mobilink log file after
synchrozation failed:
I. 07/27 17:10:05. <Main>: MobiLink server started
I. 07/27 17:10:05. <Main>: Option 1: -c
I. 07/27 17:10:05. <Main>: Option 2:
dsn=GlobalDB_ASE1253
;uid=sa;pwd=********
I. 07/27 17:10:05. <Main>: Option 3: -v+
I. 07/27 17:10:05. <Main>: Option 4: -za
I. 07/27 17:10:05. <Main>: Option 5: -ze
I. 07/27 17:10:05. <Main>: Option 6: -e
I. 07/27 17:10:05. <Main>: Option 7: SendColumnNames=on
I. 07/27 17:10:05. <Main>: Verbose logging: show row values
I. 07/27 17:10:05. <Main>: Verbose logging: show script
names when invoked
I. 07/27 17:10:05. <Main>: Verbose logging: show script
contents when invoked
I. 07/27 17:10:05. <Main>: Verbose logging: show schema for
each table
I. 07/27 17:10:05. <Main>: Verbose logging: show an error
when the first read of a synchronization fails
I. 07/27 17:10:05. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 07/27 17:10:05. <Main>: Verbose logging: show rowcount
values
I. 07/27 17:10:05. <Main>: Individual database connections
will be closed after synchronization errors.
I. 07/27 17:10:05. <Main>: BLOB cache size: 524288
I. 07/27 17:10:05. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 07/27 17:10:05. <Main>: Maximum number of database
connections: 6
I. 07/27 17:10:05. <Main>: Maximum number of deadlock
retries: 10
I. 07/27 17:10:05. <Main>: Timeout for inactive database
connections: 60 minutes
I. 07/27 17:10:05. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 07/27 17:10:05. <Main>: Rowset size: 10
I. 07/27 17:10:05. <Main>: Upload cache size: 524288 bytes
I. 07/27 17:10:05. <Main>: Download cache memory size:
1048576 bytes
I. 07/27 17:10:05. <Main>: Download cache directory size:
10485760 bytes
I. 07/27 17:10:05. <Main>: Number of worker threads: 5
I. 07/27 17:10:05. <Main>: Maximum number of threads
uploading concurrently: 5
I. 07/27 17:10:05. <Main>: Unknown users will be rejected
(when there is no authenticate_user script).
I. 07/27 17:10:05. <Main>: Warning: Example scripts may be
automatically generated and activated for unknown versions.
I. 07/27 17:10:05. <Main>: Local file for remote
synchronization logs: 'SendColumnNames=on'
I. 07/27 17:10:05. <Main>: Stream specifier 1: TCPIP
I. 07/27 17:10:06. <Main>: ODBC DBMS Name: SQL Server
I. 07/27 17:10:06. <Main>: ODBC DBMS Version: 12.50.0000
I. 07/27 17:10:06. <Main>: ODBC DBMS Driver Version:
04.20.0063 (B0061, U0057)
I. 07/27 17:10:06. <Main>: ODBC Version supported by the
driver: 3.52
I. 07/27 17:10:06. <Main>: ODBC isolation set to: Read
Committed
I. 07/27 17:10:06. <Main>: Connected
I. 07/27 17:10:06. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 07/27 17:10:06. <thread 1.1>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.2>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.3>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.4>: Ready to handle requests
I. 07/27 17:10:06. <thread 1.5>: Ready to handle requests
I. 07/27 17:10:49. <thread 1.5>: Working on a request
I. 07/27 17:10:49. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 07/27 17:10:49. <thread 1.5>: ml_scripts_modified last
modified at: 2005-07-27 13:36:01.483
I. 07/27 17:10:50. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version
WHERE name = ?
I. 07/27 17:10:50. <thread 1.5>: ASA synchronization request
from: ss (version: default)
I. 07/27 17:10:50. <1.5> [ss]: ODBC isolation set to: Read
Committed
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT t1.event, t2.script_language,
t2.script FROM ml_connection_script
t1, ml_script t2 WHERE
t1.version_id = ? AND t1.script_id = t2.script_id
I. 07/27 17:10:50. <1.5> [ss]: begin_connection <connection>
(no script)
I. 07/27 17:10:50. <1.5> [ss]: COMMIT Transaction:
begin_connection
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name = ?
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
= ?
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10017] The
consolidated and remote databases have different timestamp
precisions. Consolidated database timestamps are precise to
2 digit(s) in the fractional second while the remote
database timestamps are precise to 6 digit(s)
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10018] The
timestamp precision mismatch may be resolved by setting the
DEFAULT_TIMESTAMP_IN
CREMENT option on the remote database to
10000 and TRUNCATE_TIMESTAMP_V
ALUES to 'On'
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10020] The
timestamp precision mismatch may affect upload conflict
detection. Use the -zp option to cause the MobiLink
synchronization server to use the lowest timestamp precision
for conflict detection purposes
I. 07/27 17:10:50. <1.5> [ss]: Publication #1: sc_pub,
subscription id: 6, last download time: 2005-07-27
12:51:38.200000
I. 07/27 17:10:50. <1.5> [ss]: Table #1: sc_house, 7 columns
I. 07/27 17:10:50. <1.5> [ss]: Column #1: numeric(8,0) NOT
NULL PRIMARY KEY
I. 07/27 17:10:50. <1.5> [ss]: Column #2: varchar(100) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #3: varchar(50) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #4: numeric(3,0) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #5: numeric(4,0) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #6: varchar(50) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Column #7: varchar(10) NOT
NULL
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 07/27 17:10:50. <1.5> [ss]: Progress offsets for the
publications that are explicitly involved in the current
synchronization
I. 07/27 17:10:50. <1.5> [ss]: Subscription id 6:
consolidated progress 451807 and remote progress 451807
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
UPDATE ml_subscription SET
last_download_time = ?, publication_name = ? WHERE
user_id = ? AND subscription_id = ?
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
= ?
I. 07/27 17:10:50. <1.5> [ss]: begin_synchronizatio
n
<connection> (no script)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT t1.event, t2.script_language,
t2.script FROM ml_table_script t1, ml_script t2 WHERE
t1.table_id = ? AND t1.version_id = ? AND t1.script_id
= t2.script_id
I. 07/27 17:10:50. <1.5> [ss]: begin_synchronizatio
n
sc_house (no script)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id = ? AND subscription_id =
?
I. 07/27 17:10:50. <1.5> [ss]: Last upload time for
subscription id 6: 2005-07-27 12:51:38.106000
I. 07/27 17:10:50. <1.5> [ss]: begin_publication
<connection> (no script)
I. 07/27 17:10:50. <1.5> [ss]: COMMIT Transaction:
begin_synchronizatio
n
I. 07/27 17:10:50. <1.5> [ss]: begin_upload <connection> (no
script)
I. 07/27 17:10:50. <1.5> [ss]: begin_upload sc_house (no
script)
I. 07/27 17:10:50. <1.5> [ss]: begin_upload_rows sc_house
(no script)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
save tran it0
I. 07/27 17:10:50. <1.5> [ss]: Updated row (new values):
I. 07/27 17:10:50. <1.5> [ss]: 123456
I. 07/27 17:10:50. <1.5> [ss]:
ãz?^á
ã"S"Ýì
I. 07/27 17:10:50. <1.5> [ss]: "?'s
Zá_Ý?
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: f^æ
T^_
I. 07/27 17:10:50. <1.5> [ss]: ss
I. 07/27 17:10:50. <1.5> [ss]: upload_update sc_house (open
for write):
update sc_house set
financial_no = convert(numeric(8, 0),
?),
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'ss'
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
update sc_house set
financial_no = convert(numeric(8, 0),
?),
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'ss'
E. 07/27 17:10:50. <1.5> [ss]: Error: [-10002] ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL
Server]Syntax error during explicit conversion of CHAR value
'ãz?^á
ã"S"Ýì' to a NUMERIC field.
(ODBC State = HY000, Native error code
= 249)
I. 07/27 17:10:50. <1.5> [ss]: upload_update sc_house
(close)
I. 07/27 17:10:50. <1.5> [ss]: Translated SQL:
rollback tran it0
W. 07/27 17:10:50. <1.5> [ss]: Warning: [10039] Error
detected while using multi-row cursor -- retrying with
single row cursor
I. 07/27 17:10:50. <1.5> [ss]: Updated row (new values):
I. 07/27 17:10:50. <1.5> [ss]: 123456
I. 07/27 17:10:50. <1.5> [ss]:
ãz?^á
ã"S"Ýì
I. 07/27 17:10:50. <1.5> [ss]: "?'s
Zá_Ý?
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: f^æ
T^_
I. 07/27 17:10:50. <1.5> [ss]: ss
I. 07/27 17:10:50. <1.5> [ss]: upload_update sc_house (open
for write):
update sc_house set
financial_no = convert(numeric(8, 0),
?),
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'ss'
I. 07/27 17:10:50. <1.5> [ss]: Cached ODBC statement:
update sc_house set
financial_no = convert(numeric(8, 0),
?),
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'ss'
E. 07/27 17:10:50. <1.5> [ss]: Error: [-10002] ODBC:
[DataDirect][ODBC Sybase Wire Protocol driver][SQL
Server]Syntax error during explicit conversion of CHAR value
'ãz?^á
ã"S"Ýì' to a NUMERIC field.
(ODBC State = HY000, Native error code
= 249)
E. 07/27 17:10:50. <1.5> [ss]: Error: Unable to update table
'sc_house' using upload_update
I. 07/27 17:10:50. <1.5> [ss]: Error Context:
I. 07/27 17:10:50. <1.5> [ss]: User Name: ss
I. 07/27 17:10:50. <1.5> [ss]: Modified User Name: ss
I. 07/27 17:10:50. <1.5> [ss]: Transaction: upload
I. 07/27 17:10:50. <1.5> [ss]: Table Name: sc_house
I. 07/27 17:10:50. <1.5> [ss]: Update Row:
I. 07/27 17:10:50. <1.5> [ss]: 123456
I. 07/27 17:10:50. <1.5> [ss]:
ãz?^á
ã"S"Ýì
I. 07/27 17:10:50. <1.5> [ss]: "?'s
Zá_Ý?
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: 2
I. 07/27 17:10:50. <1.5> [ss]: f^æ
T^_
I. 07/27 17:10:50. <1.5> [ss]: ss
I. 07/27 17:10:50. <1.5> [ss]: Script Version: default
I. 07/27 17:10:50. <1.5> [ss]: Script: update sc_house set
financial_no = convert(numeric(8, 0),
?),
addr = convert(varchar(100)
, ?),
street = convert(varchar(50),
?),
area_no = convert(numeric(3, 0), ?),
bldg_no = convert(numeric(4, 0), ?),
city = convert(varchar(50),
?),
user_id = convert(varchar(10),
?)
where user_id = 'ss'
I. 07/27 17:10:50. <1.5> [ss]: End of Error Context
W. 07/27 17:10:51. <1.5> [ss]: Warning: [10010] No
handle_error script is defined. The default action code
(3000) will decide the error behavior
I. 07/27 17:10:51. <1.5> [ss]: An error occurred while
uploading an updated row into table 'sc_house'. The updated
column values are as follows:
I. 07/27 17:10:51. <1.5> [ss]: 123456
I. 07/27 17:10:51. <1.5> [ss]:
ãz?^á
ã"S"Ýì
I. 07/27 17:10:51. <1.5> [ss]: "?'s
Zá_Ý?
I. 07/27 17:10:51. <1.5> [ss]: 2
I. 07/27 17:10:51. <1.5> [ss]: 2
I. 07/27 17:10:51. <1.5> [ss]: f^æ
T^_
I. 07/27 17:10:51. <1.5> [ss]: ss
I. 07/27 17:10:51. <1.5> [ss]: upload_update sc_house
(close)
I. 07/27 17:10:51. <1.5> [ss]: ROLLBACK Transaction:
end_upload
I. 07/27 17:10:51. <1.5> [ss]: end_publication <connection>
(no script)
I. 07/27 17:10:51. <1.5> [ss]: end_synchronization sc_house
(no script)
I. 07/27 17:10:51. <1.5> [ss]: end_synchronization
<connection> (no script)
I. 07/27 17:10:51. <1.5> [ss]: end_connection <connection>
(no script)
I. 07/27 17:10:51. <1.5> [ss]: COMMIT Transaction:
end_connection
I. 07/27 17:10:51. <1.5> [ss]: Disconnected from
consolidated database
I. 07/27 17:10:51. <1.5> [ss]: Synchronization failed
Awaiting your response,
Shirad
| |
|
| Hi Reg,
Thanks for pointing out the issue. It worked now.
Appreciate your quick response along with David.
Regards,
SS
|
|
|
|
|