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