It's all about the answers!

Ask a question

JRS not working


Gerald Weichbold (1114) | 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 (1114) | answered Apr 27 '15, 7:03 a.m.
can anybody help?

Your answer


Register or to post your answer.