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

Article Id: 140742
Status: Published
Updated On: 25-11-2019 08:52
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.