IBM Support

"Internal error" when launching JAVA-based functions (for example 'Intercompany Report' and 'Command center') caused by using incompatible Oracle JAR file

Troubleshooting


Problem

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

Symptom

The displayed error message will be long and complicated. However, the crucial portions ("caused by...") contain the following phrases:
  • Could not commit with auto-commit set on
  • Socket read timed out
  • No more data to read from socket


====================================
Fuller error message examples:

15:06:26,097 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@36085bcd/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inCompanyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@855d4003]
<...>
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
Caused by:
java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4443)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4490)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:301)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:200)
at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:83)
... 23 more
====================================
07:37:44,120 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@faefdcce/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@2d12c73e]
com.ibm.cognos.ccr.common.SQLConnectionException: exceptionId=ERR.ANY.CONNECTIONEXCEPTION.CANNOT_LOAD_MAPPING, argument(s)=[com.ibm.cognos.ccr.classic.MappingImportSQLDAO@7eb93732(size=9), EntityType=configproperty, {SELECT id, code, entityTypeName FROM XMAPPING WHERE entityTypeName = 'com.cognos.ccr.models.configproperty.ConfigProperty'}]
at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.load(MappingImportSQLDAO.java:113)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.initializeMappings(AbstractImportSQLDAO.java:175)
<....>
Caused by:
java.sql.SQLException: Cannot execute 'SELECT id, code, entityTypeName FROM XMAPPING WHERE entityTypeName = 'com.cognos.ccr.models.configproperty.ConfigProperty''
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:333)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelect(DatabaseUtility.java:293)
at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.load(MappingImportSQLDAO.java:105)
... 12 more
Caused by:
java.sql.SQLRecoverableException: IO Error: Socket read timed out
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:782)
<.................>
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:324)
... 14 more
Caused by:
oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:350)
at oracle.net.ns.DataPacket.receive(DataPacket.java:105)
<.................>
at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
<.................>
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:766)
... 21 more
====================================
Caused by:
java.sql.SQLException: Cannot execute 'SELECT id, code, entityTypeName FROM XMAPPING WHERE entityTypeName = 'com.cognos.ccr.models.configproperty.ConfigProperty''
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:333)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelect(DatabaseUtility.java:293)
at com.ibm.cognos.ccr.classic.MappingImportSQLDAO.load(MappingImportSQLDAO.java:105)
... 11 more
Caused by:
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:453)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390)
====================================

[{"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.

Document Information

Modified date:
08 May 2025

UID

swg21995556

Page Feedback