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.

versoin 11.0.1.2755 I am working on a conversion from asa 9.2 to 11. Everything seems to be working until I try and sync to the new server. dbmlsync connects to remote database reads the procedures and then just disconnects with no errors. Not sure where to go from here. Thanks.

Here is the log.

I. 2012-04-12 08:24:39. SQL Anywhere MobiLink Client Version 11.0.1.2755
I. 2012-04-12 08:24:39. 
I. 2012-04-12 08:24:39. Copyright © 2011, iAnywhere Solutions, Inc.
I. 2012-04-12 08:24:39. Portions copyright © 2011, Sybase, Inc. All rights reserved.
I. 2012-04-12 08:24:39. Use of this software is governed by the Sybase License Agreement. Refer to http://www.sybase.com/softwarelicenses
I. 2012-04-12 08:24:39. 
I. 2012-04-12 08:24:39. 1: -v+
I. 2012-04-12 08:24:39. 2: -qc
I. 2012-04-12 08:24:39. 3: -c
I. 2012-04-12 08:24:39. 4: *****************************************************
I. 2012-04-12 08:24:39. 5: -u
I. 2012-04-12 08:24:39. 6: kfalls_ws6
I. 2012-04-12 08:24:39. 7: -o
I. 2012-04-12 08:24:39. 8: \weighstation11\manual_kfalls_ws6.txt
I. 2012-04-12 08:24:39. Connecting to remote database
W. 2012-04-12 08:24:39. The sp_hook_dbmlsync_download_com_error hook has been deprecated. Support for this hook will be removed in a future release.
W. 2012-04-12 08:24:39. The sp_hook_dbmlsync_download_sql_error hook has been deprecated. Support for this hook will be removed in a future release.
I. 2012-04-12 08:24:39. Found hook procedures:
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_upload_end
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_abort
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_download_log_ri_violation
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_end
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_download_com_error
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_begin
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_delay
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_download_sql_error
I. 2012-04-12 08:24:39. Loading synchronization information
W. 2012-04-12 08:24:39. The sp_hook_dbmlsync_download_com_error hook has been deprecated. Support for this hook will be removed in a future release.
W. 2012-04-12 08:24:39. The sp_hook_dbmlsync_download_sql_error hook has been deprecated. Support for this hook will be removed in a future release.
I. 2012-04-12 08:24:39. Found hook procedures:
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_upload_end
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_abort
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_download_log_ri_violation
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_end
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_download_com_error
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_begin
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_delay
I. 2012-04-12 08:24:39. sp_hook_dbmlsync_download_sql_error
I. 2012-04-12 08:24:39. Options in database for subscription to 'wam_pub' for 'kfalls_ws6':
I. 2012-04-12 08:24:39.         mem=2 Mb;pp=10;sv=v1.9;st=ON;
I. 2012-04-12 08:24:39. Disconnecting from remote database

asked 12 Apr '12, 10:23

jimboidaho's gravatar image

jimboidaho
111141422
accept rate: 0%

edited 12 Apr '12, 10:56

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.7k343118


W. 2012-04-12 08:24:39. The sp_hook_dbmlsync_download_com_error hook has been deprecated. Support for this hook will be removed in a future release.

For other customers who may be reading this thread, be aware that the 'sp_hook_dbmlsync_download_com_error' hook has been removed in version 12.0.0 and up.

See: http://dcx.sybase.com/index.html#1101/en/mlclient_en11/sp-hook-download-com-ml-ref.html for the deprecation notice

See: http://dcx.sybase.com/index.html#1201/en/sachanges/sacf9dd45a-c56f-4923-aaef-d737361e576f.html for the discontinued feature notice.

permanent link

answered 12 Apr '12, 10:42

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

I think I asked this question once before. mem=2m not mem=2 Mb. Must be the first sign of old age, memory going. Sorry. All is well.

permanent link

answered 12 Apr '12, 10:35

jimboidaho's gravatar image

jimboidaho
111141422
accept rate: 0%

Glad to hear that you have found your old question and could resolve the issue! :)

(12 Apr '12, 10:44) Jeff Albion

i'm relatively new at Mobilink. my dumb guess is the db log file on the remote is out of sync with the new ASA 11 db. put a blank db on the remote device and try it again.

permanent link

answered 13 Apr '12, 15:25

Tom%20Mangano's gravatar image

Tom Mangano
672242738
accept rate: 8%

edited 13 Apr '12, 15:26

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: 12 Apr '12, 10:23

question was seen: 1,935 times

last updated: 15 Apr '12, 15:36