IBM Support

** Troubleshooting ** Error 'Model not found in context ... SQLConnectionException ... ERR.ANY.CONNECTIONEXCEPTION.CANNOT_OPEN_CONNECTION'

Troubleshooting


Problem

User launches Controller. User clicks on any of the Java-related menu items (introduced since Controller 8.5). For example, user clicks 'Maintain - configuration - Automatic Journals - Control Tables - Allocations'. User receives error message.

Symptom

ALL Scenarios:
Screen message:
Model not found in context: journalType
Unable to find instance of model of type: journalType, type interface com.ibm.cognos.ccr.journaltype.JournalTypeModel (load=DEFAULT)
exceptionID=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[http://SERVERNAME/cognos8/controllerserver/CCRWS.asmx, 010:bxxxxxxx]
FAIL:!com.ibm.cognos.ccr.common.SQLConnectionException: exceptionId=ERR.ANY.CONNECTIONEXCEPTION.CANNOT_OPEN_CONNECTION, argument(s)=[MappingModel, type interface com.ibm.cognos.ccr.classic.MappingImportDAO (load=DEFAULT), jdbc:sqlserver://servername:1433/databasename,[Ljava.lang.Object.@3cc43cc4]!
[OK]

Scenario #2 only:
CCR.LOG:

    09:28:41,984 INFO [Thread-14 ] [ccr.integration.ServerIntegrationFacade] Received call to executeTask
    09:28:42,000 INFO [Test ] [ccr.integration.ServerIntegrationFacade] Using database driver com.jnetdirect.jsql.JSQLDriver
    09:28:42,031 ERROR [Test ] [ccr.classic.BtoVersionRetriever] Could not retrieve version number for configproperty. Returning random value 1286177322031
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Failed Logon:com.jnetdirect.jsql.JSQLException: license error:*** License has expired ***. Expired on:Fri Jul 04 17:36:03 CAT 2008 url:jdbc:JSQLConnect://sqlservername/database=Test)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at com.ibm.cognos.ccr.classic.BtoVersionRetriever.getVersionNumber(BtoVersionRetriever.java:83)
    at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.getLatestSequenceNumber(AbstractImportSQLDAO.java:329)
    at com.ibm.cognos.ccr.common.AbstractModel.setOutputModelDAO(AbstractModel.java:720)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:599)
    at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:840)
    at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:654)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:78)
    at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:59)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1275)

    <......>

    .....ibm.cognos.ccr.integration.ServerIntegrationFacade.prepareContextWithSharedModels(ServerIntegrationFacade.java:418)
    at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.execute(ServerIntegrationFacade.java:284)
    at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:150)
    Caused by:
    com.jnetdirect.jsql.JSQLException: Failed Logon:com.jnetdirect.jsql.JSQLException: license error:*** License has expired ***. Expired on:Fri Jul 04 17:36:03 CAT 2008 url:jdbc:JSQLConnect://sqlservername/database=Test
    at com.jnetdirect.jsql.JSQLDriver.connect(JSQLDriver.java:803)
    at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
    at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
    ... 29 more
    09:28:42,031 ERROR [Test ] [ccr.integration.ServerIntegrationFacade] Failed when invoking method,
    com.ibm.cognos.ccr.common.InvalidContextException: com.ibm.cognos.ccr.common.SQLConnectionException: exceptionId=ERR.ANY.CONNECTIONEXCEPTION.CANNOT_OPEN_CONNECTION, argument(s)=[MappingModel, type interface com.ibm.cognos.ccr.classic.MappingImportDAO (load=DEFAULT), jdbc:JSQLConnect://sqlservername/database=Test, [Ljava.lang.Object;@31f431f4]

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5","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.

Document Information

Modified date:
08 May 2025

UID

swg21448796

Page Feedback