RQMExcelImporter Error: Invalid user / Pwd / URI

Rajesh Avanthi (108●15●145●173) | asked Apr 10 '14, 1:48 p.m.

Basically, one of my client is working on Win7 64 bit machine and has MS Office 10 (64 bit installed). on this machine they are able to access the RQM URI via web browser and access project areas.

However when they invoke the Excel add-in and specify the same URI (even tried specifying IP address of RQM server m/c) they see an error : Invalid user or pwd or URI, though the same credentials are working fine via web.

We tried disabling the firewall, Antivirus and spyware as well with no much help..
Interstingly... the same set of credentials and URI is working fine on other Win7 64 bit machine.

Any inputs on what went wrong on this specific machine..

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Don Yang (7.7k●21●114●139) | answered Apr 10 '14, 7:30 p.m.


	There are a couple of things you can check with:
	

	

	1) Whether you installed 64 bit ExcelImporter for your 64 bit MS Office2010.
	

	2) If you use 4.x RQM, whether you have latest version of ExcelImporter installed(compatible to any version of v4.x RQM).
	

	3) Would add URI/IP mapping to the client's host file help?
	

	4) Running nslookup against the server from the problem client and see if it provides more info or not
	

	5) Click on Validate on the dialog when entering the credentials and URI and see if it provides more info
	

	6) Check with C:\Users\<USER>\AppData\Roaming\Mso2Rqm  and see if more details are provided on the error.
	

	7) This problem could be quite hard to get to the root cause(you have checked antivirus, firewall, accessing to same URI in browser etc), please consider to contact support and see further troubleshooting can be done.

Comments

Rajesh Avanthi commented Apr 11 '14, 3:00 a.m. | edited Apr 11 '14, 3:06 a.m.

Thanks
Environment details:
===================
Win 7 64 bit machine
RQMExcelImporter installed in 64 bit mode.
UAC is disabled
Win Firewall is disabled...
Version of MS excel is 14.0.6023.1000(64-bit).
Office Primary Interop Assemblies for Office 10 is installed with .net framework 4 on this machine. Launched MS Excel and clicked "Addin" >> "Export to Repository".

Specified the url: https://rmcoutotec.testingsupport.com:9443/qm
Username and pwd specified correctly

The same set of credentials are working fine from Web UI... However from Excel, after specifying this and clicking on "Validate".. the following error occurs..

"====== Invalid server, user name or password! =========
Debug logs shows the below:
4/11/2014 11:55:56 AM: INFO: <Unknown Caller Context>: The
remote server returned an error: (407) Proxy Authentication
Required. 4/11/2014 11:55:56 AM: EXCEPTION: : The remote server returned an error: (407) Proxy Authentication Required.

Don Yang commented Apr 12 '14, 4:55 a.m.

ExcelImporter itself does not have function to handle proxy authentication. It seems that your browser may have proxy enabled such as using proxy configuration script. Can you please have a check with your browser and disable proxy configuration script or any proxy used and make sure it still work(using the same browser to access to RQM server) and then try to use excelImporter again and see if it works or not? Thanks

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.

It's all about the answers!

Related questions

RQMExcelImporter Error: Invalid user / Pwd / URI

One answer

Your answer