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
One answer
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