"An internal database limit has been hit which might affect monitoring or reports"

I got an email with the below text. Is there something I can do to clean up the database in some way?

Best, Rune

"An internal database limit has been hit which might affect monitoring or reports. This limit can be increased by changing the Limit_Default setting. You can look in that same file for DB_LIMIT for additional hints.

100000 or more rows were going to be returned from:
begin;
SELECT Date, CASE WHEN Value <= 5000 THEN 100 ELSE 0 END as Value
FROM StatData
WHERE St

Sent from PA Server Monitor on VS249931 (62.138.22.75) - 07 Apr 00:01
Ver 9.6.0 (Build 206)
System Alert Rule: Error: Internal error detected in monitoring service

This System Alert's delivery can be configured in Settings > System Alerts"

error limit database

asked 07 Apr, 02:34

run66
130●3●7●13
accept rate: 12%

One Answer:

oldest newest most voted

0	Hi - We recently found the cause of that message - the wrong database limit was being applied. The fix is in 9.6.0.255 and newer, which is currently the Preview build. link answered 08 Apr, 15:07 Doug ♦♦ 10.3k●12●21●38 accept rate: 20%

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Tags:

error ×39
database ×24
limit ×2

Asked: 07 Apr, 02:34

Seen: 38 times

Last updated: 08 Apr, 15:07

"An internal database limit has been hit which might affect monitoring or reports"

Follow this question

Useful Links

Product Downloads

Related questions