Error deleting an Excel object in the portal 4.9

Products

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

Issue/Introduction

Hello, 

1st case :

I created a project with no environment, data model, object and data generator. In this project, I registered new objects: CSV file and no data importation. Afterwards, delete the object without any problem.

2nd case :

I created another project in which I registered 2 new objects: CSV file and no data importation. On the other hand, I can't delete the objects.

 

 Below an extract from the TDMModelService.log file (with the error message) and a print screen of the objects.

2020-04-23 08:49:05.327 [INFO ] [https-openssl-nio-8443-exec-10] --- [U:dmw1318][M:DELETE][P:/api/ca/v1/objects]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 272, Module: TDM_SHREDDER, Started Calculating Table Order for  Derived Tables

2020-04-23 08:49:05.353 [INFO ] [https-openssl-nio-8443-exec-10] --- [U:dmw1318][M:DELETE][P:/api/ca/v1/objects]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 272, Module: TDM_SHREDDER, Completed Calculating Table Order  Derived Tables

2020-04-23 08:50:02.733 [INFO ] [https-openssl-nio-8443-exec-15] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3969, Module: TDM_SHREDDER, Started Saving Table Order for  FD  Tables

2020-04-23 08:50:02.739 [INFO ] [https-openssl-nio-8443-exec-15] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3969, Module: TDM_SHREDDER, Started Saving Table Order for  FD Tables

2020-04-23 08:50:14.276 [INFO ] [https-openssl-nio-8443-exec-17] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3971, Module: TDM_SHREDDER, Started Saving Table Order for  FD  Tables

2020-04-23 08:50:14.281 [INFO ] [https-openssl-nio-8443-exec-17] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3971, Module: TDM_SHREDDER, Started Saving Table Order for  FD Tables

2020-04-23 08:50:18.605 [INFO ] [https-openssl-nio-8443-exec-18] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                         c.c.t.m.o.s.ObjectService:  Invoking job at:https://<<SERVER_NAME>>:8443/TDMJobService/api/ca/v1/jobs

2020-04-23 08:50:18.798 [INFO ] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3976, Module: TDM_SHREDDER, Started Calculating Table Order for  Derived Tables

2020-04-23 08:50:18.822 [INFO ] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3976, Module: TDM_SHREDDER, Started Saving Table Order for  FD  Tables

2020-04-23 08:50:18.823 [INFO ] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3976, Module: TDM_SHREDDER, Started Saving Table Order for  FD Tables

2020-04-23 08:50:18.823 [INFO ] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                   c.c.t.m.o.s.TableOrderGenerator:  RequestID: 3976, Module: TDM_SHREDDER, Completed Calculating Table Order  Derived Tables

2020-04-23 08:50:18.826 [WARN ] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                      o.h.e.j.s.SqlExceptionHelper:  SQL Error: 1407, SQLState: 72000

2020-04-23 08:50:18.826 [ERROR] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                      o.h.e.j.s.SqlExceptionHelper:  ORA-01407: cannot update ("GTREP_NEXT"."GTREP_TABLE_ORDER"."RTO_TAG") to NULL

 

2020-04-23 08:50:18.826 [ERROR] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]                 o.h.i.ExceptionMapperStandardImpl:  HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute statement]

2020-04-23 08:50:18.831 [ERROR] [https-openssl-nio-8443-exec-22] --- [U:dmw1318][M:POST][P:/api/ca/v1/objects/actions/delete]              c.c.t.c.e.h.GlobalExceptionConvertor:  HTTP Error - INTERNAL SERVER ERROR: Exception: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

java.sql.SQLException: ORA-01407: cannot update ("GTREP_NEXT"."GTREP_TABLE_ORDER"."RTO_TAG") to NULL

  

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

TDMWeb-4.9.40.0.zip resolves this issue.  Please contact Broadcom Support if you need this fix.