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 SEPTEMBER 08, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information 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


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