Datacom IVPUPG03 SQLOCDE -118 DSF NFTE

Products

• Datacom
• DATACOM - AD
• Datacom/DB

Issue/Introduction

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.

Environment

Release: 15.1
Component: Datacom/DB

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  the Datacom messages documentation sections Record/Table Field Maintenance Panel Error Codes and FTE error