TDM Portal Service not starting

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Installed TDM version 4.10 but TDM Portal service is failing with below error in the TDMSchemaManagementStartup log

SEVERE: Schema migration failed with exit code '4'.
com.ca.tdm.tomcat.ProcessingException: Schema migration failed with exit code '4'.

Environment

TDM 4.10.x

Cause

The Oracle GTREP user was created with insufficient privileges. 

Resolution

Tried to create the GTREP user manually using the DB install utility but didn't work due to issues with sys user usage in the command syntax.

Used below statements to create the GTREP user and started TDM Portal service which started fine with any errors.

====================================================================

CREATE USER GTREP IDENTIFIED BY "Password";

GRANT CONNECT, RESOURCE TO GTREP;
GRANT CREATE ANY DIRECTORY, SELECT ANY TABLE, CREATE VIEW TO GTREP;
GRANT UNLIMITED TABLESPACE TO GTREP;

GRANT CREATE ANY INDEX TO GTREP;
GRANT CREATE CLUSTER TO GTREP;
GRANT CREATE INDEXTYPE TO GTREP;
GRANT CREATE OPERATOR TO GTREP;
GRANT CREATE PROCEDURE TO GTREP;
GRANT CREATE SEQUENCE TO GTREP;
GRANT CREATE SESSION TO GTREP;
GRANT CREATE TABLE TO GTREP;
GRANT CREATE TRIGGER TO GTREP;
GRANT CREATE TYPE TO GTREP;
GRANT CREATE VIEW TO GTREP;
GRANT SELECT ANY DICTIONARY TO GTREP;

=====================================================================