HOWTO troubleshoot why no PureDisk jobs get created.

Description

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.

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)