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

Is possible to update RequisitePro URL association after RQM data is migrated?

All,

I have RQM 2.0.1 running on RQMServerA. It is integrated with RequsitePro via the ReqWeb service which is set up on the same server RQMServerA. The URL for accessing ReqPro documents from within RQM is http://RQMServerA:11080. I am migrating RQM 2.0.1 data to RQM 3.0.1 which is set up on a different server, RQMServerB (RTC, JTS and CCM 3.0.1 are also installed on RQMServerB along with RQM). I will be taking RQMServerA offline, hence I have also set up the ReqWeb service on RQMServerB. After I migrated the data to RQM v3.0.1, the URL for all of the existing artifacts is still pointing to http://RQMServerA:11080, but I need to change this to http://RQMServerB:11080, since I am also planning to move the ReqWeb service to RQMServerB. I need to update the ReqPro URL for all of my existing artifacts in the migrated DB, so that the URL points to http://RQMServerB:11080. has anyone encountered this scenario? If yes, how can I update the reference/association for all of the existing items in the RQM schema? The DB schema is set up in Oracle 10g. I took a quick look at the tables in the RQM schema, but given their large volume, I am not sure which table(s)  contain the reference to the RequisitePro URL.

If it's a simple matter of identifying the relevant tables in the schema and running a SQL update query, I was wondering if someone can point me in the right direction, as it would be a big help.

Thanks,

Kevin

0 votes



One answer

Permanent link
Unfortunately, this requires a server rename since the ReqPro URL is referenced in RQM test artifacts.  However, server rename is only supported in CLM 4.0+ (see http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/topic/com.ibm.jazz.install.doc/topics/c_redeploy_server.html).

0 votes

Comments

Hi Paul,

Thank you for the reply and for the info. The good news is, I am planning to upgrade to CLM 4.0.3. I’d like to make a small precision though: I am not planning to rename the CLM server or the ReqPro server, so I am not sure how I can benefit from the server rename feature. I need to rename the embedded URL in RQM, specifically when a user clicks on the requirements document link of a test artifact from within RQM. Since I did an upgrade from RQM 2.0.1 to RQM 3.0.1 (and planning to upgrade to CLM/RQM 4.0.3), the existing link points to the ReqWeb service on RQMServerA. Since RQMServerA is going to be decommissioned, I need to update this embedded link and point it to the ReqWeb service on RQMServerB. I am hoping that there is a simple process to change this reference for all of my existing test case artifacts.

Thanks,

Kevin <o:p> </o:p>

Hi Kegham,

The only way to change these embedded ReqPro URLs in RQM is through server rename.  You would not be renaming the public URL of the CLM server but rather the public URL of the ReqPro server. For example (see http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.jazz.install.doc/topics/c_server_rename_map_file.html):

source=http://RQMServerA:11080
target=http://RQMServerB:11080

Hi Paul,

Thank you again for your input on this question, and my apologies for the belated reply. I was hoping for the chance to run my upgrade to CLM v 4.0.x. Given the current pace of the migration initiative, it might be a week or two before I will be able to give the server rename a try. I will keep you posted on how it goes.

Kevin

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,484
× 6,117
× 1,381

Question asked: Jan 20 '14, 7:07 p.m.

Question was seen: 5,547 times

Last updated: Feb 03 '14, 5:54 p.m.

Confirmation Cancel Confirm