Issue in upgrading to 9.5.0

[dn6116]

I tried to upgrade IEM from 9.2.8.74 to 9.5.0.311 and I have the following error

From the command: bash install.sh -upgrade

Rpm Package Name: BESAgent-9.5.0.311-rhe5.x86_64.rpm
Folder /var/opt/BESInstallers/Console successful populated …
Folder /var/opt/BESInstallers/Client successful populated …
Info: The configuration file ‘/opt/BESServer/bin/BESAdmin.sh’ was created successfully.
Info: The configuration file ‘/opt/BESServer/bin/BESAdmin.sh_bkp’ was created successfully.
Info: The configuration file ‘/opt/BESServer/bin/Airgap.sh’ was created successfully.
Info: The configuration file ‘/opt/BESServer/bin/Airgap.sh_bkp’ was created successfully.
Found section: [SoftwareBigFixEnterpriseClientSettingsClient_BESRelay_HTTPServer_LogFilePath] in '/var/opt/BESServer/besserver.config’
Found key: value = /var/log/BESRelay.log
Info: Configuring the database for the server component, please wait …
/opt/BESServer/bin/BESAdmin.sh -upgrade -sitePvkLocation:"/home/epmgr/IEM-License/license.pvk" -sitePvkPassword:"********"
Force still running BES applications
Upgrade database to version Enterprise 8.01
Upgrade database to version Enterprise 8.02
Upgrade database to version Enterprise 8.04
SQL0104N An unexpected token “!” was found following “”.
Expected tokens may include: “NEW”. SQLSTATE=42601
SQL0104N An unexpected token “!” was found following “”.
Expected tokens may include: “NEW”. SQLSTATE=42601
Some error occured on the selectProcess process for QUESTIONRESULTS
Error: An error occurred while configuring the database for the server component.

Please help.

Thanks,
Dan

[Aram]

Hi Dan,

Please open a PMR/Service Request for assistance with this issue:

How to ask for product help: PMRs, RFEs, and more

RFE = Request For Enhancement PMR = Problem Management Record. Also known as a Service Request (SR). The terms are interchangeable This is the general approach I would recommend: Create a forum post here as you start your investigation and gather data so that others are aware of the issue. Post links to any relevant documentation you are using to investigate / try to work around the issue. This will also give others an oportunity to add to the discussion and suggest fixes, particularly if t…

[jgstew]

@dn6116

9.5.0.311

I would generally recommend that if you are going to upgrade to 9.5.x that you should upgrade to whatever the newest version of 9.5.x that is available at the time, which should have been 9.5.2.56.

This goes for any version upgrade of BigFix, upgrade to the newest patch level of that Major.Minor version you are upgrading to.

[bhuvannarang]

Hi Dan,

As the upgrade to 9.5…x is a manual process, you would have entered your license.pvk file password to begin updation. I guess your password contains ‘!’ or some other special character.
I suggest you change your password to not have any special character and then try upgrade again.

For your current situation you might have to re-install BigFix again.

• Bhuvan

[dn6116]

Hi Bhuvan,
Yes - my password does have an “!” indeed.
I will try to change the password

Thanks,
Dan

[dn6116]

Thanks Aram,
I will do that if I can’t quickly fix it.

Cheers,
Dan

[dn6116]

Thanks Jgstew. I did try to upgrade to 9.5.2 first but I have the same issue then I back out and try lower version to see any differences.

Cheers,
Dan

[gpoliafico]

Just fyi this issue with password containing special chars like ‘!’ or ‘&’ is tracked with APAR IV84968 -> http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1IV84968