search cancel

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


Article ID: 227211


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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


Release : 4.9.1

Component : TDM Web Portal


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 null
 at org.springframework.cglib.proxy.MethodProxy.invoke(
 at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(
 at org.springframework.cglib.proxy.MethodProxy.invoke(
 at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
 at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(
 at sun.reflect.GeneratedMethodAccessor1877.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(
 at java.lang.reflect.Method.invoke(



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.



1637358707870__alter_sequence_mssql.sql get_app
1637358681955__alter_sequence_oracle.sql get_app