Question & Answer
Question
Why do I get "RI check failed" when trying to remove some old Configurations I no longer have? I am using IBM CICS Configuration Manager for z/OS (CICS CM) V5.2 and have several Configuration items for which I have removed the region and the CCM CSD. But, I cannot remove the Configuration item. I tried in option..
1, Administer
2 CICS Configurations
...when I select 4, for delete, I get ISPF short message string in the upper right corner of the screen with text:
RI check failed
Answer
The "RI Check Failed" short message on ISPF 'CICS Configurations' panelid CCVPACIL allows you to press PF1 for more detail which should display the following text:
"A referential integrity check failed for this request. Either one of the parameters in the command request references an object that does not exist, or the command request would delete a definition which is required by related definitions. Press F1 (Help) to learn more about this condition."
The actual message id is CCV9041E and is described in the CICS CM documentation.
If you press PF1 again, it will display panelid CCVHRIER for "Repository RI (referential integrity) checks - Help".
If you scroll through the help it discusses the delete action for a configuration and the various references a configuration can have to Migration Schemes, Change Packages ...
In order to maintain integrity, if a CICS configuration is referenced in a Migration Scheme path, Change Package ..., you need to either remove those resources prior to the CICS configuration, or modify them to point to a different configuration. Once you remove any references to this CICS configuration from other definitions, you should be able to successfully delete it.
I can reproduce the same message be defining a Migration Scheme that refers to a configuration and then attempting to delete that configuration. If I modify the Migration Scheme to remove the reference to the configuration, or just delete the Migration Scheme, I can go back and successfully remove the configuration.
IBM Request-For-Enhancement (RFE) 82534 has been submitted to identify what resources are prohibiting the delete of the configuration. If you would like to increase the chances of this enhancement request being completed, click on RFE 82534 then signon using your IBMid, scroll to the bottom of the page, and click on "vote" to vote for it.
Additionally, IBM Request-For-Enhancement (RFE) 98714 has been submitted to request a 'FORCE' option when deleting resources to force the deletion of the resource flagged with the referential integrity error. If you would like to increase the chances of this enhancement request being completed, click on RFE 98714 then signon using your IBMid, scroll to the bottom of the page, and click on "vote" to vote for it.
Here's a copy of the help text from CICS CM V5.3 with more details.
CCVHRIER Repository RI (referential integrity) checks - Help
More: +
Some CICS Configuration Manager definitions contain references to other
definitions. For example a Migration Scheme path's source and target
fields reference the names of CICS Configuration definitions, or a Change
Package may reference an Approve Profile.
When creating or updating definitions, CICS Configuration Manager checks
to ensure the related definitions exist, otherwise an error like
'Definition not found' occurs. In these cases, create the required
definition first.
When deleting a definition, CICS Configuration Manager performs
referential integrity (RI) checks to ensure that the deletion will not
invalidate other definitions that reference the record requested for
deletion. If the checks fail, an error like 'RI check failed' occurs. In
these cases, remove any references to the definition intended for deletion
first. Consider the following chart:
Delete definition type Related definitions triggering RI errors
----------------------- ---------------------------------------
Approval profile Change package
via the approval profile field. You can:
(1) Change the package record's
approval profile value; or
(2) Delete the change package
definition if appropriate.
CICS Configuration Migration Scheme
via a path's source/target fields. You can:
(1) Change the Configuration value
referenced in the Migration Scheme
path;
(2) Remove the paths referencing the
definition; or
(3) Delete the Migration Scheme
definition if appropriate.
Migration Scheme Change package
via PSCHEME records created when processing
the package for the Migration Scheme by
READY, APPROVE, MIGRATE, etc. You can:
(1) Delete the Change Package
definition if appropriate. This
will delete the PSCHEME records
related to the change package.
Transform Rule Set Migration Scheme
via a path's Transform Rule field. You can:
(1) Change the Transform Rule Set
named in the Migration Scheme path;
(2) Delete the Migration Scheme path; or
(3) Delete the Migration Scheme
definition if appropriate.
Transform Group
via the Transform Rule field. You can:
(1) Change the Transform Rule
named in the Transform Group; or
(2) Delete the Transform Group definition
if appropriate.
Transform Group Migration Scheme
via a path's Transform Rule field. You can:
(1) Change the Transform Group named in the
Migration Scheme path;
(2) Delete the Migration Scheme path; or
(3) Delete the Migration Scheme
definition if appropriate.
Product Synonym
CICSCM CICS CM
Was this topic helpful?
Document Information
Modified date:
06 January 2017
UID
dwa1250396