My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.

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(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(
at com.sun.proxy.$Proxy3.executeQuery(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.DMMDBManager.executeQuery(
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntColumnDataCheck.ColDataCheck(
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.deletedTables(
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.AlterModifyTable(
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.handleRequest(
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntErwinUpLoad.uploadErwin(
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(
at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(
at com.iflex.fic.newservice.ServiceProxy.invokeService(
at com.iflex.fic.newservice.NewServiceMaster.provideService(
at com.iflex.fic.newservice.DynamicServiceManager.provideService(
at com.iflex.fic.ficserver.JavaRequestHandler.handleRequest(
"Error is......No more data to read from socket"


The issue can be reproduced at will with the following steps:
1. Trigger the data model upload from UI or Command line utility

The issue has the following business impact:
Due to this issue, users cannot upload the merged model successfully.


 Cloned environment to new Server


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

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