Page History

This document provides troubleshooting steps for different issues related to Azkaban and the RED Scheduler.

Running diagnostics on an Azkaban Executor

The below python script script can be used to run a job against an Azkaban Executor that outputs diagnostic information and tests ODBC connectivity, useful for debugging and also for providing to support for analysis:

...

1. Create a new Host Script object in RED
   • Name it wsl_scheduler_diagnostics (or any name you like) 
   • Assign the 'Python Script' type to it
   • Optionally assign an ODBC/Database connection to the script, this will enable ODBC tests against this connection
   • Open the script in the Editor (double click the host script object in RED) and paste in the python code from above

   

   

2. Create a New Job in RED including this script
   • Include appropriate Scheduler Tags so the script will run against the correct Azkaban Executor
   • Frequency = None - this will allow us to kick the job off ad-hoc as required.
   • On the tasks screen select the script from the host scripts screen and click OK to publish the job

   

   

3. Execute the job and view results
   • Start the job from the RED Scheduler tab or by logging into the Azkaban Dashboard and running from there
   • Example results below:

   

   Tip
   To test other ODBC connections using the same script simply assign the script to another connection and re-run the job. To test Metadata, Source and Target in one go, then temporarily assign the script as the load script of a Load table and create a job to run the Load operation.

Adding Jobs Troubleshooting 

This section provides troubleshooting steps for some issues that you could face while adding jobs.

Cannot load scheduler tags

This

Cannot Publish job

A possible cause is the WsAzkabanWeb and WsAzkabanExec services are not running. Go to Services.msc in Windows and check if they are running. if they are not running, right click on a service and select start.