It's all about the answers!

Ask a question

Problem - CRJAZ1185W/CRJAZ2333W Error while performing server rename in RM application


Sunil Deshpande (139) | asked May 24 '21, 11:26 p.m.

  

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



permanent link
David Honey (1.8k17) | 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


Register or to post 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.