Hi Guys,
Don't know how to explain this. But I try my best.
Has anyone got Tivoli Common Reporting working in TSM 6.1?
I have installed and configure everything on my reporting server and when I go
to Tivoli Enterprise Portal I can see all data I wanna see.
But when I go to the ISC and wanna view the same data in TCR (Tivoli Common
Reporting) I got an error and it doesn't show me any information.
----------------------------------
CTGTRV014E The report can not be successfully formatted because it completed
with errors, reference ID [REPORTID_33_OBJECTID_1cd41cd4]. Click on the
following link to view the report with the errors.
CTGTRV011E See the Tivoli Common Reporting log files for more information.
https://172.16.141.128:9044/TCR/Reports/view
----------------------------------
When I click on the link I got following information
---------------------------------
The following items have errors:
ReportDesign (id = 1):
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE_DV
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV
SQL error #3: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE_DV
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV
SQL error #3: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV
( 1 time(s) )
detail : org.eclipse.birt.report.data.adapter.api.AdapterException: Cannot get
the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE_DV
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV
SQL error #3: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE_DV
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:450)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:151)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:182)
at
org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:197)
at
org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:63)
at
org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:60)
at
org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at
org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at
org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:95)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:135)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:76)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:140)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68)
at
com.ibm.tivoli.reporting.reportEngine.impl.BIRTReportEngineRunRenderHandler.runAndRenderReport(BIRTReportEngineRunRenderHandler.java:1170)
at
com.ibm.tivoli.reporting.reportEngine.impl.BIRTReportEngine.runAndRenderReport(BIRTReportEngine.java:839)
at
com.ibm.tivoli.reporting.common.runAndRender.RunAndRenderServices.runAndrenderReport(RunAndRenderServices.java:894)
at
com.ibm.tivoli.reporting.ejb.TivoliReportingEJBBean.runAndrenderReport(TivoliReportingEJBBean.java:4524)
at
com.ibm.tivoli.reporting.ejb.EJSLocalStatelessTivoliReportingEJB_f305bd50.runAndrenderReport(Unknown
Source)
at
com.ibm.tivoli.reporting.reportViewer.ReportViewer.processRequest(ReportViewer.java:529)
at
com.ibm.tivoli.reporting.reportViewer.ReportViewer.doGet(ReportViewer.java:197)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1101)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:569)
at
com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1461)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:118)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at
com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
at
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE
SQL error #3: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE
SQL error #3: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE
( 1 time(s) )
detail : org.eclipse.birt.report.data.adapter.api.AdapterException: Cannot get
the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:
ITMUSER.KSK_DATABASE
SQL error #2: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE
SQL error #3: DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC:
2;-204;42704;ITMUSER.KSK_DATABASE
at
org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:450)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:151)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:182)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1683)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:76)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
at
org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
at
org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
at
org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:33)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:95)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:135)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:76)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:95)
at
org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:135)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:27)
at
org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:76)
at
org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:133)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:140)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68)
at
com.ibm.tivoli.reporting.reportEngine.impl.BIRTReportEngineRunRenderHandler.runAndRenderReport(BIRTReportEngineRunRenderHandler.java:1170)
at
com.ibm.tivoli.reporting.reportEngine.impl.BIRTReportEngine.runAndRenderReport(BIRTReportEngine.java:839)
at
com.ibm.tivoli.reporting.common.runAndRender.RunAndRenderServices.runAndrenderReport(RunAndRenderServices.java:894)
at
com.ibm.tivoli.reporting.ejb.TivoliReportingEJBBean.runAndrenderReport(TivoliReportingEJBBean.java:4524)
at
com.ibm.tivoli.reporting.ejb.EJSLocalStatelessTivoliReportingEJB_f305bd50.runAndrenderReport(Unknown
Source)
at
com.ibm.tivoli.reporting.reportViewer.ReportViewer.processRequest(ReportViewer.java:529)
at
com.ibm.tivoli.reporting.reportViewer.ReportViewer.doGet(ReportViewer.java:197)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1101)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:569)
at
com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1461)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:118)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at
com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
at
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
----------------------------------
When I manually connect to the DB2 database and open Schema ITMUSER I can't
find any tables called KSK_DATABASE_DV
So I wonder if I missed a configuration step or has my installed failed but I
didn't see that?
Best Regards
Christian Svensson
Cell: +46-70-325 1577
E-mail: Christian.Svensson AT cristie DOT se
Skype: cristie.christian.svensson
|
