DB_LIMIT Hit limit of 300000 rows

richardsayle 6
Viewed 0

Does anyone have any idea how to resolve this?

I once found an article that suggested a change to registry keys, but it didn't specify which, I also can't locate that article at the second time of looking; can anyone shed any light?

Thanks Richard

limit database
1 Answers

Hi Richard -

This is a limit to keep a database from reading millions of rows from a database, filling memory, and then crashing.

Often when this message is seen, the report is not returning what someone is looking for (most folks won't want to look through 300,000 rows anyway).

If you do want more rows, change the registry value Limit_ReportRows. Depending on which product you're using it will be in one of the following subkeys:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PowerAdminServerMonitor

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PAStorageMonitor

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PAFileSight

You can make it as large as you want with the caveat that a report request might return enough data to crash the monitoring service.

Doug

Power Admin Support

Doug1126

Hi Doug

Thanks ver much for the response. I'll give that a whirl!

Richard

richardsayle•
Related