Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

How do I get dbmlsync to handle a current path 128 characters or longer?

1

How do I get 12.0.1.3298 dbmlsync.exe -x to properly process old log files when the current path is 128 characters long or longer?

"%SQLANY12%\bin32\dbmlsync.exe"^
  -c "ENG=remo;DBN=remo;UID=REMOTE_DBA;PWD=SQL"^
  -e "adr='host=localhost';sv=v1"^
  -o dbmlsync_log_remo.txt^
  -os 10M^
  -vnosu^
  -x

(please ignore the "...XXX137" and "...XXX138" in the following, the actual lengths are 127 and 128)

The first dbmlsync diagnostic log below shows two runs that WORK OK when the current path is 127 characters long: 

C:\projects\$SA_templates\MobiLink\MobiLink_demo_12_changing_primary_keys\simpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137

The second dbmlsync diagnostic log below shows the "No off-line transaction log file found" error produced when the current path is 128 characters long:

C:\projects\$SA_templates\MobiLink\MobiLink_demo_12_changing_primary_keys\simpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX138

Works... 

I. 2011-05-04 10:04:52. SQL Anywhere MobiLink Client Version 12.0.1.3298
I. 2011-05-04 10:04:52. 
I. 2011-05-04 10:04:52. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-05-04 10:04:52. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-05-04 10:04:52. Use of this software is governed by the Sybase License Agreement.
I. 2011-05-04 10:04:52. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-05-04 10:04:52. 
I. 2011-05-04 10:04:52. 1: -c
I. 2011-05-04 10:04:52. 2: 
I. 2011-05-04 10:04:52. 3: -e
I. 2011-05-04 10:04:52. 4: adr='host=localhost';sv=v1
I. 2011-05-04 10:04:52. 5: -o
I. 2011-05-04 10:04:52. 6: dbmlsync_log_remo.txt
I. 2011-05-04 10:04:52. 7: -os
I. 2011-05-04 10:04:52. 8: 10M
I. 2011-05-04 10:04:52. 9: -vnosu
I. 2011-05-04 10:04:52. 10: -x
I. 2011-05-04 10:04:52. Connecting to remote database
I. 2011-05-04 10:04:52. Loading synchronization information
I. 2011-05-04 10:04:52. Begin synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:04:52. Options for this synchronization:
I. 2011-05-04 10:04:52.         SV=v1,CTP=TCPIP,ADR='host=localhost'
I. 2011-05-04 10:04:52. Log scan starting at offset 0000547576
I. 2011-05-04 10:04:52. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137"
I. 2011-05-04 10:04:52. Processing transactions from active transaction log
I. 2011-05-04 10:04:53. Transaction log renamed to: 110504AA.LOG
I. 2011-05-04 10:04:53. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137"
I. 2011-05-04 10:04:53. Processing transactions from active transaction log
I. 2011-05-04 10:04:53. Hovering at end of active log
I. 2011-05-04 10:04:53. Log scan ended at offset 0000547943
I. 2011-05-04 10:04:53. Connecting to MobiLink server at 'host=localhost' using 'TCPIP'
I. 2011-05-04 10:04:53. Begin upload
I. 2011-05-04 10:04:53. Character set: windows-1252
I. 2011-05-04 10:04:53. MobiLink user name: 1
I. 2011-05-04 10:04:53. Script version: v1
I. 2011-05-04 10:04:53. Remote ID: b914f3a7-f65e-4596-8146-06d8977aae72
I. 2011-05-04 10:04:53. Subscription 'pub1' - Synchronizing - Log offset 0000547576 - Last download time 1900-01-01 00:00:00.0.
I. 2011-05-04 10:04:53. Subscription 'pub1' has never been synchronized. Progress offsets will not be checked.
I. 2011-05-04 10:04:53. Processor is little-endian
I. 2011-05-04 10:04:53. Article table: parent
I. 2011-05-04 10:04:53. Article column: varchar          p1(10) NOT NULL
I. 2011-05-04 10:04:53. Article column: integer          data NOT NULL
I. 2011-05-04 10:04:53. Article column: bigint           r1 NOT NULL PRIMARY KEY
I. 2011-05-04 10:04:53. Table Upload Order: parent
I. 2011-05-04 10:04:53. Uploading table operations
I. 2011-05-04 10:04:53. # rows inserted in table parent : 0
I. 2011-05-04 10:04:53. # rows deleted in table parent : 0
I. 2011-05-04 10:04:53. # rows updated in table parent : 0
I. 2011-05-04 10:04:53. Waiting for MobiLink to apply upload
I. 2011-05-04 10:04:53. Sending schema information to MobiLink server.
I. 2011-05-04 10:04:53. Processor is little-endian
I. 2011-05-04 10:04:53. Article table: parent
I. 2011-05-04 10:04:53. Article column: varchar          p1(10) NOT NULL
I. 2011-05-04 10:04:53. Article column: integer          data NOT NULL
I. 2011-05-04 10:04:53. Article column: bigint           r1 NOT NULL PRIMARY KEY
I. 2011-05-04 10:04:53. Table Upload Order: parent
I. 2011-05-04 10:04:53. The user authentication value is 1000.
I. 2011-05-04 10:04:53. Setting last upload time to 2011-05-04 10:04:53.58.
I. 2011-05-04 10:04:53. Setting generation number for subscription pub1 to 1.
I. 2011-05-04 10:04:53. COMMIT
I. 2011-05-04 10:04:53. Download stream: received 12 bytes from MobiLink server.
I. 2011-05-04 10:04:53. Processing download stream ...
I. 2011-05-04 10:04:53. Downloading into table: parent
I. 2011-05-04 10:04:53. # rows inserted/updated into table parent : 1
I. 2011-05-04 10:04:53. # rows deleted in table parent : 0
I. 2011-05-04 10:04:53. COMMIT
I. 2011-05-04 10:04:53. Completed processing of download stream
I. 2011-05-04 10:04:53. End synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:04:53. Disconnecting from MobiLink server
I. 2011-05-04 10:04:54. Complete log scan required.
I. 2011-05-04 10:04:54. Synchronization completed
I. 2011-05-04 10:04:54. Disconnecting from remote database
I. 2011-05-04 10:05:00. SQL Anywhere MobiLink Client Version 12.0.1.3298
I. 2011-05-04 10:05:00. 
I. 2011-05-04 10:05:00. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-05-04 10:05:00. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-05-04 10:05:00. Use of this software is governed by the Sybase License Agreement.
I. 2011-05-04 10:05:00. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-05-04 10:05:00. 
I. 2011-05-04 10:05:00. 1: -c
I. 2011-05-04 10:05:00. 2: 
I. 2011-05-04 10:05:00. 3: -e
I. 2011-05-04 10:05:00. 4: adr='host=localhost';sv=v1
I. 2011-05-04 10:05:00. 5: -o
I. 2011-05-04 10:05:00. 6: dbmlsync_log_remo.txt
I. 2011-05-04 10:05:00. 7: -os
I. 2011-05-04 10:05:00. 8: 10M
I. 2011-05-04 10:05:00. 9: -vnosu
I. 2011-05-04 10:05:00. 10: -x
I. 2011-05-04 10:05:00. Connecting to remote database
I. 2011-05-04 10:05:00. Loading synchronization information
I. 2011-05-04 10:05:00. Begin synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:05:00. Options for this synchronization:
I. 2011-05-04 10:05:00.         SV=v1,CTP=TCPIP,ADR='host=localhost'
I. 2011-05-04 10:05:00. Log scan starting at offset 0000547943
I. 2011-05-04 10:05:00. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137"
I. 2011-05-04 10:05:00. Processing transactions from active transaction log
I. 2011-05-04 10:05:01. Transaction log renamed to: 110504AB.LOG
I. 2011-05-04 10:05:01. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137"
I. 2011-05-04 10:05:01. Transaction log "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137110504AB.LOG" starts at offset 0000547943
I. 2011-05-04 10:05:01. Processing transactions from transaction log "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137110504AB.LOG"
I. 2011-05-04 10:05:01. Transaction log ends at offset 0000552654
I. 2011-05-04 10:05:01. Processing transactions from active transaction log
I. 2011-05-04 10:05:01. Hovering at end of active log
I. 2011-05-04 10:05:01. Log scan ended at offset 0000552580
I. 2011-05-04 10:05:01. Connecting to MobiLink server at 'host=localhost' using 'TCPIP'
I. 2011-05-04 10:05:01. Begin upload
I. 2011-05-04 10:05:01. Character set: windows-1252
I. 2011-05-04 10:05:01. MobiLink user name: 1
I. 2011-05-04 10:05:01. Script version: v1
I. 2011-05-04 10:05:01. Remote ID: b914f3a7-f65e-4596-8146-06d8977aae72
I. 2011-05-04 10:05:01. Subscription 'pub1' - Synchronizing - Log offset 0000547943 - Last download time 2011-05-04 10:04:53.584.
I. 2011-05-04 10:05:01. Processor is little-endian
I. 2011-05-04 10:05:01. Article table: parent
I. 2011-05-04 10:05:01. Article column: varchar          p1(10) NOT NULL
I. 2011-05-04 10:05:01. Article column: integer          data NOT NULL
I. 2011-05-04 10:05:01. Article column: bigint           r1 NOT NULL PRIMARY KEY
I. 2011-05-04 10:05:01. Table Upload Order: parent
I. 2011-05-04 10:05:01. Uploading table operations
I. 2011-05-04 10:05:01. # rows inserted in table parent : 0
I. 2011-05-04 10:05:01. # rows deleted in table parent : 0
I. 2011-05-04 10:05:01. # rows updated in table parent : 0
I. 2011-05-04 10:05:01. Waiting for MobiLink to apply upload
I. 2011-05-04 10:05:01. The user authentication value is 1000.
I. 2011-05-04 10:05:01. Setting last upload time to 2011-05-04 10:05:01.306.
I. 2011-05-04 10:05:01. Setting generation number for subscription pub1 to 1.
I. 2011-05-04 10:05:01. COMMIT
I. 2011-05-04 10:05:01. Download stream: received 1 bytes from MobiLink server.
I. 2011-05-04 10:05:01. Processing download stream ...
I. 2011-05-04 10:05:01. Downloading into table: parent
I. 2011-05-04 10:05:01. # rows inserted/updated into table parent : 0
I. 2011-05-04 10:05:01. # rows deleted in table parent : 0
I. 2011-05-04 10:05:01. COMMIT
I. 2011-05-04 10:05:01. Completed processing of download stream
I. 2011-05-04 10:05:01. End synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:05:01. Disconnecting from MobiLink server
I. 2011-05-04 10:05:01. Complete log scan required.
I. 2011-05-04 10:05:01. Synchronization completed
I. 2011-05-04 10:05:01. Disconnecting from remote database
I. 2011-05-04 10:05:13. SQL Anywhere MobiLink Client Version 12.0.1.3298
I. 2011-05-04 10:05:13. 
I. 2011-05-04 10:05:13. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-05-04 10:05:13. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-05-04 10:05:13. Use of this software is governed by the Sybase License Agreement.
I. 2011-05-04 10:05:13. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-05-04 10:05:13. 
I. 2011-05-04 10:05:13. 1: -c
I. 2011-05-04 10:05:13. 2:

I. 2011-05-04 10:05:13. 3: -e
I. 2011-05-04 10:05:13. 4: adr='host=localhost';sv=v1
I. 2011-05-04 10:05:13. 5: -o
I. 2011-05-04 10:05:13. 6: dbmlsync_log_remo.txt
I. 2011-05-04 10:05:13. 7: -os
I. 2011-05-04 10:05:13. 8: 10M
I. 2011-05-04 10:05:13. 9: -vnosu
I. 2011-05-04 10:05:13. 10: -x
I. 2011-05-04 10:05:13. Connecting to remote database
I. 2011-05-04 10:05:13. Loading synchronization information
I. 2011-05-04 10:05:13. Begin synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:05:13. Options for this synchronization:
I. 2011-05-04 10:05:13.         SV=v1,CTP=TCPIP,ADR='host=localhost'
I. 2011-05-04 10:05:13. Log scan starting at offset 0000552580
I. 2011-05-04 10:05:13. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137"
I. 2011-05-04 10:05:13. Transaction log "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137110504AB.LOG" starts at offset 0000547943
I. 2011-05-04 10:05:13. Processing transactions from transaction log "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137110504AB.LOG"
I. 2011-05-04 10:05:13. Transaction log ends at offset 0000552654
I. 2011-05-04 10:05:13. Processing transactions from active transaction log
I. 2011-05-04 10:05:13. Transaction log renamed to: 110504AC.LOG
I. 2011-05-04 10:05:14. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137"
I. 2011-05-04 10:05:14. Transaction log "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137110504AC.LOG" starts at offset 0000552654
I. 2011-05-04 10:05:14. Processing transactions from transaction log "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keyssimpleXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX137110504AC.LOG"
I. 2011-05-04 10:05:14. Transaction log ends at offset 0000557192
I. 2011-05-04 10:05:14. Processing transactions from active transaction log
I. 2011-05-04 10:05:14. Hovering at end of active log
I. 2011-05-04 10:05:14. Log scan ended at offset 0000557118
I. 2011-05-04 10:05:14. Connecting to MobiLink server at 'host=localhost' using 'TCPIP'
I. 2011-05-04 10:05:14. Begin upload
I. 2011-05-04 10:05:14. Character set: windows-1252
I. 2011-05-04 10:05:14. MobiLink user name: 1
I. 2011-05-04 10:05:14. Script version: v1
I. 2011-05-04 10:05:14. Remote ID: b914f3a7-f65e-4596-8146-06d8977aae72
I. 2011-05-04 10:05:14. Subscription 'pub1' - Synchronizing - Log offset 0000552580 - Last download time 2011-05-04 10:05:01.31.
I. 2011-05-04 10:05:14. Processor is little-endian
I. 2011-05-04 10:05:14. Article table: parent
I. 2011-05-04 10:05:14. Article column: varchar          p1(10) NOT NULL
I. 2011-05-04 10:05:14. Article column: integer          data NOT NULL
I. 2011-05-04 10:05:14. Article column: bigint           r1 NOT NULL PRIMARY KEY
I. 2011-05-04 10:05:14. Table Upload Order: parent
I. 2011-05-04 10:05:14. Uploading table operations
I. 2011-05-04 10:05:14. # rows inserted in table parent : 0
I. 2011-05-04 10:05:14. # rows deleted in table parent : 0
I. 2011-05-04 10:05:14. # rows updated in table parent : 0
I. 2011-05-04 10:05:14. Waiting for MobiLink to apply upload
I. 2011-05-04 10:05:14. The user authentication value is 1000.
I. 2011-05-04 10:05:14. Setting last upload time to 2011-05-04 10:05:14.364.
I. 2011-05-04 10:05:14. Setting generation number for subscription pub1 to 1.
I. 2011-05-04 10:05:14. COMMIT
I. 2011-05-04 10:05:14. Download stream: received 1 bytes from MobiLink server.
I. 2011-05-04 10:05:14. Processing download stream ...
I. 2011-05-04 10:05:14. Downloading into table: parent
I. 2011-05-04 10:05:14. # rows inserted/updated into table parent : 0
I. 2011-05-04 10:05:14. # rows deleted in table parent : 0
I. 2011-05-04 10:05:14. COMMIT
I. 2011-05-04 10:05:14. Completed processing of download stream
I. 2011-05-04 10:05:14. End synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:05:14. Disconnecting from MobiLink server
I. 2011-05-04 10:05:14. Complete log scan required.
I. 2011-05-04 10:05:14. Synchronization completed
I. 2011-05-04 10:05:14. Disconnecting from remote database

Fails... 

I. 2011-05-04 10:12:00. SQL Anywhere MobiLink Client Version 12.0.1.3298
I. 2011-05-04 10:12:00. 
I. 2011-05-04 10:12:00. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-05-04 10:12:00. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-05-04 10:12:00. Use of this software is governed by the Sybase License Agreement.
I. 2011-05-04 10:12:00. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-05-04 10:12:00. 
I. 2011-05-04 10:12:00. 1: -c
I. 2011-05-04 10:12:00. 2:

I. 2011-05-04 10:12:00. 3: -e
I. 2011-05-04 10:12:00. 4: adr='host=localhost';sv=v1
I. 2011-05-04 10:12:00. 5: -o
I. 2011-05-04 10:12:00. 6: dbmlsync_log_remo.txt
I. 2011-05-04 10:12:00. 7: -os
I. 2011-05-04 10:12:00. 8: 10M
I. 2011-05-04 10:12:00. 9: -vnosu
I. 2011-05-04 10:12:00. 10: -x
I. 2011-05-04 10:12:00. Connecting to remote database
I. 2011-05-04 10:12:00. Loading synchronization information
I. 2011-05-04 10:12:00. Begin synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:12:00. Options for this synchronization:
I. 2011-05-04 10:12:00.         SV=v1,CTP=TCPIP,ADR='host=localhost'
I. 2011-05-04 10:12:00. Log scan starting at offset 0000547576
I. 2011-05-04 10:12:00. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keys"
I. 2011-05-04 10:12:00. Processing transactions from active transaction log
I. 2011-05-04 10:12:01. Transaction log renamed to: 110504AA.LOG
I. 2011-05-04 10:12:01. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keys"
I. 2011-05-04 10:12:01. Processing transactions from active transaction log
I. 2011-05-04 10:12:01. Hovering at end of active log
I. 2011-05-04 10:12:01. Log scan ended at offset 0000547943
I. 2011-05-04 10:12:01. Connecting to MobiLink server at 'host=localhost' using 'TCPIP'
I. 2011-05-04 10:12:01. Begin upload
I. 2011-05-04 10:12:01. Character set: windows-1252
I. 2011-05-04 10:12:01. MobiLink user name: 1
I. 2011-05-04 10:12:01. Script version: v1
I. 2011-05-04 10:12:01. Remote ID: d99b474d-359c-447c-91d2-d49ccc3c0b57
I. 2011-05-04 10:12:01. Subscription 'pub1' - Synchronizing - Log offset 0000547576 - Last download time 1900-01-01 00:00:00.0.
I. 2011-05-04 10:12:01. Subscription 'pub1' has never been synchronized. Progress offsets will not be checked.
I. 2011-05-04 10:12:01. Processor is little-endian
I. 2011-05-04 10:12:01. Article table: parent
I. 2011-05-04 10:12:01. Article column: varchar          p1(10) NOT NULL
I. 2011-05-04 10:12:01. Article column: integer          data NOT NULL
I. 2011-05-04 10:12:01. Article column: bigint           r1 NOT NULL PRIMARY KEY
I. 2011-05-04 10:12:01. Table Upload Order: parent
I. 2011-05-04 10:12:01. Uploading table operations
I. 2011-05-04 10:12:01. # rows inserted in table parent : 0
I. 2011-05-04 10:12:01. # rows deleted in table parent : 0
I. 2011-05-04 10:12:01. # rows updated in table parent : 0
I. 2011-05-04 10:12:01. Waiting for MobiLink to apply upload
I. 2011-05-04 10:12:01. Sending schema information to MobiLink server.
I. 2011-05-04 10:12:01. Processor is little-endian
I. 2011-05-04 10:12:01. Article table: parent
I. 2011-05-04 10:12:01. Article column: varchar          p1(10) NOT NULL
I. 2011-05-04 10:12:01. Article column: integer          data NOT NULL
I. 2011-05-04 10:12:01. Article column: bigint           r1 NOT NULL PRIMARY KEY
I. 2011-05-04 10:12:01. Table Upload Order: parent
I. 2011-05-04 10:12:02. The user authentication value is 1000.
I. 2011-05-04 10:12:02. Setting last upload time to 2011-05-04 10:12:02.001.
I. 2011-05-04 10:12:02. Setting generation number for subscription pub1 to 1.
I. 2011-05-04 10:12:02. COMMIT
I. 2011-05-04 10:12:02. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keys"
I. 2011-05-04 10:12:02. Download stream: received 12 bytes from MobiLink server.
I. 2011-05-04 10:12:02. Processing download stream ...
I. 2011-05-04 10:12:02. Downloading into table: parent
I. 2011-05-04 10:12:02. # rows inserted/updated into table parent : 1
I. 2011-05-04 10:12:02. # rows deleted in table parent : 0
I. 2011-05-04 10:12:02. COMMIT
I. 2011-05-04 10:12:02. Completed processing of download stream
I. 2011-05-04 10:12:02. End synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:12:02. Disconnecting from MobiLink server
I. 2011-05-04 10:12:02. Complete log scan required.
I. 2011-05-04 10:12:02. Synchronization completed
I. 2011-05-04 10:12:02. Disconnecting from remote database
I. 2011-05-04 10:12:06. SQL Anywhere MobiLink Client Version 12.0.1.3298
I. 2011-05-04 10:12:06. 
I. 2011-05-04 10:12:06. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-05-04 10:12:06. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-05-04 10:12:06. Use of this software is governed by the Sybase License Agreement.
I. 2011-05-04 10:12:06. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-05-04 10:12:06. 
I. 2011-05-04 10:12:06. 1: -c
I. 2011-05-04 10:12:06. 2:

I. 2011-05-04 10:12:06. 3: -e
I. 2011-05-04 10:12:06. 4: adr='host=localhost';sv=v1
I. 2011-05-04 10:12:06. 5: -o
I. 2011-05-04 10:12:06. 6: dbmlsync_log_remo.txt
I. 2011-05-04 10:12:06. 7: -os
I. 2011-05-04 10:12:06. 8: 10M
I. 2011-05-04 10:12:06. 9: -vnosu
I. 2011-05-04 10:12:06. 10: -x
I. 2011-05-04 10:12:06. Connecting to remote database
I. 2011-05-04 10:12:06. Loading synchronization information
I. 2011-05-04 10:12:06. Begin synchronizing subscription(s) 'pub1'
I. 2011-05-04 10:12:06. Options for this synchronization:
I. 2011-05-04 10:12:06.         SV=v1,CTP=TCPIP,ADR='host=localhost'
I. 2011-05-04 10:12:06. Log scan starting at offset 0000547943
I. 2011-05-04 10:12:06. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keys"
I. 2011-05-04 10:12:06. Processing transactions from active transaction log
I. 2011-05-04 10:12:06. Transaction log renamed to: 110504AB.LOG
I. 2011-05-04 10:12:06. Processing transaction logs from directory "C:projects$SA_templatesMobiLinkMobiLink_demo_12_changing_primary_keys"
E. 2011-05-04 10:12:06. No off-line transaction log file found and on-line transaction log starts at offset 0000552654.
I. 2011-05-04 10:12:06. We are looking for a transaction log file starting at offset 0000552580.
E. 2011-05-04 10:12:06. Upload aborted at offset 0000552580
I. 2011-05-04 10:12:06. Complete log scan required.
I. 2011-05-04 10:12:06. Synchronization completed
I. 2011-05-04 10:12:06. Disconnecting from remote database

asked 04 May '11, 10:19

Breck%20Carter's gravatar image

Breck Carter
32.5k●541●726●1050
accept rate: 20%

edited 13 May '11, 15:47

Graeme%20Perrow's gravatar image

Graeme Perrow
9.6k●3●79●124

Hmm, when copying your pathes to my editor, they seem to be 128 vs. 129 chars long ... and they look o.k. as pathes. As such, may the 128 chars limit feel more common (though not better, arguably)?

(04 May '11, 10:27) Volker Barth
Replies hidden

Using the revision button for this question is much fun...

(04 May '11, 12:46) Volker Barth

Thanks for checking... I should have recognized "138" was wrong, it's not a power of two!

(05 May '11, 05:57) Breck Carter
2 Answers:
active answersoldest answersnewest answerspopular answers
4

You can work around this issue by adding the directory containing the offline logs (in this case the current working directory) to the end of the dbmlsync commandline.

For example:

dbmlsync.exe -c uid=dba;pwd=sql -x -v+ c:\my\really\long\current\working\directory

This bypasses the code that has the length limitation. I'll pass this issue on to the appropriate developer so that it can be fixed.

Dave

attachment from breck...92link text92

permanent link

answered 05 May '11, 16:54

Dave%20Wellstood's gravatar image

Dave Wellstood
226●2●4●10
accept rate: 0%

edited 10 May '11, 16:10

Breck%20Carter's gravatar image

Breck Carter
32.5k●541●726●1050

Are you 100% sure that works? If I remember correctly, I tried it and it did not help.

(10 May '11, 09:56) Breck Carter
Replies hidden

It worked when I tried it. Its always possible that there is something special about your case that would make it different from what I tested.

Are you positive that you did try this fix? Can you please try it again, just to be sure? If that still doesn't get you going I'll work with you to find out what's different between our 2 setups.

Dave

(10 May '11, 10:23) Dave Wellstood
0

Dave: See the attachment in your reply. There may be another length problem, wherein it works for you because my whole command line is longer (see file 003_run_dbmlsync_MODIFIED.bat, which throws a syntax error even if I use an @file).

PS I added this as a reply instead of a comment because I kept getting "unknown error".

permanent link

answered 10 May '11, 16:14

Breck%20Carter's gravatar image

Breck Carter
32.5k●541●726●1050
accept rate: 20%

edited 10 May '11, 16:14

Breck

Thanks for the nice repro. It made figuring this out much easier!

I think your problem is that you have a -x immediately before the offline log directory. Since this is a problem others might encounter I've created a new topic for it:

http://sqlanywhere-forum.sap.com/questions/5377/how-do-i-specify-the-x-option-and-the-offline-log-file-directory-together-in-dbmlsync?page=1#5378

(11 May '11, 14:31) Dave Wellstood
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Question tags:

×371
×106
×24

question asked: 04 May '11, 10:19

question was seen: 3,356 times

last updated: 13 May '11, 15:47

Related questions

Stopping synchronization at user's request (MobiLink)

dbmlsync 12 service shuts down after connection to remote db fails

How to see performed Mobilink SQL while debugging c#?

Best practices for running multiple synchronization profiles (MobiLink) ?

How do I force MobiLink to work in single row mode?

dbmlmon "I/O error when receiving authentication result."

Mobilink Client without transaction log files

MLSRV10 starting multiple DBs

Mobilink screen freezes in Windows Mobile 6.5

The database server failed to shut down the dbmlsync server