Product:
Cognos Controller 8.5.1
Symptom:
On a new installation of Cognos Controller 8.5.1 you get an error message when you try to start some of the new java functions.
E.g. you get an error when you select menu MAINTAIN-JOBS-DEFINE inside Cognos Controller.
There are different error message and probably different solutions at different installations environments. This is only suggestions to solutions for this issue.
Error message:
Model not found in context: job
Unable to find instance of model of type: job, type interface com.ibm.cognos.ccr.job.JobModel (load=LAST)
exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVIC, argument(s)=[http://SERVERNAME/cognos8/controllerserver/CCRWS.asmx,
010:e86b8e3e-90c7-11df-b642-93cfe15c0313:4108201324]
Fail:!No driver found – dbtype is invalid:com.ibm.cognos.ccr.common.DbConfiguration$DbType, SQL_SERVER=’MS SQLServer’ (provider=SQLNCLI.1)!
Solution:
Ensure that a SQLJDBC.JAR file is placed in the c:\program files\cognos\c8\server\integration folder from Microsoft if you are using Microsoft SQL 2008 server.
Error message:
Model not found in context: job
Unable to find instance of model of type: job, type interface com.ibm.cognos.ccr.job.JobModel (load=LAST)
exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVIC, argument(s)=[http://SERVERNAME/cognos8/controllerserver/CCRWS.asmx,
010:38c30464-933b-11df-b410-97c9b6150a8d:1881910691]
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://imcogbi84.DatabaseName=xC82_05std.SelectMethod=Cursor.,[Ljava.lang.Object.@2d722d72]!
Solution:
Ensure that you have updated the file c:\program files\cognos\c8\server\integration\ccr-dbTypes.properties with the correct name of the database server and the correct name of the controller database file on that server.
The SQL section in ccr-dbTypes.properties lines can look like this;
SQL_SERVER.name = MS SQLServer
SQL_SERVER.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
SQL_SERVER.url = jdbc:sqlserver://imcogbi84;DatabaseName=xC82_05std;SelectMethod=Cursor;
(imcogbi84 should be the DNS name of the database server)
(xC82_05std should be the SQL manager name of the database file)
Error message:
Model not found in context: job
Unable to find instance of model of type: job, type interface com.ibm.cognos.ccr.job.JobModel (load=LAST)
exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVIC, argument(s)=[http://SERVERNAME/cognos8/controllerserver/CCRWS.asmx,
010:e86b8e-90c7-11df-b642-93cfe15c0313:4034713480]
FAIL:!null!
Solution:
This means that the sqljdbc is working – but you do not have any data in the controller database.
Exit Cognos controller and log in again against an existing database with controller data in it.
Error message:
Model not found in context: job
Unable to find instance of model of type: job, type interface com.ibm.cognos.ccr.job.JobModel (load=LAST)
exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVIC
argument(s)=[http://SERVERNAME/cognos8/controllerserver/CCRWS.asmx, 010:b3edc368-9336-11df-9234-b0f427c64e84:2448656821]
FAIL:Could not attach to JVM.
Solution:
Ensure that you have set the CCR_JAVA_HOME variable on the Controller server to point to the folder where you have unzipped the file jre.zip. Recommendation is to unpack it to folder c:\program files\cognos\java60.
Jre.zip is found in folder c:\program files\cognos\c8\webcontent\ccr.
Background information:
Cognos Controller 8.5.1 new parts made in JAVA need the JAVA database driver. For Microsoft SQL 2008 this must be download from Microsoft Web site and installed on the Controller application server in folder c:\program files\cognos\c8\server\integration.
Cognos Controller 8.5.1 new parts works only when you use the SQLNCLI.1 database client, therefore this must be downloaded and installed on the Cognos Controller Application server – even if you use Microsoft SQL 2008 server. That client is not included in the installation of Microsoft SQL 2008 server.
You must also define in Cognos Controller Configuration on database connections to use SQLNCLI.1 and not as before SQLOLEDB.1 in the field for database connection.
Links to more information:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
http://www-01.ibm.com/support/docview.wss?uid=swg21440254