Unable to use Jazz Reporting Service report from Rational Publishing Engine
I created a report in Jazz Reporting Service and could run it successfully. Then I exported the document template and document definition for Rational Publishing Engine (using Export > Export the report to Rational Publishing Engine), imported it in RPE Launcher and configured the data source user name, password and the output path.
When trying to generate the report, the report is not generated and the following error message is displayed in the console.
Note: I could not import the report definition generated by JRS into RPE 1.3. However, when manually creating the RPE report using the JRE report both in RPE 1.2.1 and 1.3 I get the same problem.
Hunch: already in the Jazz server one component is authenticating against the other. This involves invoking several URLs one after the other. When assembling one of these URLs, a malformed URL is generated using "j_security_check" as the host name. The correct URL would be something like https://localhost:9444/jts/j_security_check.
Any idea any one?
When trying to generate the report, the report is not generated and the following error message is displayed in the console.
CRRPE1064I Starting run...
CRRPE1064I Processing document template 1 of 1.
CRRPE1064I Using URL: https://localhost:9444/rs/query/6/dataservice?report=3&limit=-1&basicAuthenticationEnabled=true&fields=results/result/(REFERENCE_ID1%7CURL1%7CURL2%7CREQUIREMENT_TYPE%7CURL1_title%7CURL2_title%7CREFERENCE_ID).
CRRPE3107I Downloading data from https://localhost:9444/rs/query/6/dataservice?report=3&limit=-1&basicAuthenticationEnabled=true&fields=results/result/(REFERENCE_ID1|URL1|URL2|REQUIREMENT_TYPE|URL1_title|URL2_title|REFERENCE_ID).
Feb 26, 2015 11:06:09 AM org.apache.http.impl.client.HttpAuthenticator authenticate
WARNING: Malformed challenge: Authentication challenge is empty
Feb 26, 2015 11:06:10 AM org.apache.http.impl.client.HttpAuthenticator authenticate
WARNING: Malformed challenge: Authentication challenge is empty
CRRPE1064I Error in engine
Auto: connection to https://localhost:9444/rs/query/6/dataservice?report=3&limit=-1&basicAuthenticationEnabled=true&fields=results/result/(REFERENCE_ID1%7CURL1%7CURL2%7CREQUIREMENT_TYPE%7CURL1_title%7CURL2_title%7CREFERENCE_ID) failed. None of the known protocols succeeded.
CRRPE1064I Aborting engine execution...In the JRS log file (C:\IBM\CLM\server\logs\rs.log) I find the following error messages
CRRPE1064I 39 publishing commands are processed. 0 publishing commands remain to be processed.
CRRPE3097I The document template is processed. If there are no more templates to process, output files are being written.
CRRPE1064I Document generation finished in 3 seconds.
CRRPE1022I The process was completed in 3.962 seconds.
CRRPE1023E The document could not be generated.
2015-02-26 09:23:19,280 [ http-bio-9444-exec-63] ERROR tion.reporting.common.restservices.BaseRestService - CRRGW5704E An java.net.UnknownHostException error occurred when processing OAuth authorization. For more information, check the Jazz Reporting Service log file.java.net.UnknownHostException: j_security_check: j_security_checkVersions: Jazz 6.0M9, Rational Publishing Engine 1.2.1
at java.net.InetAddress.getAllByName0(InetAddress.java:1302)
at java.net.InetAddress.getAllByName(InetAddress.java:1229)
at java.net.InetAddress.getAllByName(InetAddress.java:1151)
at org.apache.http.impl.conn.SystemDefaultDnsResolver.resolve(SystemDefaultDnsResolver.java:44)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.resolveHostname(DefaultClientConnectionOperator.java:259)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:159)
at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:144)
at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:131)
at org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:611)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:446)
at com.ibm.team.jfs.app.http.client.internal.ExtensibleRequestDirector.execute(ExtensibleRequestDirector.java:168)
at org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
at org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)
at com.ibm.team.integration.reporting.common.restservices.BaseRestService.postCredentials(BaseRestService.java:532)
at com.ibm.team.integration.reporting.common.restservices.BaseRestService.unauthorized_byBasic(BaseRestService.java:421)
at com.ibm.team.integration.reporting.common.restservices.BaseRestService.unauthorized(BaseRestService.java:337)
at com.ibm.team.integration.reporting.common.restservices.BaseRestService.service(BaseRestService.java:250)
at com.ibm.team.integration.reporting.data.query.QueryRunner.getUserRunningQuery(QueryRunner.java:463)
...
at java.lang.Thread.run(Thread.java:761)
2015-02-26 09:23:19,326 [ http-bio-9444-exec-63] WARN ration.reporting.common.restservices.WhoAmIService - CRRGW0039I The status of data query response is 302, but this status is HTTP code 200.
Note: I could not import the report definition generated by JRS into RPE 1.3. However, when manually creating the RPE report using the JRE report both in RPE 1.2.1 and 1.3 I get the same problem.
Hunch: already in the Jazz server one component is authenticating against the other. This involves invoking several URLs one after the other. When assembling one of these URLs, a malformed URL is generated using "j_security_check" as the host name. The correct URL would be something like https://localhost:9444/jts/j_security_check.
Any idea any one?
Accepted answer
A change occurred in the JTS authentication cookies late in S9 and this issue with basic authentication in JRS was not discovered until it was too late. The issue has been fixed and is in S10. The corresponding defect is:
Error in exported Excel Workbook - basic authentication in JRS is broken (345622)
Error in exported Excel Workbook - basic authentication in JRS is broken (345622)