Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 Server
Oracle database 12c
Symptom:
Error when starting the new java menus in a new installation.
User clicks one of the following JAVA-based menu items:
* Company – Command Center
* Group – Command Center
* Maintain-System Audit Log – Overview and data
* Maintain – Configuration – Automatic Journals – Control Tables – Allocations.
* Maintain – Jobs – Define…
You need to test all five – they may call the oracle database different.
The problem does not occur in all environments. In other words, keeping the default (unmodified) file “ccr-system-properties.properties” will work in most environments.
- By enabling the path in this file, then Controller’s Java-based functionality will try to connect using the ‘thin‘ protocol for oracle.
- If the file/path is unmodified (the default settings), then those components will try to use the ‘OCI’ oracle client. This mean the full oracle client must be installed.
Error message:
Below from Cognos Controller client error dialog
com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:169)
at java.lang.Thread.run(Thread.java:798)
Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!
at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)
… 1 more
Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]
at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)
at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)
… 7 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http://ctrlweb.companyX.com/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, passport=MTsxMTA6MzlkZDS05ODc0LTMwYTMjAxOTU1OjM3NDk3OTY4NzM7MDszOzE7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@123a963])]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)
… 10 more
Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)
… 19 more
com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:169)
at java.lang.Thread.run(Thread.java:798)
Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!
at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)
… 1 more
Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]
at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)
at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)
… 7 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http://ctrlweb.companyX.com/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, passport=MTsxMDE6ZGIwYTFiN2UtNTZY3ODEtYmEyNGJhYOjAwNzE5ODMyNDI7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@880de732])]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)
… 10 more
Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:Failed to load mapping in {0} for entity type {2} (connection details: {1}),%1=com.ibm.cognos.ccr.classic.MappingImportSQLDAO@9a78b98(size=12),%2=EntityType=configproperty,%3={SELECT id. code. entityTypeName FROM XMAPPING WHERE entityTypeName = ‘com.cognos.ccr.models.configproperty.ConfigProperty’}
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)
… 19 more
com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:169)
at java.lang.Thread.run(Thread.java:798)
Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!
at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)
… 1 more
Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]
at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)
at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)
… 7 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http://ctrlweb.companyX.com/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, passport=MTsxMDE6N2MyNTdkYzctNjc4Yy1kZWNlMWJmN2Y5OjE4MTMzU1NDU7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@9d8fd360])]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)
… 10 more
Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘hidProvider’ defined in class path resource [com/ibm/cognos/ccr/common/bto-db-dao-config.xml]: Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property ‘mappingDao’ threw exception; nested exception is com.ibm.cognos.ccr.common.UnhandledException: Could not load the Entity in the MappingImportDAO
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)
… 19 more
Below from the CCR.LOG file
17:00:22,547 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.load…
17:00:26,587 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 4 040 ms
17:00:26,587 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
17:00:26,993 INFO [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 406 ms
17:00:26,993 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.load (16 212 bytes): 4 446 ms, memory usage [kb]: max=524 288 | total=10 560 | free=3 034 | total free=516 762
17:00:29,926 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inJobModelDAO.getLatestSequenceNumber…
17:00:29,926 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 0 ms
17:00:29,926 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
17:00:29,941 INFO [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 15 ms
17:00:29,941 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inJobModelDAO.getLatestSequenceNumber (108 bytes): 15 ms, memory usage [kb]: max=524 288 | total=10 560 | free=3 644 | total free=517 372
17:00:30,300 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inAccountModelDAO.getLatestSequenceNumber…
17:00:30,300 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 0 ms
17:00:30,300 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
17:00:30,316 INFO [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 16 ms
17:00:30,316 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inAccountModelDAO.getLatestSequenceNumber (108 bytes): 16 ms, memory usage [kb]: max=524 288 | total=10 560 | free=3 226 | total free=516 954
17:00:30,394 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inAccountModelDAO.load…
17:00:30,394 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user ROOST5: 0 ms
17:00:30,394 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
17:00:30,955 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@1a443e7a/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inAccountModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@aefe9f8e]
com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction
at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:89)
at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.createMapping(MappingImportSQLDAO.java:240)
at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.getOrCreateMapping(MappingImportSQLDAO.java:136)
at com.ibm.cognos.ccr.account.internal.KontoDTOConverter.convert(KontoDTOConverter.java:98)
at com.ibm.cognos.ccr.classic.AbstractDTOConverter.convertAll(AbstractDTOConverter.java:56)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO$DTOImportHandler.processResultSet(AbstractImportSQLDAO.java:472)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:325)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelect(DatabaseUtility.java:293)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelect(DatabaseUtility.java:254)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadFromBTOAndConvertToB52(AbstractImportSQLDAO.java:290)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadFromBTOAndConvertToB52(AbstractImportSQLDAO.java:268)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadFromBTOAndConvertToB52(AbstractImportSQLDAO.java:251)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.loadEntitiesInto(AbstractImportSQLDAO.java:191)
at com.ibm.cognos.ccr.account.internal.AccountModelBTOSQLDAO.load(AccountModelBTOSQLDAO.java:126)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.ibm.cognos.ccr.common.ws.ServerTask.execute(ServerTask.java:87)
at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:57)
at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:32)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.execute(ServerIntegrationFacade.java:240)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
Caused by:
java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2360)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2407)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:301)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:200)
at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:83)
… 23 more
17:00:30,987 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inAccountModelDAO.load (83 bytes): 593 ms, memory usage [kb]: max=524 288 | total=15 424 | free=5 253 | total free=514 117
Select the cause by row and search the google internet to find a solution from IBM support;
“Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘hidProvider’ defined in class path resource”
http://www-01.ibm.com/support/docview.wss?uid=swg21995182
http://www-01.ibm.com/support/docview.wss?uid=swg21672387
First things to check:
Check that oracle client is working by enter TNSPING FRANGO.DOMAIN.COM in a Command prompt to see that you have access to the database for Cognos Controller.
Replace FRANGO.DOMAIN.COM with database value in the TNSNAMES.ORA file.
Check that file C:\orarun\tnsadmin\sqlnet.ora contain TNSNAMES first like this
NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT, HOSTNAME).
Check TNSNAMES.ORA that the file is not too big, try with only 2 entries in the file.
In add/remove program ensure that the oracle driver installed for both 64 and 32-bit version.
Check the C:\Program Files\ibm\cognos\ccr_64\server\integration\ccr-system-properties.properties file that it points to the folder where TNSNAMES.ORA is.
Check windows system variable TNS_NAMES point to the folder where TNSNAMES.ORA is.
This can be done by write SET in a CMD prompt.
Ensure that the correct OJDBC5.JAR file is in these folders;
C:\Program Files\ibm\cognos\ccr_64\server\integration
C:\Program Files\ibm\cognos\ccr_64\server\FAP\lib
C:\Program Files\ibm\cognos\ccr_64
Ensure the ORACLE drivers bin folder is first in the system variable PATH.
Any change requires a reboot of the Windows server before you test again in Cognos Controller.
For the Cognos BI 10.2.2 part you may want to check this;
Copy the appropriate file from the Oracle_installation directory of the database to be used for the connection to the c10_location\webapps\p2pd\WEB-INF\lib directory.
If your version of IBM Cognos BI uses Java™ version 1.5, copy the ojdbc5.jar file.
If your version of IBM Cognos BI uses Java version 1.6, copy the ojdbc6.jar file.
If your version of IBM Cognos BI uses Java version 1.7, copy the ojdbc7.jar file.
The path tells you what version you use C:\Program Files\ibm\cognos\ccr_64\bin64\jre\7.0\bin.
Stop and restart the IBM Cognos service.
How create log files:
Stop the Cognos Controller services on the Windows server.
Rename the file C:\Program Files\ibm\cognos\ccr_64\log\ccr.log
Start the Cognos Controller services.
Run the test to open a dialog again.
Copy the new ccr.log file to your Cognos support request.
JAVA errors are written to the ccr.log file, but many other errors are written to the windows event log.
Solution:
Ensure that you refer to the Oracle data source in Cognos Controller configuration with name only. SID name (like: it1051) , and not add .company.com to the line.
You need to ensure that the TNSNAMES.ORA have this setting and format:
it1051 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=lx21024.company.com)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=IT1051.COMPANY.COM))
)
Download the Oracle odbc6.jar drivers from here
http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
Download the full Oracle client from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html see far below on site the download links for the client only;
Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64) |
||
| winx64_12102_client.zip (64-bit) (925,039,944 bytes) | ||
Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit) |
||
| winnt_12102_client32.zip (32-bit) (902,922,170 bytes) | ||
Follow the installation instructions from IBM here http://www-01.ibm.com/support/docview.wss?uid=swg21608353
More Information: