Facing an error during cognos 10.2.1 installation on new cloud machine

[Manik Goel]

[Start Service]
07:31:27, 'LogService', 'StartService', 'Success'.
07:31:27, CAF-WRN-0011 CAF input validation disabled.
07:31:27, CAF-WRN-0021 CAF Third Party XSS checking disabled.
07:31:33, CM-SYS-2057 Creating content store tables (schema version 7.0019).
07:31:53, 'ContentManagerService', 'StartService', 'Failure'.

07:31:54, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
07:31:54, 'com.cognos.pogo.contentmanager.coordinator.Acti veCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:31:54, 'ContentManagerService', 'StartService', 'Failure'.

07:31:53, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\COGNOS10_64\configuration\schemas\content\ oracle\dbInitScript_oracle.sql". Review the configuration for the content store database in IBM Cognos Configuration to ensure that the settings are correct. Verify that the account used to access the content store is still valid by checking the status of the password and account permissions. Verify that the account that Content Manager uses has sufficient permissions to create, to connect to, and to initialize the file contents in the database. Cause: Closed Connection Stack trace: java.sql.SQLException: Closed Connection at oracle.jdbc.driver.OracleStatement.ensureOpen(Orac leStatement.java:3980) at oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1863) at or
acle.jdbc.driver.OracleStatement.execute(OracleSta tement.java:1847) at oracle.jdbc.driver.OracleStatementWrapper.execute( OracleStatementWrapper.java:301) at com.cognos.cm.dbstore.CMPreparedStatementBase.execute(CMP reparedStatementBase.java:59) at com.cognos.cm.dbstore.StatementProxy.execute(StatementPro xy.java:276) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:438) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:290) at com.cognos.cm.dbstore.CMDbStoreFactory.initDatabaseConten tDependent(CMDbStoreFactory.java:1449) at com.cognos.cm.dbstore.CMDbStoreFactory.initContentDepende nt(CMDbStoreFactory.java:2129) at com.cognos.cm.dbstore.CMDbStore.initializeContentDependen t(CMDbStore.java:4431) at com.cognos.cm.server.CMServlet.initializeContentStoreForA ctive(CMServlet.java:2190) at com.cognos.cm.server.CMServlet.init(CMServlet.java:1
890) at com.cognos.cm.server.ContentManager.start(ContentManager. java:424) at com.cognos.cm.server.ContentManagerLifecycleHandler.start (ContentManagerLifecycleHandler.java:65) at com.cognos.pogo.services.DefaultHandlerService.sta rt(DefaultHandlerService.java:88) at com.cognos.pogo.services.DispatcherServices.startI nitialService(DispatcherServices.java:418) at com.cognos.pogo.services.DispatcherServices.startI nititalServices(DispatcherServices.java:404) at com.cognos.pogo.transport.PogoServlet$PogoStartup. run(PogoServlet.java:828) at com.cognos.pogo.util.threads.SafeThread.safeRun(Sa feThread.java:70) at com.cognos.pogo.util.threads.SafeThread.run(SafeTh read.java:61)
07:31:54, CM-SYS-2057 Creating content store tables (schema version 7.0019).
07:31:54, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\COGNOS10_64\configuration\schemas\content\ oracle\dbInitScript_oracle.sql". Review the configuration for the content store database in IBM Cognos Configuration to ensure that the settings are correct. Verify that the account used to access the content store is still valid by checking the status of the password and account permissions. Verify that the account that Content Manager uses has sufficient permissions to create, to connect to, and to initialize the file contents in the database. Cause: ORA-00955: name is already used by an existing object Stack trace: java.sql.SQLException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:439) at oracle.jdbc.dri
ver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall. java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.jav a:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java: 186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:5 21) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1882) at oracle.jdbc.driver.OracleStatement.execute(OracleS ta tement.java:1847) at oracle.jdbc.driver.OracleStatementWrapper.execute( OracleStatementWrapper.java:301) at com.cognos.cm.dbstore.CMPreparedStatementBase.execute(CMP reparedStatementBase.java:59) at com.cognos.cm.dbstore.S
tatementProxy.execute(StatementProxy.java:276) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:438) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:290) at com.cognos.cm.dbstore.CMDbStoreFactory.initDatabaseConten tDependent(CMDbStoreFactory.java:1449) at com.cognos.cm.dbstore.CMDbStoreFactory.initContentDepende nt(CMDbStoreFactory.java:2129) at com.cognos.cm.dbstore.CMDbStore.initializeContentIndepend entAfterLock(CMDbStore.java:4386) at com.cognos.cm.server.CMServlet.initializeContentStoreForS tandby(CMServlet.java:2575) at com.cognos.cm.server.MultipleCMsSyncThread$initializeAsRu nnable.run(MultipleCMsSyncThread.java:973) at java.lang.Thread.run(Thread.java:780)
07:31:54, CM-SYS-5242 Background task manager is not running.
07:32:30, CM-SYS-5242 Background task manager is not running.
07:32:30, 'Dispatcher', 'Stop', 'Success'.
07:32:30, 'MetadataService', 'StopService', 'Success'.
07:32:30, 'JobService', 'StopService', 'Success'.
07:32:30, 'IndexSearchService', 'StopService', 'Success'.
07:32:30, 'IndexUpdateService', 'StopService', 'Success'.
07:32:30, 'DimensionManagementService', 'StopService', 'Success'.
07:32:30, 'AnnotationService', 'StopService', 'Success'.
07:32:30, 'ContentManagerService', 'StopService', 'Success'.
07:32:30, 'DeliveryService', 'StopService', 'Success'.
07:32:30, 'CPS Producer Registration Service', 'StopService', 'Success'.
07:32:30, 'MonitorService', 'StopService', 'Success'.
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'Fragment Server Service', 'StopService', 'Success'.
07:32:30, 'ReportService', 'StopService', 'Success'.
07:32:30, 'IndexDataService', 'StopService', 'Success'.
07:32:30, 'idVizService', 'StopService', 'Success'.
07:32:30, 'SystemService', 'StopService', 'Success'.
07:32:30,
07:32:30, 'HumanTaskService', 'StopService', 'Success'.
07:32:30, 'AgentService', 'StopService', 'Success'.
07:32:30, 'EventService', 'StopService', 'Success'.
07:32:30, 'GraphicsService', 'StopService', 'Success'.
07:32:30, 'BUX Service', 'StopService', 'Success'.
07:32:30, 'relationalMetadataService', 'StopService', 'Success'.
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'camAsyncAA', 'StopService', 'Success'.
07:32:30, 'burstDistributionService', 'StopService', 'Success'.
07:32:30, 'QueryService', 'StopService', 'Success'.
07:32:30, 'RepositoryService', 'StopService', 'Success'.
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'BatchReportService', 'StopService', 'Success'.
07:32:30, 'ContentManagerCacheService', 'StopService', 'Success'.
07:32:30, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.
07:32:30, 'visualisationGalleryService', 'StopService', 'Success'.
07:32:30, 'PDC', 'StopService', 'Success'.
07:32:30, 'CacheService', 'StopService', 'Success'.
07:32:30, 'ReportDataService', 'StopService', 'Success'.
07:32:30, 'SACamSrvc', 'StopService', 'Success'.
07:32:30, 'LogService', 'StopService', 'Success'.

[Start Service]
[ ERROR ] CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'.

[MFGF]

[Start Service]
07:31:27, 'LogService', 'StartService', 'Success'.
07:31:27, CAF-WRN-0011 CAF input validation disabled.
07:31:27, CAF-WRN-0021 CAF Third Party XSS checking disabled.
07:31:33, CM-SYS-2057 Creating content store tables (schema version 7.0019).
07:31:53, 'ContentManagerService', 'StartService', 'Failure'.

07:31:54, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
07:31:54, 'com.cognos.pogo.contentmanager.coordinator.Acti veCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:31:54, 'ContentManagerService', 'StartService', 'Failure'.

07:31:53, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\COGNOS10_64\configuration\schemas\content\ oracle\dbInitScript_oracle.sql". Review the configuration for the content store database in IBM Cognos Configuration to ensure that the settings are correct. Verify that the account used to access the content store is still valid by checking the status of the password and account permissions. Verify that the account that Content Manager uses has sufficient permissions to create, to connect to, and to initialize the file contents in the database. Cause: Closed Connection Stack trace: java.sql.SQLException: Closed Connection at oracle.jdbc.driver.OracleStatement.ensureOpen(Orac leStatement.java:3980) at oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1863) at or
acle.jdbc.driver.OracleStatement.execute(OracleSta tement.java:1847) at oracle.jdbc.driver.OracleStatementWrapper.execute( OracleStatementWrapper.java:301) at com.cognos.cm.dbstore.CMPreparedStatementBase.execute(CMP reparedStatementBase.java:59) at com.cognos.cm.dbstore.StatementProxy.execute(StatementPro xy.java:276) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:438) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:290) at com.cognos.cm.dbstore.CMDbStoreFactory.initDatabaseConten tDependent(CMDbStoreFactory.java:1449) at com.cognos.cm.dbstore.CMDbStoreFactory.initContentDepende nt(CMDbStoreFactory.java:2129) at com.cognos.cm.dbstore.CMDbStore.initializeContentDependen t(CMDbStore.java:4431) at com.cognos.cm.server.CMServlet.initializeContentStoreForA ctive(CMServlet.java:2190) at com.cognos.cm.server.CMServlet.init(CMServlet.java:1
890) at com.cognos.cm.server.ContentManager.start(ContentManager. java:424) at com.cognos.cm.server.ContentManagerLifecycleHandler.start (ContentManagerLifecycleHandler.java:65) at com.cognos.pogo.services.DefaultHandlerService.sta rt(DefaultHandlerService.java:88) at com.cognos.pogo.services.DispatcherServices.startI nitialService(DispatcherServices.java:418) at com.cognos.pogo.services.DispatcherServices.startI nititalServices(DispatcherServices.java:404) at com.cognos.pogo.transport.PogoServlet$PogoStartup. run(PogoServlet.java:828) at com.cognos.pogo.util.threads.SafeThread.safeRun(Sa feThread.java:70) at com.cognos.pogo.util.threads.SafeThread.run(SafeTh read.java:61)
07:31:54, CM-SYS-2057 Creating content store tables (schema version 7.0019).
07:31:54, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\COGNOS10_64\configuration\schemas\content\ oracle\dbInitScript_oracle.sql". Review the configuration for the content store database in IBM Cognos Configuration to ensure that the settings are correct. Verify that the account used to access the content store is still valid by checking the status of the password and account permissions. Verify that the account that Content Manager uses has sufficient permissions to create, to connect to, and to initialize the file contents in the database. Cause: ORA-00955: name is already used by an existing object Stack trace: java.sql.SQLException: ORA-00955: name is already used by an existing object at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:439) at oracle.jdbc.dri
ver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall. java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.jav a:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java: 186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:5 21) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:194) at oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:1000) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1307) at oracle.jdbc.driver.OracleStatement.executeInternal (OracleStatement.java:1882) at oracle.jdbc.driver.OracleStatement.execute(OracleS ta tement.java:1847) at oracle.jdbc.driver.OracleStatementWrapper.execute( OracleStatementWrapper.java:301) at com.cognos.cm.dbstore.CMPreparedStatementBase.execute(CMP reparedStatementBase.java:59) at com.cognos.cm.dbstore.S
tatementProxy.execute(StatementProxy.java:276) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:438) at com.cognos.cm.dbstore.CMDbStoreFactory.executeScript(CMDb StoreFactory.java:290) at com.cognos.cm.dbstore.CMDbStoreFactory.initDatabaseConten tDependent(CMDbStoreFactory.java:1449) at com.cognos.cm.dbstore.CMDbStoreFactory.initContentDepende nt(CMDbStoreFactory.java:2129) at com.cognos.cm.dbstore.CMDbStore.initializeContentIndepend entAfterLock(CMDbStore.java:4386) at com.cognos.cm.server.CMServlet.initializeContentStoreForS tandby(CMServlet.java:2575) at com.cognos.cm.server.MultipleCMsSyncThread$initializeAsRu nnable.run(MultipleCMsSyncThread.java:973) at java.lang.Thread.run(Thread.java:780)
07:31:54, CM-SYS-5242 Background task manager is not running.
07:32:30, CM-SYS-5242 Background task manager is not running.
07:32:30, 'Dispatcher', 'Stop', 'Success'.
07:32:30, 'MetadataService', 'StopService', 'Success'.
07:32:30, 'JobService', 'StopService', 'Success'.
07:32:30, 'IndexSearchService', 'StopService', 'Success'.
07:32:30, 'IndexUpdateService', 'StopService', 'Success'.
07:32:30, 'DimensionManagementService', 'StopService', 'Success'.
07:32:30, 'AnnotationService', 'StopService', 'Success'.
07:32:30, 'ContentManagerService', 'StopService', 'Success'.
07:32:30, 'DeliveryService', 'StopService', 'Success'.
07:32:30, 'CPS Producer Registration Service', 'StopService', 'Success'.
07:32:30, 'MonitorService', 'StopService', 'Success'.
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'Fragment Server Service', 'StopService', 'Success'.
07:32:30, 'ReportService', 'StopService', 'Success'.
07:32:30, 'IndexDataService', 'StopService', 'Success'.
07:32:30, 'idVizService', 'StopService', 'Success'.
07:32:30, 'SystemService', 'StopService', 'Success'.
07:32:30,
07:32:30, 'HumanTaskService', 'StopService', 'Success'.
07:32:30, 'AgentService', 'StopService', 'Success'.
07:32:30, 'EventService', 'StopService', 'Success'.
07:32:30, 'GraphicsService', 'StopService', 'Success'.
07:32:30, 'BUX Service', 'StopService', 'Success'.
07:32:30, 'relationalMetadataService', 'StopService', 'Success'.
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'camAsyncAA', 'StopService', 'Success'.
07:32:30, 'burstDistributionService', 'StopService', 'Success'.
07:32:30, 'QueryService', 'StopService', 'Success'.
07:32:30, 'RepositoryService', 'StopService', 'Success'.
07:32:30, 'com.cognos.pogo.services.DefaultHandlerService& #39;, 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.
null
07:32:30, 'BatchReportService', 'StopService', 'Success'.
07:32:30, 'ContentManagerCacheService', 'StopService', 'Success'.
07:32:30, 'IBM Cognos Enhanced Search Service', 'StopService', 'Success'.
07:32:30, 'visualisationGalleryService', 'StopService', 'Success'.
07:32:30, 'PDC', 'StopService', 'Success'.
07:32:30, 'CacheService', 'StopService', 'Success'.
07:32:30, 'ReportDataService', 'StopService', 'Success'.
07:32:30, 'SACamSrvc', 'StopService', 'Success'.
07:32:30, 'LogService', 'StopService', 'Success'.

[Start Service]
[ ERROR ] CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'.

Hi,

The key part of the error message is:

Code Select Expand

CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.
CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\COGNOS10_64\configuration\schemas\content\ oracle\dbInitScript_oracle.sql".
Review the configuration for the content store database in IBM Cognos Configuration to ensure that the settings are correct.
Verify that the account used to access the content store is still valid by checking the status of the password and account permissions.
Verify that the account that Content Manager uses has sufficient permissions to create, to connect to, and to initialize the file contents in the database.

Have you taken the steps suggested in the message? If you look at the Oracle database now, do you see any tables created during the content store initialization process?

Cheers!

MF.

[Manik Goel]

Yes i did everything as per requirement or instructions.

[mcc.chernandez]

Are you trying to reuse existing database?

ORA-00955: name is already used by an existing object Stack trace: java.sql.SQLException: ORA-00955: name is already used by an existing object