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)
All supported releases of TDM
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.
Deleted the "event" sequence and created "event" table. Stop TDMPortalService, clear the logs folder and start the TDMPortalService again.