cancel
Showing results for 
Search instead for 
Did you mean: 

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

Breck_Carter
Participant
3,569

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member

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

Breck_Carter
Participant
0 Kudos

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

Former Member
0 Kudos

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

Breck_Carter
Participant
0 Kudos
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).
Breck_Carter
Participant
0 Kudos
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).
Breck_Carter
Participant
0 Kudos
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).
Breck_Carter
Participant
0 Kudos
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).
Breck_Carter
Participant
0 Kudos
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).
Breck_Carter
Participant
0 Kudos

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".

Former Member
0 Kudos

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-fi...