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.

From a fresh installation of SA12, MobiLink and EBFs (version 12.0.1.3769) I cannot deploy my Synchronization Model properly. Operating system is Windows Server 2008 R2 and I am using the 64-bit edition of Sybase Central. I've also tried to run the deployment wizard on a Windows 8 computer with the same results.

.sql files for deployment seems to be fine, it fails on writing the .bat file for dbmlsync:

Output from deployment wizard:

Generating events. . .
Finished generating events.
Generating properties. . .
Finished generating properties.
Deploying. . . 
Deploying to 'C:\TEST\consolidated\TEST_consolidated.sql'.
Finished deploying to 'C:\TEST\consolidated\TEST_consolidated.sql'.
Deploying to 'C:\TEST\consolidated\TEST_consolidated.bat'.
Finished deploying to 'C:\TEST\consolidated\TEST_consolidated.bat'.
Deploying to 'C:\TEST\remote\TEST_remote.sql'.
Finished deploying to 'C:\TEST\remote\TEST_remote.sql'.
Deploying to 'C:\TEST\remote\TEST_remote.bat'.
Finished deploying to 'C:\TEST\remote\TEST_remote.bat'.
Deploying to 'C:\TEST\remote\TEST_dbmlsync.bat'.
The synchronization model could not be deployed.
Error for: Rendering macro APPEND_VAR
Failed.

Details from error message:

The synchronization model could not be deployed.
Error for: Rendering macro APPEND_VAR
Error for: Rendering macro APPEND_VAR
Error while generating output from templates
ianywhere.ml.design.generate.ScriptGenerationException: Error while generating output from templates

This is how the dbmlsync bat file looks like, something's missing:

goto after_find_sa_bin
:have_sqlanyn
set _sa_bin="%sqlany12%\Bin64\"
if exist %_sa_bin%dbmlsync.exe goto after_find_sa_bin
set _sa_bin="%sqlany12%\Bin32\"
:after_find_sa_bin

REM Setting variables. . .
if [%1] == [] goto usage
set CONNECTION=%~1
set PROFILE="TEST_test"
set VERBOSITY=
set PARAMS=

goto after_usage
:usage
REM Display Usage
echo Usage:   %0 CONNECTION
echo.
echo CONNECTION   REMOTE DBA connection string for synchronizing the remote database (eg "DBF=my_db.db;UID=my_sync_user;PWD=my_sync_pass") See also "GRANT REMOTE DBA statement" in documentation.
goto end
:after_usage

REM Executing commands. . .

asked 05 Nov '12, 05:13

OskarEmil's gravatar image

OskarEmil
431161831
accept rate: 50%


Thanks for reporting this problem. It occurs because you unchecked the Save message log to the following file (using -ot option) option on the Verbosity For SQL Anywhere Remote Synchronization Client page of the Deploy Synchronization Model Wizard.

As a workaround, simply leave that option enabled (as it is by default) when deploying your synchronization model.

Update: The issue number for this bug is 723368 and the fix is in build 12.0.1.3814, so will be in any future EBF releases with that build number or higher.

permanent link

answered 05 Nov '12, 19:11

Graham%20Hurst's gravatar image

Graham Hurst
2.7k11843
accept rate: 29%

edited 05 Nov '12, 19:44

Thanks a lot ^^

(06 Nov '12, 03:33) OskarEmil
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
×27
×27

question asked: 05 Nov '12, 05:13

question was seen: 2,152 times

last updated: 06 Nov '12, 03:33