DevTest 9.0 with MS Sqlserver Configuration issue

Article Id: 40546

Status: Published

Updated On: 14-02-2018 07:46

Legacy Id: TEC1069217

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