1 Reply Latest reply on Oct 30, 2019 1:29 AM by Suma Duddanahalli Shivakumar

    Getting Connection to Database error while starting CMS service

    Shashank Raj Seasoned Veteran

      Hi All,

       

      When I try to start content management services for Informatica Developer 9.6.1 HF4 , I get following error in logs:

       

       

      Database driver error...

      Function Name : Connect

      Database Error: Failed to connect to database using user [INFA95_REFDATA_REP] and connection string [WTCRD624.TCC.ETN.COM].].]

      Oct 30, 2019 4:14:09 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet shutdownServiceFramework

      INFO: [CMS_10026] Deinitializing the Content Management Service web application.

      Oct 30, 2019 4:14:09 AM com.informatica.cms.service.impl.CMSLifeCycleHandler deinitService

      FINEST: [CMS_10005] Deinitializing the Content Management Service.

      Oct 30, 2019 4:14:10 AM com.informatica.cms.service.impl.CMSLifeCycleHandler deinitService

      INFO: [CMS_10006] Deinitialized the Content Management Service.

      Oct 30, 2019 4:14:10 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet shutdownServiceFramework

      INFO: [CMS_10016] Deinitializing the client library.

      Oct 30, 2019 4:14:10 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet shutdownServiceFramework

      INFO: [CMS_10027] Deinitialized the Content Management Service web application.

      Oct 30, 2019 4:15:06 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10014] Initializing the Content Management Service web application.

      Oct 30, 2019 4:15:06 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10017] Creating the SPC handler and WebAppClientLib objects.

      Oct 30, 2019 4:15:07 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10018] Populating the service information.

      Oct 30, 2019 4:15:07 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10019] Creating the client factory.

      Oct 30, 2019 4:15:07 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10020] Getting the Java Server Faces port.

      Oct 30, 2019 4:15:07 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10021] The Content Management Service will run on port [6023].

      Oct 30, 2019 4:15:07 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10022] Getting the Java Management Extension port.

      Oct 30, 2019 4:15:07 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10023] The Java Management Extension for the Content Management Service will run on port [6024].

      Oct 30, 2019 4:15:08 AM com.informatica.cms.service.impl.ContentManagementServiceImpl <init>

      INFO: [CMS_10013] Completed the constructor for the Content Management Service Life Cycle Handler.

      Oct 30, 2019 4:15:08 AM com.informatica.cms.service.impl.CMSLifeCycleHandler initLogging

      FINEST: [CMS_10031] Initialized logging for the Content Management Service.

      Oct 30, 2019 4:15:08 AM com.informatica.cms.service.ContentManagementServiceManager <init>

      INFO: [CMS_10011] Initializing the Content Management Service Manager.

      Oct 30, 2019 4:15:08 AM com.informatica.cms.service.ContentManagementServiceManager <init>

      INFO: [CMS_10012] Initialized the Content Management Service Manager.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.upload.CMSUploadManager <init>

      INFO: [CMS_10032] Initializing the Content Management Service Upload Manager.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.upload.CMSUploadManager <init>

      INFO: [CMS_10033] Initialized the Content Management Service Upload Manager.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.download.CMSDownloadManager <init>

      INFO: [CMS_10040] Initializing the Content Management Service Download Manager.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.download.CMSDownloadManager <init>

      INFO: [CMS_10041] Initialized the Content Management Service Download Manager.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.ner.NERManager <init>

      INFO: Probabilistic engine version: [3.4].

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.classifier.ClassifierManager <init>

      INFO: Classifier version: [version 0.1 ].

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.datasync.DataSyncConductor recoverJobs

      INFO: The Content Management Service recovered [0] data synchronization tasks.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.impl.CMSLifeCycleHandler initService

      INFO: [CMS_10004] Initialized the Content Management Service.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10024] The service framework started the service.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10025] Initialized the process.

      Oct 30, 2019 4:15:25 AM com.informatica.cms.service.webapp.ContentManagementServiceServlet init

      INFO: [CMS_10015] Initialized the Content Management Service web application.

       

       

      The services got started but since it is not able to connect to Database, I am not able to export reference data. Can anyone suggest, where I need to modify the connection string?