dosubot[bot] commented on issue #7822: URL: https://github.com/apache/incubator-devlake/issues/7822#issuecomment-2264631934
<!-- Answer --> The error "Error 1146 (42S02): Table 'lake.project_incident_deployment_relationships' doesn't exist" occurs because the table `project_incident_deployment_relationships` is not present in the database. This table is likely required by the queries in the Grafana panels of the DORA dashboard. To resolve this issue, ensure that the table `project_incident_deployment_relationships` exists in the database. You may need to check the database schema setup scripts or documentation for DevLake v1.0.1-beta4 to verify if this table should be created and how it should be populated. If the table is missing, you might need to create it manually or re-run the setup scripts to include it. Additionally, ensure that the necessary data sources such as `Deployments` from GitLab CI and `Incidents` from PagerDuty are correctly configured and that the necessary transformations are defined in the data transformations section while configuring the blueprint of a project. This might help in resolving the missing table issue <sup>[[1]](https://github.com/apache/incubator-devlake/blob/main/grafana/dashboards/DORADebug.json)</sup><sup>[[2]](https://github.com/apache/incubator-devlake/blob/main/grafana/dashboards/DORA.json)</sup><sup>[[3]](https://github.com/apache/incubator-devlake/blob/main/grafana/dashboards/DORADetails-FailedDeploymentRecoveryTime.json)</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: dev-unsubscr...@devlake.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
