000037945 - No SQL Strategy found for SQL statement: Execute CreateAccount when using a Generic Database AFX connector in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Sep 13, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037945
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x, 7.1.x
IssueWhen 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}'

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

In the above example change:

Execute CreateAccount '${Account}'


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.