dosubot[bot] commented on issue #8091: URL: https://github.com/apache/incubator-devlake/issues/8091#issuecomment-2369943760
<!-- Greeting --> 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](https://dosu.dev) <!-- Answer --> 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: ```sql 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](https://github.com/apache/incubator-devlake/issues/4672) <sup>[[1]](https://github.com/apache/incubator-devlake/issues/4672)</sup>. 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](https://github.com/apache/incubator-devlake/issues/4531) <sup>[[2]](https://github.com/apache/incubator-devlake/issues/4531)</sup>. 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](https://github.com/apache/incubator-devlake/issues) section or the [SonarQube Configuration Documentation](http://localhost:4000) <sup>[[3]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.16/Configuration/SonarQube.md)</sup><sup>[[4]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.20/Configuration/SonarQube.md)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
