Previously running on SonarQube 6.7.7 on Windows server 2019 with Java 11 and MS SQL Server 2017
Currently trying to run on SonarQube version 7.9.3 on windows 2019 server with Java 11 and MS SQL server 2019.
After the successful database upgrade here is the error i get.
2020.07.13 16:21:02 INFO web[o.s.s.s.RegisterPlugins] Register plugins
2020.07.13 16:21:02 INFO web[o.s.s.s.RegisterMetrics] Register metrics
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Efferent Coupling (Average) [efferent_coupling_average]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Class Distribution / Complexity [class_complexity_distribution]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric ClangTidy issues [CXX-CLANG-TIDY]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Lines to Cover by IT on New Code [new_it_lines_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Conditions by Line [overall_conditions_by_line]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Rats issues [CXX-RATS]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Medium Severity Vulnerabilities [medium_severity_vulns]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Uncovered Conditions [overall_uncovered_conditions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Coverage by IT on New Code [new_it_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric PC-Lint issues [CXX-PC-LINT]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Uncovered Lines by IT on New Code [new_it_uncovered_lines]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Big Functions (%) [perc_big_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Number of classes and interfaces [number-of-classes-and-interfaces]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Big Functions Lines of Code (%) [perc_loc_in_big_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Lines to Cover on New Code [new_overall_lines_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Total Dependencies [total_dependencies]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Complex Functions (%) [perc_complex_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Condition Coverage by IT on New Code [new_it_branch_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Line Coverage by IT on New Code [new_it_line_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Package dependency cycles [package-dependency-cycles]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Commented-Out LOC [commented_out_code_lines]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Unit Test Details [test_data]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Other tools issues [CXX-OTHER]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Inherited Risk Score [inherited_risk_score]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Uncovered Lines on New Code [new_overall_uncovered_lines]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Public Undocumented API [CXX-PUBLIC_UNDOCUMENTED_API]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Complex Functions Lines of Code (%) [perc_loc_in_complex_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Line Coverage on New Code [new_overall_line_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Squid issues [CXX-SQUID]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Coverage Hits by Line [coverage_line_hits_data]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Covered Conditions by Line [it_covered_conditions_by_line]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric CppCheck issues [CXX-CPPCHECK]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Vera issues [CXX-VERA++]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Compiler issues [CXX-COMPILER]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Complex Functions Lines of Code [loc_in_complex_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Accessors [accessors]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Efferent couplings [efferent-couplings]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Number of package-info.java files [package_info_count]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Uncovered Lines [it_uncovered_lines]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Uncovered Conditions [it_uncovered_conditions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Condition Coverage [overall_branch_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Complex Functions [complex_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Efferent Coupling (Total) [efferent_coupling_total]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Afferent couplings [afferent-couplings]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Branches to Cover [overall_conditions_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Number of packages [package_count]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Coverage Hits by Line [it_coverage_line_hits_data]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Missing package-info.java files [missing_package_info_count]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Big Functions Lines of Code [loc_in_big_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Coverage on New Code [new_overall_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Branches to Cover [it_conditions_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric DrMemory issues [CXX-DRMEMORY]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Afferent Coupling (Total) [afferent_coupling_total]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Vulnerable Component Ratio [vulnerable_component_ratio]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Branches to Cover by IT on New Code [new_it_conditions_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Covered Conditions by Line [overall_covered_conditions_by_line]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Public API [CXX-PUBLIC_API]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric OWASP Dependency-Check Report [report]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric High Severity Vulnerabilities [high_severity_vulns]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Number of java files [java_count]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Lines to Cover [overall_lines_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Number of packages [package]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Valgrind issues [CXX-VALGRIND]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric ClangSA issues [CXX-CLANGSA]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Condition Coverage [it_branch_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Lines of Code in Functions [loc_in_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Uncovered Lines [overall_uncovered_lines]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Coverage Hits by Line [overall_coverage_line_hits_data]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Total Vulnerabilities [total_vulnerabilities]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Afferent Coupling (Average) [afferent_coupling_average]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Covered Conditions by Line [covered_conditions_by_line]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Line Coverage [overall_line_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Low Severity Vulnerabilities [low_severity_vulns]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Lines to Cover [it_lines_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Condition Coverage on New Code [new_overall_branch_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Branches to Cover on New Code [new_overall_conditions_to_cover]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Uncovered Conditions by IT on New Code [new_it_uncovered_conditions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Line Coverage [it_line_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Vulnerable Dependencies [vulnerable_dependencies]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Coverage [overall_coverage]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Conditions by Line [conditions_by_line]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Conditions by Line [it_conditions_by_line]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Missing package-info.java files [missing_package_info]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Public Documented API (%) [CXX-PUBLIC_DOCUMENTED_API_DENSITY]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Big Functions [big_functions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric Overall Uncovered Conditions on New Code [new_overall_uncovered_conditions]
2020.07.13 16:21:03 INFO web[o.s.s.s.RegisterMetrics] Disable metric IT Coverage [it_coverage]
2020.07.13 16:21:03 ERROR web[o.s.s.p.Platform] Background initialization failed. Stopping SonarQube
org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Implicit conversion from data type varbinary to datetime2 is not allowed. Use the CONVERT function to run this query.
The error may exist in org.sonar.db.qualitygate.QualityGateConditionMapper
The error may involve org.sonar.db.qualitygate.QualityGateConditionMapper.insert-Inline
The error occurred while setting parameters
SQL: insert into quality_gate_conditions (qgate_id, metric_id, operator, value_error, created_at, updated_at) values (?, ?, ?, ?, ?, ?)
Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Implicit conversion from data type varbinary to datetime2 is not allowed. Use the CONVERT function to run this query.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
at com.sun.proxy.$Proxy30.insert(Unknown Source)
at org.sonar.db.qualitygate.QualityGateConditionDao.insert(QualityGateConditionDao.java:30)
at org.sonar.server.qualitygate.QualityGateConditionsUpdater.createCondition(QualityGateConditionsUpdater.java:98)
at org.sonar.server.qualitygate.RegisterQualityGates.lambda$updateQualityConditionsIfRequired$3(RegisterQualityGates.java:131)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
at org.sonar.server.qualitygate.RegisterQualityGates.updateQualityConditionsIfRequired(RegisterQualityGates.java:131)
at org.sonar.server.qualitygate.RegisterQualityGates.start(RegisterQualityGates.java:102)
at org.sonar.core.platform.StartableCloseableSafeLifecyleStrategy.start(StartableCloseableSafeLifecyleStrategy.java:40)
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:47)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup$1.doPrivileged(PlatformLevelStartup.java:83)
at org.sonar.server.user.DoPrivileged.execute(DoPrivileged.java:46)
at org.sonar.server.platform.platformlevel.PlatformLevelStartup.start(PlatformLevelStartup.java:80)
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.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Implicit conversion from data type varbinary to datetime2 is not allowed. Use the CONVERT function to run this query.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
at org.apache.ibatis.executor.ReuseExecutor.doUpdate(ReuseExecutor.java:52)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
… 31 common frames omitted
2020.07.13 16:21:03 INFO web[o.s.p.ProcessEntryPoint] Hard stopping process
2020.07.13 16:21:03 INFO web[o.s.s.n.NotificationDaemon] Notification service stopped
