CiscoPrime LMS 4.2.3 How to delete existing 24 hr Daily Syslog Report

[dlouie]

We are using Cisco Prime LMS v4.2.3.  We have had a 24 hr. Daily syslog report running for the longest time.  The staff person that previously setup the job to run has left the company and his account has been deleted. Since his account has been deleted we have started to getting the following error:

CW2000LMS01 - Cisco Prime LMS

Job Summary
Status:	Failed
Instance ID:	16
Log File:	C:/PROGRA~2/CSCOpx/files\rme\jobs\syslog\31025_16.log
Job ID:	31025
Description:	Daily Syslog Summary - LMS / RME
RME Server Name:	CP-LMS-Temp.CDE.cal
Authorization Failure:	Either the owner of this job does not exist, or the owner does not have the permissions to run this job.

The reson for the error is obvious and I have been able to recreate this report under the a current staff member and it works fine......

My question is how to delete the old reoccurring job(s) created by the staff person that has left....

Under the Reports Tab> Fault and Event> Syslog> 24 Hour Syslog Report, I can create/schedule the report, but I do not see where the old report(s) can be deleted.

Can some one point out where the old reports and future scheduled jobs can be deleted please....

I appreciated your time and efforts!

Douglas 

[AFROJ AHMAD]

Hi,

if it is a windows server ::

1. Make note of the job ID's that you want to delete.
2. Open a dos shell and go to C:\Progra~1\CSCOpx\bin
3. Issue the command:
cwjava -cw NMSROOT com.cisco.nm.cmf.jrm.jobcli
3. It will take you to the Job CLI mode
4. Issue the command:
delete 31025 (the job ID you cannot delete).
5. Close all CiscoWorks browsers and issue the commands:
net stop crmdmgtd
net start crmdmgtd
6. Wait 15 minutes and log back in to CiscoWorks

**********************************************************************

If above does not work , then you can do it from database::

To login to DBreader
http://hostname:1741/dbreader/dbreader.html

or

https://hostname:443/dbreader/dbreader.html

 Enter the following Default credentials
User Id = cmfDBA
Password = c2kY2k  ( this is the deafault password , use your own DB passworsd)
Database Name = cmf

Press get Database Tables button

4. Look for Table JRM and verify if
JobId 31025  exists

5. If yes, press the back button of the browser
until you get back to adhoc page

6. Re enter the credentials in step 3 plus the
SQL statement to execute

delete from JRM where id = 31025

Press Execute SQL Statement Button

7. Navigate back to Job Management and see if problem still persists

Thanks-

Afroz

***Ratings Encourages Contributors ***

[dlouie]

Happy Holidays Afroz!!

Yes, this is a Windows Enterprise Server 2008R2. 

In trying your 1st suggestion, I received the following error:

C:\Program Files (x86)\CSCOpx\bin>cwjava -cw NMSROOT com.cisco.nm.cmf.jrm.jobcli

Unable to launch JVM

C:\Program Files (x86)\CSCOpx\bin>

In trying your 2nd suggestion, I got to the Ad-Hoc retrieval of Database just fine....but unfortunately upon logging in I received the following error:

*** Error ***
Could not connect to database: Invalid user ID or password (DBD: login failed)

I will need to locate the DB password as it does not seem to be the default password setting, and try it again.

Thanks for your assistance and response!!!   it is greatly appreciated!!!

Douglas

[AFROJ AHMAD]

Hi Douglas,

Happy Holidays...

C:\Program Files (x86)\CSCOpx\bin>cwjava -cw NMSROOT com.cisco.nm.cmf.jrm.jobcli

Unable to launch JVM

Change the NMSROOT in the above command to the location where LMS is installed

for e.g:::    C:/Progra~1/CSCOpx

you can reset the DB password as well::

NMSOOT\CSCOpx\bin > perl dbpasswd.pl all

Thanks-

Afroz

***Ratings Encourages Contributors**

Do rate the useful post***

[dlouie]

Happy New Year Afroz!

I tried both methods without success (please see attachment).

1st method I received a "Unable to launch JVM" message, even though Java is in the Program/Common files directories.

2nd method I received an invalid user id. or password error.  is there a way to change the cmfDBA password?  (I did not set/change the password and the previous person has left).

Thanks!!

Douglas  

[AFROJ AHMAD]

Hi Douglas,

I already shared the method of resetting the password, sharing it again

solaris/linux::

/opt/CSCOpx/bin/dbpasswd.pl all

windows:

NMSROOT\bin\perl.exe NMSROOT\bin\dbpasswd.pl all

***Do rate the useful post***

Thanks-

Afroz

***Ratings Encourages Contributors**

[dlouie]

Hello Afroz,

After resetting the DBA password, logging in to the database using the DBreader method worked our just perfect!!  Thanks for your time and patience!!

Douglas Louie