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

Analytics V2 Creation Error - More than 100000 Records

Sivagami
Valued Contributor
Valued Contributor

Hi Team,

I have recently encountered in V5.5 SP3.12.7 that the analytics returning more than 100000 records are not allowed to be created / updated? Why is it so? This used to be allowed when we were in v5.5 SP 3.10

We have bigger applications like Workday having around 3L entitlements as Workday 2.0 connector combines the org role with organizations. How can we pull all these entitlements for audit purposes?

Below is the error encountered.

Sivagami_0-1667370686809.png

Of course, I can use limit in my queries to run in batches to get the 3L records but it's not an ideal solution.

1) Limit 0,100000

2) Limit 100000,100000

3) Limit 200000,100000

-Siva

 

2 REPLIES 2

jayasudha
Saviynt Employee
Saviynt Employee

Hi Siva,

The value "maxRowThreshold" in config table should be increased to avoid this error. This is a backend activity. You can raise a Freshdesk ticket to achieve the same.

Thanks,

Jayasudha R

rushikeshvartak
All-Star
All-Star

This limit is increased to 4M in latest version

https://saviynt.freshdesk.com/support/solutions/articles/43000673804-troubleshooting-guide-for-intel... 

Alternatively you can update below using custom query 

select * from configuration where name like '%MAX_ANALYTICS_RECORDS_ALLOWED_CONFIG%'

rushikeshvartak_0-1667419131448.png

 


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