My Oracle Support Banner

When Executing Data Migration Process import-data.sh Fails With Errors (Doc ID 2997358.1)

Last updated on JANUARY 17, 2024

Applies to:

Oracle Financial Services Profitability Management Cloud Service - Version 23C and later
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service - Version 23C and later
Oracle Financial Services Funds Transfer Pricing Cloud Service - Version 23C and later
Information in this document applies to any platform.
Oracle Financial Services Profitability and Balance Sheet Management Base Cloud Service (PBSMCS)
Oracle Financial Services Profitability Management Cloud Service (PFTCS)
Oracle Financial Services Funds Transfer Pricing Cloud Service (FTPCS)

Symptoms

When trying to do a data migration from on-premise FTP to Profitability Management Cloud, the import-data.sh script fails.

ERROR

[20-11-23 19:20:21,453 GMT PM] [INFO ] **************** Starting Import Utility **************
[20-11-23 19:20:23,964 GMT PM] [INFO ]
[20-11-23 19:20:23,965 GMT PM] [INFO ] ==============================================================================================================
[20-11-23 19:20:23,965 GMT PM] [INFO ] PREPARING fsi_d_loan_contracts_31082023_1.csv FOR IMPORT
[20-11-23 19:20:23,965 GMT PM] [INFO ] generating zip for fsi_d_loan_contracts_31082023_1.csv
[20-11-23 19:20:23,972 GMT PM] [INFO ] zipped fsi_d_loan_contracts_31082023_1.csv as fsi_d_loan_contracts_31082023_1.zip
[20-11-23 19:20:23,972 GMT PM] [INFO ] uploading fsi_d_loan_contracts_31082023_1.zip to object store
[20-11-23 19:20:31,214 GMT PM] [INFO ] File uploaded with fileId --> 31902
[20-11-23 19:20:31,214 GMT PM] [INFO ] upload completed
[20-11-23 19:20:31,214 GMT PM] [INFO ] invoking import for fsi_d_loan_contracts_31082023_1.zip
[20-11-23 19:20:32,480 GMT PM] [INFO ] {"msg":"fail"}
[20-11-23 19:20:32,480 GMT PM] [ERROR] import completed with error for fsi_d_loan_contracts_31082023_1.zip please refer import log for more information
[20-11-23 19:20:32,486 GMT PM] [ERROR] error while invoking import
[20-11-23 19:20:32,486 GMT PM] [ERROR] =====Exception====
org.json.JSONException: JSONObject["logFilename"] not found.
at org.json.JSONObject.get(JSONObject.java:452) ~[JSON_parser.jar:?]
at com.ofss.fsgbu.saasmigration.ImportData.invokeSaaSImportAPI(ImportData.java:243) [saasmigration.jar:?]
at com.ofss.fsgbu.saasmigration.ImportData.triggerImport(ImportData.java:168) [saasmigration.jar:?]
at com.ofss.fsgbu.saasmigration.ImportData.main(ImportData.java:77) [saasmigration.jar:?]

Changes

 

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
References


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