CA Service Management

  • 1.  Repoint to new database server for APM 14.1

    Posted 12-17-2015 02:09 AM

    Hi Team,

     

    We prepared a APM 14.1 environment and it was working fine. But suddenly customer broke the database cluster or moved the mdb to some other database server and different instance as well without prior information.So APM is in complete chaos. APM can not start now as it is unable to find the database.

     

    We need to know how we can repoint the APM application to new database server.  So the scenario is like initially database server and instance was abc01\ca_itam where mdb was located and now xyz02\ca_itam1 We need to point ITAM application to this xyz02\ca_itam1

     

    Please let me know the necessary steps and what are the files need to be modified to point to mdb database to the new location xyz02\ca_itam1 so that ITAM application can start again.

     

     

    Thanks

    Manirul



  • 2.  Re: Repoint to new database server for APM 14.1

    Posted 12-17-2015 08:36 AM

    Hi Manirul,

     

    You can accomplish this by changing the database connection parameters in the al_cdb_configurationparameters table and in the CA.Common.LoadConfigurationAttributes.dll.config files within the ITAM folders. Run an iisreset.

    Also run  the EEMCertUtilities to re-register the uapmadmin user with the new EEM installation.

     

    Regards,

    Carol



  • 3.  Re: Repoint to new database server for APM 14.1

    Posted 12-17-2015 12:01 PM

    Hi Carol,

     

    All the servers(web,app,eem,bi,pam) except database server are intact. Do I need to reinstall the EEM or only the EEMCertUtilities  from ITAM setup?

     

    Thanks

    Manirul



  • 4.  Re: Repoint to new database server for APM 14.1

    Posted 12-17-2015 12:05 PM

    Manirul;

     

    Just run the EEMCertUtility from the setup folder; this should set the application for you.

     

    -Carol



  • 5.  Re: Repoint to new database server for APM 14.1

    Posted 12-21-2015 08:33 AM

    Hi Carol.Uranker

     

    I am getting the following error after performing the above step(did not execute the EEMCertUtility as I could not find this in ITAM 14.1 setup file ) and I can not start all the APM services as well:-

    Error:

    (System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'mdbadmin'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at CA.Common.Data.Connection.Database.OpenConnection() at CA.Common.Data.Connection.Database.ExecuteReader(String sql) at CA.Common.Web.UI.BasePage.SetTopLevelObjectAndPageKey() ClientConnectionId:bb3b2c03-0d88-4e84-bf8c-ef7d10a1da6f Error Number:18456,State:1,Class:14)

     

    Error.png

     

    Thanks

    Manirul



  • 6.  Re: Repoint to new database server for APM 14.1

    Posted 12-21-2015 08:40 AM

    Manirul,

     

    Please use the Cert Utility from a 12.9 setup file (copy the utility from a 12.9 DVD) and retry.

     

    -Carol



  • 7.  Re: Repoint to new database server for APM 14.1

    Posted 12-21-2015 11:29 AM

    Hi Carol.Uranker,

     

    I am still getting the same error after executing this EEMCertUtilies on webserver.

     

    Do I need to modify ca.common.data.dll.config as well?

     

     

    EEMCertUtilities.png

     

     

     

     

    Thanks

    Manirul



  • 8.  Re: Repoint to new database server for APM 14.1

    Posted 12-21-2015 12:30 PM

    Manirul,

     

    I would suggest you open an issue so further researching can be handled and logs requested.

     

    Thank you,    

    Carol



  • 9.  Re: Repoint to new database server for APM 14.1

    Posted 12-28-2015 06:25 PM

    Hi Manirul,

     

    Before you run the EEMCertUtilities, edit the ca.common.LoadConfigurationAttributes.dll.config file in the same directory and make sure it references the correct mdb. If you have to make any changes, the re-run the EEMCert Utilities after the changes.

    (The ca.common.data.dll.config files are not used anymore.)

     

    If that does not solve the problem, then as Carol suggested, it might be best to assist you through a support case.

     

    Best Regards,

    Gale Bacon

    CA Technologies