RQMExcelImporter: Not populating Project list
Hi,
I am using RQM Excel Importer tool and can see this in Excel Add-ins. After validating the credentials, Project list doesn't populate.
Related info:
- MS Excel 2013
- RQMExcelImporterSetupX64ForDotNET45
- RQM 6.0.6 (iFix004)
- Windows 10
- The user has JazzUser group, its role has permissions to Import XML-> Post and it's member in project area.
This is Mso2Rqm_Debug.log details:
1/9/2019 10:15:37 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands
1/9/2019 10:15:37 AM: INFO: <Unknown Caller Context>: caption : RQM
1/9/2019 10:15:37 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands
1/9/2019 10:16:48 AM: ERROR: <Unknown Caller Context>: failed to get from server: The request was aborted: Could not create SSL/TLS secure channel.
1/9/2019 10:16:48 AM: ERROR: <Unknown Caller Context>: RQMConnector: Login - Error POSTing credentials to https://xxxxx/qm
1/9/2019 10:16:48 AM: EXCEPTION: : Object reference not set to an instance of an object.
1/9/2019 10:16:48 AM: at Mso2Rqm_Common.RQMConnector.Login(String url, String username, String password)
1/9/2019 10:15:37 AM: INFO: <Unknown Caller Context>: caption : RQM
1/9/2019 10:15:37 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands
1/9/2019 10:16:48 AM: ERROR: <Unknown Caller Context>: failed to get from server: The request was aborted: Could not create SSL/TLS secure channel.
1/9/2019 10:16:48 AM: ERROR: <Unknown Caller Context>: RQMConnector: Login - Error POSTing credentials to https://xxxxx/qm
1/9/2019 10:16:48 AM: EXCEPTION: : Object reference not set to an instance of an object.
1/9/2019 10:16:48 AM: at Mso2Rqm_Common.RQMConnector.Login(String url, String username, String password)
Could you help with this issue, please?
Thanks.
3 answers
Veronica Alvarado,
In addition to Don's suggestion, please check the user getting logged in is having access to the projects - otherwise it might not list any other project area (In RQM Web UI's dashboard, project which are listed under ''My Projects' will get listed in Excel Addin UI).
Regards,
Mehul
Comments
Hi Mehul,
My user has access to one project area but he has JazzUser group assigned.
I tried using a JazzAdmin group and it's work, however most CLM users have JazzUser assigned.
Only users with JazzAdmin can export?
Thanks.
Veronica Alvarado,
If you are still seeing the issue, I would suggest to check the user's license.
Regards,
Mehul
Veronica Alvarado,
No, user need not to be part of JazzAdmin, even user from JazzUser could list the projects in addin UI. The only condition here is the logged-in user should have access to the projects. When you logged in to RQM WebUI and at dashboard if you see the project listed under 'My Projects' then for that user you will get these projects listed in list box after authentication.
Regards,
Mehul
Comments
Don Yang
Jan 10 '19, 12:12 a.m.You installed
RQMExcelImporterSetupForDotNET45 instead (supposed you need to support TLS1.2)
RQMExcelImporterSetup.exe (for 32bit Excel 2013)
Veronica Alvarado
Jan 10 '19, 2:45 p.m.