TDMEventService error - Invalid object name 'event'

Products

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

Issue/Introduction

TDMEventService.log has below SQL exception. How to resolve this.

2021-09-30 08:35:19.944 UTC [WARN ] [https-openssl-nio-8443-exec-20] --- [U:][M:][P:]                      o.h.e.j.s.SqlExceptionHelper:  SQL Error: 208, SQLState: S0002
2021-09-30 08:35:19.944 UTC [ERROR] [https-openssl-nio-8443-exec-20] --- [U:][M:][P:]                      o.h.e.j.s.SqlExceptionHelper:  Invalid object name 'event'.
2021-09-30 08:35:19.944 UTC [ERROR] [https-openssl-nio-8443-exec-20] --- [U:][M:][P:]                 o.h.i.ExceptionMapperStandardImpl:  HHH000346: Error during managed flush [org.hibernate.exception.SQLGrammarException: could not execute statement]
2021-09-30 08:35:19.944 UTC [ERROR] [https-openssl-nio-8443-exec-20] --- [U:][M:][P:]              c.c.t.e.c.CustomRestExceptionHandler:  Internal server error
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'event'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)

Environment

All supported releases of TDM

Cause

There was a sequence named "event" in the GTREP DB that was conflicting with the "event" table and didn't let the table get created and was causing the error in TDMEventService log and startup log for events.

Resolution

Deleted the "event" sequence and created "event" table. Stop TDMPortalService, clear the logs folder and start the TDMPortalService again.