Report Builder - LQE data source error - unauthorized user

Andy S (11●2) | asked Feb 02 '18, 9:12 a.m.
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

2 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Ben Shade (1●1) | answered Feb 05 '18, 9:33 a.m.
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?

Comments

Ralph Schoon commented Feb 05 '18, 9:49 a.m.

FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

You should consider contacting support.

Kenji Sarai commented 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) | answered 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

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

Report Builder - LQE data source error - unauthorized user

2 answers

Your answer