SQL Anywhere Mobile - How do I Solve this Problem

Author

How do I Solve this Problem - Cannot drop the table !

Yasir Masood

2005-06-27, 11:24 am

Hi Guys,

When I try to synchronize my ASA DB to a SQL Server DB. I
get the
following error:

Error: [-10002] ODBC: [Microsoft][ODBC SQL Server
Driver][SQL Server]Cannot drop the table
'#elbat_yraropmet_ym
mud_a_si_siht', because it does not
exist in the system catalog. (ODBC State =3d 42S02, Native
error code =3d 3701)

I am using ASA Version 9.0.1.2027, Mobilink Version
9.0.1.2027,
PocketBuilder Version 2.0.1.688, SQL Server 2000 - 8.00.818
on Windows NT 5.0 (Build 2195: Service Pack 4), and ODBC
DBMS Driver Version: 03.81.9002.

Here is the output from log file:

I. 06/27 10:29:13. Adaptive Server Anywhere MobiLink Version
9.0.1.2027
I. 06/27 10:29:13.
I. 06/27 10:29:13. Copyright =a9 1989-2004 Sybase, Inc.
Portions Copyright =a9 2002-2004,
iAnywhere Solutions, Inc.
I. 06/27 10:29:13. All rights reserved. All unpublished
rights reserved.
I. 06/27 10:29:13.
I. 06/27 10:29:13. This software contains confidential and
trade secret information of
I. 06/27 10:29:13. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 06/27 10:29:13. by the U.S. Government is subject to
restrictions set forth in a license
I. 06/27 10:29:13. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 06/27 10:29:13. other written agreement specifying the
Government's rights to use the
I. 06/27 10:29:13. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 06/27 10:29:13.
I. 06/27 10:29:13. iAnywhere Solutions, Inc., One Sybase
Drive, Dublin, CA 94568, USA
I. 06/27 10:29:13.
I. 06/27 10:29:13. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
This server is licensed to:
I. 06/27 10:29:13. Developer Edition
I. 06/27 10:29:13. Restricted Use
I. 06/27 10:29:13. <Main>: MobiLink server started
I. 06/27 10:29:13. <Main>: Option 1: -c
I. 06/27 10:29:13. <Main>: Option 2: ****************
I. 06/27 10:29:13. <Main>: Option 3: -x
I. 06/27 10:29:13. <Main>: Option 4: tcpip{port=3d2439}
I. 06/27 10:29:13. <Main>: Option 5: -v+
I. 06/27 10:29:13. <Main>: Option 6: -fr
I. 06/27 10:29:13. <Main>: Verbose logging: show row values
I. 06/27 10:29:13. <Main>: Verbose logging: show script
names when invoked
I. 06/27 10:29:13. <Main>: Verbose logging: show script
contents when invoked
I. 06/27 10:29:13. <Main>: Verbose logging: show schema for
each table
I. 06/27 10:29:13. <Main>: Verbose logging: show an error
when the first read of a synchronization fails
I. 06/27 10:29:13. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 06/27 10:29:13. <Main>: Verbose logging: show rowcount
values
I. 06/27 10:29:13. <Main>: Individual database connections
will be closed after synchronization errors.
I. 06/27 10:29:13. <Main>: BLOB cache size: 524288
I. 06/27 10:29:13. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 06/27 10:29:13. <Main>: Maximum number of database
connections: 6
I. 06/27 10:29:13. <Main>: Maximum number of deadlock
retries: 10
I. 06/27 10:29:13. <Main>: Timeout for inactive database
connections: 60 minutes
I. 06/27 10:29:13. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 06/27 10:29:13. <Main>: Rowset size: 10
I. 06/27 10:29:13. <Main>: Upload cache size: 524288 bytes
I. 06/27 10:29:13. <Main>: Download cache memory size:
1048576 bytes
I. 06/27 10:29:13. <Main>: Download cache directory size:
10485760 bytes
I. 06/27 10:29:13. <Main>: Number of worker threads: 5
I. 06/27 10:29:13. <Main>: Maximum number of threads
uploading concurrently: 5
I. 06/27 10:29:13. <Main>: Unknown users will be rejected
(when there is no authenticate_user script).
I. 06/27 10:29:13. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 06/27 10:29:13. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 06/27 10:29:13. <Main>: Stream specifier 1:
tcpip{port=3d2439}
W. 06/27 10:29:13. <Main>: Warning: [10050] ODBC:
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed
database context to 'YMOL_TEST'. (ODBC State =3d 01000,
Native error code =3d 5701)
W. 06/27 10:29:13. <Main>: Warning: [10050] ODBC:
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed
language setting to us_english. (ODBC State =3d 01000,
Native error code =3d 5703)
I. 06/27 10:29:13. <Main>: ODBC DBMS Name: Microsoft SQL
Server
I. 06/27 10:29:13. <Main>: ODBC DBMS Version: 08.00.0818
I. 06/27 10:29:13. <Main>: ODBC DBMS Driver Version:
03.81.9002
I. 06/27 10:29:13. <Main>: ODBC Version supported by the
driver: 3.52
I. 06/27 10:29:13. <Main>: Collation sequence of the
consolidated database is 'Code Page 437'
I. 06/27 10:29:13. <Main>: ODBC isolation set to: Read
Committed
I. 06/27 10:29:13. <Main>: Connected
I. 06/27 10:29:13. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 06/27 10:29:13. <thread 1.1>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.2>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.3>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.4>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.5>: Ready to handle requests
I. 06/27 10:29:29. <thread 1.5>: Working on a request
I. 06/27 10:29:29. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 06/27 10:29:29. <thread 1.5>: ml_scripts_modified last
modified at: 2005-06-23 16:39:31.973
I. 06/27 10:29:29. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version
WHERE name =3d ?
I. 06/27 10:29:29. <thread 1.5>: ASA synchronization request
from: ml_scan_YASIR (version: scan_default)
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10050]
ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
database context to 'YMOL_TEST'. (ODBC State =3d 01000,
Native error code =3d 5701)
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10050]
ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
language setting to us_english. (ODBC State =3d 01000,
Native error code =3d 5703)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: ODBC isolation set
to: Read Committed
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_connection
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_connection
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
=3d ?
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Publication #1:
scanvisit, subscription id: 3, last download time:
2005-06-27 10:23:18.093000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Table #1:
ym_car_id, 5 columns
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_id' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #5:
varchar(20)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Table #2:
ym_visit, 7 columns
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_visit' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #5: char(2)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #6: char(1)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #7:
char(10)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are explicitly involved in the
current synchronization
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Subscription id 3:
consolidated progress 372758 and remote progress 372758
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are not explicitly involved in the
current synchronization
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Subscription id 2:
consolidated progress 373580 and remote progress 373580
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_download_time =3d ?, publication_name =3d ? WHERE
user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n <connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id =3d ? AND subscription_id =3d
?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Last upload time
for subscription id 3: 2005-06-27 10:23:18.093000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_publication
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_synchronizatio
n
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:29.452000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (open for write):
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (close)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran dt1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Deleted row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 2005-06-27
10:23:18.546000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (open for write):
DELETE FROM ym_car_id
WHERE car_init =3d ?
AND car_no =3d ?
AND process_date =3d ?
AND plant_id =3d ?
AND app_name =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
DELETE FROM ym_car_id
WHERE car_init =3d ?
AND car_no =3d ?
AND process_date =3d ?
AND plant_id =3d ?
AND app_name =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (close)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_id : 2
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_id : 1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_id : 1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET progress =3d
?, publication_name =3d ? WHERE user_id =3d ? AND
subscription_id =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_upload_time =3d ? WHERE user_id =3d ? AND
subscription_id =3d ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_upload
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_download
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_download
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_download
ym_visit (no script)
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10056]
There is no download data script defined for table:
ym_car_id. Synchronization has the risk of potentially
losing download data
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (open for read):
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init =3d B.car_init
AND A.car_no =3d B.car_no
AND A.plant_id =3d B.plant_id
AND A.plant_status <> 'S'
AND B.app_name =3d 'SCAN'
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init =3d B.car_init
AND A.car_no =3d B.car_no
AND A.plant_id =3d B.plant_id
AND A.plant_status <> 'S'
AND B.app_name =3d 'SCAN'
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 2005-05-06
16:23:25.677000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 1999-05-09
12:00:00.000000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: PE
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: E
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (close)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download_rows
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_visit : 2
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_visit : 2
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_download
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Sending the
download to the remote database.
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Creating download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
001"
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_publication
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_synchronization ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_synchronization <connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_synchronization
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Synchronization
complete
I. 06/27 10:29:52. <thread 1.5>: Working on a request
I. 06/27 10:29:52. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 06/27 10:29:52. <thread 1.5>: ASA synchronization request
from: ml_scan_YASIR (version: scan_default)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
=3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Removing download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
001"
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Publication #1:
scanvisit, subscription id: 3, last download time:
2005-06-27 10:29:29.147000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Table #1:
ym_car_id, 5 columns
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_id' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #5:
varchar(20)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Table #2:
ym_visit, 7 columns
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_visit' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #5: char(2)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #6: char(1)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #7:
char(10)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are explicitly involved in the
current synchronization
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Subscription id 3:
consolidated progress 374756 and remote progress 374756
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are not explicitly involved in the
current synchronization
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Subscription id 2:
consolidated progress 373580 and remote progress 373580
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_download_time =3d ?, publication_name =3d ? WHERE
user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n <connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id =3d ? AND subscription_id =3d
?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Last upload time
for subscription id 3: 2005-06-27 10:29:29.130000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_publication
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_synchronizatio
n
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:51.936000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (open for write):
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (close)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran dt1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Deleted row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:29.452000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (open for write):
DELETE FROM ym_car_id
WHERE car_init =3d ?
AND car_no =3d ?
AND process_date =3d ?
AND plant_id =3d ?
AND app_name =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
DELETE FROM ym_car_id
WHERE car_init =3d ?
AND car_no =3d ?
AND process_date =3d ?
AND plant_id =3d ?
AND app_name =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (close)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_id : 2
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_id : 1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_id : 1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET progress =3d
?, publication_name =3d ? WHERE user_id =3d ? AND
subscription_id =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_upload_time =3d ? WHERE user_id =3d ? AND
subscription_id =3d ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_upload
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_download
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_download
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_download
ym_visit (no script)
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Warning: [10056]
There is no download data script defined for table:
ym_car_id. Synchronization has the risk of potentially
losing download data
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (open for read):
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init =3d B.car_init
AND A.car_no =3d B.car_no
AND A.plant_id =3d B.plant_id
AND A.plant_status <> 'S'
AND B.app_name =3d 'SCAN'
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init =3d B.car_init
AND A.car_no =3d B.car_no
AND A.plant_id =3d B.plant_id
AND A.plant_status <> 'S'
AND B.app_name =3d 'SCAN'
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-05-06
16:23:25.677000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-05-06
16:23:25.677000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (close)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download_rows
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_visit : 2
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_visit : 2
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_download
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Sending the
download to the remote database.
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Creating download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
002"
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_publication
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_synchronization ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_synchronization <connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_synchronization
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Synchronization
complete
I. 06/27 10:30:04. <thread 1.5>: Working on a request
I. 06/27 10:30:04. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 06/27 10:30:06. <thread 1.5>: ASA synchronization request
from: ml_scan_YASIR (version: scan_default)
I. 06/27 10:30:06. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name =3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Removing download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
002"
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Publication #1:
scan, subscription id: 2, last download time: 2005-06-27
10:23:35.217000
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #1:
ym_car_reader_import
, 16 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_reader_impor
t' has at least one timestamp
column. Due to a timestamp precision mismatch, uploaded
timestamps can lose precision, defeating download filtering
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #4:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #5:
numeric(3,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #6: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #7: char(2)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #8: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #9: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #10:
integer
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #11:
varchar(8)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #12:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #13:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #14:
numeric(6,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #15:
numeric(6,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #16:
numeric(6,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #2:
ym_car_reader_summar
y, 11 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1: integer
NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
varchar(8) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
char(10)
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_reader_summa
ry' has at least one timestamp
column. Due to a timestamp precision mismatch, uploaded
timestamps can lose precision, defeating download filtering
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #4:
timestamp
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #5:
timestamp
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #6:
timestamp
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #7: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #8: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #9:
numeric(4,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #10:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #11:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #3:
ym_car_status_dscr, 2 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1: char(2)
NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(30) NOT NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #4:
ym_plant, 2 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(30)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #5:
ym_track, 5 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #4:
numeric(3,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #5:
char(30)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #6: ym_yard,
3 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
char(30)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are explicitly involved in the
current synchronization
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Subscription id 2:
consolidated progress 373580 and remote progress 373580
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are not explicitly involved in the
current synchronization
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Subscription id 3:
consolidated progress 375491 and remote progress 375491
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_download_time =3d ?, publication_name =3d ? WHERE
user_id =3d ? AND subscription_id =3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
=3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n <connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id =3d ? AND subscription_id =3d
?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Last upload time
for subscription id 2: 2005-06-27 10:23:35.200000
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_publication
<connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_synchronizatio
n
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
<connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload
ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:32.374000
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: CH1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: E
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: PE
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: E
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Y
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 1119868166
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 01
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 16
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_reader_import
(open for write):
INSERT INTO ym_car_reader_import

( car_init, car_no, process_date,
track_id, position,
forb_ind, car_status, le_ind,
mi_ind, batch_id,
terminal_id, plant_id, yard_id,
scale_weight,
tare, allowable_weight )
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ? )
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
INSERT INTO ym_car_reader_import

( car_init, car_no, process_date,
track_id, position,
forb_ind, car_status, le_ind,
mi_ind, batch_id,
terminal_id, plant_id, yard_id,
scale_weight,
tare, allowable_weight )
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ? )
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:54.811000
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: CH1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 2
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: E
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Y
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 1119868166
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 01
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 16
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_reader_import
(close)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 1119868166
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 01
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: CH1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 2005-06-27
10:30:03.671000
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: E
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 2
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 16
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_reader_summar
y (open for write):
INSERT INTO ym_car_reader_summar
y
( batch_id, terminal_id, track_id,
process_date, start_time,
end_time, forb_ind, process_ind,
cars, plant_id, yard_id )
VALUES ( ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ? )
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
INSERT INTO ym_car_reader_summar
y
( batch_id, terminal_id, track_id,
process_date, start_time,
end_time, forb_ind, process_ind,
cars, plant_id, yard_id )
VALUES ( ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ? )
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_reader_summar
y (close)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it2
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_yard (no script)
E. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Error: [-10002]
ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot
drop the table '#elbat_yraropmet_ym
mud_a_si_siht', because
it does not exist in the system catalog. (ODBC State =3d
42S02, Native error code =3d 3701)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload ym_yard
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_upload
<connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_reader_import
: 2
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_reader_import
: 2
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_reader_summar
y : 1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_reader_summar
y : 1
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET progress =3d
?, publication_name =3d ? WHERE user_id =3d ? AND
subscription_id =3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_upload_time =3d ? WHERE user_id =3d ? AND
subscription_id =3d ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_upload
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
<connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: begin_download
ym_yard (no script)
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Warning: [10056]
There is no download data script defined for table:
ym_car_reader_import
. Synchronization has the risk of
potentially losing download data
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_reader_import
(no script)
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Warning: [10056]
There is no download data script defined for table:
ym_car_reader_summar
y. Synchronization has the risk of
potentially losing download data
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_car_status_dscr (open for read):
SELECT car_status, car_status_desc FROM
ym_car_status_dscr WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT car_status, car_status_desc FROM
ym_car_status_dscr WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_car_status_dscr (close)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_plant (open for read):
SELECT plant_id, plant_name
FROM ym_plant
WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT plant_id, plant_name
FROM ym_plant
WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_plant (close)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download_rows
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_track (open for read):
SELECT track_id, yard_id, plant_id,
track_capacity, track_name
FROM ym_track
WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT track_id, yard_id, plant_id,
track_capacity, track_name
FROM ym_track
WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_track (close)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download_rows
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_yard (open for read):
SELECT yard_id, plant_id, yard_name
FROM ym_yard
WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT yard_id, plant_id, yard_name
FROM ym_yard
WHERE last_modified > ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: download_cursor
ym_yard (close)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download_rows
ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_download
<connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_reader_import
: 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_reader_summar
y : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_status_dscr : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_plant : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_track : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_yard : 0
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_download
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Sending the
download to the remote database.
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Creating download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
003"
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: end_publication
<connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_reader_import
(no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_reader_summar
y (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_status_dscr (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization ym_plant (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization ym_track (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization ym_yard (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]:
end_synchronization <connection> (no script)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_synchronization
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Synchronization
complete
I. 06/27 10:45:48. <Main>: MobiLink server shutting down
I. 06/27 10:45:48. <Main>: MobiLink server undergoing hard
shutdown.
I. 06/27 10:45:48. <Main>: All connections and
synchronizations being terminated.
I. 06/27 10:45:49. <thread 1.5>: Shutting down
I. 06/27 10:45:49. <thread 1.4>: Shutting down
I. 06/27 10:45:49. <thread 1.3>: Shutting down
I. 06/27 10:45:49. <thread 1.2>: Shutting down
I. 06/27 10:45:49. <thread 1.1>: Shutting down
I. 06/27 10:45:50. <Main>: Removing download cache file
" C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
003"
I. 06/27 10:45:50. <Main>: end_connection <connection> (no
script)
I. 06/27 10:45:50. <Main>: COMMIT Transaction:
end_connection
I. 06/27 10:45:50. <Main>: Disconnected from consolidated
database
I. 06/27 10:45:50. <Main>: Disconnected
I. 06/27 10:45:50. <Main>: MobiLink server finished

I would appreciate your help.

Thanks.

Nick Elson

2005-06-27, 11:24 am

Since

#elbat_yraropmet_ymm
ud_a_si_siht

and not one we create, and since

3701 is the MS SQL SERVER error for system
catalog problems:

"Cannot %S_MSG the %S_MSG '%.*ls', because it
does not exist in the system catalog."

I suspect this is due to the commit that occurs at that point
and the 'clean up of temp object' SQL Server does at that
point.

I would look into how that object is used in your design
and why it was expected persist past the usage. I'm leaning
towards that being create in a stored procedure (called by a
trigger) or a trigger defined on one of your tables. The original
design is probably expecting that to be called by another trigger
or procedure but the synchronization order may make that
assumption invalid.

You may need to explicitly drop it or search for bugs
with the Microsoft product (for example BUG #: 16037
with MSSQL 6.5).

HTH

<Yasir Masood> wrote in message news:42c02123.5c94.1681692777@sybase.com...
Hi Guys,

When I try to synchronize my ASA DB to a SQL Server DB. I
get the following error:

Error: [-10002] ODBC: [Microsoft][ODBC SQL Server
Driver][SQL Server]Cannot drop the table
'#elbat_yraropmet_ym
mud_a_si_siht', because it does not
exist in the system catalog. (ODBC State = 42S02, Native
error code = 3701)

I am using ASA Version 9.0.1.2027, Mobilink Version
9.0.1.2027,
PocketBuilder Version 2.0.1.688, SQL Server 2000 - 8.00.818
on Windows NT 5.0 (Build 2195: Service Pack 4), and ODBC
DBMS Driver Version: 03.81.9002.

Here is the output from log file:

I. 06/27 10:29:13. Adaptive Server Anywhere MobiLink Version
9.0.1.2027
I. 06/27 10:29:13.
I. 06/27 10:29:13. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004,
iAnywhere Solutions, Inc.
I. 06/27 10:29:13. All rights reserved. All unpublished
rights reserved.
I. 06/27 10:29:13.
I. 06/27 10:29:13. This software contains confidential and
trade secret information of
I. 06/27 10:29:13. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 06/27 10:29:13. by the U.S. Government is subject to
restrictions set forth in a license
I. 06/27 10:29:13. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 06/27 10:29:13. other written agreement specifying the
Government's rights to use the
I. 06/27 10:29:13. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 06/27 10:29:13.
I. 06/27 10:29:13. iAnywhere Solutions, Inc., One Sybase
Drive, Dublin, CA 94568, USA
I. 06/27 10:29:13.
I. 06/27 10:29:13. Networked Seat (per-seat) model. Access
to the server is limited to 1 seat(s).
This server is licensed to:
I. 06/27 10:29:13. Developer Edition
I. 06/27 10:29:13. Restricted Use
I. 06/27 10:29:13. <Main>: MobiLink server started
I. 06/27 10:29:13. <Main>: Option 1: -c
I. 06/27 10:29:13. <Main>: Option 2: ****************
I. 06/27 10:29:13. <Main>: Option 3: -x
I. 06/27 10:29:13. <Main>: Option 4: tcpip{port=2439}
I. 06/27 10:29:13. <Main>: Option 5: -v+
I. 06/27 10:29:13. <Main>: Option 6: -fr
I. 06/27 10:29:13. <Main>: Verbose logging: show row values
I. 06/27 10:29:13. <Main>: Verbose logging: show script
names when invoked
I. 06/27 10:29:13. <Main>: Verbose logging: show script
contents when invoked
I. 06/27 10:29:13. <Main>: Verbose logging: show schema for
each table
I. 06/27 10:29:13. <Main>: Verbose logging: show an error
when the first read of a synchronization fails
I. 06/27 10:29:13. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 06/27 10:29:13. <Main>: Verbose logging: show rowcount
values
I. 06/27 10:29:13. <Main>: Individual database connections
will be closed after synchronization errors.
I. 06/27 10:29:13. <Main>: BLOB cache size: 524288
I. 06/27 10:29:13. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 06/27 10:29:13. <Main>: Maximum number of database
connections: 6
I. 06/27 10:29:13. <Main>: Maximum number of deadlock
retries: 10
I. 06/27 10:29:13. <Main>: Timeout for inactive database
connections: 60 minutes
I. 06/27 10:29:13. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 06/27 10:29:13. <Main>: Rowset size: 10
I. 06/27 10:29:13. <Main>: Upload cache size: 524288 bytes
I. 06/27 10:29:13. <Main>: Download cache memory size:
1048576 bytes
I. 06/27 10:29:13. <Main>: Download cache directory size:
10485760 bytes
I. 06/27 10:29:13. <Main>: Number of worker threads: 5
I. 06/27 10:29:13. <Main>: Maximum number of threads
uploading concurrently: 5
I. 06/27 10:29:13. <Main>: Unknown users will be rejected
(when there is no authenticate_user script).
I. 06/27 10:29:13. <Main>: Example scripts will not be
automatically generated for unknown versions.
I. 06/27 10:29:13. <Main>: Local file for remote
synchronization logs: 'dbmlsrv.mle'
I. 06/27 10:29:13. <Main>: Stream specifier 1:
tcpip{port=2439}
W. 06/27 10:29:13. <Main>: Warning: [10050] ODBC:
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed
database context to 'YMOL_TEST'. (ODBC State = 01000,
Native error code = 5701)
W. 06/27 10:29:13. <Main>: Warning: [10050] ODBC:
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed
language setting to us_english. (ODBC State = 01000,
Native error code = 5703)
I. 06/27 10:29:13. <Main>: ODBC DBMS Name: Microsoft SQL
Server
I. 06/27 10:29:13. <Main>: ODBC DBMS Version: 08.00.0818
I. 06/27 10:29:13. <Main>: ODBC DBMS Driver Version:
03.81.9002
I. 06/27 10:29:13. <Main>: ODBC Version supported by the
driver: 3.52
I. 06/27 10:29:13. <Main>: Collation sequence of the
consolidated database is 'Code Page 437'
I. 06/27 10:29:13. <Main>: ODBC isolation set to: Read
Committed
I. 06/27 10:29:13. <Main>: Connected
I. 06/27 10:29:13. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 06/27 10:29:13. <thread 1.1>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.2>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.3>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.4>: Ready to handle requests
I. 06/27 10:29:13. <thread 1.5>: Ready to handle requests
I. 06/27 10:29:29. <thread 1.5>: Working on a request
I. 06/27 10:29:29. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 06/27 10:29:29. <thread 1.5>: ml_scripts_modified last
modified at: 2005-06-23 16:39:31.973
I. 06/27 10:29:29. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version
WHERE name = ?
I. 06/27 10:29:29. <thread 1.5>: ASA synchronization request
from: ml_scan_YASIR (version: scan_default)
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10050]
ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
database context to 'YMOL_TEST'. (ODBC State = 01000,
Native error code = 5701)
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10050]
ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
language setting to us_english. (ODBC State = 01000,
Native error code = 5703)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: ODBC isolation set
to: Read Committed
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_connection
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_connection
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
= ?
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Publication #1:
scanvisit, subscription id: 3, last download time:
2005-06-27 10:23:18.093000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Table #1:
ym_car_id, 5 columns
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_id' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #5:
varchar(20)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Table #2:
ym_visit, 7 columns
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_visit' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #5: char(2)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #6: char(1)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Column #7:
char(10)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are explicitly involved in the
current synchronization
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Subscription id 3:
consolidated progress 372758 and remote progress 372758
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are not explicitly involved in the
current synchronization
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Subscription id 2:
consolidated progress 373580 and remote progress 373580
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_download_time = ?, publication_name = ? WHERE
user_id = ? AND subscription_id = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
= ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
= ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n <connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id = ? AND subscription_id =
?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Last upload time
for subscription id 3: 2005-06-27 10:23:18.093000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_publication
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_synchronizatio
n
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:29.452000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (open for write):
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (close)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran dt1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Deleted row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 2005-06-27
10:23:18.546000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (open for write):
DELETE FROM ym_car_id
WHERE car_init = ?
AND car_no = ?
AND process_date = ?
AND plant_id = ?
AND app_name = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
DELETE FROM ym_car_id
WHERE car_init = ?
AND car_no = ?
AND process_date = ?
AND plant_id = ?
AND app_name = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (close)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_upload
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_id : 2
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_id : 1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_id : 1
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET progress =
?, publication_name = ? WHERE user_id = ? AND
subscription_id = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_upload_time = ? WHERE user_id = ? AND
subscription_id = ?
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_upload
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_download
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_download
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: begin_download
ym_visit (no script)
W. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Warning: [10056]
There is no download data script defined for table:
ym_car_id. Synchronization has the risk of potentially
losing download data
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (open for read):
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init = B.car_init
AND A.car_no = B.car_no
AND A.plant_id = B.plant_id
AND A.plant_status <> 'S'
AND B.app_name = 'SCAN'
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init = B.car_init
AND A.car_no = B.car_no
AND A.plant_id = B.plant_id
AND A.plant_status <> 'S'
AND B.app_name = 'SCAN'
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 2005-05-06
16:23:25.677000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 1999-05-09
12:00:00.000000
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: PE
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: E
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (close)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download_rows
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download
ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download
ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_download
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_id : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_visit : 2
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_visit : 0
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_visit : 2
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_download
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Sending the
download to the remote database.
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Creating download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
001"
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: end_publication
<connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_id (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_synchronization ym_visit (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]:
end_synchronization <connection> (no script)
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_synchronization
I. 06/27 10:29:30. <1.5> [ml_scan_YASIR]: Synchronization
complete
I. 06/27 10:29:52. <thread 1.5>: Working on a request
I. 06/27 10:29:52. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 06/27 10:29:52. <thread 1.5>: ASA synchronization request
from: ml_scan_YASIR (version: scan_default)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
= ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Removing download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
001"
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 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. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Publication #1:
scanvisit, subscription id: 3, last download time:
2005-06-27 10:29:29.147000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Table #1:
ym_car_id, 5 columns
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_id' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #5:
varchar(20)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Table #2:
ym_visit, 7 columns
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_visit' has at least one timestamp column. Due to
a timestamp precision mismatch, uploaded timestamps can lose
precision, defeating download filtering
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #4:
char(10)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #5: char(2)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #6: char(1)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Column #7:
char(10)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are explicitly involved in the
current synchronization
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Subscription id 3:
consolidated progress 374756 and remote progress 374756
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Progress offsets
for the publications that are not explicitly involved in the
current synchronization
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Subscription id 2:
consolidated progress 373580 and remote progress 373580
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_download_time = ?, publication_name = ? WHERE
user_id = ? AND subscription_id = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n <connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_synchronizatio
n ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id = ? AND subscription_id =
?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Last upload time
for subscription id 3: 2005-06-27 10:29:29.130000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_publication
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: begin_synchronizatio
n
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Inserted row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:51.936000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (open for write):
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
INSERT INTO ym_car_id
( car_init, car_no, process_date,
plant_id, app_name )
VALUES ( ?, ?, ?, ?, ?)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_insert
ym_car_id (close)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_upload_rows
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran it1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload_rows
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
save tran dt1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Deleted row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000002
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-06-27
10:29:29.452000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: SCAN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (open for write):
DELETE FROM ym_car_id
WHERE car_init = ?
AND car_no = ?
AND process_date = ?
AND plant_id = ?
AND app_name = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
DELETE FROM ym_car_id
WHERE car_init = ?
AND car_no = ?
AND process_date = ?
AND plant_id = ?
AND app_name = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: upload_delete
ym_car_id (close)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload_deletes
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_upload
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_car_id : 2
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_car_id : 1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_car_id : 1
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows uploaded
into table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows inserted
into table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows deleted in
table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows updated
into table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows conflicted
in table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows ignored in
table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET progress =
?, publication_name = ? WHERE user_id = ? AND
subscription_id = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
UPDATE ml_subscription SET
last_upload_time = ? WHERE user_id = ? AND
subscription_id = ?
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_upload
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT {FN NOW()}
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_download
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_download
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: begin_download
ym_visit (no script)
W. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Warning: [10056]
There is no download data script defined for table:
ym_car_id. Synchronization has the risk of potentially
losing download data
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download_rows
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_delet
es ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_download_deletes
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
begin_download_rows ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (open for read):
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init = B.car_init
AND A.car_no = B.car_no
AND A.plant_id = B.plant_id
AND A.plant_status <> 'S'
AND B.app_name = 'SCAN'
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT A.car_init, A.car_no,
A.arrv_date_time, A.plant_status,
A.car_status, A.le_ind,
A.plant_id
FROM ym_visit A, ym_car_id B
WHERE A.car_init = B.car_init
AND A.car_no = B.car_no
AND A.plant_id = B.plant_id
AND A.plant_status <> 'S'
AND B.app_name = 'SCAN'
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-05-06
16:23:25.677000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Insert/Update row:
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: RAGX
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 000003
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 2005-05-06
16:23:25.677000
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: I
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: UN
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: U
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: 10
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: download_cursor
ym_visit (close)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download_rows
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download
ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download
ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_download
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_car_id : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for delete from table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
for insert/update from table ym_visit : 2
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows filtered
for download from table ym_visit : 0
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: # rows downloaded
to remote from table ym_visit : 2
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_download
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Sending the
download to the remote database.
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Creating download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
002"
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: end_publication
<connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_synchronization ym_car_id (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_synchronization ym_visit (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]:
end_synchronization <connection> (no script)
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: COMMIT
Transaction: end_synchronization
I. 06/27 10:29:52. <1.5> [ml_scan_YASIR]: Synchronization
complete
I. 06/27 10:30:04. <thread 1.5>: Working on a request
I. 06/27 10:30:04. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 06/27 10:30:06. <thread 1.5>: ASA synchronization request
from: ml_scan_YASIR (version: scan_default)
I. 06/27 10:30:06. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name = ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT user_id FROM ml_user WHERE name
= ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Removing download
cache file " C:\DOCUME~1\yasirm\L
OCALS~1\Temp\rd00000
002"
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: 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. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Publication #1:
scan, subscription id: 2, last download time: 2005-06-27
10:23:35.217000
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #1:
ym_car_reader_import
, 16 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1: char(4)
NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2: char(6)
NOT NULL PRIMARY KEY
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_reader_impor
t' has at least one timestamp
column. Due to a timestamp precision mismatch, uploaded
timestamps can lose precision, defeating download filtering
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
timestamp NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #4:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #5:
numeric(3,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #6: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #7: char(2)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #8: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #9: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #10:
integer
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #11:
varchar(8)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #12:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #13:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #14:
numeric(6,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #15:
numeric(6,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #16:
numeric(6,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #2:
ym_car_reader_summar
y, 11 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1: integer
NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
varchar(8) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
char(10)
W. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Warning: [10015]
Table 'ym_car_reader_summa
ry' has at least one timestamp
column. Due to a timestamp precision mismatch, uploaded
timestamps can lose precision, defeating download filtering
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #4:
timestamp
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #5:
timestamp
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #6:
timestamp
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #7: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #8: char(1)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #9:
numeric(4,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #10:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #11:
char(10)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #3:
ym_car_status_dscr, 2 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1: char(2)
NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(30) NOT NULL
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #4:
ym_plant, 2 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(30)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #5:
ym_track, 5 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #4:
numeric(3,0)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #5:
char(30)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Table #6: ym_yard,
3 columns
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #1:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #2:
char(10) NOT NULL PRIMARY KEY
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Column #3:
char(30)
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 06/27 10:30:07. <1.5> [ml_scan_YASIR]: Translated SQL:
SELECT progress FROM ml_subscription
WHE