DDPAL10001 error returned redefining HUMAN-RESOURCE database
search cancel

DDPAL10001 error returned redefining HUMAN-RESOURCE database

book

Article ID: 5049

calendar_today

Updated On:

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.