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

Document ID : KB000026313
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

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

Symptoms: 

   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.

Resolution: 

Determine the database level with this query:  (using SQL PLUS or Query Analyzer)

    SELECT dfvalue
    FROM <tableowner>.arg_argdeflt
    WHERE (dfkey = 'DBUtility Version')

Determine the APM web application version: 

Open APM web->click on the About link
Or
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.