Joe Clarke Thu, 08/13/2009 - 23:01

There could be a problem with your EPM database. Please post the pdshow output.

Joe Clarke Fri, 08/14/2009 - 08:50

The database is running, but there may be some corrupt tables causing the SQL queries to abort prematurely. Run the command:

NMSROOT/bin/perl NMSROOT/objects/db/conf/ action=validate dsn=dfmEpm


NMSROOT/bin/perl NMSROOT/objects/db/conf/ action=validate dsn=dfmInv

What results do you get?

jeeyishyuan Sat, 08/15/2009 - 20:27

Hi Joe,

Here's the outputs for the commands required above.

Error occurred when second command (dfmINV) is ran. Error report attached as crash report.rtf.

Please advise. Thanks!

Joe Clarke Sat, 08/15/2009 - 20:35

This is what I thought. We're currently tracking this issue internally with Sybase. You're not the only one seeing it. Until we isolate the problem, the only workaround is to reinitialize the dfmInv database or restore LMS from a known good backup. Therefore, it's a good idea to make sure you're taking frequent backups.

If you don't have a good backup, or you just want to blow away the dfmInv database, run:

NMSROOT/bin/perl NMSROOT/bin/ dsn=dfmInv dmprefix=INV

If you want to be notified when a fix is available, it would be a good idea to open a TAC service request so you can be tracked as an affected user.

jeeyishyuan Sat, 08/15/2009 - 20:45

Hi Joe,

Thanks for the prompt response!

I have two concerns based on your advise above.

1. If I restore the LMS from a good backup, will the problem occurred again in the future?

2. What is the impact for me to blow away the dfmInv database? Will dfm be able to continue monitoring the network?

Thanks & Regards,


Joe Clarke Sat, 08/15/2009 - 20:52

1. Yes, most likely. I just looked up the current status, and it appears the issue has been identified by Sybase. An upgrade to LMS 3.2 will fix the problem. You can download the LMS 3.2 eval (which will upgrade a licensed copy of 3.1) from .

2. You will lose all current DFM device data. Grouping and polling/threshold data will be retained.

jeeyishyuan Sat, 08/15/2009 - 20:57

Hi Joe,

If I opt to blow away the database, I believe I can always recover it using Auto allocation feature in DFM Device Discovery.

And I believe the problem will occur in the future?

Anonymous (not verified) Sat, 08/15/2009 - 21:02

Joe Clarke Sat, 08/15/2009 - 21:13

Yes, until you upgrade to LMS 3.2, it will most likely reoccur in the future.


This Discussion