IBM Support

"Internal Error" caused by Data Source containing full stops (.) when click 'Maintain - Jobs - Define'

Troubleshooting


Problem

User clicks 'Maintain - Jobs - Define'. User receives error.

Symptom


Internal error

Error Details:
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=h ttp://servername/ibmcognos/controllerserver/CCRWS.asmx, passport=MTswMTA6MTY3Y2M0NGItODk5YS02ZmE0LTkxMjctMjk5YmQxMWQzZjZiOjMxMDg0MDk4NDI7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=getLatestSequenceNumber, args.length=0, args=[])]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(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)
... 22 more

ccr.log:
14:29:41,116 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.getLatestSequenceNumber...
14:29:41,428 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking method,
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 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1278)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
<.....>
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
Caused by:
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 org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:104)
at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1275)
... 22 more
14:29:41,460 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.getLatestSequenceNumber (570 bytes): 344 ms, memory usage [kb]: max=524 288 | total=308 416 | free=44 280 | total free=260 152

Cause

The error 'Internal Error ... Failed to launch!' is generic - there are many possible causes for similar errors.

This Technote specifically relates to the scenario where the cause is a limitation of Controller, triggered when the 'Data Source' contains full-stops (.).

Example:

CCR12CNEW.test.com


Environment

Controller database hosted on Oracle.

Resolving The Problem

Modify the 'Data Source' so that it contains a single word SID value.

Example:

In one real-life example, the solution was to change it to be CCR12CNEW



NOTE: If if does not already exist, you would need to add an entry (inside TNSNAMES.ORA) for this new SID value (so that it resolves to the correct Oracle database server/database).

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21999559