"No driver found - dbType is invalid" when launching JAVA-based function (for example Command Center), caused by invalid 'ccr-dbTypes.properties'

Troubleshooting

Problem

User launches a JAVA-based function (for example 'Company - Command Centre'). An error appears.

Symptom

Screen:
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 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.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=https:// servername/ibmcognos/controllerserver/CCRWS.asmx, passport=MTsxMDE6NTM5ZGI0ZWEtNTc5Zi0zZDkyLTVlZjMtNGQzNjQwOTNhMWU4OjE2NDIxNTAzMzU7MDszOzE7, 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.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:379)
... 9 more
Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:java.lang.IllegalArgumentException: No driver found - dbType is invalid:com.ibm.cognos.ccr.common.DbConfiguration$DbType,SQL_SERVER='MS SQLServer' (provider=SQLNCLI11.1)
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:69)
... 22 more

ccr.log:
16:46:46,082 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.getLatestSequenceNumber...
16:46:46,145 ERROR [cognos.ccr.common.DbConfiguration] Invalid provider string: SQLNCLI11
16:46:46,160 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

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM Cognos Controller

Software version:
10.2.1

Operating system(s):
Windows

Document number:
565955

Modified date:
09 May 2025

UID

swg22006798

IBM Support

Tips