|
Home > Archive > SQL Anywhere Mobile > June 2005 > mobilink upload 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 |
mobilink upload problem
|
|
| @(none) 2005-06-18, 9:24 am |
| hi all,
I am using ASA 9 and mobilink on winXP SP2, I am having a problem with
the upload proces, I see the Begin upload-EndDownload but nothing is
uploaded (i updated a row in the remote db) when the download process
startit complains that there are rows that must first be uploaded and
the process retruns whit error. I have only one table to sync. and it
has the corresponding upload_insert/delete/update scripts and
download_cursor/delete_cursor scripts, is there something that I am
missing, I'd appreciate any guidance in this matter as I am new to this
mobilink stuff.
thanks in advance
Hugh
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-20, 8:25 pm |
| Can you please start your MobiLink server and dbmlsync executable with "-v+"
and post both logs in the forum. I'm having trouble understanding the
problem you're describing.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"@(none)" <""root\"@(none)"> wrote in message
news:42b41d55$1@foru
ms-2-dub...
> hi all,
>
> I am using ASA 9 and mobilink on winXP SP2, I am having a problem with
> the upload proces, I see the Begin upload-EndDownload but nothing is
> uploaded (i updated a row in the remote db) when the download process
> startit complains that there are rows that must first be uploaded and
> the process retruns whit error. I have only one table to sync. and it
> has the corresponding upload_insert/delete/update scripts and
> download_cursor/delete_cursor scripts, is there something that I am
> missing, I'd appreciate any guidance in this matter as I am new to this
> mobilink stuff.
>
> thanks in advance
>
> Hugh
| |
|
| Hi Reg,
thanks for your help, this is what the logs show
I am using ASA 9.0.0.1110 , Mobilink Sync. 9.0.0.1108 , Pocketbuilder 1.5.1
built 385
thanks in advance
Hugo
********************
***********
Begin synchronization User: gilbert
Pub Names: pub_pdaClin
Begin log scan. Rescan = 0.
End log scan.
Connect MobiLink.
Begin upload.
End upload.
Waiting for upload acknowledgement.
Upload acknowledged. Status = 0.
Begin download.
E. 06/19 23:05:18. The download contains modifications to a row with
operations that must first be uploaded.
End download.
Insert/Update rows = 0
Delete rows = 0
Disconnect MobiLink server.
End Synchronization. Status = 1
Synchronization error 1.
********************
****************
********************
****************
I. 06/19 23:05:05. Adaptive Server Anywhere MobiLink Version 9.0.0.1108
I. 06/19 23:05:05.
I. 06/19 23:05:05. Copyright © 1989-2003 Sybase, Inc.
Portions Copyright © 2002-2003, iAnywhere Solutions, Inc.
I. 06/19 23:05:05. All rights reserved. All unpublished rights reserved.
I. 06/19 23:05:05.
I. 06/19 23:05:05. This software contains confidential and trade secret
information of
I. 06/19 23:05:05. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 06/19 23:05:05. by the U.S. Government is subject to restrictions set
forth in a license
I. 06/19 23:05:05. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 06/19 23:05:05. other written agreement specifying the Government's
rights to use the
I. 06/19 23:05:05. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 06/19 23:05:05.
I. 06/19 23:05:05. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 06/19 23:05:05.
I. 06/19 23:05:05. Networked Seat (per-seat) model. Access to the server is
limited to 1 seat(s).
This server is licensed to:
I. 06/19 23:05:05. Developer Edition
I. 06/19 23:05:05. Restricted Use
I. 06/19 23:05:06. <Main>: MobiLink server started
I. 06/19 23:05:06. <Main>: Option 1: -zu+
I. 06/19 23:05:06. <Main>: Option 2: -v+
I. 06/19 23:05:06. <Main>: Option 3: -zs
I. 06/19 23:05:06. <Main>: Option 4: histoClin
I. 06/19 23:05:06. <Main>: Option 5: -c
I. 06/19 23:05:06. <Main>: Option 6: ****************
I. 06/19 23:05:06. <Main>: Option 7: -q
I. 06/19 23:05:06. <Main>: Option 8: -ze
I. 06/19 23:05:06. <Main>: Verbose logging: show row values
I. 06/19 23:05:06. <Main>: Verbose logging: show script names when invoked
I. 06/19 23:05:06. <Main>: Verbose logging: show script contents when
invoked
I. 06/19 23:05:06. <Main>: Verbose logging: show schema for each table
I. 06/19 23:05:06. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 06/19 23:05:06. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 06/19 23:05:06. <Main>: Verbose logging: show rowcount values
I. 06/19 23:05:06. <Main>: Individual database connections will be closed
after synchronization errors.
I. 06/19 23:05:06. <Main>: BLOB cache size: 524288
I. 06/19 23:05:06. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 06/19 23:05:06. <Main>: Maximum number of database connections: 6
I. 06/19 23:05:06. <Main>: Maximum number of deadlock retries: 10
I. 06/19 23:05:06. <Main>: Timeout for inactive database connections: 60
minutes
I. 06/19 23:05:06. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 06/19 23:05:06. <Main>: Rowset size: 10
I. 06/19 23:05:06. <Main>: Upload cache size: 524288 bytes
I. 06/19 23:05:06. <Main>: Download cache size: 524288 bytes
I. 06/19 23:05:06. <Main>: Number of worker threads: 5
I. 06/19 23:05:06. <Main>: Maximum number of threads uploading concurrently:
5
W. 06/19 23:05:06. <Main>: Warning: Unknown users will be added
automatically (when there is no authenticate_user script).
I. 06/19 23:05:06. <Main>: Warning: Example scripts may be automatically
generated for unknown versions.
I. 06/19 23:05:06. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 06/19 23:05:06. <Main>: Stream specifier 1: TCPIP
I. 06/19 23:05:06. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
I. 06/19 23:05:06. <Main>: ODBC DBMS Version: 09.00.0000
I. 06/19 23:05:06. <Main>: ODBC DBMS Driver Version: 09.00.0000
I. 06/19 23:05:06. <Main>: ODBC Version supported by the driver: 3.52
I. 06/19 23:05:06. <Main>: Collation sequence of the consolidated database
is 'cp1252'
I. 06/19 23:05:06. <Main>: Translated SQL:
SET TEMPORARY OPTION CHAINED = 'ON'
I. 06/19 23:05:06. <Main>: ODBC isolation set to: Read Committed
I. 06/19 23:05:06. <Main>: Connected
I. 06/19 23:05:06. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 06/19 23:05:06. <thread 1.1>: Ready to handle requests
I. 06/19 23:05:06. <thread 1.2>: Ready to handle requests
I. 06/19 23:05:06. <thread 1.3>: Ready to handle requests
I. 06/19 23:05:06. <thread 1.4>: Ready to handle requests
I. 06/19 23:05:06. <thread 1.5>: Ready to handle requests
I. 06/19 23:05:18. <thread 1.5>: Working on a request
I. 06/19 23:05:18. <thread 1.5>: Translated SQL:
SELECT last_modified FROM ml_scripts_modified
I. 06/19 23:05:18. <thread 1.5>: ml_scripts_modified last modified at:
2005-06-19 23:03:06.265000
I. 06/19 23:05:18. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version WHERE name = ?
I. 06/19 23:05:18. <thread 1.5>: ASA synchronization request from: gilbert
(version: pdaClin)
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SET TEMPORARY OPTION CHAINED = 'ON'
I. 06/19 23:05:18. <1.5> [gilbert]: ODBC isolation set to: Read Committed
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT t1.event, t2.script FROM ml_connection_script
t1,
ml_script t2 WHERE t1.version_id = ? AND t1.script_id = t2.script_id
I. 06/19 23:05:18. <1.5> [gilbert]: begin_connection <connection> (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: begin_connection
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT user_id FROM ml_user WHERE name = ?
I. 06/19 23:05:18. <1.5> [gilbert]: Publication #1: pub_pdaClin,
subscription id: 3, last download time: 2005-06-06 23:09:10.062000
I. 06/19 23:05:18. <1.5> [gilbert]: Table #1: ALERGIAS, 3 columns
I. 06/19 23:05:18. <1.5> [gilbert]: Column #1: char(10) NOT NULL PRIMARY KEY
I. 06/19 23:05:18. <1.5> [gilbert]: Column #2: varchar(50)
I. 06/19 23:05:18. <1.5> [gilbert]: Column #3: varchar(200)
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT progress FROM ml_subscription WHERE user_id = ?
AND subscription_id = ?
I. 06/19 23:05:18. <1.5> [gilbert]: Progress offsets for the publications
that are explicitly involved in the current synchronization
I. 06/19 23:05:18. <1.5> [gilbert]: Subscription id 3: consolidated progress
0 and remote progress 391368
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
UPDATE ml_subscription SET last_download_time = ?,
publication_name = ? WHERE user_id = ? AND subscription_id = ?
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT table_id FROM ml_table WHERE name = ?
I. 06/19 23:05:18. <1.5> [gilbert]: begin_synchronizatio
n <connection> (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT t1.event, 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/19 23:05:18. <1.5> [gilbert]: begin_synchronizatio
n ALERGIAS (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT last_upload_time FROM ml_subscription WHERE
user_id = ? AND subscription_id = ?
I. 06/19 23:05:18. <1.5> [gilbert]: Last upload time for subscription id 3:
1900-01-01 00:00:00.000000
I. 06/19 23:05:18. <1.5> [gilbert]: begin_publication <connection> (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction:
begin_synchronizatio
n
I. 06/19 23:05:18. <1.5> [gilbert]: begin_upload <connection> (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: begin_upload ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: begin_upload_rows ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
savepoint it0
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
release savepoint it0
I. 06/19 23:05:18. <1.5> [gilbert]: end_upload_rows ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: end_upload ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: end_upload <connection> (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: # rows uploaded into table ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows inserted into table ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows deleted in table ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows updated into table ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows conflicted in table ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows ignored in table ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: end_upload
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
SELECT NOW(*)
I. 06/19 23:05:18. <1.5> [gilbert]: begin_download <connection> (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: begin_download ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: begin_download_delet
es ALERGIAS (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: download_delete_curs
or ALERGIAS (open
for read):
select alergia from alergias where borrar = 'S'
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
select alergia from alergias where borrar = 'S'
I. 06/19 23:05:18. <1.5> [gilbert]: download_delete_curs
or ALERGIAS (close)
I. 06/19 23:05:18. <1.5> [gilbert]: end_download_deletes
ALERGIAS (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: begin_download_rows ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: download_cursor ALERGIAS (open for
read):
select alergia, nombre , descripcion from alergias where
borrar <> 'S' or borrar is null
I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
select alergia, nombre , descripcion from alergias where
borrar <> 'S' or borrar is null
I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
I. 06/19 23:05:18. <1.5> [gilbert]: 1
I. 06/19 23:05:18. <1.5> [gilbert]: Alergia Medicamentoza
I. 06/19 23:05:18. <1.5> [gilbert]: NULL
I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
I. 06/19 23:05:18. <1.5> [gilbert]: 2
I. 06/19 23:05:18. <1.5> [gilbert]: Alergia a Alimentos
I. 06/19 23:05:18. <1.5> [gilbert]: NULL
I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
I. 06/19 23:05:18. <1.5> [gilbert]: 3
I. 06/19 23:05:18. <1.5> [gilbert]: Alergia al polen
I. 06/19 23:05:18. <1.5> [gilbert]: NULL
I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
I. 06/19 23:05:18. <1.5> [gilbert]: 4
I. 06/19 23:05:18. <1.5> [gilbert]: Alergia 4
I. 06/19 23:05:18. <1.5> [gilbert]: NULL
I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
I. 06/19 23:05:18. <1.5> [gilbert]: 5
I. 06/19 23:05:18. <1.5> [gilbert]: Alergia 758
I. 06/19 23:05:18. <1.5> [gilbert]: NULL
I. 06/19 23:05:18. <1.5> [gilbert]: download_cursor ALERGIAS (close)
I. 06/19 23:05:18. <1.5> [gilbert]: end_download_rows ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: end_download ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: end_download <connection> (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: # rows downloaded for delete from table
ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows downloaded for insert/update from
table ALERGIAS : 5
I. 06/19 23:05:18. <1.5> [gilbert]: # rows filtered for download from table
ALERGIAS : 0
I. 06/19 23:05:18. <1.5> [gilbert]: # rows downloaded to remote from table
ALERGIAS : 5
I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: end_download
I. 06/19 23:05:18. <1.5> [gilbert]: Sending the download to the remote
database.
I. 06/19 23:05:18. <1.5> [gilbert]: end_publication <connection> (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: end_synchronization ALERGIAS (no script)
I. 06/19 23:05:18. <1.5> [gilbert]: end_synchronization <connection> (no
script)
I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: end_synchronization
I. 06/19 23:05:18. <1.5> [gilbert]: Synchronization complete
********
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-06-23, 9:24 am |
| This means that on the client between the time the upload was sent to the
MobiLink Server and
before the download was received from the MobiLink server, that another
connection to the remote database modified a row in the database that was
then later modified by the download stream received from the MobiLink
server.
The next time you synchronize, the error should not occur, unless you go
and modify a row again while dbmlsync is waiting for the download stream
from MobiLink.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Hugo" <htakada@gmail.com> wrote in message news:42ba27d4@forums
-1-dub...
> Hi Reg,
>
> thanks for your help, this is what the logs show
> I am using ASA 9.0.0.1110 , Mobilink Sync. 9.0.0.1108 , Pocketbuilder
1.5.1
> built 385
>
>
> thanks in advance
>
> Hugo
>
>
>
> ********************
***********
> Begin synchronization User: gilbert
> Pub Names: pub_pdaClin
> Begin log scan. Rescan = 0.
> End log scan.
> Connect MobiLink.
> Begin upload.
> End upload.
> Waiting for upload acknowledgement.
> Upload acknowledged. Status = 0.
> Begin download.
> E. 06/19 23:05:18. The download contains modifications to a row with
> operations that must first be uploaded.
> End download.
> Insert/Update rows = 0
> Delete rows = 0
> Disconnect MobiLink server.
> End Synchronization. Status = 1
>
> Synchronization error 1.
> ********************
****************
>
> ********************
****************
> I. 06/19 23:05:05. Adaptive Server Anywhere MobiLink Version 9.0.0.1108
> I. 06/19 23:05:05.
> I. 06/19 23:05:05. Copyright © 1989-2003 Sybase, Inc.
> Portions Copyright © 2002-2003, iAnywhere Solutions,
Inc.
> I. 06/19 23:05:05. All rights reserved. All unpublished rights reserved.
> I. 06/19 23:05:05.
> I. 06/19 23:05:05. This software contains confidential and trade secret
> information of
> I. 06/19 23:05:05. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 06/19 23:05:05. by the U.S. Government is subject to restrictions set
> forth in a license
> I. 06/19 23:05:05. agreement between the Government and iAnywhere
Solutions,
> Inc. or
> I. 06/19 23:05:05. other written agreement specifying the Government's
> rights to use the
> I. 06/19 23:05:05. software and any applicable FAR provisions, for
example,
> FAR 52.227-19.
> I. 06/19 23:05:05.
> I. 06/19 23:05:05. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
> 94568, USA
> I. 06/19 23:05:05.
> I. 06/19 23:05:05. Networked Seat (per-seat) model. Access to the server
is
> limited to 1 seat(s).
> This server is licensed to:
> I. 06/19 23:05:05. Developer Edition
> I. 06/19 23:05:05. Restricted Use
> I. 06/19 23:05:06. <Main>: MobiLink server started
> I. 06/19 23:05:06. <Main>: Option 1: -zu+
> I. 06/19 23:05:06. <Main>: Option 2: -v+
> I. 06/19 23:05:06. <Main>: Option 3: -zs
> I. 06/19 23:05:06. <Main>: Option 4: histoClin
> I. 06/19 23:05:06. <Main>: Option 5: -c
> I. 06/19 23:05:06. <Main>: Option 6: ****************
> I. 06/19 23:05:06. <Main>: Option 7: -q
> I. 06/19 23:05:06. <Main>: Option 8: -ze
> I. 06/19 23:05:06. <Main>: Verbose logging: show row values
> I. 06/19 23:05:06. <Main>: Verbose logging: show script names when invoked
> I. 06/19 23:05:06. <Main>: Verbose logging: show script contents when
> invoked
> I. 06/19 23:05:06. <Main>: Verbose logging: show schema for each table
> I. 06/19 23:05:06. <Main>: Verbose logging: show an error when the first
> read of a synchronization fails
> I. 06/19 23:05:06. <Main>: Verbose logging: show translated SQL for
prepared
> statements
> I. 06/19 23:05:06. <Main>: Verbose logging: show rowcount values
> I. 06/19 23:05:06. <Main>: Individual database connections will be closed
> after synchronization errors.
> I. 06/19 23:05:06. <Main>: BLOB cache size: 524288
> I. 06/19 23:05:06. <Main>: Maximum number of BLOB bytes to compare:
> 4294967295
> I. 06/19 23:05:06. <Main>: Maximum number of database connections: 6
> I. 06/19 23:05:06. <Main>: Maximum number of deadlock retries: 10
> I. 06/19 23:05:06. <Main>: Timeout for inactive database connections: 60
> minutes
> I. 06/19 23:05:06. <Main>: Maximum delay between retries after deadlock:
30
> seconds
> I. 06/19 23:05:06. <Main>: Rowset size: 10
> I. 06/19 23:05:06. <Main>: Upload cache size: 524288 bytes
> I. 06/19 23:05:06. <Main>: Download cache size: 524288 bytes
> I. 06/19 23:05:06. <Main>: Number of worker threads: 5
> I. 06/19 23:05:06. <Main>: Maximum number of threads uploading
concurrently:
> 5
> W. 06/19 23:05:06. <Main>: Warning: Unknown users will be added
> automatically (when there is no authenticate_user script).
> I. 06/19 23:05:06. <Main>: Warning: Example scripts may be automatically
> generated for unknown versions.
> I. 06/19 23:05:06. <Main>: Local file for remote synchronization logs:
> 'dbmlsrv.mle'
> I. 06/19 23:05:06. <Main>: Stream specifier 1: TCPIP
> I. 06/19 23:05:06. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
> I. 06/19 23:05:06. <Main>: ODBC DBMS Version: 09.00.0000
> I. 06/19 23:05:06. <Main>: ODBC DBMS Driver Version: 09.00.0000
> I. 06/19 23:05:06. <Main>: ODBC Version supported by the driver: 3.52
> I. 06/19 23:05:06. <Main>: Collation sequence of the consolidated database
> is 'cp1252'
> I. 06/19 23:05:06. <Main>: Translated SQL:
> SET TEMPORARY OPTION CHAINED = 'ON'
> I. 06/19 23:05:06. <Main>: ODBC isolation set to: Read Committed
> I. 06/19 23:05:06. <Main>: Connected
> I. 06/19 23:05:06. <Main>: Translated SQL:
> SELECT COUNT(*) FROM ml_scripts_modified
> I. 06/19 23:05:06. <thread 1.1>: Ready to handle requests
> I. 06/19 23:05:06. <thread 1.2>: Ready to handle requests
> I. 06/19 23:05:06. <thread 1.3>: Ready to handle requests
> I. 06/19 23:05:06. <thread 1.4>: Ready to handle requests
> I. 06/19 23:05:06. <thread 1.5>: Ready to handle requests
> I. 06/19 23:05:18. <thread 1.5>: Working on a request
> I. 06/19 23:05:18. <thread 1.5>: Translated SQL:
> SELECT last_modified FROM ml_scripts_modified
> I. 06/19 23:05:18. <thread 1.5>: ml_scripts_modified last modified at:
> 2005-06-19 23:03:06.265000
> I. 06/19 23:05:18. <thread 1.5>: Translated SQL:
> SELECT version_id FROM ml_script_version WHERE name = ?
> I. 06/19 23:05:18. <thread 1.5>: ASA synchronization request from: gilbert
> (version: pdaClin)
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SET TEMPORARY OPTION CHAINED = 'ON'
> I. 06/19 23:05:18. <1.5> [gilbert]: ODBC isolation set to: Read Committed
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT t1.event, t2.script FROM ml_connection_script
t1,
> ml_script t2 WHERE t1.version_id = ? AND t1.script_id = t2.script_id
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_connection <connection> (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: begin_connection
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT hashed_password FROM ml_user WHERE name = ?
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT user_id FROM ml_user WHERE name = ?
> I. 06/19 23:05:18. <1.5> [gilbert]: Publication #1: pub_pdaClin,
> subscription id: 3, last download time: 2005-06-06 23:09:10.062000
> I. 06/19 23:05:18. <1.5> [gilbert]: Table #1: ALERGIAS, 3 columns
> I. 06/19 23:05:18. <1.5> [gilbert]: Column #1: char(10) NOT NULL PRIMARY
KEY
> I. 06/19 23:05:18. <1.5> [gilbert]: Column #2: varchar(50)
> I. 06/19 23:05:18. <1.5> [gilbert]: Column #3: varchar(200)
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT progress FROM ml_subscription WHERE user_id = ?
> AND subscription_id = ?
> I. 06/19 23:05:18. <1.5> [gilbert]: Progress offsets for the publications
> that are explicitly involved in the current synchronization
> I. 06/19 23:05:18. <1.5> [gilbert]: Subscription id 3: consolidated
progress
> 0 and remote progress 391368
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> UPDATE ml_subscription SET last_download_time = ?,
> publication_name = ? WHERE user_id = ? AND subscription_id = ?
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT table_id FROM ml_table WHERE name = ?
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_synchronizatio
n <connection> (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT t1.event, 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/19 23:05:18. <1.5> [gilbert]: begin_synchronizatio
n ALERGIAS (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT last_upload_time FROM ml_subscription WHERE
> user_id = ? AND subscription_id = ?
> I. 06/19 23:05:18. <1.5> [gilbert]: Last upload time for subscription id
3:
> 1900-01-01 00:00:00.000000
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_publication <connection> (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction:
> begin_synchronizatio
n
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_upload <connection> (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_upload ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_upload_rows ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> savepoint it0
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> release savepoint it0
> I. 06/19 23:05:18. <1.5> [gilbert]: end_upload_rows ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_upload ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_upload <connection> (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows uploaded into table ALERGIAS :
0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows inserted into table ALERGIAS :
0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows deleted in table ALERGIAS : 0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows updated into table ALERGIAS : 0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows conflicted in table ALERGIAS :
0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows ignored in table ALERGIAS : 0
> I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: end_upload
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> SELECT NOW(*)
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_download <connection> (no
script)
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_download ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_download_delet
es ALERGIAS (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: download_delete_curs
or ALERGIAS (open
> for read):
> select alergia from alergias where borrar = 'S'
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> select alergia from alergias where borrar = 'S'
> I. 06/19 23:05:18. <1.5> [gilbert]: download_delete_curs
or ALERGIAS
(close)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_download_deletes
ALERGIAS (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: begin_download_rows ALERGIAS (no
script)
> I. 06/19 23:05:18. <1.5> [gilbert]: download_cursor ALERGIAS (open for
> read):
> select alergia, nombre , descripcion from alergias
where
> borrar <> 'S' or borrar is null
> I. 06/19 23:05:18. <1.5> [gilbert]: Translated SQL:
> select alergia, nombre , descripcion from alergias
where
> borrar <> 'S' or borrar is null
> I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
> I. 06/19 23:05:18. <1.5> [gilbert]: 1
> I. 06/19 23:05:18. <1.5> [gilbert]: Alergia Medicamentoza
> I. 06/19 23:05:18. <1.5> [gilbert]: NULL
> I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
> I. 06/19 23:05:18. <1.5> [gilbert]: 2
> I. 06/19 23:05:18. <1.5> [gilbert]: Alergia a Alimentos
> I. 06/19 23:05:18. <1.5> [gilbert]: NULL
> I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
> I. 06/19 23:05:18. <1.5> [gilbert]: 3
> I. 06/19 23:05:18. <1.5> [gilbert]: Alergia al polen
> I. 06/19 23:05:18. <1.5> [gilbert]: NULL
> I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
> I. 06/19 23:05:18. <1.5> [gilbert]: 4
> I. 06/19 23:05:18. <1.5> [gilbert]: Alergia 4
> I. 06/19 23:05:18. <1.5> [gilbert]: NULL
> I. 06/19 23:05:18. <1.5> [gilbert]: Insert/Update row:
> I. 06/19 23:05:18. <1.5> [gilbert]: 5
> I. 06/19 23:05:18. <1.5> [gilbert]: Alergia 758
> I. 06/19 23:05:18. <1.5> [gilbert]: NULL
> I. 06/19 23:05:18. <1.5> [gilbert]: download_cursor ALERGIAS (close)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_download_rows ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_download ALERGIAS (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_download <connection> (no script)
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows downloaded for delete from
table
> ALERGIAS : 0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows downloaded for insert/update
from
> table ALERGIAS : 5
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows filtered for download from
table
> ALERGIAS : 0
> I. 06/19 23:05:18. <1.5> [gilbert]: # rows downloaded to remote from table
> ALERGIAS : 5
> I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction: end_download
> I. 06/19 23:05:18. <1.5> [gilbert]: Sending the download to the remote
> database.
> I. 06/19 23:05:18. <1.5> [gilbert]: end_publication <connection> (no
script)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_synchronization ALERGIAS (no
script)
> I. 06/19 23:05:18. <1.5> [gilbert]: end_synchronization <connection> (no
> script)
> I. 06/19 23:05:18. <1.5> [gilbert]: COMMIT Transaction:
end_synchronization[
color=darkred]
> I. 06/19 23:05:18. <1.5> [gilbert]: Synchronization complete
> ********
>
>[/color]
| |
|
| Reg Domaratzki (iAnywhere Solutions) escribió:
> This means that on the client between the time the upload was sent to the
> MobiLink Server and
> before the download was received from the MobiLink server, that another
> connection to the remote database modified a row in the database that was
> then later modified by the download stream received from the MobiLink
> server.
>
> The next time you synchronize, the error should not occur, unless you go
> and modify a row again while dbmlsync is waiting for the download stream
> from MobiLink.
>
>
I really dont know what was the problem , I deleted and created both
databases again and everything is working now.
thanks
Hugo
| |
| David Fishburn 2005-06-29, 11:24 am |
| Hugo <hstpaadmada@gmail.com> wrote in news:42bc0adc@forums
-2-dub of
sybase.public.sqlanywhere.mobilink:
H>> This means that on the client between the time the upload was sent to
H>> the MobiLink Server and
H>> before the download was received from the MobiLink server, that
H>> another connection to the remote database modified a row in the
H>> database that was then later modified by the download stream received
H>> from the MobiLink server.
H>>
H>> The next time you synchronize, the error should not occur, unless you
H>> go and modify a row again while dbmlsync is waiting for the download
H>> stream from MobiLink.
H>>
H>>
H>
H> I really dont know what was the problem , I deleted and created both
H> databases again and everything is working now.
This type of issue can easily happen again if you have created your
subscriptions with LockTables=off and have activity on the database
while you synchronize.
To address this *very* specific case, another option exists:
MobiLink Clients
Adaptive Server Anywhere Client Synchronization Parameters
dbmlsync options
dbmlsync extended options
ConflictRetries (cr) extended option
I recommend you read up on this setting and check what value you have
for this option.
--
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]
|
|
|
|
|