My Oracle Support Banner

OFSAA 8.1 Upgrade Failed on Generatejson.sh With Meta Table for JSON Updated Failed on RES_DTL and CONS_DTL (Doc ID 2814536.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

When running generatejson.sh during GL Recon 8.1.1 upgrade, the following error occurs.

Error:

./generatejson.sh FSDFINFO
JsonGeneration_FSDFINFO.log:
[DynamicServiceManager][GlobalParameters.ISWEB]false
FIC_HOME:/app/ofsaa81/
Number of args is 2
The FIC_HOME path is /app/ofsaa81
Config table is already present checking the upgrade utility exection status
Status is not Y the starting upgarde utility for infodom..: FSDFINFO
Upgrade Script Execution Started.....

...etc

No Of Table for JSON Creation :3553
REVERS GENRATION STARTED STARTED AT Tue Sep 14 19:58:02 IST 2021

-----------------------------Table to JSON-----------------------------
Writing File Completed Successfully for Table :RES_DTL_211843
-----------------------------Table to JSON-----------------------------
Writing File Completed Successfully for Table :CONS_DTL_211843
-----------------------------Table to JSON-----------------------------

...etc list many RES_DTL and CONS_DTL

-----------------------------Table to JSON-----------------------------
Writing File Completed Successfully for Table :RES_DTL_211991
-----------------------------Table to JSON-----------------------------
Writing File Completed Successfully for Table :CONS_DTL_211991
JSON Generated and  Write Went Successfully.
FTPDrive Path : /app/ftpshare81/
Old Script location : /app/ftpshare81//FSDFINFO/erwin
Started coping scripts from : /app/ftpshare81//FSDFINFO/erwin/scripts/table to: /app/ftpshare81//FSDFINFO/json/scripts
Scripts already exits...clearing the scripts in the path : /app/ftpshare81//FSDFINFO/json/scripts/table
File Already Exists In Destination : /app/ftpshare81/FSDFINFO/json/scripts/table
Scripts Are Copied Successfully.
dmmMetadataList : 3553
Meta Table for Json updated Failed.


Steps To Replicate:
1. Apply a patch for GL Recon 8.1.1 during upgrade and it is showing data model upload failure.
2. Apply the patch without data model upload then it is failed with error below:
   “JSON generation is Failed for the Infodom FSDFINFO. Please re-run the generatejson utility for the Infodom FSDFINFO”
3. Run ./generatejson.sh FSDFINFO found the above error.
4. Re-run generatejson.sh again after truncating data in RES_DTL_XXX and CONS_DTL_XXX.
    Logs show the same "Meta Table for Json updated Failed" and no other details.
5. Observed in REV_TABLES_B, there is no Version for RES_DTL_XXX and CONS_DTL_XXX tables.


Changes

Apply patch for GL Recon 8.1.1.

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.