CA Chorus Software Manager fails to generate Flat File during Apply due to missing FMIDs

Products

• CHORUS SOFTWARE MANAGER

Issue/Introduction

Using CA Chorus Software Manager (CSM) to create a Flat File during the Apply of maintenance fails due to missing FMIDs for CA JCLCheck Workload Automation.

Environment

Release : 6.0

Component : Chorus Software Manager

Cause

There was a licensing name change for the customer concerning the CA JCLCheck Workload Automation product.  For some unknown reason the CSM repository contained an invalid entry for the 'old' CA CA JCLCheck product name that did not contain any FMID definitions, but was being referenced during the Apply process, and causing the error condition.

Resolution

After running the following CSMRPSQL job (located in CSM's runtime JCL library) with the following SYSIN statements, review of the output determined the erroneous PRODUCTID to be deleted by the subsequent run of the same job but with new SYSIN control statements.  Once the delete was performed and the CSM Tomcat was recycled the problem was resolved.

The following CSMRPSQL job provided information of the products and versions associated with the siteID 

//SYSIN   DD *                                                        
 SELECT * FROM PRODUCT;                                               
 SELECT * FROM RELEASE; 
 SELECT * FROM GENLEVEL;                                               
 SELECT * FROM  SITEPRODUCT INNER JOIN PRODUCT ON                     
   PRODUCT.PRODUCTID=SITEPRODUCT.PRODUCTID WHERE SITEID='123456';     
/*    

It was determined PRODUCTID 121 was erroneous.  Subsequent run of the CSMRPSQL job with the following SYSIN statements deleted the erroneous PRODUCTID from the repository.

//SYSIN DD *

 DELETE FROM PRODUCT WHERE PRODUCTID=121;

/*