After upgrading Unicenter Asset Portfolio Management 11.3.4, launching the web client displays the error: A connection to the database could not be established
The UAPM cache service fails to start and error logs display the following:
1. The event viewer application log shows: UAPMCache Service: The UAPM Cache Service sent metadata documents to the file system for debug.
2. Running ConnectTest.exe program from C:\Program Files\CA\SharedComponents\APM Common Services:
SETTING ARGISCONNECT PROPERTIES AND INITIALIZING
Initialization of ArgisConnect failed: -2146233088 iexceptn.CException
ArgisConnect properties - AppName = , Databasename = mdb, DatabaseType = SQL SERVER
3. The UAPMAPI<date>.csv from C:\Program Files\CA\SharedComponents\APM Common Services shows:
Microsoft.VisualBasic,13,ArgisConnect.Initialize | ArgisConnect.initializeConfiguration | CStatic.createFieldTableInfo | MetadataDef.loadClasses
All of the above errors indicate that the UAPM cache service cannot connect to the database. They also show that the APM application is not at the same level as the database. Due to metadata changes between different UAPM levels, the UAPM cache service is unable to make a connection to the database unless the web application and the database are at the same level.
Determine the database level with this query: (using SQL PLUS or Query Analyzer)
WHERE (dfkey = 'DBUtility Version')
Determine the APM web application version:
Open APM web->click on the About link
Browse to C:\Program Files\CA\SharedComponents\APM Common Services->right click on iconnect.dll->properties->click on the version tab.
Next, apply either a database or web application patch to bring both web application and database to the same level.