Model Upload Fails With - "Error while querying the database for the number of records"
(Doc ID 2444485.1)
Last updated on JUNE 27, 2021
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : OFSAAI 8.x, Model Upload_OFSS
When attempting to do a Model Upload with Sliced option,
the following error occurs in the Model Upload log.
ERROR
-----------------------
XXXXXX_XXXX_XXXX (Table name).
This column XX_YYYY_XXX has been deleted from the table XXXXXX_XXXX_XXXX in the new database model
Error while querying the database for the number of records in the Column XX_YYYY_XXX which are not null.
The Column XX_YYYY_XXX of table XXXXXX_XXXX_XXXX cannot be deleted as the table has data for this column.
Successfully executed
Below error is noticed in ETLService.log
[DMMQUERYEXECUTOR]QUery execution failed for: SELECT count(1) FROM XXXXXX_XXXX_XXXX where XX_YYYY_XXX is not null ::"No more data to read from socket"
And nohup.out has below exception
[05-09-18 20:37:37,930 PM]~[DEBUG]~[GenericOFSAAConnectionFactory]~[getConnection]~DB connection fetched successfully for DBServer: YY.YY.Y.YYY, DBName: ofsaaatm
[05-09-18 20:37:37,930 PM]~[DEBUG]~[GenericOFSAAConnectionFactory]~[getInfoConnection]~Information domain connection fetched successfully for Infodom: OFSAADOM
"java.sql.SQLRecoverableException: No more data to read from socket"
at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:456)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:762)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:5179)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:5302)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1325)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:422)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:221)
at com.sun.proxy.$Proxy3.executeQuery(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.DMMDBManager.executeQuery(DMMDBManager.java:88)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntColumnDataCheck.ColDataCheck(ClsUCntColumnDataCheck.java:59)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.deletedTables(ClsUCntUploadModel.java:6352)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.AlterModifyTable(ClsUCntUploadModel.java:2926)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.handleRequest(ClsUCntUploadModel.java:438)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntErwinUpLoad.uploadErwin(ClsUCntErwinUpLoad.java:183)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:599)
at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:134)
at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
at com.iflex.fic.newservice.NewServiceMaster.provideService(NewServiceMaster.java:211)
at com.iflex.fic.newservice.DynamicServiceManager.provideService(DynamicServiceManager.java:297)
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(JavaRequestHandler.java:546)
at com.iflex.fic.ficserver.JavaSocketConnection.run(JavaSocketConnection.java:201)
"Error is......No more data to read from socket"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Trigger the data model upload from UI or Command line utility
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload the merged model successfully.
Changes
Cloned environment to new Server
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |