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

Last updated on JULY 25, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms