Problem - CRJAZ1185W/CRJAZ2333W Error while performing server rename in RM application
Hello, <o:p> </o:p>
Server rename activity on CLM 605 with MS SQL server 2014 (Both OS Windows server 2016) <o:p> </o:p> /ccm, /qm completed 100 % but RM still in process and status 20 %. <o:p> </o:p>
As per SQL DB below query in process. <o:p> </o:p> <?query -- <o:p> </o:p> update REPOSITORY.QUERYABLE_JPI_MAPPING set URL = ( select top 1 rtrim(t2.NEW_URL + substring(t1.URL, len(t2.OLD_URL)+1, len(t1.URL)-len(t2.OLD_URL))) from REPOSITORY.QUERYABLE_JPI_MAPPING t1, REPOSITORY.MAPPING_EVENT_URL_CHANGES t2 where REPOSITORY.QUERYABLE_JPI_MAPPING.URL_SHA1 = t1.URL_SHA1 and REPOSITORY.QUERYABLE_JPI_MAPPING.URL = t1.URL and t2.JZ_PARENT_ID = '_Czp7wLbaEeu-g54cwhGK7A' and ((t1.URL_TRUN like t2.OLD_URL + '/%') or (t1.URL_TRUN like t2.OLD_URL)) order by t2.JZ_POSITION ) where exists ( select 1 from REPOSITORY.QUERYABLE_JPI_MAPPING t1, REPOSITORY.MAPPING_EVENT_URL_CHANGES t2 where REPOSITORY.QUERYABLE_JPI_MAPPING.URL_SHA1 = t1.URL_SHA1 and REPOSITORY.QUERYABLE_JPI_MAPPING.URL = t1.URL and t2.JZ_PARENT_ID = '_Czp7wLbaEeu-g54cwhGK7A' and ((t1.URL_TRUN like t2.OLD_URL + '/%') or (t1.URL_TRUN like t2.OLD_URL)) ) <o:p> </o:p> --?> <o:p> </o:p>
Please provide solution on same. <o:p> </o:p> |
One answer
David Honey (1.8k●1●7)
| answered May 25 '21, 5:30 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I suggest you contact technical support. It's unlikely anyone will be able to resolve this based on the information you have provided.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.