generate_metadata procedure missing new fields

[iversond]

We recently upgraded to 8.60 and ran the gfcpsstats11.generate_metadata procedure to make sure our GFC tables were in sync with the database. We get the following error when running the procedure:

EXECUTE gfcpsstats11.generate_metadata;

BEGIN gfcpsstats11.generate_metadata; END;
Error report -
ORA-01400: cannot insert NULL into ("SYSADM"."PS_GFC_STATS_OVRD"."DEL_STATS")

It looks like this procedure doesn't include the newer fields in the PS_GFC_STATS_OVRD table.

[davidkurtz]

Hello Dan This is slightly expected. I added the column DEL_STATS to the metadata table. It is added by gfcpsstats11.sql, but also added it to the example script gfcpsstats11_metadata_fin.sql. Your choice is between adding the column to the statements in the metadata script or adding a default value of a single space to the column on the table. I think I will now add a default value for the column (although it is not standard in PeopleSoft), but I still recommend specifying it in the metadata script. regards

…

_________________________ David Kurtz tel: +44 (0)7771 760660 ***@***.*** From: Dan Iverson ***@***.*** Sent: 14 February 2023 17:56 To: davidkurtz/gfcpsstats Cc: Subscribed Subject: [davidkurtz/gfcpsstats] `generate_metadata` procedure missing new fields (Issue #5) We recently upgraded to 8.60 and ran the gfcpsstats11.generate_metadata procedure to make sure our GFC tables were in sync with the database. We get the following error when running the procedure: EXECUTE gfcpsstats11.generate_metadata; BEGIN gfcpsstats11.generate_metadata; END; Error report - ORA-01400: cannot insert NULL into ("SYSADM"."PS_GFC_STATS_OVRD"."DEL_STATS") It looks like this procedure doesn't include the newer fields in the PS_GFC_STATS_OVRD table. — Reply to this email directly, view it on GitHub <#5> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADFJHGSNL2A7TOUYEVAJEQLWXPBMLANCNFSM6AAAAAAU333C3I> . You are receiving this because you are subscribed to this thread. <https://github.com/notifications/beacon/ADFJHGSZVWHNKURJ7SVCDXTWXPBMLA5CNFSM6AAAAAAU333C3KWGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHF44X7HI.gif> Message ID: ***@***.***>