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?
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?