My Oracle Support Banner

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

Last updated on SEPTEMBER 26, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.1.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

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.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:202)
ERWINUPLOAD Altering the Model Failed.

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.