We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.