Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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>

0 votes



One answer

Permanent link

I suggest you contact technical support. It's unlikely anyone will be able to resolve this based on the information you have provided.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,495
× 1,700
× 1,325
× 158

Question asked: May 24 '21, 11:26 p.m.

Question was seen: 1,338 times

Last updated: May 25 '21, 5:30 a.m.

Confirmation Cancel Confirm