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.
Release : 6.0
Component : Chorus Software Manager
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.
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
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;