Saviynt4Savint User import: maximum statement execution time exceeded

JustSalva
Regular Contributor
Regular Contributor

Hi all,

We implemented a complex automation using the saviynt4saviynt DB connector user import. and we are observing the following error: "Error in SQL query: Query execution was interrupted, maximum statement execution time exceeded"

This causes the import to fail, cause no data is then updated by the user import job (see screenshot below)

 

JustSalva_1-1668151005343.png

Is there a way to increment the maximum execution time or increase the resources allocated to the Saviynt4Saviynt Database user import job / to the internal database?

Kind regards,

Matteo

@FCaremoli @nfraternali

1 REPLY 1

rushikeshvartak
All-Star
All-Star

You need to increase timeout time of sql with help of saviynt support or check if any parameters can be passed in db url