Upgrading Datacom/DB to 15.1 and receive several -118 errors on IVPUPG03 on CREATE TABLE SQL statements:
SQLCODE = -118, SQLSTATE=RNFTE MESSAGE = DSF 'NFTE' A N1 REVIEW_PERCENT SQLCODE = -118, SQLSTATE=RNFTE MESSAGE = DSF 'NFTE' A P0 PLAN_CODE
Running the second part of the IVPUPG03 job to DEINSTALL the database and a rerun of the first part does not resolve the error.
The NFTE error indicates an error in FIELD processing.
Error code N1 means the field already exists in the record or table.
Error code P0 means the field specified in the PARENT attribute-value does not exist in the table.
These errors can be caused by the presence of orphans or fields in HIST status.
In this case the error was caused by the presence of HIST versions for the FIELD being added. There was no TABLE just FIELDs in HIST status.
To resolve the problem do the following: