PerfTop not showing any data for cluster overview for Open Search Performance Analysis

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
Hi Everyone, I am using Opensearch 2.11 tar ball and trying to get performance with our application. For that we ran Performance Analyzer found inside the open search package.
To get the performance data we have taken PerfTop tool (Version- 1.2.0.0) recommended by Open search documentation .
The issue is it is not showing any data in Cluster Overview dashboard .
1.Running OpenSearch
2.Running performance analyzer
Using JAVA_HOME: /home/mmuser/opsr/java/jdk-11.0.22
Using OPENSEARCH_PATH_CONF: /home/mmuser/opsr/opensearch-2.11.1/bin
Oct 23, 2024 5:39:26 AM org.jooq.tools.JooqLogger lambda$info$5
INFO:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @ @ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Thank you for using jOOQ 3.16.20

Oct 23, 2024 5:39:26 AM org.jooq.tools.JooqLogger lambda$info$5
INFO:

jOOQ tip of the day:

Oct 23, 2024 5:39:26 AM org.jooq.tools.JooqLogger lambda$info$5
INFO: Version : Database version is supported by dialect SQLITE: 3.41.2
Oct 23, 2024 5:39:31 AM org.jooq.tools.JooqLogger lambda$info$5
INFO: Single batch : No bind variables have been provided with a single statement batch execution. This may be due to accidental API misuse
Oct 23, 2024 5:39:31 AM org.jooq.tools.JooqLogger lambda$info$5
INFO: Single batch : No bind variables have been provided with a single statement batch execution. This may be due to accidental API misuse
Oct 23, 2024 5:39:31 AM org.jooq.tools.JooqLogger lambda$info$5
INFO: Single batch : No bind variables have been provided with a single statement batch execution. This may be due to accidental API misuse
Oct 23, 2024 5:39:31 AM org.jooq.tools.JooqLogger lambda$info$5
INFO: Single batch : No bind variables have been provided with a single statement batch execution. This may be due to accidental API misuse
3.Running PerfTop which is not showing any data


4.Attaching here the json which is given to run PerfTop
{
“endpoint”: “localhost:9600”,
“gridOptions”: {
“rows”: 12,
“cols”: 12
},
“graphs”: {
“tables”: [
{
“queryParams” : {
“metrics”: “CPU_Utilization,IO_ReadThroughput,IO_WriteThroughput”,
“aggregates”: “sum,sum,sum”,
“dimensions”: “Operation,IndexName,ShardID”,
“sortBy”: “CPU_Utilization”
},
“options”: {
“gridPosition”: {
“row”: 0,
“col”: 0,
“rowSpan”: 4,
“colSpan”: 7
},
“label”: “Resource Metrics”,
“keys”: false,
“fg”: “green”,
“selectedFg”: “green”,
“selectedBg”: " ",
“columnSpacing”: 1,
“refreshInterval”: 5000
}
},
{
“queryParams” : {
“metrics”: “ShardBulkDocs,ShardEvents”,
“aggregates”: “sum,sum”,
“dimensions”: “Operation,IndexName”,
“sortBy”: “ShardEvents”
},
“options”: {
“gridPosition”: {
“row”: 0,
“col”: 7,
“rowSpan”: 4,
“colSpan”: 5
},
“label”: “Shard Operation Metrics”,
“keys”: false,
“fg”: “green”,
“selectedFg”: “green”,
“selectedBg”: " ",
“columnSpacing”: 1,
“refreshInterval”: 5000
}
},
{
“queryParams” : {
“metrics”: “Latency,HTTP_RequestDocs,HTTP_TotalRequests”,
“aggregates”: “avg,sum,sum”,
“dimensions”: “Operation,HTTPRespCode,Indices”,
“dimensionFilters”: [“bulk”, “search”],
“sortBy”: “HTTP_RequestDocs”
},
“options”: {
“gridPosition”: {
“row”: 4,
“col”: 0,
“rowSpan”: 4,
“colSpan”: 7
},
“label”: “Workload”,
“keys”: false,
“fg”: “green”,
“selectedFg”: “green”,
“selectedBg”: " ",
“columnSpacing”: 1,
“refreshInterval”: 5000
}
}
],
“bars”: [
{
“queryParams” : {
“metrics”: “IO_WriteThroughput”,
“aggregates”: “sum”,
“dimensions”: “Operation”,
“dimensionFilters”: [“other”, “shardbulk”, “refresh”, “merge”]
},
“options”: {
“gridPosition”: {
“row”: 8,
“col”: 0,
“rowSpan”: 4,
“colSpan”: 3
},
“label”: “Write Throughput (Bps) per Operation”,
“labelColor”: “red”,
“barWidth”: 15,
“xOffset”: 2,
“maxHeight”: 6,
“refreshInterval”: 5000
}
},
{
“queryParams” : {
“metrics”: “CPU_Utilization”,
“aggregates”: “sum”,
“dimensions”: “Operation”
},
“options”: {
“gridPosition”: {
“row”: 8,
“col”: 3,
“rowSpan”: 4,
“colSpan”: 9
},
“label”: “CPU (cores) per Operation”,
“labelColor”: “blue”,
“barWidth”: 16,
“xOffset”: 2,
“maxHeight”: 6,
“refreshInterval”: 5000
}
}
],
“lines”: [
{
“queryParams” : {
“metrics”: “CPU_Utilization”,
“aggregates”: “sum”,
“dimensions”: “Operation”
},
“options”: {
“gridPosition”: {
“row”: 4,
“col”: 7,
“rowSpan”: 4,
“colSpan”: 5
},
“label”: “OpenSearch Operation CPU (cores) per Node”,
“showNthLabel”: 3,
“showLegend”: true,
“legend”: { “width”: 10 },
“xAxis”: [“0:00”, “0:05”, “0:10”, “0:15”, “0:20”, “0:25”, “0:30”, “0:35”, “0:40”, “0:45”, “0:50”, “0:55”],
“refreshInterval”: 5000
}
}
]
}
}

Describe the issue:
We are struggling to get the sufficient performance number of Open Search and to find the bottleneck we need the perfTop data which is not showing anyting .

Request if any one can help on this .

Configuration:

Relevant Logs or Screenshots:

Can anyone help me?? I had the same issue…
Also, I got some errors related to

[ERROR][o.o.p.r.s.m.AggregateMetric] RCA: Caught an exception while getting the DB SQL [select IndexName, ShardID, sum(max) from Shard_Size_In_Bytes where ShardID is not null group by IndexName order by sum(max) desc]; [SQLITE_ERROR] SQL error or missing database (no such table: Shard_Size_In_Bytes)