AnsweredAssumed Answered

CA Service Management Configuration Error

Question asked by Albino on Sep 26, 2017
Latest reply on Sep 29, 2017 by Raghu.Rudraraju

Hi guys!

 

Im installing a new environment with CAEEM and CA SDM pointing to a remote SQL Server, but for some reason the installation stop after "Installing CA Service Desk Manager Database Schema remotely" step.

 

I ran the installation of mdb (CASM install media \ products \ sdm \ setup.exe) on the DB server before running the Service Management installer on the application server and I'm using the SQL Server ServiceDesk user, which has sysadmin privilegies.

 

I'm using a named instance and I see no connection problems with the database server through port 56625.


The install file at C:\Users\albinosv\AppData\Local\Temp\casm show this error messages:

 

2017/09/26 13.53.14.840 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [DatabasePersister] SQLException: Invalid object name 'al_cdb_componentinstallstate'.

2017/09/26 13.53.15.949 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] Setup MDB returns code 801
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] MDB RC : 801
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] MDB Error: Unexpected error. Check logs at D:\CA\SDM\temp\mdb_sql.
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [SetupMDB] Check mdb logs at D:\CA\SDM\temp\mdb_sql.
2017/09/26 13.53.15.968 ERROR [DeployThread: Installing CA Service Desk Manager Database Schema remotely] [InstallSDMRemoteMDB] SetupMDB returns code 801

2017/09/26 14.03.57.942 ERROR [DeployThread: Configuring CA Service Desk Manager] [ConfigureSDM] SDM configuration failed with message : 09/26 13:54:39.829 WARN  ConfigThread.java      582 Configuration task (Configure MS SQL Server) is failed in step : 11

 

The install_mdb_msg file D:\CA\SDM\temp\mdb_sql shows only this:

 

09-26,13:54:39 Unable to determine the Common Component Directory for the MDB.  

 

 

 

Can anyone help?

Outcomes