AMPP Data Processing QDB SQL Job failing on step 1 (NETIQKB73289)

  • 7773289
  • 09-Dec-2011
  • 09-Dec-2011

Environment

NetIQ AppManager Performance Profiler 4.1.x
NetIQ AppManager Performance Profiler 4.5

Situation

AMPP Data Processing QDB SQL Job failing on step 1
Error: XML parsing: line 26, character 423, well formed check: no '<' in attribute value [SQLSTATE 42000] (Error 9415). The step failed.
All elements are missing metrics but showing online. The QDB is online and can be contacted but the AMPP Data Processing job is failing.

Resolution

In order to work around this issue, please update the AMPPLastRun table RunTime to reflect a timestamp 30 minutes later within the QDB, using the following query agaisnt the AMPPDB:

select RunTime from AMPPLastRun where TaskName like 'ExtractAMPPData'

Note the runtime value, and add 1800 to it. This is a unix timestamp and is measured in seconds. Adding 1800 will increase this value to 30 minutes after the last run. Replace xxxx with the new number in the query below:

update AMPPLastRun set RunTime = xxxx where TaskName like 'ExtractAMPPData'

Example:

select RunTime from AMPPLastRun where TaskName like 'ExtractAMPPData'

This returns, 1323440040.
Now add 1800 to move the time forward 30 minutes.
This equals 1323441840.

The following update would be correct the issue in this example:

update AMPPLastRun set RunTime = 1323441840 where TaskName like 'ExtractAMPPData'

After the update is complete run the AMPP Data Processing QDB SQL Job, which should now complete successfully.

Cause

This job is fails due to an xml parsing error.

Additional Information

Formerly known as NETIQKB73289