I just installed a SonarQube ( * Community Edition * Version 9.9.4 (build 87374), Oracle 19c with jdbc driver ojdbc8-23.3.0.23.09) the web application is running fine and i also got 1 java project scaned. But now i tried to scan a typescript project and i get an error when he calls the /sonar/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt,updatedAt,deprecatedKeys&activation=true&qprofile=AY2dL2d4SAflHqvcvJh1&ps=500&p=1
When i look in the logs i can see
2024.02.27 09:26:04 ERROR web[AY3K6kgR+YRYkzsxAAC5][o.s.s.w.WebServiceEngine] Fail to process request http://********/sonar/api/rules/search.protobuf?f=repo,name,severity,lang,internalKey,templateKey,params,actives,createdAt,updatedAt,deprecatedKeys&activation=true&qprofile=AY2dL2d4SAflHqvcvJh1&ps=500&p=1
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
https://docs.oracle.com/error-help/db/ora-00933/
### The error may exist in org.sonar.db.rule.RuleMapper
### The error may involve org.sonar.db.rule.RuleMapper.selectByUuids-Inline
### The error occurred while setting parameters
### SQL: select 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", r.uuid as "r_uuid", r.plugin_rule_key as "ruleKey", r.plugin_name as "repositoryKey", r.description_format as "descriptionFormat", r.status, r.name, r.plugin_config_key as "configKey", r.priority as "severity", r.is_template as "isTemplate", r.is_external as "isExternal", r.is_ad_hoc as "isAdHoc", r.language as "language", r.template_uuid as "templateUuid", r.def_remediation_function as "defRemediationFunction", r.def_remediation_gap_mult as "defRemediationGapMultiplier", r.def_remediation_base_effort as "defRemediationBaseEffort", r.gap_description as "gapDescription", r.system_tags as "systemTagsField", r.security_standards as "securityStandardsField", r.rule_type as "type", r.plugin_key as "pluginKey", r.scope, r.created_at as "createdAt", r.updated_at as "updatedAt", r.note_data as "noteData", r.note_user_uuid as "noteUserUuid", r.note_created_at as "noteCreatedAt", r.note_updated_at as "noteUpdatedAt", r.remediation_function as "remediationFunction", r.remediation_gap_mult as "remediationGapMultiplier", r.remediation_base_effort as "remediationBaseEffort", r.tags as "tagsField", r.ad_hoc_name as "adHocName", r.ad_hoc_description as "adHocDescription", r.ad_hoc_severity as "adHocSeverity", r.ad_hoc_type as "adHocType", r.education_principles as "educationPrinciplesField" from rules r left outer join rule_desc_sections rds on rds.rule_uuid = r.uuid where r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=? or r.uuid=?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Edit: strangly if i create a new quality profile that contains all available typescript rules it works … but that is not the setting i want to use …