IBM Support

"Internal error" when using Java function, caused by using invalid provider (e.g. SQLNCLI11)

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

[{"Product":{"code":"SS9S6B","label":"Cognos Controller"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21672387