NPM ocasionally stops updating the database

I'm having a problem where NPM appears to stop updating the database and by extension the data displayed on the web page. This results in our monitoring technician looking at data that is not accurate.

We're running Orion 8.5 SLX on Win 2003 SP2 our database is SQL Express 2005. Current monitoring load is 2362 total elements, my polling completion is always at least 99.3%

Anyone have an idea what could be causing my database not to update/sync?

On a related note, does anyone know if it is possible to create an alert that will trigger if the Last Database Update exceeds a predetermined value?

TIA

Find more posts tagged with

database_error

8.5.1

Database

orion_website_error

Accepted answers

All comments

aynov

I had a similar issue with the Custom MIB Poller. I have to restart the Custom MIB Poller service to fix the issue. After talking to tech support, it is very possible that my configuration (SQL Server is on the same server) could be causing the issue.

I have a scheduled task to restart the service once a day. It only take a few seconds and is a simple batch file.

tpelley

I had a similar issue with the Custom MIB Poller. I have to restart the Custom MIB Poller service to fix the issue. After talking to tech support, it is very possible that my configuration (SQL Server is on the same server) could be causing the issue.
I have a scheduled task to restart the service once a day. It only take a few seconds and is a simple batch file.
Bo

I suspected the problem might be with the SQL Server. Ours is also on the same box. We are in the process of migrating to an enterprise version of SQL perhaps moving the Orion Database to it will solve the problem.

Which service are you restarting? I tried a daily restart of the NetPerfMon Service a while back to no avail. Perhaps reloading the SQL server daily will ease the problem.

toph

How big is your database? SQL 2005 Express has a limit of 4GB. If your database is close to or bigger that is probably your problem.

Chris

tpelley

How big is your database? SQL 2005 Express has a limit of 4GB. If your database is close to or bigger that is probably your problem.

Chris

My Database comes in at about 2.5GB. I don't keep data for very long due to the 4GB limit. We are in the process of purchasing MSSQL for our Enterprise, a very expensive venture that is going to take some time. Until then, I am stuck with the express edition.

While I'm on the subject of databases, does anyone know if Orion can be configured to write to MySQL?

justinh

My Custom MIB Poller does the same thing and we have our SQL on a separate server. I'm curious what the batch file looks like that restarts the service.

aynov

Ask and ye shall receive:

net stop solarwindscustompollingservice
net start solarwindscustompollingservice

And then I just used Windows Task Scheduler to schedule the task to run once a day.

SP3 could fix this issue, which looks to be in the release notes. I am just too paranoid to verify it. And this does not hurt anything.