OFSAAI Model Upload Failing With 'java.lang.NumberFormatException' Error (Doc ID 2129890.1)

Last updated on FEBRUARY 26, 2023

Applies to:

Symptoms

On OFSAAI 7.3.2.6 AND OFSAAI 7.3.5.1, the Model Upload appears to be failing with errors.  While uploading the Data Model the process is failing while generating the SQL files. The error found in nohup.out is java exception. There is no error reported in the model upload log.

ERRORS

Model upload log messages:

fct_ftp_account_summary
The Change is made in Column ...V_ACCT_NUMBER
For input string: "3183148890"

$FIC_APP_HOME/common/FICServer/bin/nohup.out log:

java.lang.NumberFormatException: For input string: "3183148890"
  at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
  at java.lang.Integer.parseInt(Integer.java:461)
  at java.lang.Integer.(Integer.java:660)
  at com.iflex.fic.etl.UploadModel.cnt.ClsUCntColumnDataCheck.ColDataCheck(ClsUCntColumnDataCheck.java:69)
  at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.AlterModifyTable(ClsUCntUploadModel.java:2527)
  at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadModel.handleRequest(ClsUCntUploadModel.java:273)
  at com.iflex.fic.etl.UploadModel.cnt.ClsUCntErwinUpLoad.uploadErwin(ClsUCntErwinUpLoad.java:286)
  at com.iflex.fic.etl.UploadModel.cnt.ClsUCntUploadHandler.handleUpload(ClsUCntUploadHandler.java:253)
  at com.iflex.fic.etl.util.ClsUUtlETLServiceProvider.handleRequest(ClsUUtlETLServiceProvider.java:133)
  at com.iflex.fic.newservice.ServiceProxy.invokeService(ServiceProxy.java:184)
  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:202)
ERWINUPLOAD Altering the Model Failed.

Changes

Cause

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