ORA-20088: Agent APPWORX_AGENTS is not valid for this module

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Running an ad-hoc Request on a Process Flow, accepting the default Agent value of APPWORX_AGENTS and submitting, results in the error:

ErrorMsg: AwE-5001 Database Query Error
Details: ORA-20088: Agent APPWORX_AGENTS is not valid for this module.
ORA-06512: at "APPWORX.AWAPI2", line 4422
ORA-06512: at "APPWORX.AWAPI2", line 488
ORA-06512: at "APPWORX.AWAPI2", line 3611
ORA-06512: at "APPWORX.AWAPI2", line 4094
ORA-06512: at "APPWORX.AWOP_API", line 732
ORA-06512: at "APPWORX.AW_WEB_API2", line 36
ORA-06512: at line 1

Note that while other ORA-20088 type errors exist, this article is specific to the error agent value 'APPWORX_AGENTS' as well as the behavior described above and below. 

Additional observed behaviors include the following:

1. Scheduling the same Process Flow works as expected
2. Editing the Process Flow, the Agent is set to No Selection. Changing No Selection to any value and saving, and then back to No Selection and save, running an ad-hoc request on the Process Flow works as expected. 

Cause

The Process Flow's Agent value is have likely been incorrectly updated from the database end using sql client

Resolution

Run the below sql from any sql client to find if there are Process Flows that were updated to an invalid value:

select so_module from so_job_table where so_oper_seq=0;

If not rows are returned, contact Broadcom Support. If 1 or more rows are returned, run the below sql to set erroneous Process Flow Agent value back to the default 'No Selection' value:

update so_job_table set so_oper_seq = NULL where so_oper_seq=0;