Datamining report policy fails with "Empty rules not allowed in a dataselection"
|Article:TECH143710|||||Created: 2010-11-08|||||Updated: 2012-07-28|||||Article URL http://www.symantec.com/docs/TECH143710|
Empty rules not allowed in a dataselection. Please review your data selection rules.:Data Mining (Full)
*** Error Message ***
Empty rules not allowed in a dataselection. Please review your data selection rules.
*** End ***
Agent Jobstep analysis: exitcode 1, status 3, progress 0.
PureDisk 6.6.1 with Replicated Agents
One of the 'Replicated Agents' (identified by "[R]" in the hostname) was incorrectly disabled.
The 'statustypeid' field in the agent table is:
0 - Virtual Agent
1 - Inactive
2 - Enabled
As there are no dataselections associated with a Virtual Agent, the test for empty dataselections is triggered when a Virtual Agent is set to 'Inactive'.
Do NOT disable Virtual Clients.
To fix, support had to manually re-set statustypeid:
# /opt/pddb/bin/psql -U pddb ca -c "update agent set statustypeid=0 where id=48"
'Virtual Agents' are easily identified by the '[R] ' in front of the hostname.
# /opt/pddb/bin/psql -U pddb ca -c "select id,hostname from agent where statustypeid != 0 and hostname like '[R]%'"
Article URL http://www.symantec.com/docs/TECH143710