JDBC Provisioning issue Caught exception while provisioning: Please provide query to perform operation. createSQL is missing

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

Hi,

I am provisioning the JDBC connector and encountering the following error:

\“Caught exception while provisioning: Please provide query to perform operation. createSQL is missing.\”

I have implemented three queries in the provisioning rule:

  1. The first query retrieves the first name, last name, email, and employee ID.

  2. The second query retrieves the employee ID and role name, and find the role ID.

  3. The third query assigns the role to the user.

All of this logic is implemented in the provisioning rule. However, when I submit the request, I receive the error above.

The system is asking me to enable the setting below. Is this required when using a provisioning rule?

image
image1202×662 26 KB

2

Hi @Pkkumar ,

Usually if you have attached the rule to the source then no need to select provisioning query setting. Can you please check whether the the rule is attached to your source or not ?

3

Hi @Pkkumar,

Have you created and attached your provision rule properly to the source ?

4

Hi ,
Turn off those above connector features,
As you have mentioned you are doing it via rule, then ootb create account etc features should be turned off.

As you have not put any query in the “create account sql query” so it is bypassing the rule and trying to using blank query.

1 Like
5

We have attached the rule correctly and can I know what is name of the features should be turned off?

6

image
image991×252 42.3 KB
turn off these 2