"Internal error ... No more data to read from socket" when launching JAVA-based functions, caused by database shutting down earlier

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:169)
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(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run
(IntegrationServiceAdapter.java:167)
... 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(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(Unknown Source)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(Unknown Source)
at com.ibm.cognos.ccr.common.util.LocalizationUtils.getPresentationLocale(Unknown Source)
... 7 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException:
exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http:// servername /ibmcognos/cgi-
bin/cognosisapi.dll?t=controller,
passport=MTsxMDE6MzE3N2U3NDQtOGM3OS1hZWE4LTFlZTQtZTg0NTYyOGQ2MjY5OjA1OTY1NjA0ODk7MDszOzA7, request=executeTask
(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=
[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@55a6b878])]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(Unknown Source)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModel.load(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(Unknown Source)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getSharedModel(Unknown Source)
... 10 more
Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:Failed to load mapping in {0} for entity type {2} (connection
details: {1}),%1=com.ibm.cognos.ccr.classic.MappingImportSQLDAO@255a58ac(size=21),%2=EntityType=configproperty,%3={SELECT
id. code. entityTypeName FROM XMAPPING WHERE entityTypeName = 'com.cognos.ccr.models.configproperty.ConfigProperty'}
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)

ccr.log: (on the application server)

13:03:17,500 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.getLatestSequenceNumber...
13:03:17,500 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user SURAN5: 0 ms
13:03:17,500 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
13:03:17,515 ERROR [cognos.ccr.classic.BtoVersionRetriever] Could not get version for 'configproperty'. Returning random value 1493377397500. SQL: SELECT FRANGOTABLENAME, TABLECOUNTER FROM XTABVER WHERE FRANGOTABLENAME IN ('XKONFIG')
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:879)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at
<....>
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
13:03:17,531 INFO [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 31 ms
13:03:17,531 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.getLatestSequenceNumber (108 bytes): 31 ms, memory usage [kb]: max=524 288 | total=464 640 | free=114 644 | total free=174 292
13:03:17,609 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.load...
13:03:17,609 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user SURAN5: 0 ms
13:03:17,609 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
13:03:17,609 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@d3849edd/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@b32fda44]
com.ibm.cognos.ccr.common.SQLConnectionException: exceptionId=ERR.ANY.CONNECTIONEXCEPTION.CANNOT_LOAD_MAPPING, argument(s)=[com.ibm.cognos.ccr.classic.MappingImportSQLDAO@255a58ac(size=21), 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)
at com.ibm.cognos.ccr.classic.AbstractImportSQLDAO.load(AbstractImportSQLDAO.java:158)
at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.ibm.cognos.ccr.common.ws.ServerTask.execute(ServerTask.java:87)
at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:57)
at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:32)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.execute(ServerIntegrationFacade.java:240)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
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.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:869)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:324)
... 13 more
13:03:17,609 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.load (305 bytes): 0 ms, memory usage [kb]: max=524 288 | total=464 640 | free=114 477 | total free=174 125
13:10:33,912 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.getLatestSequenceNumber...
13:10:33,912 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user SURAN5: 0 ms
13:10:33,912 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
13:10:33,912 ERROR [cognos.ccr.classic.BtoVersionRetriever] Could not get version for 'configproperty'. Returning random value 1493377833912. SQL: SELECT FRANGOTABLENAME, TABLECOUNTER FROM XTABVER WHERE FRANGOTABLENAME IN ('XKONFIG')
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at <....>
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
13:10:33,912 INFO [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 0 ms
13:10:33,912 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.getLatestSequenceNumber (108 bytes): 0 ms, memory usage [kb]: max=524 288 | total=464 640 | free=114 379 | total free=174 027
13:10:33,990 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.load...
13:10:33,990 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user SURAN5: 0 ms
13:10:33,990 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
13:10:33,990 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@1f6448c4/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@e7c8dd51]
com.ibm.cognos.ccr.common.SQLConnectionException: exceptionId=ERR.ANY.CONNECTIONEXCEPTION.CANNOT_LOAD_MAPPING, argument(s)=[com.ibm.cognos.ccr.classic.MappingImportSQLDAO@255a58ac(size=21), 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
<....>
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
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.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
<....>
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:324)
... 13 more
13:10:33,990 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.load (305 bytes): 0 ms, memory usage [kb]: max=524 288 | total=464 640 | free=114 265 | total free=173 913
13:14:27,649 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.getLatestSequenceNumber...
13:14:27,649 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user SURAN5: 0 ms
13:14:27,649 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
13:14:27,649 ERROR [cognos.ccr.classic.BtoVersionRetriever] Could not get version for 'configproperty'. Returning random value 1493378067649. SQL: SELECT FRANGOTABLENAME, TABLECOUNTER FROM XTABVER WHERE FRANGOTABLENAME IN ('XKONFIG')
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
<....>
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
13:14:27,649 INFO [cognos.ccr.integration.ServerIntegrationFacade] Operation execution time: 0 ms
13:14:27,649 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inConfigpropertyModelDAO.getLatestSequenceNumber (108 bytes): 0 ms, memory usage [kb]: max=524 288 | total=464 640 | free=114 143 | total free=173 791
13:14:27,711 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inConfigpropertyModelDAO.load...
13:14:27,711 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user SURAN5: 0 ms
13:14:27,711 INFO [cognos.ccr.integration.ServerIntegrationFacade] Prepared context with shared models: 0 ms
13:14:27,711 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@fec26b05/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=inConfigpropertyModelDAO, methodName=load, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@57bb39e9]
com.ibm.cognos.ccr.common.SQLConnectionException: exceptionId=ERR.ANY.CONNECTIONEXCEPTION.CANNOT_LOAD_MAPPING, argument(s)=[com.ibm.cognos.ccr.classic.MappingImportSQLDAO@255a58ac(size=21), 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)
<....>3)
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.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:869)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at com.ibm.cognos.ccr.common.util.DatabaseUtility.executeSelectUnprepared(DatabaseUtility.java:324)
... 13 more