Z: Rewrite required - Does RSA Identity Governance and Lifecycle AFX Database Connectors support Stored Procedure Output parameters?
Originally Published: 2017-06-28
Article Number
Applies To
RSA Version/Condition: All
Issue
Some customers use Stored Procedures to perform “Add User”, “Update user”, “Enabled User” and others action to manage users/accounts via AFX Database Connector Capability's Command Code.
AFX DB Connector is not able to execute Stored Procedures with Output parameters.
AFX DB Connector is not able to capture the Store Procedure return error code and return error message.
For example:
“Add User” Stored Procedure inserts a record into the SQL table by using input parameters from Stored Procedure.
Once the stored procedure execution is completed, the Stored Procedure will return error code and error message back to stored procedure output parameters.
Once the stored procedure execution is completed, the Stored Procedure will return error code and error message back to stored procedure output parameters.
Stored Procedure syntax: sp_IAM_USERS(<ACTION>,<EmployeeID>,<Username>,<@APP_CODE>,<@ERROR_CODE>,<@ERROR_MESSAGE>)
Input parameters: <Action>,<EmployeeID>, <Username>
Output parameters: @ERROR_CODE,@ERROR_MESSAGE,@APP_CODE
Output parameters: @ERROR_CODE,@ERROR_MESSAGE,@APP_CODE
Call the DB2 stored procedure with parameters:
call sp_IAM_USERS(“USERADD”,”01091001”,”jataya”,@APP_CODE,@ERROR_CODE,@ERROR_MESSAGE)
If the employeeID “01091001” already exists in the SQL table, then calling sp_IAM_USERS will return result:
@APP_CODE=”APP1”
@ERROR_CODE=”1”
@ERROR_MESSAGE=”Account already exists.”
@ERROR_CODE=”1”
@ERROR_MESSAGE=”Account already exists.”
Resolution
The workaround (as documented on page 36 of MySQL Application Guide) is to create AFX output parameter which will be used to store the value returned by the Stored Procedure.
https://community.rsa.com/docs/DOC-62493
However, this appears to be only possible for capabilities that has "Output" parameters e.g. "Create An Account" capability.
A Request For Enhancement (ACM-75945) has been raised to accommodate this request.
Related Articles
What is the procedure for backing up and restoring the FIM database in clustered mode Number of Views Generic REST AFX Connector does not encrypt Additional Parameters when defined as Encrypted in RSA Identity Governance & L… Number of Views Procedure to upgrade Java in Envision Number of Views How to call a stored procedure from the Generic Database AFX Connector in RSA Identity Governance & Lifecycle Number of Views DBSM: Error when configuring Oracle adapter: ORA-28575: unable to open RPC connection to external procedure agent Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
