Skip to Content
Nov 19, 2018 at 11:48 AM

SQL Anywhere 17 removed during BOBJ 4.2 SP6 upgrade



I was running the service pack to upgrade BOBJ 4.2 SP5 to SP6 on a Windows Server 2012 R2 machine. All was working fine before the upgrade. The system uses the bundled SQL Anywhere 17 database for CMS and Audit.

However the upgrade failed and the SIA\CMS failed to restart afterwards because the whole install of SQL Anywhere on the machine had disappeared, taking the DSNs and install files with it!! The install dir\sqlanywhere directory has 'BIN64', 'database', and 'Jajva' folders in it, but nothing else and no content to those folders (except for the original CMS and Audit database and log files, thankfully).

How do I get out of this predicament? I have run a repair install but this has not replaced the SQL Anywhere installation. Can I manually install SQL Anywhere? How do I do that without specific licence keys for it, as I assume they are bundled somewhere in the BOBJ install.

Any other suggestions or am I facing a complete reinstall and rebuild using the database and filestore?