DDPAL10001 DUPLICATE ALIAS FOR ENTITY-TYPE while redefining HUMAN-RESOURCE sample database

Document ID : KB000005049
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

A DDUPDATE 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= 0002
while adding an ALIAS entry (HUMAN-AREA-A1) for PERSONNEL AREA

Cause:

HUMAN-AREA-A1 was also the ALIAS for a very old AREA, which name was PEOPLE, that existed in HUMAN-RESOURCE database before CA Datacom 9.0; this area should no longer exist in CA Datadictionary as it is supposed 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:
-DEL AREA,PEOPLE(nnn,psw,PRIV)
-END
                  


The above password usually is HR11.