Deploying MobiLink, Error for: Rendering macro APPEND_VAR Failed.

[Former Member]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks a lot ^^