It's all about the answers!

Ask a question

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

Sunil Deshpande (137) | 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.

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.