Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Based on the docs and this SQLANY12 post http://sqlanywhere-forum.sap.com/questions/10917/environment-variable I'd expect that SQLANY16, SQLANY16SAMP and the path variable should be updated by a deployment installer, but it isn't. Is this a bug, feature or opportunity for us to customize within our own installers?

asked 13 Jan '14, 18:09

vorear2's gravatar image

vorear2
1067713
accept rate: 0%

I can't tell for v16, however, I guess it should set these environment variables. For v12, the wizard does create an .log file that sums up what files are contained in the created MSI file, and it also lists the contained environment varibles.

And a tool like Microsoft's ORCA should show you whether the MSI does have entries in the "Environment" table.


When you say "should be updated": Do you mean they have already been set? (I'd only expect that the initial run of a v16 setup would create these variables...)

(14 Jan '14, 03:35) Volker Barth

I meant that the PATH variable should be updated. And I created a verbose MSI log and viewed the msi in InstallShield and Orca and there was no mention of environment variables.

(14 Jan '14, 10:53) vorear2

Update: CR #755094 has now been resolved in 16.0.0.1794 and above. You can obtain the patch from:

This issue is documented as KBA #1986791.


The short answer is 'yes' - there seems to be a bug in the SQL Anywhere 16 deployment wizard. Both the 'Environment' and the 'Registry' tables inside the MSI are not currently being generated in SQL Anywhere 16 MSIs (as they have been historically).

Until we can fix this issue in an EBF, there is a temporary workaround. In the folder \Deployment in your original SQL Anywhere 16 installation, there is a file 'master.xml'. You will need to edit this file in a text editor:


Find the lines:

<feature id="CMN32" hidden="true">
    <include id="common_registry_entries_32" />

Add the following text:

<feature id="CMN32" hidden="true">
    <include id="common_registry_entries_32" />
    <registry root="HKEY_LOCAL_MACHINE" path="SOFTWARE\Sybase\SQL Anywhere\16.0">
        <key name="Location" value="[SQLANYDIR]" />
        <key name="Language" value="[LANGUAGE]" />
    </registry>
    <environment name="*=-PATH" value="[~];[SQLANYDIR]\BIN32" />
    <environment name="*=-SQLANY16" value="[SQLANYDIR]" />

Find the lines:

<feature id="CMN64" deploy64="true" hidden="true">
    <include id="common_registry_entries_64" />

Add the following text:

<feature id="CMN64" deploy64="true" hidden="true">
    <include id="common_registry_entries_64" />
    <registry root="HKEY_LOCAL_MACHINE" path="SOFTWARE\Sybase\SQL Anywhere\16.0" deploy64="TRUE">
        <key name="Location" value="[SQLANYDIR]" />
        <key name="Language" value="[LANGUAGE]" />
    </registry>
    <environment name="*=-PATH" value="[~];[SQLANYDIR]\BIN64" />
    <environment name="*=-SQLANY16" value="[SQLANYDIR]" />

I have opened this issue for further investigation as CR #755094. I will update this thread once we have some further information to share. Thank you for the bug report.

permanent link

answered 14 Jan '14, 14:52

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

edited 17 Mar '14, 11:01

When I tried this workaround the deployment MSI fails at "Action register_sc_plugins_32, location: c:Program FilesSQL Anywhere 16BIN32, command: c:Program FilesSQL Anywhere 16BIN32\scjview.exe -register_sqlanywhere"

(04 Mar '14, 18:44) vorear2
Replies hidden
1

@Jeff: The CR link offers just an "empty description", and the KBA link (whatever this does mean) requires a login - could you please supply a user-readable link as usual?

(05 Mar '14, 03:26) Volker Barth
Replies hidden

Reviewing the resulting MSI deployment file, the registry entry for Shared Location was not created from the XML entry 'SOFTWARESybaseSQL Anywhere16.0' Shared Location = '[SQLANYDIR]' but I don't know enough about your deployment wizard to reverse engineer a solution.

(05 Mar '14, 12:40) vorear2
Replies hidden
1

Yes, I can also reproduce this issue if I try a Sybase Central deployment. I have now altered my instructions above to correct this - thank you for pointing this problem out.

(05 Mar '14, 13:59) Jeff Albion

Yes, this was my mistake - my apologies. This setting isn't applicable and was taken from another context. See my changes above.

(05 Mar '14, 13:59) Jeff Albion
1

@Jeff: The CR link offers just an "empty description"

Yes, this link should be updated shortly. It will be public once it is published.

and the KBA link (whatever this does mean) requires a login

SAP Knowledge Base Articles (KBAs) are accessible to SAP customers with an SAP Support plan. These articles are published by SAP Technical Support and are analogous to the old 'Solved Cases' search area from Sybase.

could you please supply a user-readable link as usual?

The public fix information on sybase.com should be published shortly - please check back in a couple of days.

Looking to the farther future though, SAP's general policy is that bug fix information, support patches, and knowledge base solutions are only available to customers with support plans.

However, we will continue to post bug fix information to sybase.com and provide links to this source while it is still available.

(05 Mar '14, 14:01) Jeff Albion

Did you test your revised fix? I'm still getting the same error.

(06 Mar '14, 12:14) vorear2

BTW, you will get this error when you don't install everything on your deployment build machine. The original problem remains and we must open the MSI to add our shortcuts and edit the build version.

(06 Mar '14, 16:46) vorear2

Yes - although I'm not sure the changes above are necessarily related to your error.

The latest official Support Package (SP) for Windows 16.0 should now contain all of the necessary changes - please apply the Support Package and let us know if this situation changes for you.

(17 Mar '14, 11:05) Jeff Albion
showing 4 of 9 show all flat view
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:

×27

question asked: 13 Jan '14, 18:09

question was seen: 3,721 times

last updated: 17 Mar '14, 11:05