on 2011 May 04 11:19 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
User | Count |
---|---|
78 | |
29 | |
9 | |
9 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.