CA Datacom IVPUPG03 SQLOCDE -118 DSF NFTE

Document ID : KB000073111
Last Modified Date : 11/07/2018
Show Technical Document Details
Issue:

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.

Cause:

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.

Resolution:

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:

  • Run DDUPDATE to CREATE the missing TABLE, then delete the TABLE and OBSOLETE it. This removes the HIST status fields.
  • Run the second job from IVPUPG03 to do the DEINSTALL
  • Re-run the first job of IVPUPG03.
Additional Information:
See  DocOps secttions Record/Table Field Maintenance Panel Error Codes and FTE error