SAP SQL Anywhere

Question

Hi

When starting SQL Central from the OS X dock, the icon changes to a Java (coffee) icon. Not so when making an alias on the desktop (for example). I have this behavior since SQL Anywhere 17. Did not have it on version 12 (did not use version 16). Has anyone else seen this?

Regards, Robert

Answer 1

1

This may be happening if you are running a file called scjview.sh from your bin64 subtree. If you have that file, simply removing it should revert the behaviour back to what you are expecting.

At least that is the only way we found to reproduce this here. The appearance of the Hot Java Cup icon in our test is related to running the JRE's java launcher directly (and not the .\bin64\scjview launcher).

We don't see the generic Java icon on Windows. But with a Mac (running OS/X 10.11) here, it appears the SQL Central icon resource is not being picked up unless you use the scjview launcher. Given you should not need to run this way, I have not investigated the reason for this any further than that.

Hopefully that is all there is to this on your side.

permanent link

answered 23 Aug '16, 16:51

Nick Elson S...
7.3k●35●107
accept rate: 32%

edited 24 Aug '16, 13:00

Hi Nick

Thank you for your investigation. Unfortunately, I do not have the mentioned scjview.sh file anywhere in my SQLAnywhere17 subfolders. The only files I found are scjview located in /Applications/SQLAnywhere17/System/bin64 and /Applications/SQLAnywhere17/System/bin64s subfolders.

Regards, Robert

(25 Aug '16, 02:58) robert

You can try applying a recent patch if running the first release of 17. We ran into an issue with our external java environment because Apple no longer ships their JVM and some mechanisms changed. By applying a patch you can maybe benefit from the fix we provided for that.

We install our SAP JVM and we do not see the problem when it using that. You might want to try to diagnose which JVM is running. To do that you can generate the scjview.sh file yourself and identify which JRE is being loaded by inspecting that file. To do that run this cmd in terminal window: scjview -batch

This will help to identify which J2SE is being used to launch that. If it is the wrong one we can work on that. If it is the correct one then I would need to investigate why you are not finding the resource.

(25 Aug '16, 10:09) Nick Elson S...

Thanks for the tip. I did that and got the scjview.sh file as you mentioned.

We are running SQL Anywhere version 17.0.4.2066.

Version of the Java defined in the scjview.sh: java version "1.8.0_91" Java(TM) SE Runtime Environment (build 1.8.0_91-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

(26 Aug '16, 11:33) robert

Is that the one under the ${SQLANY17}/bin64/jre180 directory or another location?

There should be no reason for it to be anything but the one installed with SQL Anywhere but it will help to know if this is not your situation.

(26 Aug '16, 16:27) Nick Elson S...

I do not have a jre180 subdirectory under ${SQLANY17}/bin64/. It is installed at the standard location /Library/Java/JavaVirtualMachines/. BTW, I have the JDK installed, as some tools need the Java Development Kit. Bt I assume this makes no difference, as it contains the JRE.

(29 Aug '16, 02:55) robert

That probably is all there is to this. Don't know why you don't have the JRE that is supposed to be installed along with the admin tools, but the admin tools are only ever tested with that JRE.

The JDK you are running with is not the same JRE we ship and test with but given our limited success in reproducing your behavior, it seems it could take very little to break this on the Mac. The display of the Java default icon is a fall-back position when no other icons can be found or used and something I used to see back in some older versions when explicitly running the $JAVA_HOME/bin/java launcher (ie. not scjview).

Maybe you have something odd about your system (beta OS release maybe) or something about your 'picks' for what you wanted to be installed that confused the installer (or if you have installed this as part of another suite/application) ... but it has to be something about this configuration (while likely stable) that is causing the behavior.

The only other possible factor I could think of is if your graphics resolution is significantly different we may not have a close enougn match on the icns resource ... but that would be a pure guess. One would need to fix the missing JRE issue first before we could identify that possibility.

(29 Aug '16, 09:17) Nick Elson S...

These production Macs do never get Beta Operating Systems installed. It is a standard OS X 10.11.6 installation. The SQL Anywhere is also a standard installation using the defaults of the installer. It is version 17.0.4.2066. In this respect I don't see any (bad) influence to the SQL Anywhere installation, but who knows. I am sorry I can't help more. By the way, these behaviors is on all of our Macs using the database, i. e. on 5 different ones.

(30 Aug '16, 04:48) robert

We're running the same OS and build of 17 you are so that much seems correct.

Is it possible you have a file called scjview.ini on your system? If so the contents of that could be affecting this.

Another factor not considered is the possibility your

[sa_java_stub_launcher.sh][2]

file was not configured the same way as ours. This file might show aspects unique to your systems. That last link also mentions an "Info.plist" file that contains the references to the *.icns file in the tagged section that should look like this

 <key>CFBundleIconFile</key>
 <string>SQLAnywhere.icns</string>

the latter being where we have the icons that are MIA. So if that is not wired correctly that too could be affecting this.

(30 Aug '16, 13:42) Nick Elson S...

We have no scjview.ini file on our Macs. I can't find the sa_java_stub_launcher.sh file. Although I see the entry in the Info.plist file.

The Info.plist file on our Macs look like:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
    <key>CFBundleDevelopmentRegion</key>
    <string>English</string>
    <key>CFBundleExecutable</key>
    <string>sa_java_stub_launcher.sh</string>
    <key>CFBundleIconFile</key>
    <string>SQLCentral.icns</string>
    <key>CFBundleInfoDictionaryVersion</key>
    <string>6.0</string>
    <key>CFBundleName</key>
    <string>SQL Central</string>
    <key>CFBundlePackageType</key>
    <string>APPL</string>
    <key>CFBundleSignature</key>
    <string>????</string>
    <key>CFBundleVersion</key>
    <string>6.0</string>
</dict>
</plist>

(09 Sep '16, 08:59) robert

I've been aways for a couple of weeks but there has been a thought bugging me for some time about this. There is a chance that the Java Cup icon may just be the default when no other sufficient icon was found/matched. This might be happening if your resolution is higher than expected and your icons need to be something unexpected (say 128x128 pixels or larger).

Do you happen to have some sort of ultra-high resolution displays on your systems?

I'm not certain how to easily check for the size/resolution of the icons you do see showing up successfully but if you are still interested then changing some system settings (Docking bar sizing) might have an impact. {pls ignore if this is not a true Mac OS/X concept}

(19 Sep '16, 18:47) Nick Elson S...

I have only a standard MacBook with a 1440 x 900 resolution. Also sometimes an attached 1920 x 1200 display. So these are no ultra-high resolution displays ;-)

(21 Sep '16, 13:35) robert

More comments hidden

showing 5 of 11 show all flat view

SAP SQL Anywhere

SQL Central icon (in dock) changes on start to Java icon

Follow this question

Related questions