Follow

Error: Failed to generate the report because row count is too high

 

Summary

When submitting a report that will include data for more than 50,000 certificates, you see this error message:

rowcounterror.jpg

Resolution

The default maximum number of rows to include in a report is 50,000.  The mechanism to change this value changed in 17.1.

For 17.1 and Later:

This can be increased by adding a value for "Report Max Source Record Count" to the Reporting Object in on TPP server object in the Platforms tree.   This is not available in the normal UI, so it must be added via the Support tab.  This requires an edit key from Venafi Support.  When you get the edit key, you can then add the needed value and set it to a number that is appropriate for your environment.

Screen_Shot_2017-11-02_at_3.25.28_PM.png

The example above shows a value of 200,000.   Note that this is a per server setting, so you would need to make this change on all TPP servers that are going to generate reports that will have more than 50,000 elements included.

For 16.4 and earlier:

The report row maximum value can be set via a Registry Key (which will need to be set on all servers with reporting enabled).  The key is (showing a sample value of 131072):

[HKEY_LOCAL_MACHINE\SOFTWARE\Venafi\Platform\Reporting]
"Report Max Source Record Count"=dword:00020000

Restart the TPP service for the change to take effect.

2017-12-21_13_21_49-Dev_Server_-_VMware_Workstation.png 

 

Note: This attribute does not exist by default, and if not present, the default value (50000 rows) is used.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk