JRS not working

Gerald Weichbold

(11●3●4) Apr 24 '15, 3:00 a.m.

Hello!
We are planning the roll out of ibm jazz and therefore we have an evaluating system.
I installed CLM6M11 and the jazz reporting does not work...

No change if I choose lqe or data warehouse.
I attach the logfile...
Maybe you can help me :)
Thanks!

0 votes

Comments

Gerald Weichbold

Feb 22 '17, 5:59 a.m.

2015-04-23 11:17:44,943 [ http-bio-9443-exec-111] INFO ibm.team.integration.reporting.data.utils.SqlUtils - Modified query: SELECT DISTINCT r.REFERENCE_ID AS request_id, (CONCAT((CONCAT(r.REFERENCE_ID, (': '))), r.NAME)) AS request_title, r.URL AS request, r.REQUEST_PRIORITY_ID AS priority_dbid, r.REQUEST_PRIORITY AS priority, i.TIMELINE_ID AS timeline_dbid, i.TIMELINE_NAME AS timeline, r.TEAM_ID AS team_dbid, r.TEAM_NAME AS team_name FROM RIDW.VW_REQUEST r INNER JOIN RIDW.VW_ITERATION i ON (i.ITERATION_ID = r.ITERATION_ID) INNER JOIN RIDW.VW_REQUEST_TYPE_BINDING t ON (t.REQUEST_TYPE_ID = r.REQUEST_TYPE_ID) WHERE ((((r.REQUEST_STATUS <> 'Closed') AND (t.REFERENCE_ID = 'defect')) AND (i.START_DATE <= CURRENT_TIMESTAMP)) AND (i.END_DATE >= CURRENT_TIMESTAMP)) AND (i.TIMELINE_ID = 1) ORDER BY i.TIMELINE_NAME, r.TEAM_NAME, r.REQUEST_PRIORITY_ID DESC, r.REFERENCE_ID 2015-04-23 11:17:44,988 [ http-bio-9443-exec-111] INFO am.integration.reporting.data.query.SqlQueryRunner - SQL Project Access Injection - original query: SELECT DISTINCT r.REFERENCE_ID AS request_id, (CONCAT((CONCAT(r.REFERENCE_ID, (': '))), r.NAME)) AS request_title, r.URL AS request, r.REQUEST_PRIORITY_ID AS priority_dbid, r.REQUEST_PRIORITY AS priority, i.TIMELINE_ID AS timeline_dbid, i.TIMELINE_NAME AS timeline, r.TEAM_ID AS team_dbid, r.TEAM_NAME AS team_name FROM RIDW.VW_REQUEST r INNER JOIN RIDW.VW_ITERATION i ON (i.ITERATION_ID = r.ITERATION_ID) INNER JOIN RIDW.VW_REQUEST_TYPE_BINDING t ON (t.REQUEST_TYPE_ID = r.REQUEST_TYPE_ID) WHERE ((((r.REQUEST_STATUS <> 'Closed') AND (t.REFERENCE_ID = 'defect')) AND (i.START_DATE <= CURRENT_TIMESTAMP)) AND (i.END_DATE >= CURRENT_TIMESTAMP)) AND (i.TIMELINE_ID = 1) ORDER BY i.TIMELINE_NAME, r.TEAM_NAME, r.REQUEST_PRIORITY_ID DESC, r.REFERENCE_ID 2015-04-23 11:17:44,988 [ http-bio-9443-exec-111] INFO am.integration.reporting.data.query.SqlQueryRunner - SQL Project Access Injection - modified query: SELECT DISTINCT r.REFERENCE_ID AS request_id, (CONCAT((CONCAT(r.REFERENCE_ID, (': '))), r.NAME)) AS request_title, r.URL AS request, r.REQUEST_PRIORITY_ID AS priority_dbid, r.REQUEST_PRIORITY AS priority, i.TIMELINE_ID AS timeline_dbid, i.TIMELINE_NAME AS timeline, r.TEAM_ID AS team_dbid, r.TEAM_NAME AS team_name FROM RIDW.VW_REQUEST r INNER JOIN RIDW.VW_ITERATION i ON (i.ITERATION_ID = r.ITERATION_ID) INNER JOIN RIDW.VW_REQUEST_TYPE_BINDING t ON (t.REQUEST_TYPE_ID = r.REQUEST_TYPE_ID) WHERE (((((((r.REQUEST_STATUS <> 'Closed') AND (t.REFERENCE_ID = 'defect')) AND (i.START_DATE <= CURRENT_TIMESTAMP)) AND (i.END_DATE >= CURRENT_TIMESTAMP)) AND (i.TIMELINE_ID = 1)) AND (((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 = 'wbl@keba.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 = 'wbl@keba.com'))))) AND (((t.PROJECT_ID IS NULL) OR (t.PROJECT_ID = -1)) OR (EXISTS (SELECT 1 FROM RIDW.VW_RESOURCE JRS_PAC_RESOURCE_3, RIDW.VW_PROJECT_RESOURCE_LOOKUP JRS_PAC_LOOKUP_3 WHERE ((JRS_PAC_LOOKUP_3.PROJECT_ID = t.PROJECT_ID) AND (JRS_PAC_LOOKUP_3.RESOURCE_ID = JRS_PAC_RESOURCE_3.RESOURCE_ID)) AND (JRS_PAC_RESOURCE_3.REFERENCE_ID = 'wbl@keba.com')))) ORDER BY i.TIMELINE_NAME, r.TEAM_NAME, r.REQUEST_PRIORITY_ID DESC, r.REFERENCE_ID 2015-04-23 11:18:41,805 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6016I Der Server versucht, eine Verbindung zur Datenbank "//localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx" herzustellen. 2015-04-23 11:18:41,818 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6017I Erfolgreiche Verbindung zur folgenden Datenbank: Name des DB-Produkts: Microsoft SQL Server Version des DB-Produkts: 11.00.3153 DB-URL: jdbc:sqlserver://localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx Name des JDBC-Treibers: Microsoft JDBC Driver 4.0 for SQL Server Version des JDBC-Treibers: 4.0.2206.100 2015-04-23 11:18:51,043 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6016I Der Server versucht, eine Verbindung zur Datenbank "//localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx" herzustellen. 2015-04-23 11:18:51,076 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6017I Erfolgreiche Verbindung zur folgenden Datenbank: Name des DB-Produkts: Microsoft SQL Server Version des DB-Produkts: 11.00.3153 DB-URL: jdbc:sqlserver://localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx Name des JDBC-Treibers: Microsoft JDBC Driver 4.0 for SQL Server Version des JDBC-Treibers: 4.0.2206.100 2015-04-23 11:18:53,548 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6016I Der Server versucht, eine Verbindung zur Datenbank "//localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx" herzustellen. 2015-04-23 11:18:53,565 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6017I Erfolgreiche Verbindung zur folgenden Datenbank: Name des DB-Produkts: Microsoft SQL Server Version des DB-Produkts: 11.00.3153 DB-URL: jdbc:sqlserver://localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx Name des JDBC-Treibers: Microsoft JDBC Driver 4.0 for SQL Server Version des JDBC-Treibers: 4.0.2206.100 2015-04-23 11:19:00,046 [ http-bio-9443-exec-111] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6016I Der Server versucht, eine Verbindung zur Datenbank "//localhost:1433;databaseName=dw;user=xxxxxxxx" herzustellen. 2015-04-23 11:19:00,112 [ http-bio-9443-exec-111] ERROR tegration.reporting.db.jdbcdriver.AbstractDbDriver - CRRGW6003E Der Server konnte keine Verbindung zur Datenbank herstellen, da die Datenbankverbindungseinstellungen ungültig sind oder die Datenbank nicht erreichbar ist (SQLSTATE: S0001, SQLCODE: 18456). Überprüfen Sie die Verbindungseinstellungen in Ihrer Datenquelle. com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'DWuser'. ClientConnectionId:baa61458-ac54-444c-a1fe-aaa2978c4d0d at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at com.ibm.team.integration.reporting.db.jdbcdriver.AbstractDbDriver.getConnection(AbstractDbDriver.java:322) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionFactory.createConnection(DbConnectionFactory.java:61) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.createEntry(DbConnectionPool.java:86) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.createEntry(DbConnectionPool.java:1) at com.ibm.team.integration.reporting.db.connection.impl.AbstractPool.getEntry(AbstractPool.java:122) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.getConnection(DbConnectionPool.java:113) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.getConnection(DbConnectionService.java:124) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.getTempConnection(DbConnectionService.java:98) at com.ibm.team.integration.reporting.model.utils.DbUtils.testSQLConnection(DbUtils.java:184) at com.ibm.team.integration.reporting.model.services.Endpoint.testConnection(Endpoint.java:600) at com.ibm.team.integration.reporting.model.services.Endpoint.doGet(Endpoint.java:106) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:245) at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:226) at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:358) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:767) 2015-04-23 11:19:01,127 [ http-bio-9443-exec-111] ERROR tegration.reporting.db.jdbcdriver.AbstractDbDriver - CRRGW6003E Der Server konnte keine Verbindung zur Datenbank herstellen, da die Datenbankverbindungseinstellungen ungültig sind oder die Datenbank nicht erreichbar ist (SQLSTATE: S0001, SQLCODE: 18456). Überprüfen Sie die Verbindungseinstellungen in Ihrer Datenquelle. com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'DWuser'. ClientConnectionId:c3887dc6-6f19-40d8-b59e-f204524d9bec at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012) at com.ibm.team.integration.reporting.db.jdbcdriver.AbstractDbDriver.getConnection(AbstractDbDriver.java:322) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionFactory.createConnection(DbConnectionFactory.java:61) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.createEntry(DbConnectionPool.java:86) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.createEntry(DbConnectionPool.java:1) at com.ibm.team.integration.reporting.db.connection.impl.AbstractPool.getEntry(AbstractPool.java:122) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.getConnection(DbConnectionPool.java:113) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.getConnection(DbConnectionService.java:124) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.getTempConnection(DbConnectionService.java:98) at com.ibm.team.integration.reporting.model.utils.DbUtils.testSQLConnection(DbUtils.java:184) at com.ibm.team.integration.reporting.model.services.Endpoint.testConnection(Endpoint.java:600) at com.ibm.team.integration.reporting.model.services.Endpoint.doGet(Endpoint.java:106) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:245) at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:226) at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:358) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:767) 2015-04-23 11:19:01,128 [ http-bio-9443-exec-111] ERROR ibm.team.integration.reporting.model.utils.DbUtils - CRRGW5548E Beim Überprüfen der Datenbankverbindung, die durch !CRRGW6018E Der Server konnte keine Verbindung zu folgender Datenbank herstellen: "//localhost:1433;databaseName=dw;user=xxxxxxxx". Ausnahme: "CRRGW6003E Der Server konnte keine Verbindung zur Datenbank herstellen, da die Datenbankverbindungseinstellungen ungültig sind oder die Datenbank nicht erreichbar ist (SQLSTATE: S0001, SQLCODE: 18456). Überprüfen Sie die Verbindungseinstellungen in Ihrer Datenquelle. "! verursacht wurde, ist ein com.ibm.team.integration.reporting.db.exception.DbAccessException-Fehler aufgetreten. com.ibm.team.integration.reporting.db.exception.DbAccessException: !CRRGW6018E Der Server konnte keine Verbindung zu folgender Datenbank herstellen: "//localhost:1433;databaseName=dw;user=xxxxxxxx". Ausnahme: "CRRGW6003E Der Server konnte keine Verbindung zur Datenbank herstellen, da die Datenbankverbindungseinstellungen ungültig sind oder die Datenbank nicht erreichbar ist (SQLSTATE: S0001, SQLCODE: 18456). Überprüfen Sie die Verbindungseinstellungen in Ihrer Datenquelle. "! at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionFactory.createConnection(DbConnectionFactory.java:84) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.createEntry(DbConnectionPool.java:86) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.createEntry(DbConnectionPool.java:1) at com.ibm.team.integration.reporting.db.connection.impl.AbstractPool.getEntry(AbstractPool.java:122) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionPool.getConnection(DbConnectionPool.java:113) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.getConnection(DbConnectionService.java:124) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.getTempConnection(DbConnectionService.java:98) at com.ibm.team.integration.reporting.model.utils.DbUtils.testSQLConnection(DbUtils.java:184) at com.ibm.team.integration.reporting.model.services.Endpoint.testConnection(Endpoint.java:600) at com.ibm.team.integration.reporting.model.services.Endpoint.doGet(Endpoint.java:106) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:245) at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:226) at com.ibm.team.integration.reporting.gatewayservices.Front.doGet(Front.java:66) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:358) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:767) Caused by: java.sql.SQLException: CRRGW6003E Der Server konnte keine Verbindung zur Datenbank herstellen, da die Datenbankverbindungseinstellungen ungültig sind oder die Datenbank nicht erreichbar ist (SQLSTATE: S0001, SQLCODE: 18456). Überprüfen Sie die Verbindungseinstellungen in Ihrer Datenquelle. at com.ibm.team.integration.reporting.db.jdbcdriver.AbstractDbDriver.getConnection(AbstractDbDriver.java:330) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionFactory.createConnection(DbConnectionFactory.java:61) ... 42 more 2015-04-23 11:19:11,285 [ http-bio-9443-exec-103] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6016I Der Server versucht, eine Verbindung zur Datenbank "//localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx" herzustellen. 2015-04-23 11:19:11,298 [ http-bio-9443-exec-103] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6017I Erfolgreiche Verbindung zur folgenden Datenbank: Name des DB-Produkts: Microsoft SQL Server Version des DB-Produkts: 11.00.3153 DB-URL: jdbc:sqlserver://localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx Name des JDBC-Treibers: Microsoft JDBC Driver 4.0 for SQL Server Version des JDBC-Treibers: 4.0.2206.100 2015-04-23 11:23:04,275 [ http-bio-9443-exec-108] INFO eporting.metamodel.internal.model.MetaModelManager - Aktualisierung des Metamodells beginnt. 2015-04-23 11:23:04,279 [ http-bio-9443-exec-108] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6016I Der Server versucht, eine Verbindung zur Datenbank "//localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx" herzustellen. 2015-04-23 11:23:04,292 [ http-bio-9443-exec-108] INFO n.reporting.db.connection.impl.DbConnectionFactory - CRRGW6017I Erfolgreiche Verbindung zur folgenden Datenbank: Name des DB-Produkts: Microsoft SQL Server Version des DB-Produkts: 11.00.3153 DB-URL: jdbc:sqlserver://localhost:1433;databaseName=dw;user=xxxxxxxx;password=xxxxxxxx Name des JDBC-Treibers: Microsoft JDBC Driver 4.0 for SQL Server Version des JDBC-Treibers: 4.0.2206.100 2015-04-23 11:23:04,957 [ http-bio-9443-exec-108] ERROR .team.integration.reporting.data.query.QueryRunner - CRRGW5503E Es wurde eine unerwartete Antwort von der Datenquelle empfangen: Invalid column name 'pred_requirement_link_label'. com.ibm.team.integration.reporting.common.exceptions.QueryRunningException: CRRGW5503E Es wurde eine unerwartete Antwort von der Datenquelle empfangen: Invalid column name 'pred_requirement_link_label'. at com.ibm.team.integration.reporting.data.query.SqlQueryRunner$1.run(SqlQueryRunner.java:143) at com.ibm.team.integration.reporting.db.connection.impl.DbConnectionService.executeAsRead(DbConnectionService.java:185) at com.ibm.team.integration.reporting.data.query.SqlQueryRunner.runQuery(SqlQueryRunner.java:150) at com.ibm.team.integration.reporting.data.query.SqlQueryRunner.runQuery(SqlQueryRunner.java:1) at com.ibm.team.integration.reporting.data.query.QueryRunner.runQueryRaw(QueryRunner.java:328) at com.ibm.team.integration.reporting.data.query.QueryRunner.runQuery(QueryRunner.java:263) at com.ibm.team.integration.reporting.metamodel.internal.extension.dw.Rational_DWExtension.addLinkToSameTypeProperties(Rational_DWExtension.java:1115) at com.ibm.team.integration.reporting.metamodel.internal.model.MetaModelManager.initialize(MetaModelManager.java:551) at com.ibm.team.integration.reporting.metamodel.internal.model.MetaModelManager.initializeForEndpoint(MetaModelManager.java:216) at com.ibm.team.integration.reporting.metamodel.internal.MetamodelService.processMetamodelRequest(MetamodelService.java:148) at com.ibm.team.integration.reporting.metamodel.internal.MetamodelService.doPost(MetamodelService.java:115) at com.ibm.team.integration.reporting.gatewayservices.FrontResultService.doPost(FrontResultService.java:508) at com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:176) at com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:282) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.model.utils.EndpointUtil.updateEndpointMetaModel(EndpointUtil.java:626) at com.ibm.team.integration.reporting.model.services.EndpointIndividual.replaceEndpoint(EndpointIndividual.java:435) at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPut(EndpointIndividual.java:354) at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPost(EndpointIndividual.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.model.services.Endpoint.doPost(Endpoint.java:315) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:245) at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:226) at com.ibm.team.integration.reporting.gatewayservices.Front.doPost(Front.java:78) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:358) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:767) 2015-04-23 11:23:04,965 [ http-bio-9443-exec-108] INFO eporting.metamodel.internal.model.MetaModelManager - Aktualisierung des Metamodells wurde fertig gestellt. 2015-04-23 11:23:04,965 [ http-bio-9443-exec-108] ERROR eam.integration.reporting.model.utils.EndpointUtil - java.lang.NullPointerException at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:437) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.model.utils.EndpointUtil.updateEndpointMetaModel(EndpointUtil.java:626) at com.ibm.team.integration.reporting.model.services.EndpointIndividual.replaceEndpoint(EndpointIndividual.java:435) at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPut(EndpointIndividual.java:354) at com.ibm.team.integration.reporting.model.services.EndpointIndividual.doPost(EndpointIndividual.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.model.services.Endpoint.doPost(Endpoint.java:315) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:378) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338) at com.ibm.team.integration.reporting.gatewayservices.Front.forwardRequest(Front.java:245) at com.ibm.team.integration.reporting.gatewayservices.Front.handleRequest(Front.java:226) at com.ibm.team.integration.reporting.gatewayservices.Front.doPost(Front.java:78) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.ibm.team.integration.reporting.common.services.EncodingFilter.doFilter(EncodingFilter.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:613) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:358) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:767) 2015-04-23 11:23:10,614 [ http-bio-9443-exec-108] INFO eam.integration.reporting.model.utils.EndpointUtil - CRRGW0073I SPARQL-Datenquellen-URL für Lifecycle Query Engine erhalten: https://skltibmswg01.keba.co.at:9443/lqe/sparql

1 answer

7,703 views

0 votes

One answer

Permanent link

Gerald Weichbold

(11●3●4) Apr 27 '15, 7:03 a.m.

can anybody help?

0 votes

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.

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

rational-team-concert

× 43,075

clm

× 7,622

troubleshooting

× 6,081

jazz-foundation

× 4,381

Question asked: Apr 24 '15, 3:00 a.m.

Question was seen: 7,703 times

Last updated: Feb 22 '17, 5:59 a.m.

JRS not working

Gerald Weichbold

Comments

Gerald Weichbold

1 answer

7,703 views

0 votes

One answer

Gerald Weichbold

Your answer

Follow this question

Question details

Related questions