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 DECEMBER 22, 2023

Applies to:

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

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