Custom Analytic Reports not executing in real time - Requesting Assistance

[mkaushal]

Hi Team,

I hope you're all doing well. I wanted to seek your help regarding an integration issue we are facing between ServiceNow and Saviynt in our project.

Currently, we have set up an integration where end users submit role requests on ServiceNow. This triggers the execution of Saviynt's Custom Analytic Report APIs and Request creation OOTB APIs to create the request on Saviynt. However, during our integration testing, we have encountered some challenges that require your expertise.

The problem we are experiencing is intermittent timeouts when invoking the custom analytic report API from ServiceNow. Additionally, when we attempted to directly invoke the same custom analytic report API through Saviynt, we received an error message stating that Saviynt is currently operating at its highest capacity. As a result, the execution of the Analytic Report is delayed by approximately 246 minutes (~4 hours). We suspect that this capacity constraint is also causing the timeouts in our API invocations.

Given the dynamic nature of our system, where multiple invocations of the custom analytic APIs from ServiceNow are expected, it is crucial for us to address this issue promptly. We kindly request your assistance and guidance on how to overcome this challenge effectively.

Any suggestions or recommendations on increasing the threshold for executing the analytic reports without encountering these issues would be greatly appreciated.

Thank you in advance for your support.

Best regards, Kaushal

[RakeshMG]

It looks like you are executing multiple analytics report.

Please refer to following forum topic for more details : https://forums.saviynt.com/t5/identity-governance/analytics-results-limit/m-p/36907

https://forums.saviynt.com/t5/identity-governance/analytics-control-fails-to-run/m-p/39312#M22570

[rushikeshvartak]

NAME	CONFIGDATA
analyticsGRConfigJson	{     "maxQueryExecutionTime": "300",     "maxMemoryThreshold": "90",     "retryInterval": "30",     "maxRetryCount": "5",     "batchSize": "5000",     "maxRowThreshold": "100000",     "enableMaxRowThreshold": "1"

You need to change above JSON value

Please raise FD ticket to get the value updated for analyticsGRConfigJson from 100000 to 400000.

[aksharkay]

Hi,

Thank you for your response. Our issue is more related to the resource capacity than the number of rows in the analytics response. This error pops up intermittently even when the response size doesn't change. Please let us know if they are both interlinked.

[mkaushal]

This is the specific error message that we see on Saviynt. Also, none of our Custom analytic reports do not return more than 100000 rows. They return a max of 1000 rows. Is there any fix/workaround to below issue, as we expect SNOW to call a lot of our custom analytic reports through APIs in real time?

[rushikeshvartak · Accepted solution]

Restart server and try again