It's all about the answers!

Ask a question

Error connecting to the server using RQMExcellImporter


Ana Lopez-Mancisidor (25648967) | asked May 25 '12, 2:06 p.m.
JAZZ DEVELOPER
Hi,

I am trying to use RQMEXcellImporter Utility to import an Excel file directly into RQM repository but I am not able to validate RQM Server.

I have tried https://<hostname>:9443/qm as the RQMServer name and enter a valid username and password (I can enter through the web browser without problems) but when clicking the validate button I receive the window error Validate credentials with following error:

Invalid server, username or password!

Any idea to solve the issue and connect to the RQM Server? I am using RQM 3.0.1.2 with corresponding version of RQMExcellImporter utility addin as Excel macro

Thanks,

6 answers



permanent link
Paul Slauenwhite (8.4k12) | answered May 28 '12, 7:57 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
I would recheck your username/password. If correct, check your public URI at https://<hostname>:9443/qm/admin. Are there any unique characters in the hostname/username/password?

permanent link
Ana Lopez-Mancisidor (25648967) | answered May 28 '12, 9:45 a.m.
JAZZ DEVELOPER
Hi Paul, I am using the IBM cloud (with default CLM solution installed) so I have checked the public URI "Trusted client authorization URIs" value and and the current value by default installation is blank.

So I assume this is the problem, because testing the same Excel Import utility with another RQM instance which has a value for the public URI works.

Can I add manually a value for the public URI to have the Excel import utility working? The customer is evaluating the CLM solution using this public cloud and I don't want to break the installation adding manually this value to the public URI. Changing this value would have any other collateral effect and other functionalities of the CLM solution may stop working?

Thanks,

Ana

permanent link
Paul Slauenwhite (8.4k12) | answered May 28 '12, 11:14 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
Yes, that may be the issue. However, it appears the RQM Excel/Word Importer does not fully support RQM cloud deployments. You can open a RQM defect (https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.newWorkItem).

permanent link
Hao Wan (1.5k35) | answered May 28 '12, 10:04 p.m.
JAZZ DEVELOPER
Hi Ana,
would you please give us a IBM cloud link with CLM solution installed? so we can take a look to see if there can be some work around for you currently.

Hi Paul, I am using the IBM cloud (with default CLM solution installed) so I have checked the public URI "Trusted client authorization URIs" value and and the current value by default installation is blank.

So I assume this is the problem, because testing the same Excel Import utility with another RQM instance which has a value for the public URI works.

Can I add manually a value for the public URI to have the Excel import utility working? The customer is evaluating the CLM solution using this public cloud and I don't want to break the installation adding manually this value to the public URI. Changing this value would have any other collateral effect and other functionalities of the CLM solution may stop working?

Thanks,

Ana

permanent link
Ana Lopez-Mancisidor (25648967) | answered May 29 '12, 6:14 a.m.
JAZZ DEVELOPER
I have sent you a separate email with link, user and password details to access the IBM cloud with the CLM solution installed due to confidential reasons.

Thanks,

Ana

permanent link
Paul Slauenwhite (8.4k12) | answered May 29 '12, 7:02 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
To close out this thread, https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/68272 was opened but resolved as 'works for me' using the RQM 3.0.1.3 Excel/Word Importer.

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.