IBM Support

CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1139'

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.

[{"Product":{"code":"SSVMSD","label":"Platform RTM"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1.2","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

More support for:
Platform RTM

Software version:
9.1.2

Document number:
678865

Modified date:
17 June 2018

UID

isg3T1020779

Manage My Notification Subscriptions