DDPAL10001 error returned redefining HUMAN-RESOURCE database

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB

Issue/Introduction

A DDUPDATE job is executed in order to re-define HUMAN-RESOURCE sample database structure in CA DataDictionary, but it fails and returns the following error message:

     FUNCTION = ADD ALIAS
                   NAME       = HUMAN-AREA-A1

    **** ERROR ****  RETURN CODE = DDPAL10001  DUPLICATE ALIAS FOR ENTITY-TYPE
                                               DUPLICATE ALIAS, NAME= PEOPLE
                                                                    VERSION= 0001

while adding an ALIAS entry (HUMAN-AREA-A1) for PERSONNEL AREA

Environment

Release: 15.1
Component: DataDictionary

Cause

HUMAN-AREA-A1 was also the ALIAS for a very old AREA, named PEOPLE, that existed in the HUMAN-RESOURCE database before CA Datacom 9.0; this area should no longer exist in CA DataDictionary, and it is assumed that it has been already deleted by previous upgrade processes that recreated the sample database.

Resolution

First run a DDUPDATE or DDUTILTY with the following cards to have a list of all the versions of PEOPLE area:

-RPT INDEX,AREA,PEOPLE
-END               

Then delete the history version(s) of that area using these cards via DDUPDATE:

-DEL AREA,PEOPLE(nnn,psw,PRIV)
-END           

The above password is usually HR11.