I'm somewhat new to using SQL Anywhere. We have a project requirement for it so I've installed the base installation files from SAP. Without any updates added, the SA17 version reports 17.0.0.1062. This is on Windows Server 2012 R2 btw. I also have JRE8u261 installed. In this configuration SQL Central (scjview.exe) opens just fine. However, once I start applying any of the recent EBF patch files I can no longer open SQL Central. The patch files install fine on the surface, but if I try to open SQL Central now I get the following error: "This file could not be found: sqlcentral1700.jar" It seems like I have tried every file starting with PL61 Build 6175 (released on 13.08.2020). I worked my way all the way back to PL42 Build 5750 (released on 16.04.2019) before I no longer got the error. I would have to uninstall SA and reinstall it each time. So right now I'm on 17.0.10.5750 and I can't upgrade without it breaking SQL Central. I'm downloading the EBF zip files from the SAP Launchpad site (e.g., SQLANYW170000P_61-71001031.ZIP). Am I doing something wrong when I try to upgrade? Is there a specific log file I can view that can give me a better idea of how to proceed? Any help would be greatly appreciated. Thank you. |
As JBSchueler commented above, it was a bad Windows environment variable. I'm adding this so there is an official answer to the question. |
Is your SQLANY17 environment variable set correctly? This is a key requirement in recent releases.
Oh my! That was it. Thank you! The environment variable was set, but it was pointing to "C:\Program Files (x86)\SQL Anywhere 17\". I changed it to "C:\Program Files\SQL Anywhere 17\" and the upgrades are working fine now. Yay!