|
Home > Archive > SQL Anywhere Mobile > October 2005 > Column check constraints problem ????
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Column check constraints problem ????
|
|
|
| Hi,
We got the dbmlsynch error message:
E. 10/21 10:01:41. SQL statement failed: (-209) Constraint
'ASA96' violated: Invalid value for column 'Column2' in
table 'Table2' => no data was inserted into table.
However when we extract and reload from ssremote there are
no problem, and all data was load to table.
Event, we try to run insert statement and it take all the
rows without any error message.
Any idea ????
Thanks
| |
| David Fishburn 2005-10-27, 8:21 am |
| Toni wrote in news:4358fd5b.73a.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
T> We got the dbmlsynch error message:
T>
T> E. 10/21 10:01:41. SQL statement failed: (-209) Constraint
T> 'ASA96' violated: Invalid value for column 'Column2' in
T> table 'Table2' => no data was inserted into table.
T>
T> However when we extract and reload from ssremote there are
T> no problem, and all data was load to table.
T> Event, we try to run insert statement and it take all the
T> rows without any error message.
Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).
Start ML using -vcrsn -ot ml.txt
Start dbmlsync -v+ -o rem.txt
Post both outputs.
That should provide a good start for us with the information we need.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
|
| Hi David,
We are using ASE12.5 on unix vs ASA901.2009 on xp, and we
are having both dbmlsr9 and dbmlsynch are running on windows
xp and on the same pc.
The output of both dbmlsr9 & dbmlsynch:
dbmlsr9:
I. 10/24 09:45:59. Adaptive Server Anywhere MobiLink Version
9.0.1.2009
I. 10/24 09:45:59. <Main>: MobiLink server started
I. 10/24 09:45:59. <Main>: Option 1: -c
I. 10/24 09:45:59. <Main>: Option 2: ****************
I. 10/24 09:45:59. <Main>: Option 3: -vcrsn
I. 10/24 09:45:59. <Main>: Option 4: -v+
I. 10/24 09:45:59. <Main>: Option 5: -zp
I. 10/24 09:45:59. <Main>: Option 6: -za
I. 10/24 09:45:59. <Main>: Option 7: -zu+
I. 10/24 09:45:59. <Main>: Option 8: -x
I. 10/24 09:45:59. <Main>: Option 9: tcpip
I. 10/24 09:45:59. <Main>: Verbose logging: show row values
I. 10/24 09:45:59. <Main>: Verbose logging: show script
names when invoked
I. 10/24 09:45:59. <Main>: Verbose logging: show script
contents when invoked
I. 10/24 09:45:59. <Main>: Verbose logging: show schema for
each table
I. 10/24 09:45:59. <Main>: Verbose logging: show an error
when the first read of a synchronization fails
I. 10/24 09:45:59. <Main>: Verbose logging: show translated
SQL for prepared statements
I. 10/24 09:45:59. <Main>: Verbose logging: show rowcount
values
I. 10/24 09:45:59. <Main>: Individual database connections
will be closed after synchronization errors.
I. 10/24 09:45:59. <Main>: BLOB cache size: 524288
I. 10/24 09:45:59. <Main>: Maximum number of BLOB bytes to
compare: 4294967295
I. 10/24 09:45:59. <Main>: Maximum number of database
connections: 6
I. 10/24 09:45:59. <Main>: Maximum number of deadlock
retries: 10
I. 10/24 09:45:59. <Main>: Timeout for inactive database
connections: 60 minutes
I. 10/24 09:45:59. <Main>: Maximum delay between retries
after deadlock: 30 seconds
I. 10/24 09:45:59. <Main>: Rowset size: 10
I. 10/24 09:45:59. <Main>: Upload cache size: 524288 bytes
I. 10/24 09:45:59. <Main>: Download cache memory size:
1048576 bytes
I. 10/24 09:45:59. <Main>: Download cache directory size:
10485760 bytes
I. 10/24 09:45:59. <Main>: Number of worker threads: 5
I. 10/24 09:45:59. <Main>: Maximum number of threads
uploading concurrently: 5
W. 10/24 09:45:59. <Main>: Warning: Unknown users will be
added automatically (when there is no authenticate_user
script).
I. 10/24 09:45:59. <Main>: Warning: Example scripts may be
automatically generated and activated for unknown versions.
I. 10/24 09:45:59. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 10/24 09:45:59. <thread 1.1>: Ready to handle requests
I. 10/24 09:45:59. <thread 1.2>: Ready to handle requests
I. 10/24 09:45:59. <thread 1.3>: Ready to handle requests
I. 10/24 09:45:59. <thread 1.4>: Ready to handle requests
I. 10/24 09:45:59. <thread 1.5>: Ready to handle requests
I. 10/24 09:47:10. <thread 1.5>: Working on a request
I. 10/24 09:47:10. <thread 1.5>: Translated SQL:
SELECT last_modified FROM
ml_scripts_modified
I. 10/24 09:47:10. <thread 1.5>: ml_scripts_modified last
modified at: 2005-10-21 10:06:47.733
I. 10/24 09:47:10. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version
WHERE name = ?
I. 10/24 09:47:10. <thread 1.5>: ASA synchronization request
from: user1 (version: ver2)
I. 10/24 09:47:10. <1.5> [user1]: ODBC isolation set to:
Read Committed
I. 10/24 09:47:10. <1.5> [user1]: 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. 10/24 09:47:10. <1.5> [user1]: begin_connection
<connection> (no script)
I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
begin_connection
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE
name = ?
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT user_id FROM ml_user WHERE name =
?
I. 10/24 09:47:10. <1.5> [user1]: Publication #1: pub,
subscription id: 8, last download time: 2005-10-21
09:08:15.810000
I. 10/24 09:47:10. <1.5> [user1]: Table #1: table1, 3
columns
I. 10/24 09:47:10. <1.5> [user1]: Column1 char(10) NOT NULL
PRIMARY KEY
I. 10/24 09:47:10. <1.5> [user1]: Column2 varchar(70) NOT
NULL
I. 10/24 09:47:10. <1.5> [user1]: Column3 timestamp NOT NULL
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT progress FROM ml_subscription
WHERE user_id = ? AND subscription_id = ?
I. 10/24 09:47:10. <1.5> [user1]: Progress offsets for the
publications that are explicitly involved in the current
synchronization
I. 10/24 09:47:10. <1.5> [user1]: Subscription id 8:
consolidated progress 4051230 and remote progress 4051230
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
UPDATE ml_subscription SET
last_download_time = ?, publication_name = ? WHERE user_id =
? AND subscription_id = ?
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT table_id FROM ml_table WHERE name
= ?
I. 10/24 09:47:10. <1.5> [user1]: begin_synchronizatio
n
<connection> (no script)
I. 10/24 09:47:10. <1.5> [user1]: 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. 10/24 09:47:10. <1.5> [user1]: begin_synchronizatio
n
table1 (no script)
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT last_upload_time FROM
ml_subscription WHERE user_id = ? AND subscription_id = ?
I. 10/24 09:47:10. <1.5> [user1]: Last upload time for
subscription id 8: 2005-10-21 12:15:00.006000
I. 10/24 09:47:10. <1.5> [user1]: begin_publication
<connection> (no script)
I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
begin_synchronizatio
n
I. 10/24 09:47:10. <1.5> [user1]: begin_upload <connection>
(no script)
I. 10/24 09:47:10. <1.5> [user1]: begin_upload table1 (no
script)
I. 10/24 09:47:10. <1.5> [user1]: begin_upload_rows table1
(no script)
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
save tran it0
I. 10/24 09:47:10. <1.5> [user1]: end_upload_rows table1 (no
script)
I. 10/24 09:47:10. <1.5> [user1]: end_upload table1 (no
script)
I. 10/24 09:47:10. <1.5> [user1]: end_upload <connection>
(no script)
I. 10/24 09:47:10. <1.5> [user1]: # rows uploaded into table
table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows inserted into table
table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows deleted in table
table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows updated into table
table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows conflicted in table
table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows ignored in table
table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
UPDATE ml_subscription SET progress = ?,
publication_name = ? WHERE user_id = ? AND subscription_id =
?
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT GETDATE()
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
UPDATE ml_subscription SET
last_upload_time = ? WHERE user_id = ? AND subscription_id =
?
I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
end_upload
I. 10/24 09:47:10. <1.5> [user1]: Cached ODBC statement:
SELECT {FN NOW()}
I. 10/24 09:47:10. <1.5> [user1]: begin_download
<connection> (no script)
I. 10/24 09:47:10. <1.5> [user1]: begin_download table1 (no
script)
I. 10/24 09:47:10. <1.5> [user1]: begin_download_delet
es
table1 (no script)
I. 10/24 09:47:10. <1.5> [user1]: end_download_deletes
table1 (no script)
I. 10/24 09:47:10. <1.5> [user1]: begin_download_rows table1
(no script)
I. 10/24 09:47:10. <1.5> [user1]: download_cursor table1
(open for read):
SELECT Column1, Column2, Column3
FROM table1
I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
SELECT Column1, Column2, Column3
FROM table1
I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
I. 10/24 09:47:10. <1.5> [user1]: ABCDE
I. 10/24 09:47:10. <1.5> [user1]:
AAAAAAAAAAAAAAAAAAAA
AAAAA
I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
00:00:00.000000
I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
I. 10/24 09:47:10. <1.5> [user1]: WXYZ
I. 10/24 09:47:10. <1.5> [user1]: BBBBBBBBBBBBBBBBBBBB
BBB
I. 10/24 09:47:10. <1.5> [user1]: 1998-12-04
00:00:00.000000
I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
I. 10/24 09:47:10. <1.5> [user1]: OFO
I. 10/24 09:47:10. <1.5> [user1]: CCCCCCCCCCCCCCCCCC
I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
00:00:00.000000
I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
I. 10/24 09:47:10. <1.5> [user1]: IJK
I. 10/24 09:47:10. <1.5> [user1]: DDDDDDDDDDDDDDDDDD
I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
00:00:00.000000
I. 10/24 09:47:10. <1.5> [user1]: download_cursor table1
(close)
I. 10/24 09:47:10. <1.5> [user1]: end_download_rows table1
(no script)
I. 10/24 09:47:10. <1.5> [user1]: end_download table1 (no
script)
I. 10/24 09:47:10. <1.5> [user1]: end_download <connection>
(no script)
I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded for
delete from table table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded for
insert/update from table table1 : 4
I. 10/24 09:47:10. <1.5> [user1]: # rows filtered for
download from table table1 : 0
I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded to
remote from table table1 : 4
I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
end_download
I. 10/24 09:47:10. <1.5> [user1]: Sending the download to
the remote database.
I. 10/24 09:47:10. <1.5> [user1]: end_publication
<connection> (no script)
I. 10/24 09:47:10. <1.5> [user1]: end_synchronization table1
(no script)
I. 10/24 09:47:10. <1.5> [user1]: end_synchronization
<connection> (no script)
I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
end_synchronization
I. 10/24 09:47:10. <1.5> [user1]: Synchronization complete
====================
====================
==================
dbmlsynch:
I. 10/24 09:47:09. Synchronization Started
I. 10/24 09:47:09. 1: -c
I. 10/24 09:47:09. 2: ********************
************
I. 10/24 09:47:09. 3: -v+
I. 10/24 09:47:09. 4: -e
I. 10/24 09:47:09. 5: SendColumnNames=on
I. 10/24 09:47:09. Adaptive Server Anywhere MobiLink
Synchronization Version 9.0.1.2009
I. 10/24 09:47:09. Connecting to remote database
I. 10/24 09:47:09. Loading synchronization information
I. 10/24 09:47:09. Options in database for subscription to
'pub' for 'user1':
I. 10/24 09:47:09. scriptversion=ver2;
I. 10/24 09:47:09. Options in database for subscription to
'pub' for 'user1':
I. 10/24 09:47:09. scriptversion=ver2;
I. 10/24 09:47:09. Options in database for subscription to
'pub' for 'user1':
I. 10/24 09:47:09. scriptversion=ver2;
I. 10/24 09:47:09. Begin synchronizing 'pub' for MobiLink
user 'user1'
I. 10/24 09:47:09. Options for this synchronization:
I. 10/24 09:47:09.
SCN='YES',SV='ver2',
CTP='TCPIP',ADR='hos
t=localhost'
I. 10/24 09:47:09. Log scan starting at offset 0004051230
I. 10/24 09:47:09. Processing transactions from active
transaction log
I. 10/24 09:47:09. Hovering at end of active log
I. 10/24 09:47:09. Connecting to MobiLink server at
'host=localhost' using 'dbmlsock9.dll'
I. 10/24 09:47:10. Uploading header
I. 10/24 09:47:10. Stream version: 529
I. 10/24 09:47:10. Processor is little-endian
I. 10/24 09:47:10. Character set: cp1252
I. 10/24 09:47:10. MobiLink user name: user1
I. 10/24 09:47:10. Script version: ver2
I. 10/24 09:47:10. Synchronization ID: 1630770949
I. 10/24 09:47:10. Publication 'pub' - Synchronizing - Log
offset 0004051230 - Last download time 2005-10-21
09:08:15.81.
I. 10/24 09:47:10. Begin upload
I. 10/24 09:47:10. Uploading publication definition(s)
I. 10/24 09:47:10. Article table: table1
I. 10/24 09:47:10. Article column: Column1
I. 10/24 09:47:10. Article column: Column2
I. 10/24 09:47:10. Article column: Column3
I. 10/24 09:47:10. Table Upload Order: table1
I. 10/24 09:47:10. Uploading table operations
I. 10/24 09:47:10. Upload operations on table 'table1'
I. 10/24 09:47:10. # rows inserted in table table1 : 0
I. 10/24 09:47:10. # rows deleted in table table1 : 0
I. 10/24 09:47:10. # rows updated in table table1 : 0
I. 10/24 09:47:10. Log scan ended at offset 0004056287
I. 10/24 09:47:10. Waiting for MobiLink to apply upload
I. 10/24 09:47:10. The user authentication value is 1000.
I. 10/24 09:47:10. Setting last upload time to 2005-10-24
09:47:27.01.
I. 10/24 09:47:10. Setting generation number for publication
pub to 1.
I. 10/24 09:47:10. COMMIT
I. 10/24 09:47:10. Download stream: received 237 bytes from
MobiLink Server.
I. 10/24 09:47:10. Processing download stream ...
I. 10/24 09:47:10. Downloading into table: table1
I. 10/24 09:47:10. Insert/Update row:
I. 10/24 09:47:10. ABCDE
I. 10/24 09:47:10. AAAAAAAAAAAAAAAAAAAA
AAAAA
I. 10/24 09:47:10. 1998-02-09 00:00:00.0
I. 10/24 09:47:10. Insert/Update row:
I. 10/24 09:47:10. WXYZ
I. 10/24 09:47:10. BBBBBBBBBBBBBBBBBBBB
BBB
I. 10/24 09:47:10. 1998-12-04 00:00:00.0
I. 10/24 09:47:10. Insert/Update row:
I. 10/24 09:47:10. FGH
I. 10/24 09:47:10. CCCCCCCCCCCCCCCCCC
I. 10/24 09:47:10. 1998-02-09 00:00:00.0
I. 10/24 09:47:10. Insert/Update row:
I. 10/24 09:47:10. IJK
I. 10/24 09:47:10. DDDDDDDDDDDDDDDDDD
I. 10/24 09:47:10. 1998-02-09 00:00:00.0
I. 10/24 09:47:10. # rows inserted/updated into table table1
: 4
I. 10/24 09:47:10. # rows deleted in table table1 : 0
E. 10/24 09:47:10. SQL statement failed: (-209) Constraint
'ASA154' violated: Invalid value for column 'Column1' in
table 'table1'
I. 10/24 09:47:10. ROLLBACK
I. 10/24 09:47:10. Download stream processing failed
I. 10/24 09:47:10. End synchronizing 'pub' for MobiLink user
'user1'
I. 10/24 09:47:10. Disconnecting from MobiLink server
I. 10/24 09:47:10. Complete log scan required.
I. 10/24 09:47:10. Synchronization completed
I. 10/24 09:47:10. Options in database for subscription to
'pub' for 'user1':
I. 10/24 09:47:10. scriptversion=ver2;
I. 10/24 09:47:10. Disconnecting from remote database
| |
| Greg Fenton 2005-10-27, 8:21 am |
| Toni wrote:
> E. 10/24 09:47:10. SQL statement failed: (-209) Constraint
> 'ASA154' violated: Invalid value for column 'Column1' in
> table 'table1'
Can you do a "dbunload -n" (no data) of the remote database and check
what the ASA154 constraint is?
If you still aren't sure what the problem is, can you post the schema?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| Hi Greg,
The check constraints is real check, however, the previous
output we need to edit data bc it is real data.
thanks,
The check constraints:
check(Column1 like '[S][0-9][0-9][0-9]' or
Column1 like '[F][0-9][0-9][0-9]' or
Column1 like '[D][0-9][0-9][0-9]')
> Toni wrote:
>
> Can you do a "dbunload -n" (no data) of the remote
> database and check what the ASA154 constraint is?
>
> If you still aren't sure what the problem is, can you post
> the schema?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| David Fishburn 2005-10-27, 8:21 am |
| Toni wrote in news:435cebec.5315.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
T> Hi David,
T>
T> We are using ASE12.5 on unix vs ASA901.2009 on xp, and we
T> are having both dbmlsr9 and dbmlsynch are running on windows
T> xp and on the same pc.
T>
T> The output of both dbmlsr9 & dbmlsynch:
T>
T> dbmlsr9:
T>
T> I. 10/24 09:45:59. Adaptive Server Anywhere MobiLink Version
T> 9.0.1.2009
T> I. 10/24 09:45:59. <Main>: MobiLink server started
T> I. 10/24 09:45:59. <Main>: Option 1: -c
T> I. 10/24 09:45:59. <Main>: Option 2: ****************
T> I. 10/24 09:45:59. <Main>: Option 3: -vcrsn
T> I. 10/24 09:45:59. <Main>: Option 4: -v+
T> I. 10/24 09:45:59. <Main>: Option 5: -zp
T> I. 10/24 09:45:59. <Main>: Option 6: -za
T> I. 10/24 09:45:59. <Main>: Option 7: -zu+
T> I. 10/24 09:45:59. <Main>: Option 8: -x
T> I. 10/24 09:45:59. <Main>: Option 9: tcpip
T> I. 10/24 09:45:59. <Main>: Verbose logging: show row values
T> I. 10/24 09:45:59. <Main>: Verbose logging: show script
T> names when invoked
T> I. 10/24 09:45:59. <Main>: Verbose logging: show script
T> contents when invoked
T> I. 10/24 09:45:59. <Main>: Verbose logging: show schema for
T> each table
T> I. 10/24 09:45:59. <Main>: Verbose logging: show an error
T> when the first read of a synchronization fails
T> I. 10/24 09:45:59. <Main>: Verbose logging: show translated
T> SQL for prepared statements
T> I. 10/24 09:45:59. <Main>: Verbose logging: show rowcount
T> values
T> I. 10/24 09:45:59. <Main>: Individual database connections
T> will be closed after synchronization errors.
T> I. 10/24 09:45:59. <Main>: BLOB cache size: 524288
T> I. 10/24 09:45:59. <Main>: Maximum number of BLOB bytes to
T> compare: 4294967295
T> I. 10/24 09:45:59. <Main>: Maximum number of database
T> connections: 6
T> I. 10/24 09:45:59. <Main>: Maximum number of deadlock
T> retries: 10
T> I. 10/24 09:45:59. <Main>: Timeout for inactive database
T> connections: 60 minutes
T> I. 10/24 09:45:59. <Main>: Maximum delay between retries
T> after deadlock: 30 seconds
T> I. 10/24 09:45:59. <Main>: Rowset size: 10
T> I. 10/24 09:45:59. <Main>: Upload cache size: 524288 bytes
T> I. 10/24 09:45:59. <Main>: Download cache memory size:
T> 1048576 bytes
T> I. 10/24 09:45:59. <Main>: Download cache directory size:
T> 10485760 bytes
T> I. 10/24 09:45:59. <Main>: Number of worker threads: 5
T> I. 10/24 09:45:59. <Main>: Maximum number of threads
T> uploading concurrently: 5
T> W. 10/24 09:45:59. <Main>: Warning: Unknown users will be
T> added automatically (when there is no authenticate_user
T> script).
T> I. 10/24 09:45:59. <Main>: Warning: Example scripts may be
T> automatically generated and activated for unknown versions.
T> I. 10/24 09:45:59. <Main>: Translated SQL:
T> SELECT COUNT(*) FROM ml_scripts_modified
T> I. 10/24 09:45:59. <thread 1.1>: Ready to handle requests
T> I. 10/24 09:45:59. <thread 1.2>: Ready to handle requests
T> I. 10/24 09:45:59. <thread 1.3>: Ready to handle requests
T> I. 10/24 09:45:59. <thread 1.4>: Ready to handle requests
T> I. 10/24 09:45:59. <thread 1.5>: Ready to handle requests
T> I. 10/24 09:47:10. <thread 1.5>: Working on a request
T> I. 10/24 09:47:10. <thread 1.5>: Translated SQL:
T> SELECT last_modified FROM
T> ml_scripts_modified
T> I. 10/24 09:47:10. <thread 1.5>: ml_scripts_modified last
T> modified at: 2005-10-21 10:06:47.733
T> I. 10/24 09:47:10. <thread 1.5>: Translated SQL:
T> SELECT version_id FROM ml_script_version
T> WHERE name = ?
T> I. 10/24 09:47:10. <thread 1.5>: ASA synchronization request
T> from: user1 (version: ver2)
T> I. 10/24 09:47:10. <1.5> [user1]: ODBC isolation set to:
T> Read Committed
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT t1.event, t2.script_language,
T> t2.script FROM ml_connection_script
t1, ml_script t2 WHERE
T> t1.version_id = ? AND t1.script_id = t2.script_id
T> I. 10/24 09:47:10. <1.5> [user1]: begin_connection
T> <connection> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
T> begin_connection
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT hashed_password FROM ml_user WHERE
T> name = ?
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT user_id FROM ml_user WHERE name =
T> ?
T> I. 10/24 09:47:10. <1.5> [user1]: Publication #1: pub,
T> subscription id: 8, last download time: 2005-10-21
T> 09:08:15.810000
T> I. 10/24 09:47:10. <1.5> [user1]: Table #1: table1, 3
T> columns
T> I. 10/24 09:47:10. <1.5> [user1]: Column1 char(10) NOT NULL
T> PRIMARY KEY
T> I. 10/24 09:47:10. <1.5> [user1]: Column2 varchar(70) NOT
T> NULL
T> I. 10/24 09:47:10. <1.5> [user1]: Column3 timestamp NOT NULL
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT progress FROM ml_subscription
T> WHERE user_id = ? AND subscription_id = ?
T> I. 10/24 09:47:10. <1.5> [user1]: Progress offsets for the
T> publications that are explicitly involved in the current
T> synchronization
T> I. 10/24 09:47:10. <1.5> [user1]: Subscription id 8:
T> consolidated progress 4051230 and remote progress 4051230
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> UPDATE ml_subscription SET
T> last_download_time = ?, publication_name = ? WHERE user_id =
T> ? AND subscription_id = ?
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT table_id FROM ml_table WHERE name
T> = ?
T> I. 10/24 09:47:10. <1.5> [user1]: begin_synchronizatio
n
T> <connection> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT t1.event, t2.script_language,
T> t2.script FROM ml_table_script t1, ml_script t2 WHERE
T> t1.table_id = ? AND t1.version_id = ? AND t1.script_id =
T> t2.script_id
T> I. 10/24 09:47:10. <1.5> [user1]: begin_synchronizatio
n
T> table1 (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT last_upload_time FROM
T> ml_subscription WHERE user_id = ? AND subscription_id = ?
T> I. 10/24 09:47:10. <1.5> [user1]: Last upload time for
T> subscription id 8: 2005-10-21 12:15:00.006000
T> I. 10/24 09:47:10. <1.5> [user1]: begin_publication
T> <connection> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
T> begin_synchronizatio
n
T> I. 10/24 09:47:10. <1.5> [user1]: begin_upload <connection>
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: begin_upload table1 (no
T> script)
T> I. 10/24 09:47:10. <1.5> [user1]: begin_upload_rows table1
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> save tran it0
T> I. 10/24 09:47:10. <1.5> [user1]: end_upload_rows table1 (no
T> script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_upload table1 (no
T> script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_upload <connection>
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: # rows uploaded into table
T> table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows inserted into table
T> table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows deleted in table
T> table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows updated into table
T> table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows conflicted in table
T> table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows ignored in table
T> table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> UPDATE ml_subscription SET progress = ?,
T> publication_name = ? WHERE user_id = ? AND subscription_id =
T> ?
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT GETDATE()
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> UPDATE ml_subscription SET
T> last_upload_time = ? WHERE user_id = ? AND subscription_id =
T> ?
T> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
T> end_upload
T> I. 10/24 09:47:10. <1.5> [user1]: Cached ODBC statement:
T> SELECT {FN NOW()}
T> I. 10/24 09:47:10. <1.5> [user1]: begin_download
T> <connection> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: begin_download table1 (no
T> script)
T> I. 10/24 09:47:10. <1.5> [user1]: begin_download_delet
es
T> table1 (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_download_deletes
T> table1 (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: begin_download_rows table1
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: download_cursor table1
T> (open for read):
T> SELECT Column1, Column2, Column3
T> FROM table1
T> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
T> SELECT Column1, Column2, Column3
T> FROM table1
T> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
T> I. 10/24 09:47:10. <1.5> [user1]: ABCDE
T> I. 10/24 09:47:10. <1.5> [user1]:
T> AAAAAAAAAAAAAAAAAAAA
AAAAA
T> I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
T> 00:00:00.000000
T> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
T> I. 10/24 09:47:10. <1.5> [user1]: WXYZ
T> I. 10/24 09:47:10. <1.5> [user1]: BBBBBBBBBBBBBBBBBBBB
BBB
T> I. 10/24 09:47:10. <1.5> [user1]: 1998-12-04
T> 00:00:00.000000
T> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
T> I. 10/24 09:47:10. <1.5> [user1]: OFO
T> I. 10/24 09:47:10. <1.5> [user1]: CCCCCCCCCCCCCCCCCC
T> I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
T> 00:00:00.000000
T> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
T> I. 10/24 09:47:10. <1.5> [user1]: IJK
T> I. 10/24 09:47:10. <1.5> [user1]: DDDDDDDDDDDDDDDDDD
T> I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
T> 00:00:00.000000
T> I. 10/24 09:47:10. <1.5> [user1]: download_cursor table1
T> (close)
T> I. 10/24 09:47:10. <1.5> [user1]: end_download_rows table1
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_download table1 (no
T> script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_download <connection>
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded for
T> delete from table table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded for
T> insert/update from table table1 : 4
T> I. 10/24 09:47:10. <1.5> [user1]: # rows filtered for
T> download from table table1 : 0
T> I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded to
T> remote from table table1 : 4
T> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
T> end_download
T> I. 10/24 09:47:10. <1.5> [user1]: Sending the download to
T> the remote database.
T> I. 10/24 09:47:10. <1.5> [user1]: end_publication
T> <connection> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_synchronization table1
T> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: end_synchronization
T> <connection> (no script)
T> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
T> end_synchronization
T> I. 10/24 09:47:10. <1.5> [user1]: Synchronization complete
T>
T> ====================
====================
==================
T> dbmlsynch:
T> I. 10/24 09:47:09. Synchronization Started
T> I. 10/24 09:47:09. 1: -c
T> I. 10/24 09:47:09. 2: ********************
************
T> I. 10/24 09:47:09. 3: -v+
T> I. 10/24 09:47:09. 4: -e
T> I. 10/24 09:47:09. 5: SendColumnNames=on
T> I. 10/24 09:47:09. Adaptive Server Anywhere MobiLink
T> Synchronization Version 9.0.1.2009
T> I. 10/24 09:47:09. Connecting to remote database
T> I. 10/24 09:47:09. Loading synchronization information
T> I. 10/24 09:47:09. Options in database for subscription to
T> 'pub' for 'user1':
T> I. 10/24 09:47:09. scriptversion=ver2;
T> I. 10/24 09:47:09. Options in database for subscription to
T> 'pub' for 'user1':
T> I. 10/24 09:47:09. scriptversion=ver2;
T> I. 10/24 09:47:09. Options in database for subscription to
T> 'pub' for 'user1':
T> I. 10/24 09:47:09. scriptversion=ver2;
T> I. 10/24 09:47:09. Begin synchronizing 'pub' for MobiLink
T> user 'user1'
T> I. 10/24 09:47:09. Options for this synchronization:
T> I. 10/24 09:47:09.
T> SCN='YES',SV='ver2',
CTP='TCPIP',ADR='hos
t=localhost'
T> I. 10/24 09:47:09. Log scan starting at offset 0004051230
T> I. 10/24 09:47:09. Processing transactions from active
T> transaction log
T> I. 10/24 09:47:09. Hovering at end of active log
T> I. 10/24 09:47:09. Connecting to MobiLink server at
T> 'host=localhost' using 'dbmlsock9.dll'
T> I. 10/24 09:47:10. Uploading header
T> I. 10/24 09:47:10. Stream version: 529
T> I. 10/24 09:47:10. Processor is little-endian
T> I. 10/24 09:47:10. Character set: cp1252
T> I. 10/24 09:47:10. MobiLink user name: user1
T> I. 10/24 09:47:10. Script version: ver2
T> I. 10/24 09:47:10. Synchronization ID: 1630770949
T> I. 10/24 09:47:10. Publication 'pub' - Synchronizing - Log
T> offset 0004051230 - Last download time 2005-10-21
T> 09:08:15.81.
T> I. 10/24 09:47:10. Begin upload
T> I. 10/24 09:47:10. Uploading publication definition(s)
T> I. 10/24 09:47:10. Article table: table1
T> I. 10/24 09:47:10. Article column: Column1
T> I. 10/24 09:47:10. Article column: Column2
T> I. 10/24 09:47:10. Article column: Column3
T> I. 10/24 09:47:10. Table Upload Order: table1
T> I. 10/24 09:47:10. Uploading table operations
T> I. 10/24 09:47:10. Upload operations on table 'table1'
T> I. 10/24 09:47:10. # rows inserted in table table1 : 0
T> I. 10/24 09:47:10. # rows deleted in table table1 : 0
T> I. 10/24 09:47:10. # rows updated in table table1 : 0
T> I. 10/24 09:47:10. Log scan ended at offset 0004056287
T> I. 10/24 09:47:10. Waiting for MobiLink to apply upload
T> I. 10/24 09:47:10. The user authentication value is 1000.
T> I. 10/24 09:47:10. Setting last upload time to 2005-10-24
T> 09:47:27.01.
T> I. 10/24 09:47:10. Setting generation number for publication
T> pub to 1.
T> I. 10/24 09:47:10. COMMIT
T> I. 10/24 09:47:10. Download stream: received 237 bytes from
T> MobiLink Server.
T> I. 10/24 09:47:10. Processing download stream ...
T> I. 10/24 09:47:10. Downloading into table: table1
T> I. 10/24 09:47:10. Insert/Update row:
T> I. 10/24 09:47:10. ABCDE
T> I. 10/24 09:47:10. AAAAAAAAAAAAAAAAAAAA
AAAAA
T> I. 10/24 09:47:10. 1998-02-09 00:00:00.0
T> I. 10/24 09:47:10. Insert/Update row:
T> I. 10/24 09:47:10. WXYZ
T> I. 10/24 09:47:10. BBBBBBBBBBBBBBBBBBBB
BBB
T> I. 10/24 09:47:10. 1998-12-04 00:00:00.0
T> I. 10/24 09:47:10. Insert/Update row:
T> I. 10/24 09:47:10. FGH
T> I. 10/24 09:47:10. CCCCCCCCCCCCCCCCCC
T> I. 10/24 09:47:10. 1998-02-09 00:00:00.0
T> I. 10/24 09:47:10. Insert/Update row:
T> I. 10/24 09:47:10. IJK
T> I. 10/24 09:47:10. DDDDDDDDDDDDDDDDDD
T> I. 10/24 09:47:10. 1998-02-09 00:00:00.0
T> I. 10/24 09:47:10. # rows inserted/updated into table table1
T>: 4
T> I. 10/24 09:47:10. # rows deleted in table table1 : 0
T> E. 10/24 09:47:10. SQL statement failed: (-209) Constraint
T> 'ASA154' violated: Invalid value for column 'Column1' in
T> table 'table1'
Well based on your constraint:
The check constraints:
check(Column1 like '[S][0-9][0-9][0-9]' or
Column1 like '[F][0-9][0-9][0-9]' or
Column1 like '[D][0-9][0-9][0-9]')
The data you are downloading violates it.
So the remote is failing the download as expected.
You need to either cleanup your data, or fix up your constraints.
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
| |
| Graham Hurst 2005-10-27, 8:21 am |
| As well as the other responses, note that it is very unusual outside of
testing to run both dbmlsync (the synchronization client) and dbmlsrv9
(the synchronization server) on the same computer.
You might want to reconsider your architecture unless you will only ever
have one remote computer. Note that the MobiLink server works best with
a high-bandwidth, reliable connection to the consolidated database.
Cheers,
Graham
Toni wrote:
> Hi David,
>
> We are using ASE12.5 on unix vs ASA901.2009 on xp, and we
> are having both dbmlsr9 and dbmlsynch are running on windows
> xp and on the same pc.
>
> The output of both dbmlsr9 & dbmlsynch:
>
> dbmlsr9:
>
> I. 10/24 09:45:59. Adaptive Server Anywhere MobiLink Version
> 9.0.1.2009
> I. 10/24 09:45:59. <Main>: MobiLink server started
> I. 10/24 09:45:59. <Main>: Option 1: -c
> I. 10/24 09:45:59. <Main>: Option 2: ****************
> I. 10/24 09:45:59. <Main>: Option 3: -vcrsn
> I. 10/24 09:45:59. <Main>: Option 4: -v+
> I. 10/24 09:45:59. <Main>: Option 5: -zp
> I. 10/24 09:45:59. <Main>: Option 6: -za
> I. 10/24 09:45:59. <Main>: Option 7: -zu+
> I. 10/24 09:45:59. <Main>: Option 8: -x
> I. 10/24 09:45:59. <Main>: Option 9: tcpip
> I. 10/24 09:45:59. <Main>: Verbose logging: show row values
> I. 10/24 09:45:59. <Main>: Verbose logging: show script
> names when invoked
> I. 10/24 09:45:59. <Main>: Verbose logging: show script
> contents when invoked
> I. 10/24 09:45:59. <Main>: Verbose logging: show schema for
> each table
> I. 10/24 09:45:59. <Main>: Verbose logging: show an error
> when the first read of a synchronization fails
> I. 10/24 09:45:59. <Main>: Verbose logging: show translated
> SQL for prepared statements
> I. 10/24 09:45:59. <Main>: Verbose logging: show rowcount
> values
> I. 10/24 09:45:59. <Main>: Individual database connections
> will be closed after synchronization errors.
> I. 10/24 09:45:59. <Main>: BLOB cache size: 524288
> I. 10/24 09:45:59. <Main>: Maximum number of BLOB bytes to
> compare: 4294967295
> I. 10/24 09:45:59. <Main>: Maximum number of database
> connections: 6
> I. 10/24 09:45:59. <Main>: Maximum number of deadlock
> retries: 10
> I. 10/24 09:45:59. <Main>: Timeout for inactive database
> connections: 60 minutes
> I. 10/24 09:45:59. <Main>: Maximum delay between retries
> after deadlock: 30 seconds
> I. 10/24 09:45:59. <Main>: Rowset size: 10
> I. 10/24 09:45:59. <Main>: Upload cache size: 524288 bytes
> I. 10/24 09:45:59. <Main>: Download cache memory size:
> 1048576 bytes
> I. 10/24 09:45:59. <Main>: Download cache directory size:
> 10485760 bytes
> I. 10/24 09:45:59. <Main>: Number of worker threads: 5
> I. 10/24 09:45:59. <Main>: Maximum number of threads
> uploading concurrently: 5
> W. 10/24 09:45:59. <Main>: Warning: Unknown users will be
> added automatically (when there is no authenticate_user
> script).
> I. 10/24 09:45:59. <Main>: Warning: Example scripts may be
> automatically generated and activated for unknown versions.
> I. 10/24 09:45:59. <Main>: Translated SQL:
> SELECT COUNT(*) FROM ml_scripts_modified
> I. 10/24 09:45:59. <thread 1.1>: Ready to handle requests
> I. 10/24 09:45:59. <thread 1.2>: Ready to handle requests
> I. 10/24 09:45:59. <thread 1.3>: Ready to handle requests
> I. 10/24 09:45:59. <thread 1.4>: Ready to handle requests
> I. 10/24 09:45:59. <thread 1.5>: Ready to handle requests
> I. 10/24 09:47:10. <thread 1.5>: Working on a request
> I. 10/24 09:47:10. <thread 1.5>: Translated SQL:
> SELECT last_modified FROM
> ml_scripts_modified
> I. 10/24 09:47:10. <thread 1.5>: ml_scripts_modified last
> modified at: 2005-10-21 10:06:47.733
> I. 10/24 09:47:10. <thread 1.5>: Translated SQL:
> SELECT version_id FROM ml_script_version
> WHERE name = ?
> I. 10/24 09:47:10. <thread 1.5>: ASA synchronization request
> from: user1 (version: ver2)
> I. 10/24 09:47:10. <1.5> [user1]: ODBC isolation set to:
> Read Committed
> I. 10/24 09:47:10. <1.5> [user1]: 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. 10/24 09:47:10. <1.5> [user1]: begin_connection
> <connection> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
> begin_connection
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT hashed_password FROM ml_user WHERE
> name = ?
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT user_id FROM ml_user WHERE name =
> ?
> I. 10/24 09:47:10. <1.5> [user1]: Publication #1: pub,
> subscription id: 8, last download time: 2005-10-21
> 09:08:15.810000
> I. 10/24 09:47:10. <1.5> [user1]: Table #1: table1, 3
> columns
> I. 10/24 09:47:10. <1.5> [user1]: Column1 char(10) NOT NULL
> PRIMARY KEY
> I. 10/24 09:47:10. <1.5> [user1]: Column2 varchar(70) NOT
> NULL
> I. 10/24 09:47:10. <1.5> [user1]: Column3 timestamp NOT NULL
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT progress FROM ml_subscription
> WHERE user_id = ? AND subscription_id = ?
> I. 10/24 09:47:10. <1.5> [user1]: Progress offsets for the
> publications that are explicitly involved in the current
> synchronization
> I. 10/24 09:47:10. <1.5> [user1]: Subscription id 8:
> consolidated progress 4051230 and remote progress 4051230
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> UPDATE ml_subscription SET
> last_download_time = ?, publication_name = ? WHERE user_id =
> ? AND subscription_id = ?
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT table_id FROM ml_table WHERE name
> = ?
> I. 10/24 09:47:10. <1.5> [user1]: begin_synchronizatio
n
> <connection> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: 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. 10/24 09:47:10. <1.5> [user1]: begin_synchronizatio
n
> table1 (no script)
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT last_upload_time FROM
> ml_subscription WHERE user_id = ? AND subscription_id = ?
> I. 10/24 09:47:10. <1.5> [user1]: Last upload time for
> subscription id 8: 2005-10-21 12:15:00.006000
> I. 10/24 09:47:10. <1.5> [user1]: begin_publication
> <connection> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
> begin_synchronizatio
n
> I. 10/24 09:47:10. <1.5> [user1]: begin_upload <connection>
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: begin_upload table1 (no
> script)
> I. 10/24 09:47:10. <1.5> [user1]: begin_upload_rows table1
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> save tran it0
> I. 10/24 09:47:10. <1.5> [user1]: end_upload_rows table1 (no
> script)
> I. 10/24 09:47:10. <1.5> [user1]: end_upload table1 (no
> script)
> I. 10/24 09:47:10. <1.5> [user1]: end_upload <connection>
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: # rows uploaded into table
> table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows inserted into table
> table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows deleted in table
> table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows updated into table
> table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows conflicted in table
> table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows ignored in table
> table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> UPDATE ml_subscription SET progress = ?,
> publication_name = ? WHERE user_id = ? AND subscription_id =
> ?
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT GETDATE()
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> UPDATE ml_subscription SET
> last_upload_time = ? WHERE user_id = ? AND subscription_id =
> ?
> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
> end_upload
> I. 10/24 09:47:10. <1.5> [user1]: Cached ODBC statement:
> SELECT {FN NOW()}
> I. 10/24 09:47:10. <1.5> [user1]: begin_download
> <connection> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: begin_download table1 (no
> script)
> I. 10/24 09:47:10. <1.5> [user1]: begin_download_delet
es
> table1 (no script)
> I. 10/24 09:47:10. <1.5> [user1]: end_download_deletes
> table1 (no script)
> I. 10/24 09:47:10. <1.5> [user1]: begin_download_rows table1
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: download_cursor table1
> (open for read):
> SELECT Column1, Column2, Column3
> FROM table1
> I. 10/24 09:47:10. <1.5> [user1]: Translated SQL:
> SELECT Column1, Column2, Column3
> FROM table1
> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
> I. 10/24 09:47:10. <1.5> [user1]: ABCDE
> I. 10/24 09:47:10. <1.5> [user1]:
> AAAAAAAAAAAAAAAAAAAA
AAAAA
> I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
> 00:00:00.000000
> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
> I. 10/24 09:47:10. <1.5> [user1]: WXYZ
> I. 10/24 09:47:10. <1.5> [user1]: BBBBBBBBBBBBBBBBBBBB
BBB
> I. 10/24 09:47:10. <1.5> [user1]: 1998-12-04
> 00:00:00.000000
> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
> I. 10/24 09:47:10. <1.5> [user1]: OFO
> I. 10/24 09:47:10. <1.5> [user1]: CCCCCCCCCCCCCCCCCC
> I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
> 00:00:00.000000
> I. 10/24 09:47:10. <1.5> [user1]: Insert/Update row:
> I. 10/24 09:47:10. <1.5> [user1]: IJK
> I. 10/24 09:47:10. <1.5> [user1]: DDDDDDDDDDDDDDDDDD
> I. 10/24 09:47:10. <1.5> [user1]: 1998-02-09
> 00:00:00.000000
> I. 10/24 09:47:10. <1.5> [user1]: download_cursor table1
> (close)
> I. 10/24 09:47:10. <1.5> [user1]: end_download_rows table1
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: end_download table1 (no
> script)
> I. 10/24 09:47:10. <1.5> [user1]: end_download <connection>
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded for
> delete from table table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded for
> insert/update from table table1 : 4
> I. 10/24 09:47:10. <1.5> [user1]: # rows filtered for
> download from table table1 : 0
> I. 10/24 09:47:10. <1.5> [user1]: # rows downloaded to
> remote from table table1 : 4
> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
> end_download
> I. 10/24 09:47:10. <1.5> [user1]: Sending the download to
> the remote database.
> I. 10/24 09:47:10. <1.5> [user1]: end_publication
> <connection> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: end_synchronization table1
> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: end_synchronization
> <connection> (no script)
> I. 10/24 09:47:10. <1.5> [user1]: COMMIT Transaction:
> end_synchronization
> I. 10/24 09:47:10. <1.5> [user1]: Synchronization complete
>
> ====================
====================
==================
> dbmlsynch:
> I. 10/24 09:47:09. Synchronization Started
> I. 10/24 09:47:09. 1: -c
> I. 10/24 09:47:09. 2: ********************
************
> I. 10/24 09:47:09. 3: -v+
> I. 10/24 09:47:09. 4: -e
> I. 10/24 09:47:09. 5: SendColumnNames=on
> I. 10/24 09:47:09. Adaptive Server Anywhere MobiLink
> Synchronization Version 9.0.1.2009
> I. 10/24 09:47:09. Connecting to remote database
> I. 10/24 09:47:09. Loading synchronization information
> I. 10/24 09:47:09. Options in database for subscription to
> 'pub' for 'user1':
> I. 10/24 09:47:09. scriptversion=ver2;
> I. 10/24 09:47:09. Options in database for subscription to
> 'pub' for 'user1':
> I. 10/24 09:47:09. scriptversion=ver2;
> I. 10/24 09:47:09. Options in database for subscription to
> 'pub' for 'user1':
> I. 10/24 09:47:09. scriptversion=ver2;
> I. 10/24 09:47:09. Begin synchronizing 'pub' for MobiLink
> user 'user1'
> I. 10/24 09:47:09. Options for this synchronization:
> I. 10/24 09:47:09.
> SCN='YES',SV='ver2',
CTP='TCPIP',ADR='hos
t=localhost'
> I. 10/24 09:47:09. Log scan starting at offset 0004051230
> I. 10/24 09:47:09. Processing transactions from active
> transaction log
> I. 10/24 09:47:09. Hovering at end of active log
> I. 10/24 09:47:09. Connecting to MobiLink server at
> 'host=localhost' using 'dbmlsock9.dll'
> I. 10/24 09:47:10. Uploading header
> I. 10/24 09:47:10. Stream version: 529
> I. 10/24 09:47:10. Processor is little-endian
> I. 10/24 09:47:10. Character set: cp1252
> I. 10/24 09:47:10. MobiLink user name: user1
> I. 10/24 09:47:10. Script version: ver2
> I. 10/24 09:47:10. Synchronization ID: 1630770949
> I. 10/24 09:47:10. Publication 'pub' - Synchronizing - Log
> offset 0004051230 - Last download time 2005-10-21
> 09:08:15.81.
> I. 10/24 09:47:10. Begin upload
> I. 10/24 09:47:10. Uploading publication definition(s)
> I. 10/24 09:47:10. Article table: table1
> I. 10/24 09:47:10. Article column: Column1
> I. 10/24 09:47:10. Article column: Column2
> I. 10/24 09:47:10. Article column: Column3
> I. 10/24 09:47:10. Table Upload Order: table1
> I. 10/24 09:47:10. Uploading table operations
> I. 10/24 09:47:10. Upload operations on table 'table1'
> I. 10/24 09:47:10. # rows inserted in table table1 : 0
> I. 10/24 09:47:10. # rows deleted in table table1 : 0
> I. 10/24 09:47:10. # rows updated in table table1 : 0
> I. 10/24 09:47:10. Log scan ended at offset 0004056287
> I. 10/24 09:47:10. Waiting for MobiLink to apply upload
> I. 10/24 09:47:10. The user authentication value is 1000.
> I. 10/24 09:47:10. Setting last upload time to 2005-10-24
> 09:47:27.01.
> I. 10/24 09:47:10. Setting generation number for publication
> pub to 1.
> I. 10/24 09:47:10. COMMIT
> I. 10/24 09:47:10. Download stream: received 237 bytes from
> MobiLink Server.
> I. 10/24 09:47:10. Processing download stream ...
> I. 10/24 09:47:10. Downloading into table: table1
> I. 10/24 09:47:10. Insert/Update row:
> I. 10/24 09:47:10. ABCDE
> I. 10/24 09:47:10. AAAAAAAAAAAAAAAAAAAA
AAAAA
> I. 10/24 09:47:10. 1998-02-09 00:00:00.0
> I. 10/24 09:47:10. Insert/Update row:
> I. 10/24 09:47:10. WXYZ
> I. 10/24 09:47:10. BBBBBBBBBBBBBBBBBBBB
BBB
> I. 10/24 09:47:10. 1998-12-04 00:00:00.0
> I. 10/24 09:47:10. Insert/Update row:
> I. 10/24 09:47:10. FGH
> I. 10/24 09:47:10. CCCCCCCCCCCCCCCCCC
> I. 10/24 09:47:10. 1998-02-09 00:00:00.0
> I. 10/24 09:47:10. Insert/Update row:
> I. 10/24 09:47:10. IJK
> I. 10/24 09:47:10. DDDDDDDDDDDDDDDDDD
> I. 10/24 09:47:10. 1998-02-09 00:00:00.0
> I. 10/24 09:47:10. # rows inserted/updated into table table1
> : 4
> I. 10/24 09:47:10. # rows deleted in table table1 : 0
> E. 10/24 09:47:10. SQL statement failed: (-209) Constraint
> 'ASA154' violated: Invalid value for column 'Column1' in
> table 'table1'
> I. 10/24 09:47:10. ROLLBACK
> I. 10/24 09:47:10. Download stream processing failed
> I. 10/24 09:47:10. End synchronizing 'pub' for MobiLink user
> 'user1'
> I. 10/24 09:47:10. Disconnecting from MobiLink server
> I. 10/24 09:47:10. Complete log scan required.
> I. 10/24 09:47:10. Synchronization completed
> I. 10/24 09:47:10. Options in database for subscription to
> 'pub' for 'user1':
> I. 10/24 09:47:10. scriptversion=ver2;
> I. 10/24 09:47:10. Disconnecting from remote database
|
|
|
|
|