How do I gather job information for rejected data on the repository? (NETIQKB49657)

  • 7749657
  • 02-Feb-2007
  • 09-Aug-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

How do I indetify which agent the rejected data is coming from?
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?

Resolution

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.

Additional Information

Formerly known as NETIQKB49657

Feedback service temporarily unavailable. For content questions or problems, please contact Support.