IBM Support

Error 400 when using a query in a chart

Troubleshooting


Problem

Error 400 when using a query in a chart eg ATKRST121E The condition parameter 'CPU_ID=-1' contains an unknown property ID 'CPU_ID' ATKRST101E The parameter 'condition' with a value of 'System Name like 'Ozbezarius1'' is not formatted correctly.

Symptom

I have set a chart to use an ITM dataset and I wanted to use a query to filter the data that is getting diaplyed but I each time I save the settings it shows error 400 in GUI? and in the SystemOut I have messages with error codes ATKRST121E and ATKRST101E

Cause

In the docs is specified that you can use the Query Condition field to specify a filter for the request that cannot be expressed with the data set's defined parameters. Only items that match the specified filter are returned. Filters strings are formatted as ColumnName operator value, where: ColumnName is the name of a data column. The name of the column is not the column's label that is shown in the user interface column choice drop-down list, so you must be familiar with the data set.

https://www.ibm.com/support/knowledgecenter/en/SSEKCU_1.1.2.1/com.ibm.psc.doc/iscdoc/doc/dash_r_dv_line_charts.html

Environment

Dash/JazzSM , chart populated by a ITM dataset

Resolving The Problem

In order to see what is the correct parameter that you can use , you could use the Firefox webconsole and check the URL build while the rest requests are made that contains the 'itmes' used

example

User-added image
User-added image

https://9.132.151.108:16311/ibm/tivoli/rest/providers/itm.TEMS.9.132.151.104/datasources/TMSAgent.%25IBM.STATIC134/datasets/MetricGroup.KLZCPU/items?d=1491558660892&r=0.47640229704909565&clearCache=true&optimize=true&count=1000&condition=CPUID%3D1?m_SourceToken=Ozbezarius1%3ALZ?m_pageId=1491558452736?m_refId=0.7848645905649059?m_tz=Europe%2FAthens&properties=`ORIGINNODE`%2C`TIMESTAM`P%2C`CPUID`

So, you can use queries like

CPUID=1

ORIGINNODE= 'Ozbezarius1:LZ'

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

Modified date:
02 November 2020

UID

ibm10745895