• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Tools to monitor LBI health

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Xin Li
Veteran Member Send Private Message
Posts: 133
Veteran Member
12/22/2009 2:43 PM

Anybody out there ever implement any tools to montior LBI health? We had some issues at one point scheduled reports did not run due to LBI failed to connect to backend SQL Server database. It would be nice to catch this kind of error before my users do.

 

Joel Hawthorne
Basic Member Send Private Message
Posts: 6
Basic Member
1/4/2010 2:59 AM
Since most of our scheduled jobs run overnight; we have a scheduled job that delivers a simple Employee Head count to my e-mail (and to our DBA) every night at midnight.

This way, I am at least sure that the db connection is working just before most of the nightly jobs kick off. If the e-mail is NOT received, then the job failed and we have a problem. This gives us enough warning to address the problem before scheduled jobs fail. This has saved me a ton of problems on a few occasions.

Hope this helps.
Kirk Compton
New Member Send Private Message
Posts: 2
New Member
1/4/2010 12:31 PM
We have developed some customer and specific alerts for Lawson systems from the LSF Core to LBI and Process Flow. They monitor sysems as well as processes. So all the processes running woudl be alerted on if something stopped. For example fi LADB stopped connecting to the database you would get an alert immediatley.

if this is something of interest you can email me at kcompton@reveregroup.com

Regards,
Kirk