Troubleshooting
Problem
There are error messages in cacti.log like below, " 05/01/2014 05:05:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139', SQL:"SELECT distinct host.id,host.hostname FROM host LEFT JOIN grid_clusters ON grid_clusters.clusterid=host.clusterid INNER JOIN grid_hostgroups ON grid_hostgroups.clusterid=host.clusterid AND grid_hostgroups.host=host.hostname WHERE grid_clusters.disabled='' AND grid_clusters.clusterid=5 AND (grid_hostgroups.groupName RLIKE '*')" "
Symptom
ELIM graph cannot be generated.
Cause
The operand of REGEXP/RLIKE is not a valid regular expression.
Resolving The Problem
Resolve this issue by the following procedure,
1 On Platform RTM WEB GUI navigate to Console -> ELIMs.
2 Edit the ELIM instance in question.
3 Modify field "Enter a value for this filter" to a valid regular expression.
Was this topic helpful?
Document Information
More support for:
Platform RTM
Software version:
9.1.2
Document number:
678865
Modified date:
17 June 2018
UID
isg3T1020779