Unable to update product list / PAS Exception thrown within BaseProdListCMD String index out of range: 0
Article ID: 218772
Updated On:
Products
Issue/Introduction
Environment
Release : 6.0
Component : Chorus Software Manager
Cause
The following non mainframe products were added to supportservices.ca.com for some site ids?
This is the list that is causing this java.lang.StringIndexOutOfBoundsException: String index out of range: 0 :
<product type="Entitled" code="APMAGT990" name="CA Application Performance Mgmt Agent - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMJNA990" name="CA Application Performance Mgmt Java and .NET Agent - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMNGM002" name="CA Wily Application Performance Mgmt - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMNGM564" name="CA Wily Application Performance Mgmt - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMNGM990" name="CA Application Performance Mgmt - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMNJA990" name="CA Application Performance Mgmt Node. JS Agent - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMPHP990" name="CA Application Performance Mgmt PHP Agent - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="APMZAP002" name="CA Wily Application Performance Mgmt for zAAP - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="CEMAGT990" name="CA Introscope to CA Application Performance Management Upgrade Distributed Agent - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="CEMJNP990" name="CA Introscope to CA Application Performance Management Upgrade Java and .NET Processor - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="CEMUGD002" name="CA Introscope to CA Application Performance Management Upgrade Mainframe - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="CNMNFA990" name="CA Network Flow Analysis for UIM - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="CNMNFP990" name="CA Network Flow Analysis for UIM - Partner - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="DXIAPM990" name="DX Application Performance Management - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="ITRCPM002" name="CA Wily Introscope - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="ITRCPM564" name="CA Wily Introscope - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="ITRCPM990" name="CA Wily Introscope - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="ITRZAA002" name="CA Wily Introscope for zAAP - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="MSPNFA990" name="CA Network Flow Analysis MSP - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="MSPNFU990" name="CA Network Flow Analysis for UIM MSP - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="NCCRUL990" name="Clarity Creator User License - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="PPMFFS990" name="Clarity Full Function User On Premise Subscription - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="PPMRUS990" name="Clarity Restricted User On Premise Subscription - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RA50DS990" name="CA Network Flow Analysis 50 Devices Software Only N/A - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RACNSL990" name="CA Network Flow Analysis Console - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RADHAS990" name="CA NetQoS ReporterAnalyzer Super Data Storage Appliance High Availability - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RADSAS990" name="CA NetQoS ReporterAnalyzer Data Storage Appliance - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RAIBLS990" name="CA Network Flow Analysis Interface Bundle - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RASHAS990" name="CA Network Flow Analysis Super Harvester High Availability - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RASHVS990" name="CA Network Flow Analysis Super Harvester - MULTI-PLATFORM" site="105772"/>
<product type="Entitled" code="RPTANL990" name="CA Network Flow Analysis - MULTI-PLATFORM" site="105772"/>
Resolution
This DBSQLPR JCL below adds these non mainframe products to your CSM as hidden so that CSM will ignore them.
These will be available under "show hidden products". Do not restore these products by selecting them then clicking '"show products".
They can be deleted later if necessary.
The productid start at 7000 because no one should have 7000 products in CSM. To be sure you could run this DBSQLPR with input:
//SYSIN DD *
SELECT * FROM PRODUCT;
/*
Scroll to the end of the output to to get the current maximum productid, in this example the maximum productid is 800:
800 Automic Automation Intelligence Integration for non-Broadcom.
It is not necessary to recycle MSMTC. Click on 'Update Complete Product List' from the products tab and it should be successful.
<...+....1....+....2....+....3....+....4....+....5....+....6....+....7..
================================ T O P =================================
//STEP05A EXEC PGM=DBSQLPR,
// PARM='PRTWIDTH=1500,INPUTWIDTH=72,ROWLIMIT=7000'
//* The STEPLIB below should be the same as the MSMMUFS startup
//* The CXX below should have the same HLQ as the PXX in the
//* MSMMUFS startup except that the DDNAME is CXX and that last
//* qualifier is also CXX in this JCL.
//*
//*
//STEPLIB DD DSN=hlq.CSM.RT.CUSLIB,
// DISP=SHR
// DD DSN=hlq.CSM.RT.CAAXLOAD,
// DISP=SHR
//CXX DD DSN=hlq.CSM.RT.DB.RBBCSMX.CXX,
// DISP=SHR
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//STDERR DD SYSOUT=*
//STDOUT DD SYSOUT=*
//OPTIONS DD *
AUTHID=CASWMGT
/*
//SYSIN DD *
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7000,
'CA Wily Application Performance Mgmt for zAAP - MULTI-PLATFORM',
'APMZAP002',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7001,
'CA Application Performance Mgmt Agent - MULTI-PLATFORM',
'APMAGT990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7002,
'CA Application Performance Mgmt Java and .NET Agent - MULTI-PLATFORM',
'APMJNA990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7003,
'CA Wily Application Performance Mgmt - MULTI-PLATFORM',
'APMNGM002',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7004,
'CA Wily Application Performance Mgmt - MULTI-PLATFORM',
'APMNGM564',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7005,
'CA Application Performance Mgmt - MULTI-PLATFORM',
'APMNGM990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7006,
'CA Application Performance Mgmt Node. JS Agent - MULTI-PLATFORM',
'APMNJA990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7007,
'CA Application Performance Mgmt PHP Agent - MULTI-PLATFORM',
'APMPHP990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7008,
'CA Introscope to CA Application Performance Management Upgrade Distrib
uted Agent - MULTI-PLATFORM',
'CEMAGT990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7009,
'CA Introscope to CA Application Performance Management Upgrade Java an
d .NET Processor - MULTI-PLATFORM',
'CEMJNP990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7010,
'CA Introscope to CA Application Performance Management Upgrade Mainfra
me - MULTI-PLATFORM',
'CEMUGD002',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7011,
'CA Network Flow Analysis for UIM - MULTI-PLATFORM',
'CNMNFA990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7012,
'CA Network Flow Analysis for UIM - Partner - MULTI-PLATFORM',
'CNMNFP990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7013,
'DX Application Performance Management - MULTI-PLATFORM',
'DXIAPM990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7014,
'CA Wily Introscope - MULTI-PLATFORM',
'ITRCPM002',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7015,
'CA Wily Introscope - MULTI-PLATFORM',
'ITRCPM564',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7016,
'CA Wily Introscope - MULTI-PLATFORM',
'ITRCPM990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7017,
'CA Wily Introscope for zAAP - MULTI-PLATFORM',
'ITRZAA002',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7018,
'CA Network Flow Analysis MSP - MULTI-PLATFORM',
'MSPNFA990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7019,
'CA Network Flow Analysis for UIM MSP - MULTI-PLATFORM',
'MSPNFU990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7020,
'Clarity Creator User License - MULTI-PLATFORM',
'NCCRUL990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7021,
'Clarity Full Function User On Premise Subscription - MULTI-PLATFORM',
'PPMFFS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7022,
'Clarity Restricted User On Premise Subscription - MULTI-PLATFORM',
'PPMRUS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7023,
'CA Network Flow Analysis 50 Devices Software Only N/A - MULTI-PLATFORM
',
'RA50DS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7024,
'CA Network Flow Analysis Console - MULTI-PLATFORM',
'RACNSL990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7025,
'CA NetQoS ReporterAnalyzer Super Data Storage Appliance High Availabil
ity - MULTI-PLATFORM',
'RADHAS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7026,
'CA NetQoS ReporterAnalyzer Data Storage Appliance - MULTI-PLATFORM',
'RADSAS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7027,
'CA Network Flow Analysis Interface Bundle - MULTI-PLATFORM',
'RAIBLS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7028,
'CA Network Flow Analysis Super Harvester High Availability - MULTI-PLA
TFORM',
'RASHAS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7029,
'CA Network Flow Analysis Super Harvester - MULTI-PLATFORM',
'RASHVS990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
INSERT INTO PRODUCT ( PRODUCTID,
NAME,
DESCRIPTION,
HIDDEN,
VENDORID,
TCREATED,
DOCCODE )
VALUES (7030,
'CA Network Flow Analysis - MULTI-PLATFORM',
'RPTANL990',
1,
2,
'2020-03-04-15.32.41.450000',
'0000');
/*
Feedback
