Model Upload Fails With - "Error while querying the database for the number of records" (Doc ID 2444485.1)

Last updated on SEPTEMBER 08, 2018

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.