Error message in TDM Portal when creating a new project of type "Upgrade version"

Products

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

Issue/Introduction

On the TDM portal, we sometimes get an error message when we want to create a new project of type "Upgrade version".

See attachments for more information

TDM portal version 4.9.356

Cause

From the TDMProjectService.log:

 

2021-10-06 12:22:37.630 UTC [ERROR] [https-openssl-nio-8443-exec-10] --- [U:<<USER_ID>> ][M:POST][P:/api/ca/v1/projects/9972/versions/]                c.c.t.s.s.EventSubscriptionService:  Error during subscriber notification : DATARESERVATION_SERVICE : User <<USER_ID>> does not have permissions to perform this operation.
2021-10-06 12:22:37.630 UTC [INFO ] [https-openssl-nio-8443-exec-10] --- [U:<<USER_ID>> ][M:POST][P:/api/ca/v1/projects/9972/versions/]                c.c.t.s.s.EventSubscriptionService:  Rolling back on notified subscribers
2021-10-06 12:22:37.630 UTC [ERROR] [https-openssl-nio-8443-exec-10] --- [U:<<USER_ID>> ][M:POST][P:/api/ca/v1/projects/9972/versions/]                       c.c.t.p.c.VersionController:  Failed to copy version data from 9973 for projectId 9972
com.ca.tdm.serviceEventSubscription.common.SubscriberException: null
 at com.ca.tdm.serviceEventSubscription.service.EventSubscriptionService.notifySubscriber(EventSubscriptionService.java:268)
 at com.ca.tdm.serviceEventSubscription.service.EventSubscriptionService.eventOccured(EventSubscriptionService.java:150)
 at com.ca.tdm.projects.service.VersionService.notifyCopyProjectVersionListeners(VersionService.java:837)
 at com.ca.tdm.projects.service.VersionService$$FastClassBySpringCGLIB$$f39c6cb6.invoke(<generated>)
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
 at com.ca.tdm.projects.service.VersionService$$EnhancerBySpringCGLIB$$9df87625.notifyCopyProjectVersionListeners(<generated>)
 at com.ca.tdm.projects.controller.VersionController.create(VersionController.java:231)
 at com.ca.tdm.projects.controller.VersionController$$FastClassBySpringCGLIB$$f811b622.invoke(<generated>)
 at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
 at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
 at com.ca.tdm.security.SecurityAccessManager.checkAccess(SecurityAccessManager.java:145)
 at sun.reflect.GeneratedMethodAccessor1877.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)

...

Environment

Release : 4.9.1

Component : TDM Web Portal

Resolution

Your user <<USER_ID>> does not have Admin Privileges .  Assign him to an Admin group so he can do the work.  The additional issue was that future work on the projects were not copied.  This has been corrected:

Our solution from the Developers:
************************************************

This problem is related to constraint violations.

Follow the script to fix the defect.

The file ending with mssql is to run if the customer are using SQL Server.
The file ending with oracle is to run if the customer are using Oracle.

You don’t need to run all of them, just 1 according with GTREP database. 

Before you start to run, please stop the portal, to force the portal to get the fresh values.

PS.: We have already an US to take care of root cause of this issue.

************************************************

I have attached both scripts for completeness sake to the article.  

DE517007 Converted to UserStory US790124 as a lot more work is needed to make upgrade version production ready.