SonarQube Pipelines run successfully but no data in dashboard - v1.0.2-beta1

[mrpaapi]

Looks like SonarQube Dashboard is crashing. After successful import using pipelines, dashboard has no data.

[dosubot]

Hello @mrpaapi! I'm here to help you with any bugs, questions, or contributions you may have. If you need assistance, feel free to ask. Dosu

I found two similar closed issues that might be relevant to your problem:

1. [Bug][Dashboard] Wrong bug title in the Sonarqube dashboard: This issue was resolved by modifying the character set of several tables. The suggested solution was to run the following scripts to change the collation, then run the SonarQube blueprint again:

   ALTER TABLE _tool_sonarqube_projects CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE _tool_sonarqube_issues CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE _tool_sonarqube_issue_code_blocks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE _tool_sonarqube_hotspots CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE _tool_sonarqube_file_metrics CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE _tool_sonarqube_accounts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE cq_projects CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE cq_issues CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE cq_issue_code_blocks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
   ALTER TABLE cq_file_metrics CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

   You can find more details here ^[1].

2. [Bug][Sonarqube] Lack of metrics for dashboard: This issue was resolved by adding the number of lines metric. You can find more details here ^[2].

Additionally, common reasons for the SonarQube dashboard displaying 'No data' after a successful pipeline run could include:

• Data Scope Configuration: Ensure that the correct SonarQube projects and data entities are selected during the data scope configuration.
• Sync Policy: Verify that the sync frequency and other sync settings are correctly configured.
• Data Collection Issues: Check if there were any errors during the data collection process.

For more detailed troubleshooting, you can refer to the Troubleshooting section or the SonarQube Configuration Documentation ^[3][4].

To continue talking to Dosu, mention @dosu.

[klesh]

Looks like a known issue to me. Can you confirm? @Startrekzky

[mrpaapi]

I ran this but still no Luck

can you run the following scripts to change collation, then run the sonarqube bp again:
ALTER TABLE _tool_sonarqube_projects CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE _tool_sonarqube_issues CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE _tool_sonarqube_issue_code_blocks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE _tool_sonarqube_hotspots CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE _tool_sonarqube_file_metrics CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE _tool_sonarqube_accounts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cq_projects CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cq_issues CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cq_issue_code_blocks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cq_file_metrics CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

[mrpaapi]

Any update please? @klesh @Startrekzky @nathenharvey @tonyjw

[VadimVoykin]

Hello @Startrekzky!
We managed to determine that the issue lies in the Grafana queries. In order to fix it, we changed the Data Source of each "Panel" from "Mixed" to "mysql" and changed the table in the query by appending the "lake." prefix.