Approval process issue with java code

Products

• CA Service Catalog

Issue/Introduction

Catalog's PAM process used for approvals is failing an error like this:

Failed to execute code:Process.grpName__ = Process.Select_Operator_1_2_1.QueryResults[Process.curLoopIndex__].sdGrpName;Process.curLoopIndex__++;-- msg.array.subscript.outofrange (#2)

 

Environment

Release : 17.1

Component : CA SERVICE CATALOG

Cause

There was some custom code to process the SQL results from the Select Operator, Select_Operator_1_2_1.

The query in question there was resulting 0 records, and so the operator was failing

Resolution

Try to execute the SQL Select that is being used in the select operator, directly against the database.  Fix the data or the query accordingly so that the resulting data is acceptable by rest of the PAM process.

Then retry the whole approval process.