Calling a StoredProcedure in PX Action Tab generates an error

book

Article ID: 5823

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

When we try to call Stored Procedure through a Policy Xpress (PX), Action Tab, an exception is generated.

Cause

As per Policy Xpress Action implementation, for selection or retrieving of any data value should be use Data Tab and to update and insert action for any attribute value should be use Action TabĀ 

Environment

Identity Manager 12.x

Resolution

If your Stored Procedure, even executing an INSERT or UPDATE into it, returns any value you must configure in Data Tab.