DDPFI70001 DATACOM-ID IS MISSING during upgrade job.

Products

• Datacom
• DATACOM - AD

Issue/Introduction

BDUPG07 running DDUPDATE -UPG TABLE,ALL(TEST) or ALL(PROD) to set the ENCRYPTION attributes to default values gives

**** ERROR **** RETURN CODE = DDPFI70001 DATACOM-ID IS MISSING

 

 

 

Environment

Datacom/AD 14.0

Resolution

RETURN CODE = DDPFI70001 DATACOM-ID IS MISSING

indicates that you have a table defined to your Datadictionary that has an incorrect Datacom table id - outside the range 1-240.

To resolve:

1. Run DQBATCH using

//SYSIN DD *

SIGN/ON DATACOM-INSTALL PASSWORD NEWUSER

OPTION QUERYLANG=DQL

FIND ALL AGGREGATE WITH (ENTITY-TYPE = 'TBL' AND DATACOM-ID > 240 *

AND (STATUS = 'T' OR STATUS = 'P')) *

PRINT ENTITY-NAME *

STATUS *

ENTITY-VER *

DATACOM-ID *

DATABASE-ID

EXECUTE *

/*

2. Run DBUTLTY REPORT AREA=CXX,DBID=nnnnn for every base that a table with an invalid table Datacom-id and check what the datacom-id should be per this report.

3.To correct,run DDUPDATE  

 -UPD TABLE,table enitity name(PROD,,PRIV)

3150 xxx nnn  

-END

 

with xxx being the table Datacom short name in 3 characters and nnn being the table datacom-id per that CXX report .