LMS 4.2.4 - Unable to create notification group

[Boon Keat Gan]

Hi,

I am trying to create the Fault Notification Group. However, I click on the add it show the following message.

There are no devices in the system (in Known state).

This may be because devices have not been added to DFM, because DFM is in the process of learning about added devices, or because all devices were selected for deletion.  Check the Discovery Status page for more information.

Discovery Summary

Discovery Status:	Completed
Discovery Type:	Custom
Discovery Start Time:	Thu Dec 12 10:33:18 SGT 2013
Discovery End Time:	Thu Dec 12 14:18:23 SGT 2013
Total Devices Discovered:	95
Reachable Devices:	50
Unreachable Devices:	45
Devices Newly Added to DCR:	0
Devices Updated to DCR:	50

I am pretty sure that my discovery has added 50 devices and it is on managed mode.

How to do a further checking on this?

Appreaciate if anyone can guide me. Thank you!

[AFROJ AHMAD]

Hi Boon,

Go to

Admin > Collection Settings > Fault > Fault Monitoring Device Administration

check if you have devices there  under ALL KNOWN DEVICES under inventory ?

IF above is not the case,share the screen shot of

Admin > Getting Started >Device management.

Thanks-

Afroz

[Boon Keat Gan]

Hi Afroz,

Yes. I can see the device in All Known Devices. Is it a cisco bug?

[AFROJ AHMAD]

Hi,

Follow the procedure with the database directly and execute SQL commands.

NOTE: please be careful while you run the below commands.

To get the database page please use the URL :

http://LMSServerIP:1741/dbreader/dbreader.html
OR
https://LMSServerIP:443/dbreader/dbreader.html

Their use the following procedure : Username: cmfDBA password: xxxxxxxxx database: cmf 
===========
to reset the database password ,if you don't remember it , you can reset it with the
below command:

NMSROOT/CSCOpx/bin>perl dbpasswd.pl all

===========
 Execute following commands (one by one and click on Execute SQL Statement)  drop table dfmogsgrouppropertiestable  drop table dfmogsgroupcachetable  drop table dfmogstagtable  drop table dfmusergroupassociationtable  delete from dbversion where component='DFM'  After you drop the above table's restart daemon manager using the following command from the server CMD. Net stop crmdmgtd && net start crmdmgtd 

Thanks-

Afroz

[Do rate the useful post]

[Boon Keat Gan]

Hi Afroz,

After perform the password reset. What is the default password for the database?

[AFROJ AHMAD]

default password is

C2kY2k

[Boon Keat Gan]

Did the given steps and still having the same issue.

The log from the command you provided.

SQL Statement:

drop table dfmogsgrouppropertiestable

--------------------------------------------------------------------------------

Statement Executed Successfully; Rows affected: 0

SQL Statement:

drop table dfmogsgroupcachetable 

--------------------------------------------------------------------------------

Statement Executed Successfully; Rows affected: 0

SQL Statement:

drop table dfmogstagtable 

--------------------------------------------------------------------------------

Statement Executed Successfully; Rows affected: 0

SQL Statement:

drop table dfmusergroupassociationtable 

--------------------------------------------------------------------------------

Statement Executed Successfully; Rows affected: 0

SQL Statement:

delete from dbversion where component='DFM'

--------------------------------------------------------------------------------

Statement Executed Successfully; Rows affected: 1

[AFROJ AHMAD · Accepted solution]

Try to Reboot the server and check the issue again.

[Boon Keat Gan]

Hi Afroz,

It is working fine after a reboot. Thank you so much for the help!!

Do you have any best practice guide that I can refer to?

We migrating from LMS 2.6 to new LMS 4.2.4 and I believe there is alots of setting that I not set properly.