It's all about the answers!

Ask a question

Error connecting LQE to a doors data source


Richard Good (77734) | asked Nov 24 '16, 6:02 a.m.

Hello,

Hoping someone can help, as I have been stuck in a loop for hours. I am trying to collect some doors data using doors web access as an intermediary

CRLQE0353E Data source (LQE Functional User) is asking for authentication for the requested resource. Please check your OAuth configuration for this data source.

Unauthorized (401)
I have added the local key to doors and altered the festival.xml file and added the datasource as described in the following two links. I have ensured all the processes are up, but no dice. Any ideas why, places to look for a solution? I am a bit worried by the dwa address being http and the following setting in the festival.xml file
<f:property name="ForceHttpsForAuthenticationForOAuth" value="true"/>
I have tried setting that to both false and true but it doesn't work. Also, the trusted connection tick box within DOORS in the Registered OAuth Consumer dialog is greyed out and not selectable, not sure If that is an issue?
I have raised a case with IBM, but the correct answer has not arrived yet.
Thanks for any help
Richard

Accepted answer


permanent link
John Carolan (71616) | answered Nov 24 '16, 7:20 a.m.
Hi Richard,

You should definitely set <f:property name="ForceHttpsForAuthenticationForOAuth" value="false "/> if DWA isn't running in secure mode, and make sure to restart DWA after saving that change.  If you haven't already seen this video on IBM DeveloperWorks, it might be useful to step through it to see if it matches what you're doing.

https://www.ibm.com/developerworks/community/blogs/iotsupport/entry/How_to_index_DOORS_9_6_artifacts_in_Lifecycle_Query_Engine?lang=en

One more thing to check is the Derby database port.  Sometimes the default port number (1527) is grabbed by something else - so it might be worth stopping Derby, seeing the port is still in use with a 'netstat' and if it is, reset the Derby port to something free.  You'd need to update that port in all these files:

<DWA_HOME>\server\festival\config\festival.xml:
<DWA_HOME>\derby.start.bat:
<DWA_HOME>\derby\derby.properties:
<DWA_HOME>\derby\scripts\init_setting.bat:

and restart DWA.  That's all I can think of - if that doesn't help then the Support guys should be able to figure it out.

John
Richard Good selected this answer as the correct answer

Comments
Richard Good commented Nov 24 '16, 9:18 a.m.

Hi John

Your video is a great deal clearer than the two articles I refer to. Things like adding the DOORS user and making sure the password is the same as in the festival file are not mentioned explicitly in the article, probably because they are considered obvious. I think I had it right at one point, but it ended up as lqe_user, which is the internal lqe user in jazz rather than "LQE Functional User". That and the article telling me to put <f:property name="ForceHttpsForAuthenticationForOAuth" value="true"/> which is clearly wrong meant I stood no chance.

Logging on to DWA directly with LQE Functional User is also good advice, not sure but I may have got hung up behind the scenes on the update password on first logon dialog. Many thanks for your help

Richard


Richard Good commented Nov 25 '16, 3:57 a.m.

Hi John,

Don't suppose you can provide some example SPARQL to return in a query all the DOORS requirements collected from the DOORS classic data source, but none of the DNG or Design Manager ones. LQE tells me it has successfully collected all the DOORS database, but I'm not sure I believe it. I run the Requirement custom artefact element query and it picks up all other requirements, but no DOORS ones, well as far as I can see. As a SPARQL novice I think, but am not sure that the standard requirement query should collect all DOORS requirements. Can you enlighten me please

Richard


John Carolan commented Nov 25 '16, 8:07 a.m.

I'm not much of a SPARQL guru I'm afraid, but I posted something basic which should work in your question: https://jazz.net/forum/questions/231558/lqe-query-to-pick-up-all-requirements-collected-from-doors?page=1&focusedAnswerId=231603#231603

Your answer


Register or to post your answer.