My Oracle Support Banner

Object Registration failure due to incorrect partition information defined in the Data Model With ORA-01858 Error (Doc ID 2790759.1)

Last updated on JULY 13, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

on 807 version:

--------------

Perform data model customization using erwin version 9.7 or higher and trigger data model upload.

Model upload fails during object registration with below error in webserver nohup.out:

java.lang.Exception: Error while executing the queryFailed Executing Batch: error occurred during batching: ORA-01858: a non-numeric character was found where a numeric was expected

at com.iflex.fic.etl.UploadModel.cnt.ObjectRegistrationHelper.executeSigleBatchList(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.ObjectRegistrationHelper.executeSigleBatchList(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.ObjectRegistrationHelper.executeMultipleBatches(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.ObjectRegistrationHelper.manageObjRegForLargerQueries(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.ObjectRegistrationHelper.executeObjectRegistrationQueries(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntObjectRegistrar.populateTablesForObjectRegistration(Unknown Source)
at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(Unknown Source)
at com.iflex.fic.metadata.services.ModelUploadServiceProvider.handleRequest(Unknown Source)

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
Cause
Solution
References


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