Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Blue

"failed to get the necessary information for one or more jobs"

How do I go about fixing whatever that's causing "failed to get the necessary information" in RME 3.5 -> Admin -> Approve or reject jobs?

1 ACCEPTED SOLUTION

Accepted Solutions
Red

Re: "failed to get the necessary information for one or more job

This is due to issues with your jobs in the jrm

The fix requires access to dbreader for both cmf and rme. If you know your cmf and rme database paswords, then you may do the following.

Log in to the cmf database and go to the JRM table.

Make a note of all the jobs listed in ther.

Next, issue the following SQL statement with the rme database credentials:

Delete MakerCheckerInfo where JobID not in ()

So, let's say the job list you found in the JRM table was: 1024, 1235, 1457

The SQL command you would excute with RME dbreader credentials would be:

Delete MakerCheckerInfo where JobID not in (1024, 1235, 1457)

Once that is done, stop / start the daemon manager

13 REPLIES
Red

Re: "failed to get the necessary information for one or more job

This is due to issues with your jobs in the jrm

The fix requires access to dbreader for both cmf and rme. If you know your cmf and rme database paswords, then you may do the following.

Log in to the cmf database and go to the JRM table.

Make a note of all the jobs listed in ther.

Next, issue the following SQL statement with the rme database credentials:

Delete MakerCheckerInfo where JobID not in ()

So, let's say the job list you found in the JRM table was: 1024, 1235, 1457

The SQL command you would excute with RME dbreader credentials would be:

Delete MakerCheckerInfo where JobID not in (1024, 1235, 1457)

Once that is done, stop / start the daemon manager

Blue

Re: "failed to get the necessary information for one or more job

Thanks. Is JRM the exact table name? I'm pretty sure I have the same password for both rme and cmf. However, it's not working when fetcing cmf db tables (db name: cmf???). Is /opt/CSCOpx/bin/resetpassword the script that resets database passwords?

Secondly, when running Syslog Severity Summery Report, it returns "No records found. Recommended Action: Please check whether logging has been enabled on selected device(s)". It'd been fine up until this morning. This happens regardless of which devices get selected. Syslog Collector Status looks fine. I wonder if the Syslog report issue may be related to the Job Approval/Reject issue. Is there a general db issue here?

Blue

Re: "failed to get the necessary information for one or more job

Here's the Process Status

Red

Re: "failed to get the necessary information for one or more job

dbreader cmf database credentials:

User Id = cmfDBA

Password =

Database = cmf

To reset the cmf database password:

/etc/init.d/dmgtd stop

cd /opt/CSCOpx/bin

./dbpasswd.pl dsn=cmf npwd=password

Blue

Re: "failed to get the necessary information for one or more job

Still get Could not connect to database: Invalid user ID or password (DBD: login failed).

Syslog Severity Summary appears to have stopped analyzing syslogs today. There's records before today.

Red

Re: "failed to get the necessary information for one or more job

Are you logging in to the application as admin before going to dbreader?

Blue

Re: "failed to get the necessary information for one or more job

Yes, I'm logged in as admin.

I did ./dbpasswd.pl dsn=cmf npwd=password initially. Still couldn't log in. Then I did ./dbpasswd.pl all, and was able to get into the cmf database afterwards.

I find a phantom NetConfig Job (id 1015) in the JRM table. It has type_id of "<>", a sch_start time of 2005-10-04 00:00:00.000, and no other details (fields are blank or zero). There's no NetConfig Job 1015 in the Job Browser. Could this be the one causing the problem? If so, should I exclude 1015 from the SQL query? For example:

Delete MakerCheckerInfo where JobID not in (1001, 1002, 1014)

Red

Re: "failed to get the necessary information for one or more job

That could very well be the job that is causing the problem.

Blue

Re: "failed to get the necessary information for one or more job

I got this error when "Delete MakerCheckerInfo where JobID not in (1001, 1002, 1003, 1004, 1009, 1006, 1008, 1013, 1011, 1012, 1014)"

SQL Statement:

Delete MakerCheckerInfo where JobID not in \(1001, 1002, 1003, 1004, 1009, 1006, 1008, 1013, 1011, 1012, 1014\)

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

*** Error ***

Syntax error near '\' (DBD: prepare failed)

Red

Re: "failed to get the necessary information for one or more job

cd /opt/CSCOpx/cgi-bin/dbadmin/pdbadmin

vi nph-dbreader.pl

:set nu *** this will give you the line numbers

go to line 50 and add a new line after it, type

$stmt =~ s/\\//g;

save the file change and then try to run the dbreader again.

Blue

Re: "failed to get the necessary information for one or more job

Got a slightly different error:

SQL Statement:

Delete MakerCheckerInfo where JobID not in (1001, 1002, 1003, 1004, 1009, 1006, 1008, 1013, 1011, 1012, 1014)

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

*** Error ***

Table 'MakerCheckerInfo' not found (DBD: execute failed)

The nph-dbreader.pl looks like this:

50 $stmt = $input{'stmt'};

51 $stmt =~ s/\\//g;

Red

Re: "failed to get the necessary information for one or more job

Are you using the following credentials in dbreader now?

userid: dba

database name: rme

Blue

Re: "failed to get the necessary information for one or more job

no

username: cmfDBA

database name: cmf

Switched to dba/rme. Seemed to have worked:

SQL Statement:

Delete MakerCheckerInfo where JobID not in (1001, 1002, 1003, 1004, 1009, 1006, 1008, 1013, 1011, 1012, 1014)

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

Statement Executed Successfully; Rows affected: 77

218
Views
5
Helpful
13
Replies