Issue/Problem/Symptoms:
We have configured Devtest 9.0 with external database (MS SQL server) by adding required details in dradis.properties file and while starting Enterprise Dashboard, ED is not started properly.
Environment:
Devtest 9.0
Database: MS SQL 2008 Server
Cause:
We noticed below error in enterprisedashboard.log file. Even though database is empty and having DBA privileges noticed this error. We have added few external jars (sqljdbc4.jar, sqljdbc4-0.jar) and few LDAP jars after installation of Devtest 9.0
2016-03-29 07:07:51,421Z (15:07) [main] INFO System.out - Enterprise Dashboard Exception Found non-empty schema [dbo] without metadata table! Use baseline() or set baselineOnMigrate to true to initialize the metadata table.
2016-03-29 07:07:51,421Z (15:07) [main] ERROR System.err - org.flywaydb.core.api.FlywayException: Found non-empty schema [dbo] without metadata table! Use baseline() or set baselineOnMigrate to true to initialize the metadata table.
Resolution/Workaround:
We removed all external jars and also deleted sql driver jars which are added manually (because, Devtest already has sqljdbc driver jar in <Devtest_home>/lib/shared folder) and restarted Enterprisedashboard. Now, ED is started fine and then we added required external LDAP, MQ jar files.