Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Report Builder - LQE data source error - unauthorized user

Questions
Tags
Users
Badges
Andy S
(11●2) edited
Feb 02 '18, 9:37 a.m.
Please excuse me if my terminology is slightly off - I'm approaching this build from a WAS-experienced side and don't have much experience with the Rational side.

JTS: 6.0.5
WAS: 8.5.5.12

We have an LQE data source in JTS that looks fine on its own, but we cannot set it as a data source within Report Builder. When i click Test Connection I get a 401 error. Unauthorized User:

Substatus: CRRGW5502E
Detailed message: CRRGW5502E Authorization is required. You are not authorized to access the URL: {0}.

I am logged on as 'clmadmin' in JazzAdmins group
The data source has Authorization type: Jazz Team Server
I have checked the Authorization consumer key and secret for jrs_user 

I have checked jrs_user is an authorized user in the LQE data source access control permissions. I have even tried adding 'everyone' as an authorized group for the entier LQE Index in Permissions.

The CRRGW5502E error is reflected in the rs.log


Additional. If I hit the (built-in) refresh button on the datasource page (rs -> data sources) I get a red box with

Unauthorized user, CRRGW5109E Authorization information is missing from the request or from the Jazz Reporting Service authorization., The loading of the metamodel for this data source failed. Please see the log file. <time>


I'm at a loss where else to check, or what else to try. Any help or guidance would be gratefully received.

Thanks, Andy

1

0 votes

2 answers
2,626 views
0 votes

2 answers

Permanent link
Ben Shade
(1●1) edited
Feb 05 '18, 9:34 a.m.

Update:

Changed to Authorisation Jazz Security Architecture SSO, and the gui page all goes 'green' but the log is still kicking off:
 [             WebContainer : 21] ERROR integration.reporting.data.query.SparqlQueryRunner  - CRRGW5502E Authorization is required. You are not authorized to access the URL: https://............/lqe/sparql.

[             WebContainer : 21] ERROR team.integration.reporting.model.services.Endpoint  -
java.lang.IllegalStateException: SRVE0199E: OutputStream already obtained
        at com.ibm.ws.webcontainer.srt.SRTServletResponse.getWriter(SRTServletResponse.java:836)
        at com.ibm.team.integration.reporting.model.services.Endpoint.testConnection(Endpoint.java:700)
        at com.ibm.team.integration.reporting.model.services.Endpoint.doGet(Endpoint.java:135)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
....

Any thoughts?

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Feb 05 '18, 9:49 a.m.

You should consider contacting support.

Kenji Sarai
Feb 06 '18, 1:00 a.m.

I am investigating similar "Unauthorized user" error in Report Builder, but with data warehouse data source. In this environment, this error happens about 1 minute after the login, regardless of what operation is done in Report Builder. Is this the same symptom as yours?

I will keep you updated if I find something new.

Permanent link
Ben Shade
(1●1) Feb 06 '18, 9:41 a.m.

So we are not sure, but we have it working (most of the time).
We believe it is related to licensing, but even so we think all the underlying processes are working and we can get the users to work as well (by adding/removing licenses) and logging out and in again. In our case the Authorasation must be using SSO (as this is what is setup)

Conclusion: We have it now working 'enough'
Summary: No underlying processes have a known issue, and most of the time the GUI also works for most admin users and we have a fix when they don't

0 votes

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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,486

Question asked: Feb 02 '18, 9:12 a.m.

Question was seen: 2,626 times

Last updated: Feb 06 '18, 9:41 a.m.

Related questions
Confirmation Cancel Confirm