cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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

on ‎2011 May 04 11:19 AM

3,548

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

Show replies
Show replies
VolkerBarth
Contributor
‎2011 May 04 11:27 AM
0 Kudos

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)?

VolkerBarth
Contributor
‎2011 May 04 1:46 PM
0 Kudos

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

Breck_Carter
Participant
‎2011 May 05 6:56 AM
0 Kudos

Oops, forgot to include the command line in the question... it is there now, and it shows that there's no path coded, so the @data option is unlikely to help. The problem is with the current path, and it only affects the dbmlsync -x process on the second and later runs. All other utilities, including other processes performed by dbmlsync, have no problem with long current paths. If you look at the diagnostic log, you will see when the current path gets to 128, the last folder is dropped entirely (not a simple truncation).

Breck_Carter
Participant
‎2011 May 05 6:57 AM
0 Kudos

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

Former Member
‎2011 May 05 4:53 PM
0 Kudos

Thanks for adding the command line. Now that I can see it, I agree that the @data option won't help.

Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎2011 May 05 5:54 PM

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

Show replies
Show replies
Breck_Carter
Participant
‎2011 May 10 10:56 AM
0 Kudos

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

Former Member
‎2011 May 10 11:23 AM
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
‎2011 May 10 5:12 PM
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
‎2011 May 10 5:12 PM
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
‎2011 May 10 5:13 PM
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
‎2011 May 10 5:13 PM
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
‎2011 May 10 5:13 PM
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
‎2011 May 10 5:14 PM
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".

Show replies
Show replies
Former Member
‎2011 May 11 3:31 PM
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...

Ask a Question