Troubleshooting
Problem
User launches a JAVA-based function (e.g. "Group - Command Center"). An error appears.
Symptom
Group - Command Center:
Internal 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:170)
at java.lang.Thread.run(Thread.java:781)
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://vstocs-102beta/ibmcognos/controllerserver/CCRWS.asmx, passport=MTsxMDE6OWIzNTA2NTctN2E0NC0zMjBjLTRlMjUtNTgxNTQ3NmVhNGY4OjM2Mzk4MzQ3MTA7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=getLatestSequenceNumber, args.length=0, args=[])].....
After clicking on OK, the Java loading window will close, trying to launch any Java function again will not work and will not generate any error on the client.
However on each attempt to launch java functions, an error will be provide in the application server java log, in C:\Program Files\ibm\cognos\ccr_64\log\ccr.log.
- 10:50:28,001 ERROR [cognos.ccr.common.DbConfiguration] Invalid provider string: SQLNCLI11
10:50:28,001 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking method,
java.lang.Exception: Invalid provider string: SQLNCLI11
at com.ibm.cognos.ccr.common.DbConfiguration.mapProviderToDBType(DbConfiguration.java:289)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacadeUtil.createDBConfiguration(ServerIntegrationFacadeUtil.java:43)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.execute(ServerIntegrationFacade.java:228)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
10:50:28,235 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.getLatestSequenceNumber (41 bytes): 406 ms, memory usage [kb]: max=524 288 | total=4 352 | free=1 032 | total free=520 968
Cause
Incorrect provider string in database connection.
More Information
This error has been seen when a customer tries to use the incorrect provider string "SQLNCLI11" (instead of the correct "SQLNCLI11.1"):
Environment
Microsoft SQL server 2012
Diagnosing The Problem
Controller is configured with SQL server 2012, and in the database connection parameters in Controller configuration the provider string is set to SQLNCLI11. Testing the database connection works fine, and most things in Controller also works. However no Java functions can be used. For example Maintain->Jobs->Define, and Command Center.
Resolving The Problem
Change the provider to a valid value (for example 'SQLNCLI11.1' ).
Steps:
1. Obtain a short period of downtime (no users on the system)
2. Logon to the Controller application server
3. Launch "Controller Configuration"
4. Locate the relevant Database Connection
5. Modify the value 'Provider' to be a supported value
TIP: Below are the supported values for Controller 10.2:
Database client | Provider |
SQL 2005 | SQLNCLI.1 |
SQL 2008 | SQLNCLI10.1 |
SQL 2012 | SQLNCLI11.1 |
Oracle | OraOLEDB.Oracle.1 |
DB2 | IBMDADB2.DB2COPY1 |
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21672387