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

[yjdabear]

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?

[nhabib · Accepted solution]

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

[yjdabear]

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?

[yjdabear]

Here's the Process Status

[nhabib]

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

[yjdabear]

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.

[nhabib]

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

[yjdabear]

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)

[nhabib]

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

[yjdabear]

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)

[nhabib]

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.

[yjdabear]

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;

[nhabib]

Are you using the following credentials in dbreader now?

userid: dba

database name: rme

[yjdabear]

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