It's all about the answers!

Ask a question

Jazz reporting service: error loading imported ready-to-use reports


Milan Krivic (9807159130) | asked Nov 14 '14, 10:13 a.m.
retagged Nov 14 '14, 10:27 a.m. by Laura W. Hinson (16126)
 Hello,

I installed Jazz Reporting service component, registered it with all clm applications, and when I tried to open some of these reports, I got following errors on rs.log:

2014-11-13 15:36:54,634 [            server.startup : 2] ERROR rting.model.extensions.ModelContextBuilderExtender  - CRRGW5112E The database directory at install_path\\server\conf\rs\db cannot be created.
2014-11-13 15:36:54,634 [            server.startup : 2]  INFO rting.model.extensions.ModelContextBuilderExtender  - CRRGW0065I Set up the database in the install_path\\server\conf\rs\db directory.
2014-11-13 15:36:54,665 [            server.startup : 2]  INFO rting.model.extensions.ModelContextBuilderExtender  - CRRGW0067I Obtained the install_path\\AppServer\profiles\AppSrv01\installedApps\vwr013Node01Cell\rs_war.ear\rs.war\WEB-INF\queryStore query store directory.
2014-11-14 14:37:11,986 [             WebContainer : 23]  WARN egration.reporting.common.utils.AuthenticationUtil  - CRRGW0038I The access token might be expired, so you need to go through the OAuth process again.
com.ibm.team.jfs.app.oauth.OAuthInvalidOrExpiredTokenException: CRJZS0034E The OAuth token is not valid or has expired.
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrorsInternal(OAuthHelper.java:1982)
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrors(OAuthHelper.java:1961)
at com.ibm.team.jfs.app.oauth.OAuthHttpResponseInterceptor.process(OAuthHttpResponseInterceptor.java:31)
at org.apache.http.protocol.ImmutableHttpProcessor.process(ImmutableHttpProcessor.java:116)
at org.apache.http.protocol.HttpRequestExecutor.postProcess(HttpRequestExecutor.java:342)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:472)
at com.ibm.team.jfs.app.http.client.internal.ExtensibleRequestDirector.execute(ExtensibleRequestDirector.java:149)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getCurrentUserURL(AuthenticationUtil.java:182)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getUserAccount(AuthenticationUtil.java:135)
at com.ibm.team.integration.reporting.gatewayservices.Front.getUserID(Front.java:326)
at com.ibm.team.integration.reporting.gatewayservices.Front.authenticate(Front.java:297)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:187)
at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:976)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
2014-11-14 14:37:12,330 [             WebContainer : 23]  WARN egration.reporting.common.utils.AuthenticationUtil  - CRRGW0038I The access token might be expired, so you need to go through the OAuth process again.
com.ibm.team.jfs.app.oauth.OAuthInvalidOrExpiredTokenException: CRJZS0034E The OAuth token is not valid or has expired.
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrorsInternal(OAuthHelper.java:1982)
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrors(OAuthHelper.java:1961)
at com.ibm.team.jfs.app.oauth.OAuthHttpResponseInterceptor.process(OAuthHttpResponseInterceptor.java:31)
at org.apache.http.protocol.ImmutableHttpProcessor.process(ImmutableHttpProcessor.java:116)
at org.apache.http.protocol.HttpRequestExecutor.postProcess(HttpRequestExecutor.java:342)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:472)
at com.ibm.team.jfs.app.http.client.internal.ExtensibleRequestDirector.execute(ExtensibleRequestDirector.java:149)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getCurrentUserURL(AuthenticationUtil.java:182)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getUserAccount(AuthenticationUtil.java:135)
at com.ibm.team.integration.reporting.gatewayservices.Front.getUserID(Front.java:326)
at com.ibm.team.integration.reporting.gatewayservices.Front.authenticate(Front.java:297)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:187)
at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:976)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
2014-11-14 14:37:13,141 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 14:37:13,983 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 14:37:14,077 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 14:37:14,092 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 14:37:15,902 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 14:37:15,918 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 15:03:46,091 [              WebContainer : 7] ERROR ration.reporting.model.services.EndpointIndividual  - CRRGW5524E An com.hp.hpl.jena.query.QueryParseException error occurred when updating a data source.  For more information, see the Reporting Service log file.
com.hp.hpl.jena.query.QueryParseException: Encountered " <STRING_LITERAL2> "\"false\" "" at line 43, column 121.
Was expecting one of:
    <IRIref> ...
    <PNAME_NS> ...
    <PNAME_LN> ...
    <VAR1> ...
    <VAR2> ...
    "a" ...
    
at com.hp.hpl.jena.sparql.lang.ParserARQUpdate._parse(ParserARQUpdate.java:67)
at com.hp.hpl.jena.sparql.lang.ParserARQUpdate.parse$(ParserARQUpdate.java:40)
at com.hp.hpl.jena.sparql.lang.UpdateParser.parse(UpdateParser.java:42)
at com.hp.hpl.jena.update.UpdateFactory.make(UpdateFactory.java:90)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:81)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:59)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:49)
at com.ibm.team.integration.reporting.model.stores.SPARQLQueryStore.updateEndpoint(SPARQLQueryStore.java:519)
at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.createEndpoint(TDBResourceStore.java:1154)
at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.replaceEndpoint(TDBResourceStore.java:928)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.replaceEndpoint(EndpointIndividual.java:411)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPut(EndpointIndividual.java:328)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPost(EndpointIndividual.java:114)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
at com.ibm.team.integration.reporting.model.services.Endpoint.doPost(Endpoint.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:252)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:233)
at com.ibm.team.integration.reporting.gatewayservices.Front.doPost(Front.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:976)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
2014-11-14 15:05:31,073 [             WebContainer : 34]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 15:05:31,089 [             WebContainer : 34]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 15:05:40,792 [              WebContainer : 9] ERROR ration.reporting.model.services.EndpointIndividual  - CRRGW5524E An com.hp.hpl.jena.query.QueryParseException error occurred when updating a data source.  For more information, see the Reporting Service log file.
com.hp.hpl.jena.query.QueryParseException: Encountered " <STRING_LITERAL2> "\"false\" "" at line 43, column 121.
Was expecting one of:
    <IRIref> ...
    <PNAME_NS> ...
    <PNAME_LN> ...
    <VAR1> ...
    <VAR2> ...
    "a" ...
    
at com.hp.hpl.jena.sparql.lang.ParserARQUpdate._parse(ParserARQUpdate.java:67)
at com.hp.hpl.jena.sparql.lang.ParserARQUpdate.parse$(ParserARQUpdate.java:40)
at com.hp.hpl.jena.sparql.lang.UpdateParser.parse(UpdateParser.java:42)
at com.hp.hpl.jena.update.UpdateFactory.make(UpdateFactory.java:90)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:81)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:59)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:49)
at com.ibm.team.integration.reporting.model.stores.SPARQLQueryStore.updateEndpoint(SPARQLQueryStore.java:519)
at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.createEndpoint(TDBResourceStore.java:1154)
at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.replaceEndpoint(TDBResourceStore.java:928)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.replaceEndpoint(EndpointIndividual.java:411)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPut(EndpointIndividual.java:328)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPost(EndpointIndividual.java:114)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
at com.ibm.team.integration.reporting.model.services.Endpoint.doPost(Endpoint.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:252)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:233)
at com.ibm.team.integration.reporting.gatewayservices.Front.doPost(Front.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:976)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
2014-11-14 15:06:20,089 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 15:06:20,104 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 15:06:21,617 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 15:06:21,633 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 15:06:21,633 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 15:06:21,649 [             WebContainer : 23]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 15:11:20,789 [             WebContainer : 21]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-14 15:11:20,804 [             WebContainer : 21]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://host_name:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-14 15:12:56,339 [             WebContainer : 30]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT t.TIMELINE_ID AS timeline_dbid, 
       t.NAME AS timeline_name,
       CONCAT(CONCAT(CONCAT(t.NAME, ' ['), t.PROJECT_NAME), ']') AS timeline_fulltitle,
       t.URL as timeline_uri,
       RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId
FROM RIDW.VW_TIMELINE t
JOIN RIDW.VW_PROJECT p ON t.PROJECT_ID = p.PROJECT_ID 
AND (p.PROJECT_CLASS_NAME = 'RTC Project Area' OR p.PROJECT_CLASS_NAME = 'Info not available') 
WHERE t.ISSOFTDELETED = 0
ORDER BY t.PROJECT_NAME, t.NAME
2014-11-14 15:12:56,339 [             WebContainer : 30]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT t.TIMELINE_ID AS timeline_dbid, t.NAME AS timeline_name, (CONCAT((CONCAT((CONCAT(t.NAME, (' ['))), t.PROJECT_NAME)), ']')) AS timeline_fulltitle, t.URL AS timeline_uri, RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId FROM RIDW.VW_TIMELINE t INNER JOIN RIDW.VW_PROJECT p ON ((t.PROJECT_ID = p.PROJECT_ID) AND ((p.PROJECT_CLASS_NAME = 'RTC Project Area') OR (p.PROJECT_CLASS_NAME = 'Info not available'))) WHERE ((t.ISSOFTDELETED = 0) AND (((p.PROJECT_ID IS NULL) OR (p.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = p.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com'))))) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) ORDER BY t.PROJECT_NAME, t.NAME
2014-11-14 15:13:10,160 [             WebContainer : 30]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT t.TIMELINE_ID AS timeline_dbid, 
       t.NAME AS timeline_name,
       CONCAT(CONCAT(CONCAT(t.NAME, ' ['), t.PROJECT_NAME), ']') AS timeline_fulltitle,
       t.URL as timeline_uri,
       RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId
FROM RIDW.VW_TIMELINE t
JOIN RIDW.VW_PROJECT p ON t.PROJECT_ID = p.PROJECT_ID 
AND (p.PROJECT_CLASS_NAME = 'RTC Project Area' OR p.PROJECT_CLASS_NAME = 'Info not available') 
WHERE t.ISSOFTDELETED = 0
ORDER BY t.PROJECT_NAME, t.NAME
2014-11-14 15:13:10,160 [             WebContainer : 30]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT t.TIMELINE_ID AS timeline_dbid, t.NAME AS timeline_name, (CONCAT((CONCAT((CONCAT(t.NAME, (' ['))), t.PROJECT_NAME)), ']')) AS timeline_fulltitle, t.URL AS timeline_uri, RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId FROM RIDW.VW_TIMELINE t INNER JOIN RIDW.VW_PROJECT p ON ((t.PROJECT_ID = p.PROJECT_ID) AND ((p.PROJECT_CLASS_NAME = 'RTC Project Area') OR (p.PROJECT_CLASS_NAME = 'Info not available'))) WHERE ((t.ISSOFTDELETED = 0) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com'))))) AND (((p.PROJECT_ID IS NULL) OR (p.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = p.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) ORDER BY t.PROJECT_NAME, t.NAME
2014-11-14 15:20:08,120 [             WebContainer : 32]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT i.TIMELINE_ID AS timeline_dbid,
       i.NAME AS iteration_name,
       r.NAME AS request_title,
       r.URL AS request
FROM RIDW.VW_REQUEST r
JOIN RIDW.VW_ITERATION i ON i.ITERATION_ID = r.ITERATION_ID 
AND r.REQUEST_STATUS = 'Closed'
GROUP BY i.TIMELINE_ID, i.NAME, r.NAME, r.URL

2014-11-14 15:20:08,120 [             WebContainer : 32]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT i.TIMELINE_ID AS timeline_dbid, i.NAME AS iteration_name, r.NAME AS request_title, r.URL AS request FROM RIDW.VW_REQUEST r INNER JOIN RIDW.VW_ITERATION i ON ((i.ITERATION_ID = r.ITERATION_ID) AND (r.REQUEST_STATUS = 'Closed')) WHERE (((r.PROJECT_ID IS NULL) OR (r.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = r.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com')))) AND (((i.PROJECT_ID IS NULL) OR (i.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = i.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) GROUP BY i.TIMELINE_ID, i.NAME, r.NAME, r.URL


Also, I can't even build a custom reports, when I choose the datasource, test it, it is ok. but on build page, I can't click on continue because it is disabled.

any help would be appreciated.

Thanks,

Comments
Theresa Ramsey commented Nov 14 '14, 4:14 p.m. | edited Dec 03 '15, 2:24 a.m.
JAZZ DEVELOPER

Can you also let us know what data source you are using?  

If the import worked ok, you should see reports on the Use page.  

5 answers



permanent link
Kevin Cornell (5411) | answered Nov 14 '14, 3:48 p.m.

I cannot figure out from the error log contents (above) what actually failed during the import. There were multiple authentication expired token errors but I think that is normal when you first connect to JRS.

There were also 2 SPARQL syntax errors trying to update a data source,

com.hp.hpl.jena.query.QueryParseException: Encountered " <string_literal2> "\"false\" "" at line 43, column 121.

but when I examined the stack trace this looks like the request was from the UI and not the import mechanism. I did not see any other errors in the log contents that would indicate an error during import of the OOTB reports.

As for building a new report, when you open the “Build” page and select a data source, the section where you select the data source should also list all of the types (work Items, test cases, requirements, etc.) available for that data source. You have to select one type before the Continue button is enabled.

If none of the types are shown for a data warehouse, then there was a problem during initialization of that data source. Do the following:

1) Shutdown the JRS server

2) Delete the JRS log file (.../server/logs/rs.log if using Tomcat)

3) Restart JRS and try to Build the report again.

4) If no types are shown, go to the data sources page and select the data warehouse link to edit that data source.

5) Click Save. This will cause the meta-model data to be refreshed, unless an error occurs.

6) If the types still do not show when building a report, copy the rs.log file and attach it to this thread.


permanent link
Milan Krivic (9807159130) | answered Nov 17 '14, 6:50 a.m.
 Hi all,

we actually setup and configured JRS on same WAS profile as the CLM applications.
We are using WAS 8.5.5.1 and DB2 10.1

We succeeded to import all reports:

All reports


but when we run on of them, for example, in dashboard widget, we are getting this:

JRS widget

When we preview full report, we get this:

JRS full report

Also, when we check default DW connection Data Source, we are getting this:

Data Source Connection


When I try to update datasource by adding Database schema prefix, I am getting this error:

Error Update Connection


Also, this is the new log, and I did all steps like Kevin mentioned...

2014-11-17 09:55:53,275 [            server.startup : 1] ERROR rting.model.extensions.ModelContextBuilderExtender  - CRRGW5112E The database directory at install_path\\server\conf\rs\db cannot be created.
2014-11-17 09:55:53,275 [            server.startup : 1]  INFO rting.model.extensions.ModelContextBuilderExtender  - CRRGW0065I Set up the database in the install_path\\server\conf\rs\db directory.
2014-11-17 09:55:53,275 [            server.startup : 1]  INFO rting.model.extensions.ModelContextBuilderExtender  - CRRGW0067I Obtained the install_path\\profiles\AppSrv01\installedApps\vwr013Node01Cell\rs_war.ear\rs.war\WEB-INF\queryStore query store directory.
2014-11-17 10:02:21,466 [              WebContainer : 5]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-17 10:02:22,371 [              WebContainer : 5]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-17 10:02:23,104 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT t.TIMELINE_ID AS timeline_dbid, 
       t.NAME AS timeline_name,
       CONCAT(CONCAT(CONCAT(t.NAME, ' ['), t.PROJECT_NAME), ']') AS timeline_fulltitle,
       t.URL as timeline_uri,
       RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId
FROM RIDW.VW_TIMELINE t
JOIN RIDW.VW_PROJECT p ON t.PROJECT_ID = p.PROJECT_ID 
AND (p.PROJECT_CLASS_NAME = 'RTC Project Area' OR p.PROJECT_CLASS_NAME = 'Info not available') 
WHERE t.ISSOFTDELETED = 0
ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:02:23,104 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT t.TIMELINE_ID AS timeline_dbid, t.NAME AS timeline_name, (CONCAT((CONCAT((CONCAT(t.NAME, (' ['))), t.PROJECT_NAME)), ']')) AS timeline_fulltitle, t.URL AS timeline_uri, RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId FROM RIDW.VW_TIMELINE t INNER JOIN RIDW.VW_PROJECT p ON ((t.PROJECT_ID = p.PROJECT_ID) AND ((p.PROJECT_CLASS_NAME = 'RTC Project Area') OR (p.PROJECT_CLASS_NAME = 'Info not available'))) WHERE ((t.ISSOFTDELETED = 0) AND (((p.PROJECT_ID IS NULL) OR (p.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = p.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com'))))) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:04:55,391 [              WebContainer : 9]  WARN egration.reporting.common.utils.AuthenticationUtil  - CRRGW0038I The access token might be expired, so you need to go through the OAuth process again.
com.ibm.team.jfs.app.oauth.OAuthInvalidOrExpiredTokenException: CRJZS0034E The OAuth token is not valid or has expired.
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrorsInternal(OAuthHelper.java:1982)
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrors(OAuthHelper.java:1961)
at com.ibm.team.jfs.app.oauth.OAuthHttpResponseInterceptor.process(OAuthHttpResponseInterceptor.java:31)
at org.apache.http.protocol.ImmutableHttpProcessor.process(ImmutableHttpProcessor.java:116)
at org.apache.http.protocol.HttpRequestExecutor.postProcess(HttpRequestExecutor.java:342)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:472)
at com.ibm.team.jfs.app.http.client.internal.ExtensibleRequestDirector.execute(ExtensibleRequestDirector.java:149)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getCurrentUserURL(AuthenticationUtil.java:182)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getUserAccount(AuthenticationUtil.java:135)
at com.ibm.team.integration.reporting.gatewayservices.Front.getUserID(Front.java:326)
at com.ibm.team.integration.reporting.gatewayservices.Front.authenticate(Front.java:297)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:187)
at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3826)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:976)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:283)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1048)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.readyInboundPostHandshake(SSLConnectionLink.java:716)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyHandshakeCompletedCallback.complete(SSLConnectionLink.java:412)
at com.ibm.ws.ssl.channel.impl.SSLUtils.handleHandshake(SSLUtils.java:1066)
at com.ibm.ws.ssl.channel.impl.SSLHandshakeIOCallback.complete(SSLHandshakeIOCallback.java:87)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
2014-11-17 10:04:55,485 [              WebContainer : 9]  WARN egration.reporting.common.utils.AuthenticationUtil  - CRRGW0038I The access token might be expired, so you need to go through the OAuth process again.
com.ibm.team.jfs.app.oauth.OAuthInvalidOrExpiredTokenException: CRJZS0034E The OAuth token is not valid or has expired.
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrorsInternal(OAuthHelper.java:1982)
at com.ibm.team.jfs.app.oauth.OAuthHelper.checkResponseForOAuthErrors(OAuthHelper.java:1961)
at com.ibm.team.jfs.app.oauth.OAuthHttpResponseInterceptor.process(OAuthHttpResponseInterceptor.java:31)
at org.apache.http.protocol.ImmutableHttpProcessor.process(ImmutableHttpProcessor.java:116)
at org.apache.http.protocol.HttpRequestExecutor.postProcess(HttpRequestExecutor.java:342)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:472)
at com.ibm.team.jfs.app.http.client.internal.ExtensibleRequestDirector.execute(ExtensibleRequestDirector.java:149)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:820)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:754)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getCurrentUserURL(AuthenticationUtil.java:182)
at com.ibm.team.integration.reporting.common.utils.AuthenticationUtil.getUserAccount(AuthenticationUtil.java:135)
at com.ibm.team.integration.reporting.gatewayservices.Front.getUserID(Front.java:326)
at com.ibm.team.integration.reporting.gatewayservices.Front.authenticate(Front.java:297)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:187)
at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:909)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
2014-11-17 10:04:55,625 [              WebContainer : 9]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-17 10:04:55,656 [              WebContainer : 9]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-17 10:04:55,672 [              WebContainer : 9]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-17 10:04:55,672 [              WebContainer : 9]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-17 10:04:59,104 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT t.TIMELINE_ID AS timeline_dbid, 
       t.NAME AS timeline_name,
       CONCAT(CONCAT(CONCAT(t.NAME, ' ['), t.PROJECT_NAME), ']') AS timeline_fulltitle,
       t.URL as timeline_uri,
       RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId
FROM RIDW.VW_TIMELINE t
JOIN RIDW.VW_PROJECT p ON t.PROJECT_ID = p.PROJECT_ID 
AND (p.PROJECT_CLASS_NAME = 'RTC Project Area' OR p.PROJECT_CLASS_NAME = 'Info not available') 
WHERE t.ISSOFTDELETED = 0
ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:04:59,104 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT t.TIMELINE_ID AS timeline_dbid, t.NAME AS timeline_name, (CONCAT((CONCAT((CONCAT(t.NAME, (' ['))), t.PROJECT_NAME)), ']')) AS timeline_fulltitle, t.URL AS timeline_uri, RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId FROM RIDW.VW_TIMELINE t INNER JOIN RIDW.VW_PROJECT p ON ((t.PROJECT_ID = p.PROJECT_ID) AND ((p.PROJECT_CLASS_NAME = 'RTC Project Area') OR (p.PROJECT_CLASS_NAME = 'Info not available'))) WHERE ((t.ISSOFTDELETED = 0) AND (((p.PROJECT_ID IS NULL) OR (p.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = p.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com'))))) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:05:05,578 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT t.TIMELINE_ID AS timeline_dbid, 
       t.NAME AS timeline_name,
       CONCAT(CONCAT(CONCAT(t.NAME, ' ['), t.PROJECT_NAME), ']') AS timeline_fulltitle,
       t.URL as timeline_uri,
       RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId
FROM RIDW.VW_TIMELINE t
JOIN RIDW.VW_PROJECT p ON t.PROJECT_ID = p.PROJECT_ID 
AND (p.PROJECT_CLASS_NAME = 'RTC Project Area' OR p.PROJECT_CLASS_NAME = 'Info not available') 
WHERE t.ISSOFTDELETED = 0
ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:05:05,578 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT t.TIMELINE_ID AS timeline_dbid, t.NAME AS timeline_name, (CONCAT((CONCAT((CONCAT(t.NAME, (' ['))), t.PROJECT_NAME)), ']')) AS timeline_fulltitle, t.URL AS timeline_uri, RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId FROM RIDW.VW_TIMELINE t INNER JOIN RIDW.VW_PROJECT p ON ((t.PROJECT_ID = p.PROJECT_ID) AND ((p.PROJECT_CLASS_NAME = 'RTC Project Area') OR (p.PROJECT_CLASS_NAME = 'Info not available'))) WHERE ((t.ISSOFTDELETED = 0) AND (((p.PROJECT_ID IS NULL) OR (p.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = p.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com'))))) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:05:06,654 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - original query:
 SELECT t.TIMELINE_ID AS timeline_dbid, 
       t.NAME AS timeline_name,
       CONCAT(CONCAT(CONCAT(t.NAME, ' ['), t.PROJECT_NAME), ']') AS timeline_fulltitle,
       t.URL as timeline_uri,
       RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId
FROM RIDW.VW_TIMELINE t
JOIN RIDW.VW_PROJECT p ON t.PROJECT_ID = p.PROJECT_ID 
AND (p.PROJECT_CLASS_NAME = 'RTC Project Area' OR p.PROJECT_CLASS_NAME = 'Info not available') 
WHERE t.ISSOFTDELETED = 0
ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:05:06,654 [              WebContainer : 5]  INFO am.integration.reporting.data.query.SqlQueryRunner  - SQL Project Access Injection - modified query:
 SELECT t.TIMELINE_ID AS timeline_dbid, t.NAME AS timeline_name, (CONCAT((CONCAT((CONCAT(t.NAME, (' ['))), t.PROJECT_NAME)), ']')) AS timeline_fulltitle, t.URL AS timeline_uri, RTRIM(t.EXTERNAL_KEY2) AS timeline_itemId FROM RIDW.VW_TIMELINE t INNER JOIN RIDW.VW_PROJECT p ON ((t.PROJECT_ID = p.PROJECT_ID) AND ((p.PROJECT_CLASS_NAME = 'RTC Project Area') OR (p.PROJECT_CLASS_NAME = 'Info not available'))) WHERE ((t.ISSOFTDELETED = 0) AND (((p.PROJECT_ID IS NULL) OR (p.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_1, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_1 WHERE ((JRS_PAC_LOOKUP_1.PROJECT_ID = p.PROJECT_ID) AND (JRS_PAC_LOOKUP_1.RESOURCE_ID = JRS_PAC_RESOURCE_1.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_1.REFERENCE_ID = 'user@mail.com'))))) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_2, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_2 WHERE ((JRS_PAC_LOOKUP_2.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_2.RESOURCE_ID = JRS_PAC_RESOURCE_2.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_2.REFERENCE_ID = 'user@mail.com')))) ORDER BY t.PROJECT_NAME, t.NAME
2014-11-17 10:09:55,083 [              WebContainer : 2]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6016I The server is attempting to connect to the following database: "//clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;"
2014-11-17 10:09:55,098 [              WebContainer : 2]  INFO n.reporting.db.connection.impl.DbConnectionFactory  - CRRGW6017I The connection to the following database was successful:
 Db Product Name: DB2/NT64
  Db Product Version: SQL10013
  Db URL: jdbc:db2://clm_server:50000/DW:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.65.97
2014-11-17 12:37:03,762 [              WebContainer : 4] ERROR ration.reporting.model.services.EndpointIndividual  - CRRGW5524E An com.hp.hpl.jena.query.QueryParseException error occurred when updating a data source.  For more information, see the Reporting Service log file.
com.hp.hpl.jena.query.QueryParseException: Encountered " <STRING_LITERAL2> "\"false\" "" at line 43, column 121.
Was expecting one of:
    <IRIref> ...
    <PNAME_NS> ...
    <PNAME_LN> ...
    <VAR1> ...
    <VAR2> ...
    "a" ...
    
at com.hp.hpl.jena.sparql.lang.ParserARQUpdate._parse(ParserARQUpdate.java:67)
at com.hp.hpl.jena.sparql.lang.ParserARQUpdate.parse$(ParserARQUpdate.java:40)
at com.hp.hpl.jena.sparql.lang.UpdateParser.parse(UpdateParser.java:42)
at com.hp.hpl.jena.update.UpdateFactory.make(UpdateFactory.java:90)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:81)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:59)
at com.hp.hpl.jena.update.UpdateFactory.create(UpdateFactory.java:49)
at com.ibm.team.integration.reporting.model.stores.SPARQLQueryStore.updateEndpoint(SPARQLQueryStore.java:519)
at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.createEndpoint(TDBResourceStore.java:1154)
at com.ibm.team.integration.reporting.model.stores.TDBResourceStore.replaceEndpoint(TDBResourceStore.java:928)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.replaceEndpoint(EndpointIndividual.java:411)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPut(EndpointIndividual.java:328)
at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPost(EndpointIndividual.java:114)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
at com.ibm.team.integration.reporting.model.services.Endpoint.doPost(Endpoint.java:279)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:79)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:1385)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:194)
at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:252)
at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:233)
at com.ibm.team.integration.reporting.gatewayservices.Front.doPost(Front.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:82)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:960)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1064)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:909)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:283)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1048)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.readyInboundPostHandshake(SSLConnectionLink.java:716)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyHandshakeCompletedCallback.complete(SSLConnectionLink.java:412)
at com.ibm.ws.ssl.channel.impl.SSLUtils.handleHandshake(SSLUtils.java:1066)
at com.ibm.ws.ssl.channel.impl.SSLHandshakeIOCallback.complete(SSLHandshakeIOCallback.java:87)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)


I am using default dataware house source connection. During the final setup, I was asked to type db2 password, and as You can see, db connection is ok.



permanent link
Milan Krivic (9807159130) | answered Nov 17 '14, 7:28 a.m.
 This happens when I want to build custom report:

Custom report

As you can see, the Continue button is disabled...

permanent link
Milan Krivic (9807159130) | answered Nov 17 '14, 7:41 a.m.
edited Nov 17 '14, 7:48 a.m.
 Also, this is the system_error.log:

************ Start Display Current Environment ************
Log file started at: [13.11.14. 15:36:17:568 CET]
************* End Display Current Environment *************
[13.11.14. 15:36:45:430 CET] 00000068 SystemErr     R log4j:ERROR Could not find value for key log4j.appender.rmPerfLog
[13.11.14. 15:36:45:430 CET] 00000068 SystemErr     R log4j:ERROR Could not instantiate appender named "rmPerfLog".
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R java.net.UnknownHostException: www.ibm.com
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at java.net.Socket.connect(Socket.java:537)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at java.net.Socket.connect(Socket.java:486)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.http.HttpClient.openServer(HttpClient.java:424)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.http.HttpClient.openServer(HttpClient.java:538)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.http.HttpClient.<init>(HttpClient.java:221)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.http.HttpClient.New(HttpClient.java:304)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.http.HttpClient.New(HttpClient.java:323)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:999)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:853)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1207)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:390)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at com.ibm.ut.help.common.web.ProxyUtil.followRedirects(ProxyUtil.java:215)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at com.ibm.ut.help.common.web.ProxyUtil.getConnection(ProxyUtil.java:239)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at com.ibm.ut.help.common.web.URLUtil.getConnection(URLUtil.java:42)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at com.ibm.ut.help.common.web.URLUtil.getStream(URLUtil.java:47)
[13.11.14. 15:36:45:710 CET] 0000006c SystemErr     R at com.ibm.ccl.ut.help.info.entry.NavTree.categorizeTocXML(NavTree.java:246)
[13.11.14. 15:36:45:726 CET] 0000006c SystemErr     R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[13.11.14. 15:36:45:726 CET] 0000006c SystemErr     R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[13.11.14. 15:36:45:726 CET] 0000006c SystemErr     R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[13.11.14. 15:36:45:726 CET] 0000006c SystemErr     R at java.lang.reflect.Method.invoke(Method.java:611)
[13.11.14. 15:36:45:726 CET] 0000006c SystemErr     R at com.ibm.ccl.ut.help.info.IndexThread.run(IndexThread.java:105)
[13.11.14. 15:36:54:290 CET] 00000049 SystemErr     R SLF4J: Class path contains multiple SLF4J bindings.
[13.11.14. 15:36:54:290 CET] 00000049 SystemErr     R SLF4J: Found binding in [bundleresource://267.fwk-592489347:1/org/slf4j/impl/StaticLoggerBinder.class]
[13.11.14. 15:36:54:290 CET] 00000049 SystemErr     R SLF4J: Found binding in [wsjar:file:/install_path//AppSrv01/installedApps/vwr013Node01Cell/rs_war.ear/rs.war/WEB-INF/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
[13.11.14. 15:36:54:290 CET] 00000049 SystemErr     R SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
[13.11.14. 15:36:54:353 CET] 00000049 SystemErr     R log4j:WARN No appenders could be found for logger (com.ibm.team.integration.reporting.common.configs.SG_ServletContextListener).
[13.11.14. 15:36:54:368 CET] 00000049 SystemErr     R log4j:WARN Please initialize the log4j system properly.
[13.11.14. 15:36:54:368 CET] 00000049 SystemErr     R log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
[13.11.14. 15:38:39:822 CET] 000000e5 SystemErr     R log4j:WARN No appenders could be found for logger (com.ibm.team.jfs.internal.app.cache.bundle.CacheRegistrar).
[13.11.14. 15:38:39:822 CET] 000000e5 SystemErr     R log4j:WARN Please initialize the log4j system properly.
[17.11.14. 09:55:14:962 CET] 00000064 SystemErr     R log4j:ERROR Could not find value for key log4j.appender.rmPerfLog
[17.11.14. 09:55:14:962 CET] 00000064 SystemErr     R log4j:ERROR Could not instantiate appender named "rmPerfLog".
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R java.net.UnknownHostException: www.ibm.com
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at java.net.Socket.connect(Socket.java:537)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at java.net.Socket.connect(Socket.java:486)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.http.HttpClient.openServer(HttpClient.java:424)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.http.HttpClient.openServer(HttpClient.java:538)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.http.HttpClient.<init>(HttpClient.java:221)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.http.HttpClient.New(HttpClient.java:304)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.http.HttpClient.New(HttpClient.java:323)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:999)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:853)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1207)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:390)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at com.ibm.ut.help.common.web.ProxyUtil.followRedirects(ProxyUtil.java:215)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at com.ibm.ut.help.common.web.ProxyUtil.getConnection(ProxyUtil.java:239)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at com.ibm.ut.help.common.web.URLUtil.getConnection(URLUtil.java:42)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at com.ibm.ut.help.common.web.URLUtil.getStream(URLUtil.java:47)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at com.ibm.ccl.ut.help.info.entry.NavTree.categorizeTocXML(NavTree.java:246)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at java.lang.reflect.Method.invoke(Method.java:611)
[17.11.14. 09:55:16:725 CET] 0000006d SystemErr     R at com.ibm.ccl.ut.help.info.IndexThread.run(IndexThread.java:105)
[17.11.14. 09:55:52:948 CET] 00000046 SystemErr     R SLF4J: Class path contains multiple SLF4J bindings.
[17.11.14. 09:55:52:948 CET] 00000046 SystemErr     R SLF4J: Found binding in [bundleresource://267.fwk1456247285:1/org/slf4j/impl/StaticLoggerBinder.class]
[17.11.14. 09:55:52:948 CET] 00000046 SystemErr     R SLF4J: Found binding in [wsjar:file:/install_path//AppSrv01/installedApps/vwr013Node01Cell/rs_war.ear/rs.war/WEB-INF/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
[17.11.14. 09:55:52:948 CET] 00000046 SystemErr     R SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
[17.11.14. 09:55:53:010 CET] 00000046 SystemErr     R log4j:WARN No appenders could be found for logger (com.ibm.team.integration.reporting.common.configs.SG_ServletContextListener).
[17.11.14. 09:55:53:010 CET] 00000046 SystemErr     R log4j:WARN Please initialize the log4j system properly.
[17.11.14. 09:55:53:010 CET] 00000046 SystemErr     R log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
[17.11.14. 09:57:24:036 CET] 000000fe SystemErr     R log4j:WARN No appenders could be found for logger (com.ibm.team.jfs.internal.app.cache.bundle.CacheRegistrar).
[17.11.14. 09:57:24:036 CET] 000000fe SystemErr     R log4j:WARN Please initialize the log4j system properly.
[17.11.14. 13:04:09:713 CET] 00000057 SystemErr     R log4j:ERROR Could not find value for key log4j.appender.rmPerfLog
[17.11.14. 13:04:09:713 CET] 00000057 SystemErr     R log4j:ERROR Could not instantiate appender named "rmPerfLog".
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R java.net.UnknownHostException: www.ibm.com
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:253)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:376)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at java.net.Socket.connect(Socket.java:537)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at java.net.Socket.connect(Socket.java:486)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.http.HttpClient.openServer(HttpClient.java:424)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.http.HttpClient.openServer(HttpClient.java:538)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.http.HttpClient.<init>(HttpClient.java:221)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.http.HttpClient.New(HttpClient.java:304)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.http.HttpClient.New(HttpClient.java:323)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:999)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:978)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:853)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1207)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:390)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at com.ibm.ut.help.common.web.ProxyUtil.followRedirects(ProxyUtil.java:215)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at com.ibm.ut.help.common.web.ProxyUtil.getConnection(ProxyUtil.java:239)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at com.ibm.ut.help.common.web.URLUtil.getConnection(URLUtil.java:42)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at com.ibm.ut.help.common.web.URLUtil.getStream(URLUtil.java:47)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at com.ibm.ccl.ut.help.info.entry.NavTree.categorizeTocXML(NavTree.java:246)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at java.lang.reflect.Method.invoke(Method.java:611)
[17.11.14. 13:04:16:483 CET] 0000006a SystemErr     R at com.ibm.ccl.ut.help.info.IndexThread.run(IndexThread.java:105)
[17.11.14. 13:04:21:070 CET] 00000049 SystemErr     R SLF4J: Class path contains multiple SLF4J bindings.
[17.11.14. 13:04:21:070 CET] 00000049 SystemErr     R SLF4J: Found binding in [bundleresource://267.fwk-603977121:1/org/slf4j/impl/StaticLoggerBinder.class]
[17.11.14. 13:04:21:070 CET] 00000049 SystemErr     R SLF4J: Found binding in [wsjar:file:/install_path//AppSrv01/installedApps/vwr013Node01Cell/rs_war.ear/rs.war/WEB-INF/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
[17.11.14. 13:04:21:070 CET] 00000049 SystemErr     R SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
[17.11.14. 13:04:21:132 CET] 00000049 SystemErr     R log4j:WARN No appenders could be found for logger (com.ibm.team.integration.reporting.common.configs.SG_ServletContextListener).
[17.11.14. 13:04:21:132 CET] 00000049 SystemErr     R log4j:WARN Please initialize the log4j system properly.
[17.11.14. 13:04:21:132 CET] 00000049 SystemErr     R log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
[17.11.14. 13:06:47:164 CET] 00000111 SystemErr     R log4j:WARN No appenders could be found for logger (com.ibm.team.jfs.internal.app.cache.bundle.CacheRegistrar).
[17.11.14. 13:06:47:164 CET] 00000111 SystemErr     R log4j:WARN Please initialize the log4j system properly.

I tried to upgrade dwhouse again, but the same problems persist.

permanent link
Kevin Cornell (5411) | answered Nov 17 '14, 10:36 a.m.

So I figured out the SPARQL syntax error exception in the log ... When you specified the database schema and clicked Save, an invalid SPARQL update command was generated internally in JRS when saving the data source resource. I'll fix that but it should not affect you. That database schema field of a data source is not needed unless you are using an old version of an ORACLE database. Some databases did not support separate databases for different applications. So all of the tables and views for a single application (e.g., the CLM data warehouse) had to add a schema prefix to their table names in order to avoid collisions with tables from other applications.

DB2 creates separate databases so a schema prefix must not be defined.

I noticed on the Build Report page, none of the types were listed for the data warehouse. When you defined the connection to the data warehouse you specified a user name and password. In my testing I usually use the DB2 administrator but if you specify a different user, you MUST define the permissions in DB2 so that the user has read access to all of the tables and views. I think this may be your problem.

After you ensure your DB2 user has read permissions, in JRS open the DW data source and simply click Save. This will refresh the metamodel in JRS. On the Build Report page, you should see the types listed for Change Management, Quality Management and Requirements Management.

Your answer


Register or to post your answer.