Currently Create Operation only Supports Stored Procedure

[MADHAVREDDY (MADHAVA REDDY PANDHIRI)]

Hi Team,

Version of IIQ IdentityIQ 8.4.

Login to SailPoint → Go to Home -->Click on Manage User Access
In the Add Access tab search for role with (JDBC) Application Name or Role Name and Select Role–>Click on Next and Submit.
getting the above screenshot error.

ERROR: INVALID CONFIG : GenericCreateJDBCRule : createAccount() Currently Create Operation only Supports Stored Procedure

Thanks
Madhav

[enistri_devo (Emanuele Nistri)]

Hi @MADHAVREDDY,

it means the application support only stored procedure for creation and in your prov rule you are tring to you use a normal INSERT

[Arun-Kumar]

Hi Madhavreddy,

Check the usePrepareCall entry in your application object from debug page. If it is true, it will allow the stored procedure.

[gaurav_khandelwal]

Hi @MADHAVREDDY ,

Set usePrepareCall as false in application from debug. This should fix the issue.

Thanks

[MADHAVREDDY (MADHAVA REDDY PANDHIRI)]

After configure the above “usePrepareCall” parameter in application from debug still getting the same error

[Arun-Kumar]

Could you please share the app.xml file to check the configuration?

[Arun-Kumar]

Did you select the “use stored procedure” check box in application configuration?

if it is checked, uncheck the selection and use the query.

Regards,
Arun

[ashutosh08 (Ashutosh Singh)]

Hi @MADHAVREDDY,

Is it possible for you to share your application xml after removing your sensitive information?

Thanks