ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

TDMEventService error - Invalid object name 'event'


Article ID: 225503


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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 Invalid object name 'event'.


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.


Release : 4.9

Component :


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