I am trying to upgrade the Idera Dashboard from version 4.4.0.18 to 4.6.0.9 but, when I run the installer it tells me the installation was unsuccessful, with no hint as to what to do about it.
Looking in C:\Program Files\Idera\Dashboard\WebApplication\log, there are three log files updated during the attempted installation. The first contains just three info messages, The second contains a number of error messages along the lines of:
2020-02-19 16:09:10 [http-bio-9291-exec-1] ERROR [AccessControlFilter] - Unable to get user information from Security Context. WebURL=login
It also contains a number of warning messages, such as:
2020-02-19 16:07:53 [main] WARN [Log4jLogMsg] - {Messages.language-files-path-not-found}Language files path not found
2020-02-19 16:09:05 [http-bio-9291-exec-5] WARN [ProductInstanceFilter] - Unable to figure out current product from the URL. Path=/login
2020-02-19 16:09:16 [http-bio-9291-exec-1] WARN [CommonUtil] - Skipping truncation: Either src or pathToTruncate is empty / null Or length of SRC is less than pathTotruncate.
The third file contains another warning like the "Language files path not found" above, plus more information messages.
How do I resolve this?
How are you upgrading the Dashboard? Usually, people tend to upgrade Dashboard while running the main installer for another product such as SQL Diagnostic Manager or SQL Safe. In that scenario, there should be some installation log files that are created (usually in the same directory from which the installer was executed from). It's the installation log files that you'll want to review, not the logs that you mentioned.
Yes, I was upgrading it together with SQL Diagnostic Manager which succeeded.
I have found the installation log in the extract folder. Seems the first error relates to a failed attempt to decrypt a keystore file:
Copying contents of file C:\Program Files\Idera\Dashboard\WebApplication\conf\keystore to C:\Program Files\Idera\Dashboard\WebApplication\conf\keystore.bakMSI (s) (7C:78) [17:05:50:140]: Doing action: VerifyServiceAccountOnSilentInstallAction ended 17:05:50: CASaveKeystoreFile. Return value 1.MSI (s) (7C:E4) [17:05:50:140]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI5469.tmp, Entrypoint: VerifyServiceAccountOnSilentInstallAction start 17:05:50: VerifyServiceAccountOnSilentInstall.SFXCA: Extracting custom action to temporary directory: C:\Windows\Installer\MSI5469.tmp-\SFXCA: Binding to CLR version v4.0.30319Calling custom action CustomActions2!CustomActions.CustomActions.VerifyServiceAccountOnSilentInstall************************* Begin QuickDecrypt *****************************Error occured while decrypting the passed value. Exception:The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. ************************* Begin QuickDecrypt *****************************
Any idea?
Any chance you can attach the log file? I curious to see if there's something else that might be the underlying issue.
Sorry, I went to send this last night before leaving the office but now can't find any trace so clearly something went awry. Log file attached, with server/instance names and network credentials anonymised:
InstallDashboard.zip
It failed to send again this morning - a message appeared at the top of the page saying "An error occurred. Please try again or contact your administrator". Don't you just love informative error messages?
Looks like it was the size of the log file - it succeeded after I'd zipped it.
Looks like the error you are running into is on line 7294.
Error occured during upgrade of repository. Could not update the repository : Cannot DROP FUNCTION 'dbo.f_GetRepositoryVersion' because it is being referenced by object 'DF__Registere__MinCw__4707859D'.
From what I can from the log, it looks like you are currently on version 4.4. I'm guessing that you must have upgraded to that version from a prior version as well. In any case, you should be able to get passed this error simply by dropping the constraint from the IderaDashboardRepository database. The constraint should be found in the [Common].[RegisteredProducts] table.
Once deleted, try the upgrade again.
Hi, just to say I hit this same issue, upgrading Dashboard from 4.4.0.18 to 4.6.0.9.
Same fix worked for me:
USE [IderaDashboardRepository];ALTER TABLE [Common].[RegisteredProducts] DROP CONSTRAINT [DF__Registere__MinCw__4183B671];
(Note precise constraint name will tend to vary...)
Thanks for posting.