10-03-2005 11:51 AM
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?
Solved! Go to Solution.
10-03-2005 04:40 PM
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
10-03-2005 04:40 PM
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
10-04-2005 04:39 AM
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?
10-04-2005 05:00 AM
10-04-2005 05:26 AM
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
10-04-2005 07:17 AM
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.
10-04-2005 07:22 AM
Are you logging in to the application as admin before going to dbreader?
10-04-2005 09:11 AM
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)
10-04-2005 09:55 AM
That could very well be the job that is causing the problem.
10-04-2005 09:57 AM
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)
10-04-2005 10:03 AM
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.
10-04-2005 10:16 AM
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;
10-04-2005 10:47 AM
Are you using the following credentials in dbreader now?
userid: dba
database name: rme
10-04-2005 10:49 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide