DevTest 9.0 with MS Sqlserver Configuration issue

Products

• CA Application Test
• Service Virtualization
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

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.

Environment

Release:
Component: ITKOTF