I have successful configured this APM API as dataset to my Grafana server, dashboards do show data from my APM Agents, including those which I have configured from your examples here on this project.

First of all, thanks for this master piece.

The issue I am facing is, I am not able to see all possibles Attributes for some Agents type, most specifically for RDB Agents. I need to create a dashboard with the TOP_SQL attribute group, but it is not available on the dataset.

From rest I am able to see it:
/ibm/tivoli/rest/providers/itm.KD8/datasources/TMSAgent.%25IBM.OracleAgentRDB/datasets/MetricGroup.KRZTOPSQL

Is some limitation or pre-configured attributes you have set for this? Or does it should get all attributes by default?

I have noted that this same attribute is not available on APM Dashboard it self, is there any relation?

Thanks.

Please include this information:

• What Grafana version are you using?
  6.7.3
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
  0.90, via git.
• What OS are you running grafana on?
  RHEL 7.7
• What did you do?
  Imported the sample Linux dashboard.
• What was the expected result?
  Being able to see the graphs without manually changing the Agent Instance value from the dropdown list (rs41:LZ)
• What happened instead?
  No value shown if the agent instance value is set to rs41:LZ.
• If related to metric query / query editor:
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

If the agent instace value is changed to a value from the dropdown list, values are shown. If the rs41:LZ value is used instead an error pops up:

Server Response: 500, Message: ATKRST100E An unexpected error occured. The error message is as follows: 'com.ibm.usmi.console.navigator.model.NavExceptionKFWITM633E Exception: KFWITM775E Request failed due to invalid managed system(s) or resource group(s): rs41:LZ: nested exception is: com.ibm.tivoli.monitoring.provider.navmodel.ITMRuntimeException: KFWITM775E Request failed due to invalid managed system(s) or resource group(s): rs41:LZ'.

Grafana v5.4.3
ITM v06.30.07.00
IBM APM datasource v0.8 (downloaded git release)
RHEL 7.6

Hi

How to get list of disks on the server or list of queues on the queue manger?
Variable can be used in conditions (for filtering results).

i tried but it didn't work.
Now for all query is added the string '/datasets/msys/items?properties=all'.
URL is brouken.

Example:

test query (list cpu ids):

TMSAgent.%25IBM.STATIC134/datasets/MetricGroup.KLZCPU/items?&optimize=true&param_SourceToken=skarsv100:LZ&properties=CPUID

result (url is malformed):
169.44.6.110/api/datasources/proxy/2/datasources/TMSAgent.%25IBM.STATIC134/datasets/MetricGroup.KLZCPU/items?&optimize=true&param_SourceToken=skarsv100:LZ&properties=CPUID/datasets/msys/items?properties=all

Please include this information:

• What Grafana version are you using? 5.3.2

I am having problem with teps when using IBM APM in graphfana, I can not clear the referer of the same call using nginx on the same server where grafana is installed. Can you help me?

Error no TEPS(ITM 6.3):

[11/9/18 17:47:39:033 BRST] 00000022 rest E com.ibm.tivoli.rest.RestRequestProcessor service ##### Rejecting request due to invalid Referer attribute:http://d7156lx0270:3000
[11/9/18 17:47:39:034 BRST] 00000022 webapp E com.ibm.ws.webcontainer.webapp.WebApp logServletError SRVE0293E: [Servlet Error]-[RestServlet]: com.ibm.ws.webcontainer.webapp.WebAppErrorReport: SRVE0295E: Error reported: 500
at com.ibm.ws.webcontainer.webapp.WebAppDispatcherContext.sendError(WebAppDispatcherContext.java:626)
at com.ibm.ws.webcontainer.webapp.WebAppDispatcherContext.sendError(WebAppDispatcherContext.java:656)
at com.ibm.ws.webcontainer.srt.SRTServletResponse.sendError(SRTServletResponse.java:1236)
at com.ibm.ws.webcontainer.srt.SRTServletResponse.sendError(SRTServletResponse.java:1210)
at com.ibm.tivoli.rest.RestRequestProcessor.handleRequest(RestRequestProcessor.java:245)
at org.apache.wink.server.internal.servlet.RestServlet.service(RestServlet.java:124)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:166)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1691)

Nginx.conf

user nginx;
worker_processes 10;

error_log /var/log/nginx/error.log warn;
pid /var/run/nginx.pid;

events {
worker_connections 1024;
}

http {
include /etc/nginx/mime.types;
default_type application/octet-stream;

log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                  '$status $body_bytes_sent "$http_referer" '
                  '"$http_user_agent" "$http_x_forwarded_for"';

access_log  /var/log/nginx/access.log  main;

sendfile        on;
#tcp_nopush     on;

keepalive_timeout  65;

#gzip  on;

include /etc/nginx/conf.d/*.conf;

server {
    listen 8080;
    server_name d7156lx0270;
    root /usr/share/nginx/html;

    #Load the default configuration files for the default server block.
    include /etc/nginx/default.d/*.conf;

    location / {

             proxy_pass http://localhost:3000/;
             proxy_set_header Referer "http://10.205.75.96:15200";


    }

    error_page 404 /404.html;
        location = /40x.html {
    }
}

}

~

hi,
I am seeing a few ERROR messages in the server1 log of APM after enabling this configuration.

[6/14/17 17:14:38:967 AEST] 0002d6de com.ibm.tivoli.rest E ##### The referer field does not exist in the HTTP request. The lack of a referer field could be considered a CSRF attack when the request is performing a state change.null
[6/14/17 17:14:38:968 AEST] 0002d6de ibm.tivoli.monitoring.provider.metrics.MetricsGaianCollector I *************collection request without refId received.
[6/14/17 17:14:38:975 AEST] 0002d70f com.ibm.tivoli.rest E ##### The referer field does not exist in the HTTP request. The lack of a referer field could be considered a CSRF attack when the request is performing a state change.null

FYI - since my APM on prem is over https, I had to use https://:8091/ instead of http://server:8090

Also, Yes I have enabled the "nginx" proxy. Without having it, it was showing errors to even connect to the data source.

Thanks

Hi,

Is it possible to use wildcards on Condition ? Something like TRANID like '%C%' ?

Thanks

Hello,

When users select time ranges greater than 24 hours for Tivoli 6.3 datasource in Garafana, the TEPS server java process spikes CPU and then TEPS becomes unusable. We then need to restart TEPS. Have opened ticket with IBM, Any suggestions to stabilize the tool would be helpfull.

Plugin sends incorrect value for param_SourceToken.

For instance,

Plugin sends param_SourceToken=Primary:ab3_vm00001948:NT

When it should send:

param_SourceToken=ab3_vm00001948:NT

In a nutshell, it is tacking on a Primary: when it should not... as Primary is not list in the TEMS list.

tivlls@nl03hts021ccpxa:/opt/IBM/TEMS/bin> tacmd listsystems -t NT | grep vm00001948
ab3_vm00001948:NT NT 06.30.07.00 Y

Note that there are a lot of systems that do have a "Primary" on them
Primary:ab3_nl0311AB33169:NT NT 06.30.07.00 Y
Primary:ab3_nl0311AB36501:NT NT 06.30.07.00 Y
Primary:ab3_nl0311AB31879:NT NT 06.30.07.00 Y

so the rule is not universal. Why one is and one is not is not clear to me.

• What Grafana version are you using?
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
• What OS are you running grafana on?
• What did you do?
• What was the expected result?
• What happened instead?
• If related to metric query / query editor:
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

Please include this information:

• What Grafana version are you using?
  Version 7.3.7

• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
  Downloaded and extract in /var/lib/grafana/plugins

• What OS are you running grafana on?
  RHEL 7

• What did you do?
  Add IBM APM data source and got server response code: 502

• What was the expected result?
  IBM APM data source added

• What happened instead?
  Add IBM APM data source and got server response code: 502

Error message :
t=2021-06-17T20:55:15+0700 lvl=eror msg="Data proxy error" logger=data-proxy-log userId=7 orgId=1 uname=JULIAN path=/api/datasources/proxy/14 remote_addr=xx.xx.xxx.xxx referer=http://xx.xx.xx.xxx:3000/datasources/edit/14/ error="http: proxy error: x509: certificate relies on legacy Common Name field, use SANs or temporarily enable Common Name matching with GODEBUG=x509ignoreCN=0"

Please include this information:

• What Grafana version are you using?

• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?V0.7 with fix for Make strings and dates displayable

• What OS are you running grafana on? RHEL 6.5

• What did you do? I select a attribute that returns a string

• What was the expected result? Display a Sting attribute
  grafana issue.docx

• What happened instead? I get a - displayed

• If related to metric query / query editor:
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

The returning data is correct, it is not being displayed correctly in Grafana.

":"Mar 5, 2018 10:21:48 AM"}],"tooltip":"","label":"","typeLabel":"","type":"","id":"0_621"},{"properties":[{"value":"Primary","label":"gtmsConfigPeerNodeRole","valueType":"string","id":"GTMSCONFI1"},{"value":"2018-03-05T10:22:48","label":"Timestamp","valueType":"isodatetime","id":"TIMESTAMP","displayValue":

hi
we have installed the latest grafana in linux
and we use apm datasource
and today we found we can test datasource ok.
but when we delete a datasource query and create a new
but we can not choose agent type
why ?
we can find agent type list when we click ,and we choose,but can not work ,
why ?but we can test apm datasource succeded,why ?
log:
t=2017-11-03T14:13:39+0800 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path="/api/datasources/proxy/2/datasources/Select Agent Type.../datasets/Select AttributeGroup.../columns" status=404 remote_addr=127.0.0.1 time_ms=35 size=7807 referer=

in fact we have found such error sometimes,but can not find where is wrong.
can anybody give us some hints?
i think is apm plugin is not so stable?

Hi Experts

we have been facing problems when trying to connect to the Data source for our IBM APM application, the process that we follow is to click Grafana Logo -> Data Sources -> IBM APM Datasource -> Edit Data Source. There we filled all the required fields including basic Auth Details with smadmin user and password.. the issue comes when we click on Save and Test a pop up is prompted asking for user and password for http://SERVERIP:3000 ; we have tried different user combinations with no success, the error that prompts is "Data source connection problem. Server response code: 401" even if no user and password is used the same error is prompted, please any help is appreciated

Hello!

We are using this plugin (https://grafana.com/grafana/plugins/ibm-apm-datasource/) on Grafana v8.5.21 connected with ITM TEPS v6.3.7 SP13. We are able to fetch real time and historical data, but on every query we see CPU usage on TEPS and TEMS get higher and doesnt come down after metric is fetch, we see also the CPU usage increase for the agent process/service on the client/agent server and doesnt come down after metric is fetch or after we switch in Grafana to another server/client. It appers that the query keeps running forever.
To workaround the issue we have to kill Java TEPS process /opt/IBM/ITM/lx8266/iw/java/bin/java then restart TEPS.
The "Deallocate dataset after every metric query" is enabled.
Any idea?
Thank you!

Please include this information:

• What Grafana version are you using?
  5.1.0
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
  8.1.3.0
• What OS are you running grafana on?
  Linux
• What did you do?
  Installed APM plugin and created new Datasource
• What was the expected result?
  Imported IIB dashboard, conneced to IIB and APM crashed
• What happened instead?
  APM crashed with out of memory exception. We did select "Select checkbox "Deallocate dataset after every metric query". But after 10-15 minutes of loading Dashboard we saw APM reporting OOM exceptions.

Are there any recommendations to fix this and keep APM stable while reporting metrics into Grafana ?

hi
every one
my version is 452
and my time range is last 1 hr
and time in grafana server is : Sun Nov 5 21:46:12 CST 2017
and my notebook time is 20171105,21:56
and my query url is :
http://dtbdtb.oicp.net:9008/api/datasources/proxy/1/datasources/TMSAgent.%25IBM.KSG/datasets/MetricGroup.KSGHYPERVS/items?optimize=true&param_SourceToken=in3:icm:SG&param_Time=20171105T125319--20171105T135319&param_refId=1396487587635&properties=VCPU_RATE,WRITETIME,REGI_NAME

time range is 20171105T125319--20171105T135319
why ?
8 hours offset ?
where should i modify ?
thank you

Please include this information:

• What Grafana version are you using?
  6.6.2

• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
  Revision: 0.8 and made an update made available on the 23rd

• What OS are you running grafana on?
  SUSE Linux Enterprise Server 12

• What did you do?
  the datasource was configured and the available dashboards were imported

• What was the expected result?
  The expected result was that the consultations were lost in the TEP

• What happened instead?
  After configuring the datasource it was possible to consult the metrics in the TEP,
  but we are having performance problems and the return of queries has been taking longer than normal

• If related to metric query / query editor:
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

Please include this information:

• What Grafana version are you using? v7.2.2.1
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ? v0.8
• What OS are you running grafana on? Redhat v7.5

I am already running v0.8 of the APM datasource. I want to upgrade to the new v0.9 APM Datasource. Do I need to uninstall the previous version? Do I need to configure new datasources for my dashboards, or does installing v0.9 take over from v0.8? Thanks.

Hello 👋 from Grafana Labs

We have detected that your plugin might still be using AngularJS and recommend migrating it to React, so that it may continue to operate successfully in future versions of Grafana.

You can read more on why and how by visiting our documentation: https://grafana.com/docs/grafana/latest/developers/angular_deprecation/

You can reach out to us with any questions via slack: slack.grafana.com - channel #plugins or our plugin development community forum

Hi Rafal,

First, many thanks for this datasource. It is very nice being able to query the ITM wharehouse with grafana !

I recently tried to use it with the "status panel" (https://grafana.com/plugins/vonage-status-panel) and had an issue handling string metrics.
I don't know if it's a compatibility problem between the panel and the datasource or the datasource that does not provide the awaited answer.
I've seen that the datasource does not return a "display value" in case of a string metric, which is not the case with numeric ones.

Can you have a look ?

Here's an example:

Thanks for your help.

not stable ,give up using grafana!
i tried a week,and wish it is a good choice for display data from itm and other db
but is not stable ,can not use in production
give up
it is a pity

After version 0.6 when adding an ITM metric I can not select agent type, it reverts always to Select Agent Type...

Hi Rafal,

When I add the datasource on Grafana it works correctly, however when I try to copy your dashboards or even create another on my own I got the error "Server response 404" and "Server response: 500".

I'm using ITM63 only as a datasource, here's the connection URI for my server:

http://my.ip.address:15200/ibm/tivoli/rest/providers/itm.hub.myhostname

Could you please advise?
Thank you.

This is not an error per se, but is there any link to the IBM documentation regarding the metrics and what they do? For instance, i have ABSF_THR. What is this? What is it related to? I know it's for threads but what's the different between ABSF_THR and NUM_ACTTHR?
Any help will be well received!

Please include this information:

• What Grafana version are you using?
  6.7
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
  Both
• What OS are you running grafana on?
  Rhel7
• What did you do?
  Configure the Datasource to create some dashboards
• What was the expected result?
  More faster
• What happened instead?
  Too slow to get the data
• If related to metric query / query editor:
  Any metric
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

I've followed the installation instructions for version 0.6 but ITM TEPS is still eating memory.
The server returns and 500 error after each DELETE method call.
{
"xhrStatus": "complete",
"request": {
"method": "DELETE",
"url": "api/datasources/proxy/2/datasources/TMSAgent.%25IBM.STATIC021/datasets/MetricGroup.NTPROCSSR",
"params": {
"param_SourceToken": "Primary:IBERPER:NT",
"optimize": "true",
"param_Time": "20171028T220000--20171031T143915",
"properties": "DPCTIME,TIMESTAMP,INSTCNAME",
"condition": "INSTCNAME = '_Total'",
"param_refId": 1402437313643
}
},
"response": {
"error": "Internal Server Error",
"response": "Error 500: SRVE0295E: Error reported: 500\r\n",
"message": "Internal Server Error"
}
}

Please include this information:

• What Grafana version are you using?

• 7.1.5

• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?

• 0.9; placed files in /var/lib/grafana/plugins

• What OS are you running grafana on?

• RHEL 6.3

• What did you do?

• Installed and configured APM plugin to pull data from Tivoli. I am able to obtain Tivoli detailed historical data and generate graphs but it is only 2 days of data in my setup of TEMS

• What was the expected result?

• Install and configure APM plugin to pull historical summarized data from Tivoli, which is configured for 30+ days retention

• What happened instead?

• The APM plugin is only able to obtain the Tivoli detailed historical data which is only 2 days worth of data to create graphs in Grafana

• If related to metric query / query editor:
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

Is there a configuration option in the APM plugin to poll Tivoli historical summarized data instead of the detailed historical data? I've tried Agent Type KSY:Summarization and Pruning but it results in an error in Grafana - 'KFWITM217E Request error: SQL1_OpenRequest failed

Hi
first of all thank you for your work!

I am experiencing the following problem:

• grafana 7.3.7
• plugin version 0.9.0
• redhat 7
• ITM6.3

I would like to run a query passing the agent's name as a variable, but it doesn't seem to work

Agent Type - TMSAgent.%IBM.STATIC125
Metric Group - MetricGroup.T6TXCS

Agent Instance: $NODO1 (where nodo1 is like myagent:T6)

request:Object
method:"get"
url:"api/datasources/proxy/11/datasources/TMSAgent.%25IBM.STATIC125/datasets/MetricGroup.T6TXCS/items"
params:Object
param_SourceToken:""$NODO1"" not myagent:T6
optimize:"true"
param_Time:"20210228T151501--20210228T211501"
properties:"SERVTIME,WRITETIME,APPLICATIN"
condition:"APPLICATIN = 'myapplication'" <-- this is a correctly valued variable $TX=myapplcation
param_refId:805981393523
param_Refresh:1
param_Limit:"20000"
data:undefined
hideFromInspector:false
response:Object
msgId:"ATKRST100E"
stackTrace:"com.ibm.usmi.console.navigator.model.NavException: (ATKRST100E) ATKRST100E An unexpected error occured. The error message is as follows: 'KFWITM454E Request failed due to offline managed system(s).'.: nested exception is:
com.ibm.tivoli.monitoring.provider.navmodel.ITMRuntimeException: KFWITM454E Request failed due to offline managed system(s).

G.

• What Grafana version are you using?
  8.0.2

• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
  Git Clone (0.9.1)

• What OS are you running grafana on?
  RHEL 7

• What did you do?
  Trying to create alerts on Grafana after successfully configuring the plugin.

• What was the expected result?
  Alerts should be configurable.

• What happened instead?
  In all the dashboards using the IBM APM datasource i have the message in the Alert section "The datasource does not support alerting queries"

Hi,
We get an issue with displaying data from Synthetic Transactions.

Query Inspector

Expand All Copy to Clipboard
Object
xhrStatus:"complete"
request:Object
method:"GET"
url:"api/datasources/proxy/27/datasources/TMSAgent.%25IBM.KSOTXN/datasets/MetricGroup.KSOTRANSAC/items"
params:Object
param_SourceToken:"SO:TEST_MO_TEST"
optimize:"true"
param_Time:"20190703T041544--20190703T101544"
properties:"TRANSTIME,WRITETIME,TRANSNAME"
condition:undefined
param_refId:214682627803
data:undefined
response:Object
msgSeverity:"error"
msgId:"ATKRST100E"
msgText:"ATKRST100E An unexpected error occured. The error message is as follows: 'com.ibm.usmi.console.navigator.model.NavExceptionKFWITM633E Exception: com.ibm.db2.jcc.am.SqlSyntaxErrorExceptionKFWITM634E SQL execution or subsequent request processing failed for SELECT a.TMZDIFF,a."TRANSTIME" AS "TRANSTIME",a."WRITETIME" AS "WRITETIME",a."TRANSNAME" AS "TRANSNAME" FROM LP_KSOTRANSAC a WHERE ( a.ORIGINNODE IN (?)) AND a.WRITETIME >= ? AND a.WRITETIME <= ? ORDER BY WRITETIME ASC : nested exception is: com.ibm.tivoli.monitoring.provider.navmodel.ITMRuntimeException: com.ibm.db2.jcc.am.SqlSyntaxErrorExceptionKFWITM634E SQL execution or subsequent request processing failed for SELECT a.TMZDIFF,a."TRANSTIME" AS "TRANSTIME",a."WRITETIME" AS "WRITETIME",a."TRANSNAME" AS "TRANSNAME" FROM LP_KSOTRANSAC a WHERE ( a.ORIGINNODE IN (?)) AND a.WRITETIME >= ? AND a.WRITETIME <= ? ORDER BY WRITETIME ASC '."

Opened a IBM support case and did some research it seems like the smadmin aint got access to the DATAMART db2 database, we should use the ITMUSER to connect to DATAMART.
Do you know if it's possible to display IBM APM Synthetic Transaction data in Grafana?

Happens after refresh of the same dataset

KFWITM454E Request failed due to offline managed system(s)

{"msgId":"ATKRST100E","stackTrace":"com.ibm.usmi.console.navigator.model.NavException: (ATKRST100E) ATKRST100E An unexpected error occured. The error message is as follows: 'KFWITM454E Request failed due to offline managed system(s).'.: nested exception is: \n\tcom.ibm.tivoli.monitoring.provider.navmodel.ITMRuntimeException: KFWITM454E Request failed due to offline managed system(s).\n\tat com.ibm.tivoli.rest.RestURI.getExceptionResponse(RestURI.java:580)\n\tat com.ibm.tivoli.rest.RestProvidersURI.getDatasourceDatasetItems(RestProvidersURI.java:2304)\n\tat sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)\n\tat java.lang.reflect.Method.invoke(Method.java:611)\n\tat org.apache.wink.server.internal.handlers.InvokeMethodHandler.handleRequest(InvokeMethodHandler.java:63)\n\tat org.apache.wink.server.handlers.AbstractHandler.handleRequest(AbstractHandler.java:33)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.handlers.CreateInvocationParametersHandler.handleRequest(CreateInvocationParametersHandler.java:54)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.handlers.AbstractHandler.handleRequest(AbstractHandler.java:34)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.handlers.FindResourceMethodHandler.handleSubResourceMethod(FindResourceMethodHandler.java:188)\n\tat org.apache.wink.server.internal.handlers.FindResourceMethodHandler.handleRequest(FindResourceMethodHandler.java:110)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.handlers.FindRootResourceHandler.handleRequest(FindRootResourceHandler.java:95)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.handlers.HeadMethodHandler.handleRequest(HeadMethodHandler.java:53)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.handlers.OptionsMethodHandler.handleRequest(OptionsMethodHandler.java:46)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.handlers.SearchResultHandler.handleRequest(SearchResultHandler.java:33)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.log.ResourceInvocation.handleRequest(ResourceInvocation.java:92)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.internal.log.Requests.handleRequest(Requests.java:76)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:26)\n\tat org.apache.wink.server.handlers.RequestHandlersChain.handle(RequestHandlersChain.java:22)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.doChain(AbstractHandlersChain.java:67)\n\tat org.apache.wink.server.handlers.AbstractHandlersChain.run(AbstractHandlersChain.java:52)\n\tat org.apache.wink.server.internal.RequestProcessor.handleRequestWithoutFaultBarrier(RequestProcessor.java:207)\n\tat org.apache.wink.server.internal.RequestProcessor.handleRequest(RequestProcessor.java:154)\n\tat com.ibm.tivoli.rest.RestRequestProcessor.handleRequest(RestRequestProcessor.java:381)\n\tat org.apache.wink.server.internal.servlet.RestServlet.service(RestServlet.java:124)\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:668)\n\tat com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)\n\tat com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)\n\tat com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)\n\tat com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)\n\tat com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)\n\tat com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)\n\tat com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)\n\tat com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)\n\tat com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)\n\tat com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)\n\tat com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)\n\tat com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)\n\tat com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)\n\tat com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)\n\tat com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)\n\tat com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:277)\n\tat com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)\n\tat com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)\n\tat com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:166)\n\tat com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)\n\tat com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)\n\tat com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)\n\tat com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)\n\tat com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)\n\tat com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)\n\tat com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1691)\nCaused by: com.ibm.tivoli.monitoring.provider.navmodel.ITMRuntimeException: KFWITM454E Request failed due to offline managed system(s).\n\tat com.ibm.tivoli.monitoring.provider.navmodel.ITMNavReportCollection.getResult(ITMNavReportCollection.java:859)\n\tat com.ibm.tivoli.monitoring.provider.navmodel.ITMNavReportCollection.getLargeTableModelNodes(ITMNavReportCollection.java:318)\n\tat com.ibm.tivoli.monitoring.provider.navmodel.ITMNavReportCollection.getAllNodes(ITMNavReportCollection.java:344)\n\tat com.ibm.tivoli.rest.navmodel.NavNodeFilter.getNodes(NavNodeFilter.java:152)\n\tat com.ibm.tivoli.rest.navmodel.NavCollection.getNodes(NavCollection.java:1191)\n\tat com.ibm.tivoli.rest.RestProvidersURI.getDatasourceDatasetItems(RestProvidersURI.java:2287)\n\t... 77 more\nCaused by: KFWITM454E Request failed due to offline managed system(s).\n\tat com.ibm.TEPS.CTQuery.QueryModelManager.executeRequest(QueryModelManager.java:438)\n\tat candle.fw.model.PBasedRequest.execute(PBasedRequest.java:894)\n\tat com.ibm.tivoli.monitoring.provider.navmodel.ITMNavReportCollection.getResult(ITMNavReportCollection.java:854)\n\t... 82 more\nCaused by: exception candle.fw.corba.CTProperty.PropertyBasedException {\ncandle.fw.corba.CTProperty.Property[] errorProperties={struct candle.fw.corba.CTProperty.Property {\njava.lang.String key=\"-1020\",\norg.omg.CORBA.Any value=\"autoNT_Processor\"\n},struct candle.fw.corba.CTProperty.Property {\njava.lang.String key=\"-2101a\",\norg.omg.CORBA.Any value=701\n},struct candle.fw.corba.CTProperty.Property {\njava.lang.String key=\"-2102\",\norg.omg.CORBA.Any value=\"Query node(s) offline, report id = \\'autoNT_Processor\\'.\"\n},struct candle.fw.corba.CTProperty.Property {\njava.lang.String key=\"-2105\",\norg.omg.CORBA.Any value=\"REPT101\"\n},struct candle.fw.corba.CTProperty.Property {\njava.lang.String key=\"-2108\",\norg.omg.CORBA.Any value=true\n}}\n}\n\tat candle.fw.corba.CTProperty.PropertyBasedExceptionHelper.read(PropertyBasedExceptionHelper.java:27)\n\tat candle.fw.corba.CTQuery._EvaluatorStub.executeRequest(_EvaluatorStub.java:82)\n\tat com.ibm.TEPS.CTQuery.CTQueryBrokerImpl.executeRequest(CTQueryBrokerImpl.java:150)\n\tat com.ibm.TEPS.CTQuery.QueryModelManager.executeRequest(QueryModelManager.java:373)\n\t... 84 more\n","msgSeverity":"error","msgText":"ATKRST100E An unexpected error occured. The error message is as follows: 'KFWITM454E Request failed due to offline managed system(s).'."}

• What Grafana version are you using?
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
• What OS are you running grafana on?
• What did you do?
• What was the expected result?
• What happened instead?
• If related to metric query / query editor:
  Include raw network request & response: get by opening Chrome Dev Tools (F12, Ctrl+Shift+I on windows, Cmd+Opt+I on Mac), go the network tab.

Hi
Grafana version: 5.3.4
IBM APM datasource version: 0.8.0 (grafana-cli)
OS are you running grafana on: Centos 7.5

I added a variable to the dashboard settings to get a list of Windows OS (NT) agents, but the query (TMSAgent.%IBM.STATIC021) returns nothing.

request:
GET /api/datasources/proxy/6/datasources/TMSAgent.%25IBM.STATIC021/datasets/msys/items?properties=all HTTP/1.1

response:
{"items":[],"filteredRows":0,"identifier":"id","totalRows":0,"numRows":0}

Hello Rafal,

I have upgraded the APM from 8.1.3 to 8.1.4, after that the Datasource communication stopped:

I am using the URL: http://ibmsvvux0002:8090/ibm/tivoli/rest/providers/itm.KD8
please have a look on the imagem below:

Checking the Grafana Logs its showing this:

t=2017-10-09T15:30:44-0300 lvl=eror msg="Basic auth failed" logger=context error="User not found"
t=2017-10-09T15:30:44-0300 lvl=info msg="Request Completed" logger=context userId=0 orgId=0 uname= method=GET path=/api/datasources/proxy/1 status=401 remote_addr=10.105.164.9 time_ms=0 size=31 referer=http://ibmsvvux0001:3000/datasources/edit/1

Do you know if there is any kind of issue on the new APM Version?

I add the datasource on Grafana it works correctly, however when I try to copy your dashboards or even create another on my own I got the error "Server response 404"

and my provider version is 8.x

http://<teps_server_hostname>:15200/ibm/tivoli/rest/providers/itm.<TEMS_NAME> my url parameters is HUBTEMS, then the datasource connection successful. but while i open a new dashboard ,there has a icon on the top left, the mouse on it shows that the error "404",

i'd spent serveral hours on it, can u please tell me some propable reasons of that? i wonder if the ibm's version affects? my ibm server's version is 6.2X, i am afforting in rebuillding a new version6.3x to retry it while waiting for your answser.

best wishes!

for apm plugin,one metric work fine,if change the group by,n/a,but you said that only primary key can be group by,so i can accept it ,so i change back,but also keep n/a
why ?
it seems that plugin is not stable

Please include this information:

• What Grafana version are you using?
• 8
• What IBM APM datasource version are you using and how you installed it (git clone/downloaded git release/grafana-cli) ?
• Tried with 0.8 and 0.9
• What OS are you running grafana on?
• RHEL 7 / Docker container with persistent volume
• What did you do? Tried to apply new version of Grafana