TDMEventService error - Invalid object name 'event'
search cancel

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)

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.