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.

I am trying to upgrade v9.0.2.2542 to 11.0.1.2755. I have updated the Sql Anywhere consolidated and I also ran the upgrade_asa.sql script with some error but the mlserver seems to be running.

I upgraded the remote using the dbunload and the -ar switch and that worked fine. Now I am trying to run dbmlsync for the first time and the sync immediately fails with the following log. I am not sure what to do??

I. 2012-03-08 17:46:40. SQL Anywhere MobiLink Client Version 11.0.1.2755
I. 2012-03-08 17:46:40. 
I. 2012-03-08 17:46:40. Copyright © 2011, iAnywhere Solutions, Inc.
I. 2012-03-08 17:46:40. Portions copyright © 2011, Sybase, Inc. All rights reserved.
I. 2012-03-08 17:46:40. Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
I. 2012-03-08 17:46:40. 
I. 2012-03-08 17:46:40. Connecting to remote database
I. 2012-03-08 17:46:40. Loading synchronization information
I. 2012-03-08 17:46:40. Disconnecting from remote database

asked 08 Mar '12, 19:50

jimboidaho's gravatar image

jimboidaho
111141422
accept rate: 0%

edited 09 Mar '12, 10:07

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.7k343118

Errors in the upgrade process are likely important to look at first. Please provide more details.

Can you provide any more details of the failure? Are there any errors in the MobiLink log? Using MobiLink server options such as -v+ and -ot generate high verbosity and log to a file respectively and can generally provide some clues.

(09 Mar '12, 09:47) Bill Frier

Here is the v+ log. The errors where on the consolidated and I am not hitting the consolidated yet. I think I will start another thread for the consolidated errors.

I. 2012-03-09 08:00:01. SQL Anywhere MobiLink Client Version 11.0.1.2755
I. 2012-03-09 08:00:01. 
I. 2012-03-09 08:00:01. Copyright © 2011, iAnywhere Solutions, Inc.
I. 2012-03-09 08:00:01. Portions copyright © 2011, Sybase, Inc. All rights reserved.
I. 2012-03-09 08:00:01. Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
I. 2012-03-09 08:00:01. 
I. 2012-03-09 08:00:01. 1: -v+
I. 2012-03-09 08:00:01. 2: -c
I. 2012-03-09 08:00:01. 3: **************************************
I. 2012-03-09 08:00:01. 4: -u
I. 2012-03-09 08:00:01. 5: kfalls_ws6
I. 2012-03-09 08:00:01. 6: -ot
I. 2012-03-09 08:00:01. 7: kfalls_ws6.txt
I. 2012-03-09 08:00:01. Connecting to remote database
I. 2012-03-09 08:00:01. Found hook procedures:
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_upload_end
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_abort
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_download_log_ri_violation
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_end
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_begin
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_delay
I. 2012-03-09 08:00:01. Loading synchronization information
I. 2012-03-09 08:00:01. Found hook procedures:
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_upload_end
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_abort
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_download_log_ri_violation
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_end
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_begin
I. 2012-03-09 08:00:01. sp_hook_dbmlsync_delay
I. 2012-03-09 08:00:01. Options in database for subscription to 'wam_pub' for 'kfalls_ws6':
I. 2012-03-09 08:00:01.         mem=2 Mb;pp=10;sch=EVERY:00:10;sv=v1.9;st=ON;
I. 2012-03-09 08:00:01. Disconnecting from remote database
(09 Mar '12, 10:02) jimboidaho

The problem was with the format of the extended options. "mem=2 Mb" is not a valid option. If you change it to "mem=2M" it should work like a charm.

I'm not pleased that no error or warning was reported, and will look into why.

permanent link

answered 09 Mar '12, 10:11

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.7k343118
accept rate: 37%

1

That was it. Yep an error would have been nice :-). Thanks Reg.

(09 Mar '12, 10:15) jimboidaho
Replies hidden
1

I'd recommend to "accept" this answer, cf. this "How-To"...

(09 Mar '12, 11:02) Volker Barth
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

Question tags:

×371

question asked: 08 Mar '12, 19:50

question was seen: 1,259 times

last updated: 12 Mar '12, 17:59