NetIQ AppManager 7.0.x
How do I gather job information for rejected data on the repository?
How do I find out about data that was rejected in the QDB database?
Is there a manual query that I can use to get data that has been rejected by the management server?
Is there a manual query that I can use find all job information related to rejected data?
To find rejected data in the AppManager repository in SQL Query Analyzer use the following queries:
- For data which has been rejected by the management server, typically rejected due to orphaned jobs:
SELECT * FROM datarejected
- For all job information associated with rejected data:
SELECT * FROM job
RIGHT OUTER JOIN datarejected
ON datarejected.jobid = job.jobid
ORDER BY datarejected.jobid
To find the agent that the rejected data is coming from you must search the ms.log for the jobID found by the queries above and you should be able to find the IP address that the data is coming from.
Cold start the agent (Restart the Agent Services using -o start parameter.)
This should stop the agent from sending rejected data if the rejected data is coming from orphaned jobs.