Issue while migrating sonarqube data from Mysql to MSSQL- Sonarqube web is stopped

SonarQube Server / Community Build
1

We are planning to migrate the db from mysql to mssql where we used ssma for migration and finally pointed the sonarqube to connect with newly migrated mssql which is throwing the below error and sonarqube is not coming up.
2020.01.14 04:51:33 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2020.01.14 04:51:35 INFO web[][o.s.p.StopWatcher] Stopping process
2020.01.14 04:51:36 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.01.14 04:51:38 INFO web[][o.e.p.PluginsService] no modules loaded
2020.01.14 04:51:38 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.01.14 04:51:38 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.01.14 04:51:38 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.01.14 04:51:40 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.01.14 04:51:40 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2020.01.14 04:51:40 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost;databaseName=sonar3
2020.01.14 04:51:45 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: C:\Users\krutgr\Downloads\sonar3db\sonarqube-7.6
2020.01.14 04:51:45 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.7.0.1491 / 1d54e49a5f952dfb4ccded090f8043a2a62d0372
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.0.1.143 / 65c55e41e32c114704fd597ccea91fc55becb4ec
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin LDAP / 2.2.0.608 / 79dc3fa4393a29667673c70182f3016288b548b7
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarC# / 7.10.0.7896 / 4e51d150065288432fd1411d29d5aebf2ab7f133
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.0.3.724 / 3ad5232345519caed38a24c70fb77e91757833bf
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.4.0.1222 / 68d9cb3b7daccbc4869c4f2b89d09218d26a0829
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.1.0.1612 / 1809c7be6d88396c0a1b8d597b1e9e0ed8d29730
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.1.0.1615 / 4181edb5eff5605bec82dc0aa15ecd70eaa5857f
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 5.0.0.6962 / ac2fe7567f3dfeb3295e2e710afd8c06b7760e9d
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJava / 5.10.1.16922 / 448c4b8fce8d8ac53a9a7a7265d4de1c1ac87a4e
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPHP / 2.16.0.4355 / 80c76cb14e9eae6bd982fa6ac8c39b2de1f89b6f
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPython / 1.11.0.2473 / 3ec86bb66699ff9ccf2c00c84f360210eb3ffd8d
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarRuby / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 1.9.0.3766 / 4a4080b78001a78d758d1d0fa0190fb9496b6f57
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB / 7.10.0.7896 / 4e51d150065288432fd1411d29d5aebf2ab7f133
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2020.01.14 04:51:46 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2020.01.14 04:51:51 INFO web[][o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
2020.01.14 04:51:52 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@295ecd87 [pattern=UrlPattern{inclusions=[/api/system/migrate_db., …], exclusions=[/api/properties*, …]}]*
2020.01.14 04:51:52 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.01.14 04:52:23 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2020.01.14 04:52:24 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2020.01.14 04:52:25 INFO web[][o.e.p.PluginsService] no modules loaded
2020.01.14 04:52:25 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2020.01.14 04:52:25 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2020.01.14 04:52:25 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2020.01.14 04:52:27 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2020.01.14 04:52:27 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2020.01.14 04:52:27 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost;databaseName=sonar3
2020.01.14 04:52:31 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: C:\Users\krutgr\Downloads\sonar3db\sonarqube-7.6
2020.01.14 04:52:31 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.7.0.1491 / 1d54e49a5f952dfb4ccded090f8043a2a62d0372
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.0.1.143 / 65c55e41e32c114704fd597ccea91fc55becb4ec
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin LDAP / 2.2.0.608 / 79dc3fa4393a29667673c70182f3016288b548b7
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarC# / 7.10.0.7896 / 4e51d150065288432fd1411d29d5aebf2ab7f133
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.0.3.724 / 3ad5232345519caed38a24c70fb77e91757833bf
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.4.0.1222 / 68d9cb3b7daccbc4869c4f2b89d09218d26a0829
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.1.0.1612 / 1809c7be6d88396c0a1b8d597b1e9e0ed8d29730
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.1.0.1615 / 4181edb5eff5605bec82dc0aa15ecd70eaa5857f
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 5.0.0.6962 / ac2fe7567f3dfeb3295e2e710afd8c06b7760e9d
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJava / 5.10.1.16922 / 448c4b8fce8d8ac53a9a7a7265d4de1c1ac87a4e
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPHP / 2.16.0.4355 / 80c76cb14e9eae6bd982fa6ac8c39b2de1f89b6f
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPython / 1.11.0.2473 / 3ec86bb66699ff9ccf2c00c84f360210eb3ffd8d
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarRuby / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 1.9.0.3766 / 4a4080b78001a78d758d1d0fa0190fb9496b6f57
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB / 7.10.0.7896 / 4e51d150065288432fd1411d29d5aebf2ab7f133
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2020.01.14 04:52:32 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2020.01.14 04:52:33 INFO web[][o.s.s.p.d.m.c.MssqlCharsetHandler] Verify that database collation is case-sensitive and accent-sensitive
2020.01.14 04:52:33 INFO web[][o.s.s.p.w.MasterServletFilter] Initializing servlet filter org.sonar.server.ws.WebServiceFilter@4cf01560 [pattern=UrlPattern{inclusions=[/api/system/migrate_db., …], exclusions=[/api/properties*, …]}]*
2020.01.14 04:52:33 INFO web[][o.s.s.a.EmbeddedTomcat] HTTP connector enabled on port 9000
2020.01.14 04:52:37 INFO web[][o.s.s.p.UpdateCenterClient] Update center: https://update.sonarsource.org/update-center.properties (no proxy)
2020.01.14 04:52:38 INFO web[][o.s.s.e.IndexCreator] Create index metadatas
2020.01.14 04:52:39 INFO web[][o.s.s.e.IndexCreator] Create type metadatas/metadata
2020.01.14 04:52:41 INFO web[][o.s.s.e.IndexCreator] Create index components
2020.01.14 04:52:41 INFO web[][o.s.s.e.IndexCreator] Create type components/component
2020.01.14 04:52:41 INFO web[][o.s.s.e.IndexCreator] Create type components/authorization
2020.01.14 04:52:42 INFO web[][o.s.s.e.IndexCreator] Create index tests
2020.01.14 04:52:42 INFO web[][o.s.s.e.IndexCreator] Create type tests/test
2020.01.14 04:52:42 INFO web[][o.s.s.e.IndexCreator] Create index projectmeasures
2020.01.14 04:52:43 INFO web[][o.s.s.e.IndexCreator] Create type projectmeasures/projectmeasure
2020.01.14 04:52:43 INFO web[][o.s.s.e.IndexCreator] Create type projectmeasures/authorization
2020.01.14 04:52:43 INFO web[][o.s.s.e.IndexCreator] Create index rules
2020.01.14 04:52:43 INFO web[][o.s.s.e.IndexCreator] Create type rules/activeRule
2020.01.14 04:52:43 INFO web[][o.s.s.e.IndexCreator] Create type rules/ruleExtension
2020.01.14 04:52:43 INFO web[][o.s.s.e.IndexCreator] Create type rules/rule
2020.01.14 04:52:44 INFO web[][o.s.s.e.IndexCreator] Create index issues
2020.01.14 04:52:44 INFO web[][o.s.s.e.IndexCreator] Create type issues/issue
2020.01.14 04:52:44 INFO web[][o.s.s.e.IndexCreator] Create type issues/authorization
2020.01.14 04:52:44 INFO web[][o.s.s.e.IndexCreator] Create index users
2020.01.14 04:52:45 INFO web[][o.s.s.e.IndexCreator] Create type users/user
2020.01.14 04:52:45 INFO web[][o.s.s.e.IndexCreator] Create index views
2020.01.14 04:52:45 INFO web[][o.s.s.e.IndexCreator] Create type views/view
2020.01.14 04:52:45 INFO web[][o.s.s.s.LogServerId] Server ID: 49B321BC-AWjretrDtjyy6boYAnFq
2020.01.14 04:52:46 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/plugins/download
2020.01.14 04:52:46 WARN web[][o.s.a.s.w.WebService$Action] The response example is not set on action api/permissions/search_templates
2020.01.14 04:52:46 INFO web[][o.s.s.t.TelemetryDaemon] Sharing of SonarQube statistics is enabled.
2020.01.14 04:52:46 INFO web[][o.s.s.n.NotificationDaemon] Notification service started (delay 60 sec.)
2020.01.14 04:52:46 INFO web[][o.s.s.s.GeneratePluginIndex] Generate scanner plugin index
2020.01.14 04:52:46 INFO web[][o.s.s.s.RegisterPlugins] Register plugins
2020.01.14 04:52:46 ERROR web[][o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
java.lang.IllegalStateException: No Default organization uuid configured

  • at com.google.common.base.Preconditions.checkState(Preconditions.java:173)*
  • at org.sonar.server.organization.DefaultOrganizationProviderImpl.getDefaultOrganization(DefaultOrganizationProviderImpl.java:54)*
  • at org.sonar.server.organization.DefaultOrganizationProviderImpl.get(DefaultOrganizationProviderImpl.java:48)*
  • at org.sonar.server.organization.DefaultOrganizationEnforcer.start(DefaultOrganizationEnforcer.java:34)*
  • at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)*
  • at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)*
  • at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)*
  • at java.lang.reflect.Method.invoke(Unknown Source)*
  • at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)*
  • at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)*
  • at org.picocontainer.injectors.AbstractInjectionFactory$LifecycleAdapter.start(AbstractInjectionFactory.java:84)*
  • at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)*
  • at org.picocontainer.behaviors.Stored$RealComponentLifecycle.start(Stored.java:132)*
  • at org.picocontainer.behaviors.Stored.start(Stored.java:110)*
  • at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016)*
  • at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009)*
  • at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)*
  • at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:135)*
  • at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)*
  • at org.sonar.server.platform.platformlevel.PlatformLevelStartup.access$001(PlatformLevelStartup.java:46)*
  • at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:82)*
  • at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)*
  • at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:79)*
  • at org.sonar.server.platform.Platform.executeStartupTasks(Platform.java:196)*
  • at org.sonar.server.platform.Platform.access$400(Platform.java:46)*
  • at org.sonar.server.platform.Platform$1.lambda$doRun$1(Platform.java:121)*
  • at org.sonar.server.platform.Platform$AutoStarterRunnable.runIfNotAborted(Platform.java:371)*
  • at org.sonar.server.platform.Platform$1.doRun(Platform.java:121)*
  • at org.sonar.server.platform.Platform$AutoStarterRunnable.run(Platform.java:355)*
  • at java.lang.Thread.run(Unknown Source)*
    2020.01.14 04:52:46 INFO web[][o.s.p.StopWatcher] Stopping process

Please help

2

Sonarqube Version 7.6

3

Hello @Susmitha,

This looks that you (or something) messed up with the DB integrity.

  • How many rows do you have in your organizations table? Only one should be there.
  • Do you have a property with the kee organization.default in the internal_properties table?