ETL Job is failing. (NETIQKB45055)

  • 7745055
  • 02-Feb-2007
  • 16-Mar-2011

Environment

NetIQ Analysis Center 2.x

Situation

ETL Job is failing.

Resolution

To troubleshoot an ETL job failure:

  1. Open SQL Enterprise Manager.
  2. Go to Management Folder | SQL Server Agent | Jobs.
  3. Right-click the failing ETL package job and select Properties.
  4. Click the Steps tab.
  5. Double-click the first step.
  6. Highlight and copy the entire Command contents.
  7. Open a command prompt.
  8. Paste the command and hit Enter.  (This process manually runs the command and will show any errors that are encountered.)
  9. Repeat Steps 5 - 8 for the next step in the ETL package job until an error is generated.  From there, you should have a better idea of what the problem or error is.
  10. If no error is generated after executing all steps in the ETL package, then you have basically re-initialized all steps.  Please right click the ETL Package Job in SQL Enterprise Manager and select Start Job.  Let the job run and see if it gives an error again or not.

Cause

Transaction log on Data Mart database was filling up.  Transaction Log space needs to be increased.

Additional Information

Formerly known as NETIQKB45055