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

I am trying to create a batch process to upgrade from to that is the recommended build from the Check for Updates option.

Based on the example on the documentation below, the process does start, the files got extracted from the exe but, after the "Computing space requirements" screen is closed, a next dialog screen displays and waits for user intervention with: Click Update to apply the Maintenance Release. Click Cancel to quit.

d:\software\sqlanywhere\setup.exe /l:1033 /s "/v: /qn REGKEY=[..snip..] INSTALLDIR=c:\sa12"

I already tried replacing /qn with /quiet and with /passive and those options didn't seem to make any difference.

Is anyone using a different set of parameters to launch unatended EBF installations?

asked 17 Nov '11, 16:45

Derli%20Marcochi's gravatar image

Derli Marcochi
accept rate: 33%

edited 17 Nov '11, 21:17

Mark%20Culp's gravatar image

Mark Culp

It seemed to work fine when I ran through the process with a similar command line. Can you list the steps you followed after downloading SQLAnywhere1201.exe, up to the point you ran setup.exe?

(18 Nov '11, 13:18) Bill Frier
Replies hidden

Bill, Below is the content of my batch file where e: is my USB drive where the EBF exe is located:

e:\sqlanywhere12.0.1.exe /l:1033 /s "/v: /qn /log c:\temp\sa12.log REGKEY=1DFA77E6-91B2-4DCC-B8BE-98EA70705D39 INSTALLDIR=%SQLANY12%"

I also tried copying the exe and the batch file to the location where sqlany32.msi file was previously installed ( C:\Documents and Settings\All Users\Application Data\SQL Anywhere 12\Installation) but this didn't seem to make any difference either.

I can post the log file if needed (it is quite long).

(18 Nov '11, 13:39) Derli Marcochi

There is a setup.exe and supporting setup files inside of SQLAnywhere1201.exe. To run the silent install you must unpack these files and run that setup.exe.

One way to get the unpacked install is to,

  1. Run SQLAnywhere1201.exe up to the point where the install's user interface first appears. The unpacked install is now available in your Windows temp directory. For me on Windows XP, it was in "Documents and Settings\<userid>\LOCALS~1\Temp\pft75~tmp.
  2. Copy the unpacked install files somewhere safe as these files will be deleted when the setup wizard is closed.
  3. Close the setup wizard UI opened by SQLAnywhere1201.exe

Alternatively, many compression utilities will also allow you to directly extract the the files from SQLAnywhere1201.exe.

Now you should be able to use the unpacked setup files with the command you list above.

permanent link

answered 18 Nov '11, 14:49

Bill%20Frier's gravatar image

Bill Frier
accept rate: 41%

edited 18 Nov '11, 15:38

I started the SQLAnywhere1201.exe and was able to copy all the extracted files to another folder as you suggested. I then ran the extracted setup.exe using the statement below.

The Windows Installer screen displayed with the available options so the process didn't start as I would expect.

e:sqlany12setup.exe /l:1033 /s "/v: /qn REGKEY=1DFA77E6-91B2-4DCC-B8BE-98EA70705D39 INSTALLDIR=%SQLANY12%"

Any thoughts?

(19 Nov '11, 10:38) Derli Marcochi

Just to make sure I was not overlooking something I extracted the files using an utility this time (Universal Extractor) and had the same results as in my previous attempt with the files from the temp folder.

The update process seems to start but after a few seconds only the Windows Installer screen displays.

(19 Nov '11, 17:01) Derli Marcochi
Replies hidden

FWIW, may a MSI created with the builtin "Deployment Wizard" be an alternative for you?

As a regular MSI package, that can be used both for attended and unattended installations.

(20 Nov '11, 06:14) Volker Barth

I think the option of having the files extracted and then sent to the customers will be better (at least for now) as we won't have to run the deployment wizard process for every new EBF. Thanks!

(20 Nov '11, 13:47) Derli Marcochi

I was able to figure out the reason of my issues with the batch file to silently launch the EBF setup.exe file.

Since users can install SA 12 under any local folder, I had to use the SQLANY12 environment variable to get the root path during an EBF install.

As the default target location for SA12 is the C:\Program Files\SQL Anywhere 12 folder, the spaces were causing the Windows Installer to always fail. This would not be the case had I used c:\sa12 or something similar as the target path.

After the INSTALLDIR parameter was properly escaped, the batch statement ran fine and the EBF was properly installed.

permanent link

answered 20 Nov '11, 13:24

Derli%20Marcochi's gravatar image

Derli Marcochi
accept rate: 33%

edited 20 Nov '11, 13:27

FWIW, would you tell how to mask the quotes - like this?

e:\sqlany12setup.exe /l:1033 /s "/v: /qn REGKEY=1DFA77E6-91B2-4DCC-B8BE-98EA70705D39 INSTALLDIR=""%SQLANY12%"""
(21 Nov '11, 03:52) Volker Barth
Replies hidden

Do you mean escape the quotes? Interior quotes are escaped with a backslash. There are some examples in the silent install doc.

(21 Nov '11, 08:44) Bill Frier

Thanks! Yes, that's what I had asked for - so my sample was wrong and should be like:

e:\sqlany12setup.exe /l:1033 /s "/v: /qn REGKEY=1DFA77E6-91B2-4DCC-B8BE-98EA70705D39 INSTALLDIR=\"%SQLANY12%\""

(21 Nov '11, 08:46) Volker Barth

This is correct. When I tested in a server I also had to add the /norestart setting as the server was rebooting after the EBF completed.

(21 Nov '11, 10:28) Derli Marcochi
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 17 Nov '11, 16:45

question was seen: 4,393 times

last updated: 21 Nov '11, 10:28