OBSOLETE of a database structure gets DDPPWR0001 PASSWORD REQUIRED error message even if a password has been provided

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

DDUPDATE utility is executed to delete all the versions of HUMAN-RESOURCE sample database via OBSOLETE function:

+DEL DATABASE,HUMAN-RESOURCE(PROD,DD,PRIV)
1000 OBSOLETE
+END 

but it fails due to:

CODE ENTITY-TYPE,OCCURRENCE(VERS,PSWD,OVRD),STATUS,LOCK
-DEL DATABASE,HUMAN-RESOURCE(PROD,DD,PRIV)
TRANSACTION ERROR: DDPPWR0001 PASSWORD REQUIRED


even if the password is actually provided in the -DEL header transaction

Cause:

An old version of the occurrence has a different password, as shown by an Index report:

DATABASE HUMAN-RESOURCE 0002 H 0 HR11
DATABASE HUMAN-RESOURCE 0003 H 0 DD
DATABASE HUMAN-RESOURCE 0004 P 0 DD
DATABASE HUMAN-RESOURCE T001 T 0 DD

Resolution:

Version 002 must be deleted first, as it has a different password (HR11 instead of DD):

+DEL DATABASE,HUMAN-RESOURCE(0002,HR11,PRIV)
+END

then the other versions can be deleted all together using the OBSOLETE function:

+DEL DATABASE,HUMAN-RESOURCE(PROD,DD,PRIV)
1000 OBSOLETE
+END

Additional Information:

Technical document TEC1999261 shows how to run a CA Datadictionary report to display the passwords for any occurrence.