TDMEventService error - Invalid object name 'event'

book

Article ID: 225503

calendar_today

Updated On:

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)

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.

Environment

Release : 4.9

Component :

Resolution

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