HOWTO troubleshoot why no PureDisk jobs get created.

Article:HOWTO36960  |  Created: 2010-12-17  |  Updated: 2011-06-22  |  Article URL http://www.symantec.com/docs/HOWTO36960
Article Type
How To



Problem:

Attempt to manually run a policy results in a message "No Jobs were required to be created to run the Policy."

Initial check list of common causes have been verified OK
- Data selections look OK.
- Clients are enabled.

Howto trouble shoot:

Kill off the existing workflow engine

# /etc/init.d/puredisk stop pdworkflowd

Now start the workflow engine in debug mode

# /opt/pdwfe/bin/pdwfe --debug --trace

Monitor workflow log

# tail -f /Storage/log/pdwfe.log

Attempt to start the policy in question (this example is policy id 108):

# /opt/pdag/bin/php /opt/pdspa/workflowengine/createJobs.php -p 108

Review pdwfe.log:

Start of policy number 108:

Sat Dec 18 2010 12:44:34.660104 DEBUG (1074268480): Request policy 108
Sat Dec 18 2010 12:44:34.660126 INFO  (1074268480): Run Policy 'Build Systems' (id :108)

The SQL statement which is used to determine how many jobs to start.

Sat Dec 18 2010 12:44:34.660490 DEBUG (1074268480): SELECT DISTINCT dataselection.id AS id, dataselection.agentid AS agentid FROM dataselection JOIN agent ON agent.id = dataselection.agentid WHERE (dataselection.id NOT IN (SELECT systemdsid FROM storagepool WHERE NOT systemdsid ISNULL)) AND (((agent.department = '3') AND (agent.type = '0') AND (dataselection.dstypeid = '1') AND (dataselection.disabled = 0) AND (dataselection.originaltemplateid = '4'))) ORDER BY dataselection.id

This statement can now be run manually to narrow down which test is returning 0 rows.

goodfairy:~ # /opt/pddb/bin/psql -U pddb ca -c "SELECT DISTINCT dataselection.id AS id, dataselection.agentid AS agentid FROM dataselection JOIN agent ON agent.id = dataselection.agentid WHERE (dataselection.id NOT IN (SELECT systemdsid FROM storagepool WHERE NOT systemdsid ISNULL)) AND (((agent.department = '3') AND (agent.type = '0') AND (dataselection.dstypeid = '1') AND (dataselection.disabled = 0) AND (dataselection.originaltemplateid = '4'))) ORDER BY dataselection.id"
 id | agentid
----+---------
  7 |       7
  8 |       6
(2 rows)
 

In the working example above, two jobs will be created.

i.e. One row per job.

 



Article URL http://www.symantec.com/docs/HOWTO36960


Terms of use for this information are found in Legal Notices