IBM Support

RI Check Failed when removing CICS Configuration from CICS CM

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.              
                                     
 


[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2L7A","label":"CICS Configuration Manager for z\/OS"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"","Version":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Product Synonym

CICSCM CICS CM

Document Information

Modified date:
06 January 2017

UID

dwa1250396