I was excited to see that we can now use custom Repository Queries for variables, unfortunatelly even the simplest query does not work, it just gives no results:
[Query type: Repository Query]
select target_name from sysman.mgmt$target
The same query run directly on the DB works and lists all targets. Am I doing something wrong? I tried it with and without qualifying the schema name “sysman” and also with a backslash before the $, it's not working.
We are using grafana 10.3.3 and OEM 13.5.21, Plugin Version 4.0.1
Note: I can query data with the same Datasource in Dashboards (Custom Repository Query) so it's not a permission issue like missing grants or something. The same query which works in a Dashboard does not work as a Repository Query variable. Please help.
[EDIT]: I checked with Chromes Developer Tools and the query actually gets executed and returns the desired result in the raw response data, but it has a status “500”, I'm guessing that's the problem? How can I fix this?
{
"results": {
"": {
"status": 500,
"frames": [
{
"schema": {
"fields": [
{
"name": "TARGET_NAME",
"type": "string",
"typeInfo": {
"frame": "string",
"nullable": true
}
}
]
},
"data": {
"values": [
[
"my_target1",
"my_target2",
“my_target3”
]
]
}
}
]
}
}
}
@murtaza-husain-oracle are you still working on this plugin and aware of this issue? Is there a solution I could try without having to wait for an update?