SonarQube Community: sonarqube-9.7.1.62043
Java 11
ojdbc7-12.1.0.2
Hi - I am getting below error snippets from web.log when starting sonar qube in Windows (StartSonar.bat). I have tried creating new account in DB but still fails. Kindly assist me. Thank you!
2022.11.25 09:26:35 WARN web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5c29bfd-org.sonar.server.platform.db.migration.AutoDbMigration': Initialization of bean failed; nested exception is org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #1 'Create initial schema' failed
2022.11.25 09:26:35 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5c29bfd-org.sonar.server.platform.db.migration.AutoDbMigration': Initialization of bean failed; nested exception is org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #1 'Create initial schema' failed
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:628)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
.
.
.
Caused by: org.sonar.server.platform.db.migration.step.MigrationStepExecutionException: Execution of migration step #1 'Create initial schema' failed
.
.
.
... 43 common frames omitted
Caused by: java.lang.IllegalStateException: Fail to execute CREATE TABLE active_rule_parameters (uuid VARCHAR2 (40 CHAR) NOT NULL,value VARCHAR2 (4000 CHAR) NULL,rules_parameter_key VARCHAR2 (128 CHAR) NULL,active_rule_uuid VARCHAR2 (40 CHAR) NOT NULL,rules_parameter_uuid VARCHAR2 (40 CHAR) NOT NULL, CONSTRAINT pk_active_rule_parameters PRIMARY KEY (uuid))
.
.
.
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object