ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 5049

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services Datacom/AD CA ecoMeter Server Component FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA On Demand Portal CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET 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.