JRS not working
![]()
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! |
One answer
|
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.
Comments
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