It's all about the answers!

Ask a question

JRS not working


Gerald Weichbold (1134) | asked 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!

Comments
Gerald Weichbold commented Apr 24 '15, 3:01 a.m. | edited 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

One answer



permanent link
Gerald Weichbold (1134) | answered Apr 27 '15, 7:03 a.m.
can anybody help?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.