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

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.