No SQL Strategy found for SQL statement: Execute CreateAccount when using a Generic Database AFX connector in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2019-09-13
Article Number
000041645
Applies To
RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x, 7.1.x
 
 
Issue
When defining the Create an account AFX capability for a Generic Database connector, the command fails with:
  
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:

User-added image


The SQL command being used is:   
Execute CreateAccount '${Account}'


 
Cause
The Execute command is not recognized by the Generic Database AFX connector.
Resolution
The solution is to use the Call command. When using the Call command, replace the single quotes with parentheses.

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.
Don't see what you're looking for?