The 4.8.1 TDM Portal does not start (org.flywaydb.core.api.FlywayException)

book

Article ID: 140742

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Installed TDM 4.8.1 on Oracle 12c  Database  and NOT using default tablespace as users.

After installing the TDM portal, when they try to start the service, after some seconds the service goes down, and we see at the log files the error below:

Command to give the gtrep permission 
alter session set "_ORACLE_SCRIPT"=true;
create user gtrep identified by <<TDM USER PASSWORD>> default tablespace users;
 
We are NOT able to install the TDM Portal, getting below error.  It is searching the default tablespace users
2019-11-20 22:21:06.503 UTC [INFO ] ---                           o.f.c.i.u.VersionPrinter:  Flyway 4.2.0 by Boxfuse
2019-11-20 22:21:06.519 UTC [INFO ] ---                         o.f.c.i.d.DbSupportFactory:  Database: jdbc:oracle:thin:@//scan-oradesbr01.extra.caixa.gov.br:1521/ORADES89 (Oracle 12.2)
2019-11-20 22:21:07.237 UTC [ERROR] ---                               c.ca.tdm.schema.Main:  Migration failed: 'FlywayException: Validate failed: Detected failed migration to version 4.6.0.0 (tables)'
org.flywaydb.core.api.FlywayException: Validate failed: Detected failed migration to version 4.6.0.0 (tables)
    at org.flywaydb.core.Flyway.doValidate(Flyway.java:1065)
    at org.flywaydb.core.Flyway.access$100(Flyway.java:72)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:975)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:971)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1464)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:971)
    at com.ca.tdm.schema.SchemaMigrator.migrate(SchemaMigrator.java:90)
    ... 2 common frames omitted
Wrapped by: com.ca.tdm.schema.ProcessingException: Migration failed: 'FlywayException: Validate failed: Detected failed migration to version 4.6.0.0 (tables)'
    at com.ca.tdm.schema.SchemaMigrator.migrate(SchemaMigrator.java:92)
    at com.ca.tdm.schema.Main.run(Main.java:92)
    at com.ca.tdm.schema.Main.main(Main.java:55)
2019-11-20 22:21:07.237 UTC [ERROR] ---                               c.ca.tdm.schema.Main:  Check log file C:\ProgramData\CA\CA Test Data Manager Portal\logs\TDMSchemaManagementStartup.log

Cause

In TDM, USERS tablespace is hardcoded and cannot be changed

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

We do not support other table spaces. Use the default USER table space.