We migrated to Enterprise latest version : sonarqube-enterprise-10.8.0.100206.zip
After upgrade we get below error:
failed with status FAILED, Error message: ### Error querying database. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column ‘rdi_severity’ from result set. Cause: java.lang.IllegalArgumentException: No enum constant org.sonar.api.issue.impact.Severity.BLOCKER ### The error may exist in org.sonar.db.rule.RuleMapper ### The error may involve org.sonar.db.rule.RuleMapper.selectAll ### The error occurred while handling results ### SQL: select rdi.rule_uuid as “rdi_ruleUuid”, rdi.software_quality as “rdi_softwareQuality”, rdi.severity as “rdi_severity”, CASE WHEN rt.is_system_tag = 1 THEN rt.value ELSE NULL END as rt_systemTags, CASE WHEN rt.is_system_tag = 0 THEN rt.value ELSE NULL END as rt_tags, rt.is_system_tag as “rt_isSystemTag”, rt.value as “rt_value”, rds.content as “rds_content”, rds.uuid as “rds_uuid”, rds.kee as “rds_kee”, rds.context_key as “rds_contextKey”, rds.context_display_name as "rds_contextDisplayName
Hello Colin
sorry for not sharing the detail : It happens during Sonarqube publish step for many pipelines and we are stuck, here are some more logs.
Could you pls kindly help?
{
"task": {
"id": "e893ce3c-8901-42bf-9e9a-2884809ca4a3",
"type": "REPORT",
"componentId": "****",
"componentKey": "***JobSchedulerHost",
"componentName": "***JobSchedulerHost",
"componentQualifier": "TRK",
"status": "FAILED",
"submittedAt": "2024-12-16T07:35:57+0000",
"submitterLogin": "d****-com48172",
"startedAt": "2024-12-16T07:35:57+0000",
"executedAt": "2024-12-16T07:35:58+0000",
"executionTimeMs": 860,
"errorMessage": "\n### Error querying database. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'rdi_severity' from result set. Cause: java.lang.IllegalArgumentException: No enum constant org.sonar.api.issue.impact.Severity.BLOCKER\n### The error may exist in org.sonar.db.rule.RuleMapper\n### The error may involve org.sonar.db.rule.RuleMapper.selectAll\n### The error occurred while handling results\n### SQL: select rdi.rule_uuid as \"rdi_ruleUuid\", rdi.software_quality as \"rdi_softwareQuality\", rdi.severity as \"rdi_severity\", CASE WHEN rt.is_system_tag = 1 THEN rt.value ELSE NULL END as rt_systemTags, CASE WHEN rt.is_system_tag = 0 THEN rt.value ELSE NULL END as rt_tags, rt.is_system_tag as \"rt_isSystemTag\", rt.value as \"rt_value\", rds.content as \"rds_content\", rds.uuid as \"rds_uuid\", rds.kee as \"rds_kee\", rds.context_key as \"rds_contextKey\", rds.context_display_name as \"rds_contextDisplayName",
"hasScannerContext": true,
"branch": "feature/BB-5441-test-sonarqube-analysis-on-new",
"branchType": "BRANCH",
"warningCount": 0,
"warnings": [],
"infoMessages": []
}
}
When possible, we prefer that users share code/logs publicly, redacted as necessary, so that all users can benefit from these interactions in the Community. Our default is transparency.
Hi Colin , I could not find that error on those log files this is why It took so long and I wait for my devops team to share it when it happens. Today we ignore the error so it is set as warning and allowing us to see the metrics which is not ideal.
This is the error we get on devops job log.
failed with status FAILED, Error message: ### Error querying database. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column ‘rdi_severity’ from result set. Cause: java.lang.IllegalArgumentException: No enum constant org.sonar.api.issue.impact.Severity.BLOCKER ### The error may exist in org.sonar.db.rule.RuleMapper ### The error may involve org.sonar.db.rule.RuleMapper.selectAll ### The error occurred while handling results ### SQL: select rdi.rule_uuid as “rdi_ruleUuid”, rdi.software_quality as “rdi_softwareQuality”, rdi.severity as “rdi_severity”, CASE WHEN rt.is_system_tag = 1 THEN rt.value ELSE NULL END as rt_systemTags, CASE WHEN rt.is_system_tag = 0 THEN rt.value ELSE NULL END as rt_tags, rt.is_system_tag as “rt_isSystemTag”, rt.value as “rt_value”, rds.content as “rds_content”, rds.uuid as “rds_uuid”, rds.kee as “rds_kee”, rds.context_key as “rds_contextKey”, rds.context_display_name as "rds_contextDisplayName
