How to re-apply an update from SLM

Title

Issue

After the update from 9.19 to 9.20 I got the following error when trying to open the SLM-SMaCC:

"The SLM Administration Tool application version required by this database is 9.20.0. The current application version is 9.19.0."

Environment

SLM 9.19, 9.xx

Steps to reproduce

It seems something went wrong with the rollback, as it ended up with a higher DB version compared to SLM and SMACC, found the following "InstallationWorker" error in UpdateServiceGUI log file (C:\Program Files\Snow Software\Logs\UpdateService):

ERROR SnowSoftware.Update.ProductUpdate [(null)] - An error occurred while executing instructions of v 9.20.00 for Snow License Manager Enterprise Edition (UR# 498). Beginning rollback.

ERROR SnowSoftware.Update.ProductUpdate [(null)] - The exception was:
System.IO.IOException: An unexpected error occurred while copying [DotNetLibs\1.11.20045.2\Microsoft.Data.SqlClient.dll] from [C:\Program Files\Snow Software\Snow License Manager\DotNetLibs\1.11.20045.2] to [C:\Program Files\Snow Software\Snow License Manager\Backup\2022-05-23_1350_UR498_UpdateService\DotNetLibs\1.11.20045.2]. ---> System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files\Snow Software\Snow License Manager\DotNetLibs\1.11.20045.2\Microsoft.Data.SqlClient.dll'.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost)
at SnowSoftware.Update.IO.DirectoryInfoExtensions.CopyDirectory(DirectoryInfo fromDirectory, DirectoryInfo toDirectory, IEnumerable`1 filesToCopy, Boolean overwrite, Boolean copyAcl)
--- End of inner exception stack trace ---
at SnowSoftware.Update.IO.DirectoryInfoExtensions.CopyDirectory(DirectoryInfo fromDirectory, DirectoryInfo toDirectory, IEnumerable`1 filesToCopy, Boolean overwrite, Boolean copyAcl)
at SnowSoftware.Update.Installation.ReplaceProductFilesInstruction.Execute(ProductUpdate update)
at SnowSoftware.Update.ProductUpdate.Install()

ERROR SnowSoftware.Update.ProductUpdate [(null)] - An error occurred while executing instructions of v 9.20.00 for Snow License Manager Enterprise Edition (UR# 498). Rollback complete.

- Check that this mismatch of version also exist in the database using the following query:
select * from SnowLicenseManager.dbo.tblSystemInfo
-Check the version in SLM GUI = "9.19"

-Check the version in Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Snow Software\Snow Update Service\Installed Products\SnowLicenseManagerEnterpriseEdition = "version 9.20 update 498"

-Check the availables versions to be install in SUS:

-Check the Updatehistory.xml (C:\Program Files\Snow Software\Snow Update Service\Resources) looking for inconsistencies:

Summary of version inconsistencies:
SLM GUI: version 9.19
SUS: It does not show version 9.20 available, since it reviews the Updatehistory.xml and there it shows a successful installation on the first attempt, even when it failed and it tried to roll back.
Regedit: SLM version 9.20 update 498
Updatehistory.xml: First the file shows the update to 9.20 successfully and in the next attempt it failed, which does not make sense because it already installed that version successfully.

Solution

As the update to 9.20 has not completed correctly we need to run the update again.

In order to run the update again we will need to modify the version where the incorrect one is found, which in this case is 9.20. If you do not feel comfortable with making changes to the windows registry please contact Snow Support for assistance.

- Snow Update Service - Installed Products - SnowLicenceManagerEnterpriseEdition. Change the regedit to the current version 9.19, note that you can get the UpdateRevision number from the Updatehistory.xml or contact Snow Support for assistance.

- First save a copy and then delete (fix) the incorrect section within the updateHistory.xml file (C:\Program Files\Snow Software\Snow Update Service\Resources). In the example below we delete what is marked in the red box:

delete the red.png

- The update is now available in SUS

SUS9.20.png

NOTE: Please stop all the Snow services before doing the update to 9.20.0

Cause

The upgrade couldn't replace a file (library) because it was in use and had an error when rolling back the upgrade.

Was this helpful?

Support Hub

Product

Snow Update Service

Version

9.x

Deployment type

On-premises;Service Provider Edition (SPE)

Visibility

Guest

URL Name

Update-from-SLM-9-19-0-to-9-20-0

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Related Articles

Please wait...

Case id: 00001065