Analytics V2 Creation Error - More than 100000 Records

[Sivagami]

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.

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

[jayasudha]

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]

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%'