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

book

Article ID: 5049

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

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.

Environment

Release: DBCISF00200-15.1-Datacom-Database-Option for CICS Services
Component:

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.