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.

asked 09 Sep '20, 02:31

rwatt's gravatar image

rwatt
71129
accept rate: 100%

edited 09 Sep '20, 02:42

2

Is your SQLANY17 environment variable set correctly? This is a key requirement in recent releases.

(10 Sep '20, 12:08) JBSchueler
Replies hidden

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!

(10 Sep '20, 15:57) rwatt

As JBSchueler commented above, it was a bad Windows environment variable. SQLANY17 was originally set to "C:\Program Files (x86)\SQL Anywhere 17\". Once it was changed to "C:\Program Files\SQL Anywhere 17\" the upgrades are working fine now. Thanks again, JBSchueler!

I'm adding this so there is an official answer to the question.

permanent link

answered 10 Sep '20, 16:00

rwatt's gravatar image

rwatt
71129
accept rate: 100%

edited 10 Sep '20, 16:09

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:

×243
×104
×95
×9
×3

question asked: 09 Sep '20, 02:31

question was seen: 3,351 times

last updated: 10 Sep '20, 16:09