IBM Support

"EclipseStarter failed! ... Failed to launch! ... Could not load the Entity in the MappingImportDAO" for several (some) JAVA-based menu items, caused by misconfigured 'ccr-system-properties.properties' file

Technote (troubleshooting)


Problem(Abstract)

User clicks one of the following JAVA-based menu items:
* Company – Command Center
* Group - Command Center
* Maintain-System Audit Log – Overview and data

An error appears.

However, some JAVA-based functions do work OK (no errors), for example:
* Maintain – Configuration – Automatic Journals – Control Tables - Allocations..
* Maintain – Jobs – Define…

Symptom

com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!

at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:170)
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(IntegrationApplication.java:101)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:168)
... 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(DefaultModelContext.java:417)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:382)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(DefaultModelContext.java:257)
at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(LocalizationUtils.java:222)
at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(IntegrationApplication.java:91)
... 6 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http :// servername/ibmcognos/controllerserver/CCRWS.asmx, passport=MTsxMDE6NDYwOWZmYTMtOTM2MS0zZGQzLTI0Y2QtNzMzNGU3ZjAyNDdhOjE2NjMwMzA0ODM7MDszOzA7, 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(JAXWSClient.java:88)
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(JAXWSClient.java:134)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(RemoteDao.java:97)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.getLatestSequenceNumber(RemoteDao.java:63)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.getLatestSequenceNumber(CachingDao.java:94)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.isDifferentModelVersion(CachingDao.java:200)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.needsRefresh(CachingDao.java:196)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(CachingDao.java:101)
at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:561)
at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:551)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:81)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(AbstractModelFactory.java:93)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:379)
... 9 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>(WebServiceConnectionException.java:69)
... 22 more


Cause

Unconfigured (or misconfigured) 'ccr-system-properties.properties' file.

More Information
By default, the Controller Java engine first tries to locate the Oracle database server via the Oracle 'thin' method.

  • This requires TNS
  • Therefore, the Controller system needs the file 'ccr-system-properties.properties' to be correctly configured with the location of the TNSNAMES.ORA file.

If the default method (thin) fails, then the Java engine will fall back to using an alternative method (OCI). In many environments, this will fail.

Environment

Controller database hosted on Oracle database server.

Resolving the problem

Specify the correct location of the TNSNAMES.ORA file in the ccr-system-properties.properties file in the ...Server\integration folder.


Steps:
1. Logon to the Controller application server as an administrator
2. Locate the 'integration' folder.

This folder location will vary depending on the environment.

  • TIP: By default, the location for a Controller 10.2.x system is here: C:\Program Files\IBM\cognos\ccr_64\server\integration

3. Open the file " ccr-system-properties.properties" (inside Notepad)
4. Edit the file as appropriate.

The correct value in here will vary depending on the environment, such as:
  • Which Oracle client version has been installed
  • Where the Oracle client has been installed (which folder the TNSNAMES.ORA file is located in)

Example:
The following example is based on Oracle 11G client, being installed into the default location (for the user 'administrator').
  • Therefore, the default location of the TNSNAMES.ORA file would be: C:\app\Administrator\product\11.2.0\client_1\network\admin

Therefore, in this case, you need to modify the file so that it has the following line:
    oracle.net.tns_admin=C:\\app\\Administrator\\product\\11.2.0\\client_1\\network\\admin

In other words, it would look similar to:


IMPORTANT: Make sure that your entry uses DOUBLE backslashes ('\\') instead of the standard Windows single backslash (\).

Document information

More support for: Cognos Controller
Controller

Software version: 10.2.0

Operating system(s): Windows

Reference #: 1995182

Modified date: 02 December 2016


Translate this page: