No SQL Strategy found for SQL statement: Execute CreateAccount when using a Generic Database AFX connector in RSA Identity Governance & Lifecycle
Originally Published: 2019-09-13
Last Modified: 2023-11-30
Article Number
Applies To
RSA Version/Condition: 7.0.x, 7.1.x
Issue
java.lang.IllegalArgumentException: No SQL Strategy found for SQL statement: Execute CreateAccount
'#[groovy:com.aveksa.AFX.server.runtime.esb.core.AfxPropertyMgr.getInstance().getPropertyValue(message, 'Account')]'
The Create an account command is defined as follows:
The SQL command being used is:
Execute CreateAccount '${Account}'
Cause
Resolution
In the above example change:
FROM
Execute CreateAccount '${Account}'
TO:
Call CreateAccount (${Account})
For more information, please see RSA Knowledge Base Article 000037943 -- How to call a stored procedure from the Generic Database AFX Connector in RSA Identity Governance & Lifecycle.
Related Articles
RSA Identity Governance and Lifecycle Data Collection Migration Guide 10Number of Views How to enable SQL Statement tracing in SQL Server? 35Number of Views Customer Preparations for Upcoming RSA Via Lifecycle and Governance 7.0.0 Release 3Number of Views RSA Identity Governance and Lifecycle - Linux RHEL Connector Datasheet 13Number of Views RSA Identity Governance and Lifecycle - Office365 Connector Datasheet 23Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?