It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,235

question asked: Nov 12 '10, 3:52 a.m.
question was seen: 7,182 times
last updated: Nov 12 '10, 3:52 a.m.

Related questions

TO Do Action Executive view appear following error

0
Bin Tan (11●3●2) | asked Nov 12 '10, 3:52 a.m.
Hi guys:
When I action Executive view in public Folders->Dashboards by Category-> Executive View appear follow error:
please help to me find out that problem cause,thanks.
RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'.
com.cognos.portal.fragment.server.SOAPFaultException: RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'.
at com.cognos.portal.fragment.service.ServiceEnvironment.getBiBusTargetStream(ServiceEnvironment.java:438)
at com.cognos.portal.fragment.service.ServiceEnvironment.getLocalTargetStream(ServiceEnvironment.java:258)
at com.cognos.portal.fragment.Environment.getTargetStream(Environment.java:577)
at com.cognos.portal.fragment.server.document.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:110)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:395)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:401)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.PageDocument.writeFragmentInstance(PageDocument.java:375)
at com.cognos.portal.fragment.server.document.PageDocument.writePage(PageDocument.java:245)
at com.cognos.portal.fragment.server.document.PageDocument.processDocument(PageDocument.java:170)
at com.cognos.portal.fragment.server.document.PageDocument.writeXML(PageDocument.java:83)
at com.cognos.portal.fragment.server.document.FragmentReferenceDocument.writeXML(FragmentReferenceDocument.java:55)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:401)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.PageDocument.writeFragmentInstance(PageDocument.java:375)
at com.cognos.portal.fragment.server.document.PageDocument.writePage(PageDocument.java:245)
at com.cognos.portal.fragment.server.document.PageDocument.processDocument(PageDocument.java:170)
at com.cognos.portal.fragment.server.document.PageDocument.writeHTML(PageDocument.java:142)
at com.cognos.portal.fragment.server.document.FragmentReferenceDocument.writeHTML(FragmentReferenceDocument.java:68)
at com.cognos.portal.fragment.server.DashboardProcessor.writeHTML(DashboardProcessor.java:286)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:248)
at com.cognos.portal.fragment.service.DashboardService.invokeImpl(DashboardService.java:290)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:659)
at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:625)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:135)
at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:257)
at com.cognos.pogo.transport.PogoServlet.doGet(PogoServlet.java:573)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:311)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1096)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:570)
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:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
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.HttpInboundLink.ready(HttpInboundLink.java:267)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
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)
<SOAP><faultcode>SOAP-ENV:Client</faultcode><faultstring>Client Error</faultstring><detail><bus> <bus>Error</bus>
<bus>-9</bus>
<bus>
<bus>RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'.</bus>
<bus>9</bus>
</bus>
<bus>
<bus>UDA-SQL-0107 A general exception has occurred during the operation "fetch".</bus>
<bus>32</bus>
</bus>
<bus>
<bus> SQL0290N Table space access is not allowed. SQLSTATE=55039
</bus>
<bus>83</bus>
</bus>
<bus>
<bus>RSV-SRV-0042 Trace back:</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSReportServiceMethod.cpp(239): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_Request</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkException</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRun_Request</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_Request</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Execution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::execute</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSPageAssembly.cpp(287): QFException: CCL_RETHROW: RSPageAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSTableRowAssembly.cpp(160): QFException: CCL_RETHROW: RSTableRowAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSTableCellAssembly.cpp(122): QFException: CCL_RETHROW: RSTableCellAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1051): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1211): QFException: CCL_RETHROW: RSQueryMgr::createIterator</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1511): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1498): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQFSession.cpp(243): QFException: CCL_RETHROW: RSQFSession::DoRequest</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSSession.cpp(603): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSSession.cpp(601): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSSession.cpp(558): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::Execute</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2</bus>
<bus>1</bus>
</bus>
<bus>
<bus>CoordinationQFSQuery.cpp(4174): QFException: CCL_THROW: CoordinationPlanner</bus>
<bus>1</bus>
</bus>
</bus></detail></SOAP>
at com.cognos.portal.soap.impl.SOAPConnectionImpl.handleFault(SOAPConnectionImpl.java:289)
at com.cognos.portal.soap.impl.SOAPConnectionImpl.readResponse(SOAPConnectionImpl.java:237)
at com.cognos.portal.soap.impl.SOAPConnectionImpl.processResponse(SOAPConnectionImpl.java:196)
at com.cognos.portal.soap.impl.BusConnectionImpl.execute(BusConnectionImpl.java:131)
at com.cognos.portal.fragment.service.ServiceEnvironment.getBiBusTargetStream(ServiceEnvironment.java:410)
at com.cognos.portal.fragment.service.ServiceEnvironment.getLocalTargetStream(ServiceEnvironment.java:258)
at com.cognos.portal.fragment.Environment.getTargetStream(Environment.java:577)
at com.cognos.portal.fragment.server.document.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:110)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:395)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:401)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.PageDocument.writeFragmentInstance(PageDocument.java:375)
at com.cognos.portal.fragment.server.document.PageDocument.writePage(PageDocument.java:245)
at com.cognos.portal.fragment.server.document.PageDocument.processDocument(PageDocument.java:170)
at com.cognos.portal.fragment.server.document.PageDocument.writeXML(PageDocument.java:83)
at com.cognos.portal.fragment.server.document.FragmentReferenceDocument.writeXML(FragmentReferenceDocument.java:55)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:401)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.PageDocument.writeFragmentInstance(PageDocument.java:375)
at com.cognos.portal.fragment.server.document.PageDocument.writePage(PageDocument.java:245)
at com.cognos.portal.fragment.server.document.PageDocument.processDocument(PageDocument.java:170)
at com.cognos.portal.fragment.server.document.PageDocument.writeHTML(PageDocument.java:142)
at com.cognos.portal.fragment.server.document.FragmentReferenceDocument.writeHTML(FragmentReferenceDocument.java:68)
at com.cognos.portal.fragment.server.DashboardProcessor.writeHTML(DashboardProcessor.java:286)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:248)
at com.cognos.portal.fragment.service.DashboardService.invokeImpl(DashboardService.java:290)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:659)
at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:625)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:135)
at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:257)
at com.cognos.pogo.transport.PogoServlet.doGet(PogoServlet.java:573)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:311)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1096)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:570)
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:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
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.HttpInboundLink.ready(HttpInboundLink.java:267)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
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)

Root Cause:
<SOAP><faultcode>SOAP-ENV:Client</faultcode><faultstring>Client Error</faultstring><detail><bus> <bus>Error</bus>
<bus>-9</bus>
<bus>
<bus>RQP-DEF-0177 An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'.</bus>
<bus>9</bus>
</bus>
<bus>
<bus>UDA-SQL-0107 A general exception has occurred during the operation "fetch".</bus>
<bus>32</bus>
</bus>
<bus>
<bus> SQL0290N Table space access is not allowed. SQLSTATE=55039
</bus>
<bus>83</bus>
</bus>
<bus>
<bus>RSV-SRV-0042 Trace back:</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSReportService.cpp(758): QFException: CCL_CAUGHT: RSReportService::process()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSReportServiceMethod.cpp(239): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRun_Request</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSASyncExecutionThread.cpp(774): QFException: RSASyncExecutionThread::checkException</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSASyncExecutionThread.cpp(211): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRun_Request</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSASyncExecutionThread.cpp(824): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRun_Request</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Execution/RSRenderExecution.cpp(593): QFException: CCL_RETHROW: RSRenderExecution::execute</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(264): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSLayoutAssembly.cpp(64): QFException: CCL_RETHROW: RSLayoutAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSReportPagesAssembly.cpp(163): QFException: CCL_RETHROW: RSReportPagesAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSPageAssembly.cpp(287): QFException: CCL_RETHROW: RSPageAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSTableRowAssembly.cpp(160): QFException: CCL_RETHROW: RSTableRowAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(281): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSTableCellAssembly.cpp(122): QFException: CCL_RETHROW: RSTableCellAssembly::assemble</bus>
<bus>1</bus>
</bus>
<bus>
<bus>Assembly/RSDocAssemblyDispatch.cpp(331): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1051): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIterator</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1211): QFException: CCL_RETHROW: RSQueryMgr::createIterator</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1511): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgr.cpp(1498): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQueryMgrExecutionHandlerImpl.cpp(154): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>RSQFSession.cpp(243): QFException: CCL_RETHROW: RSQFSession::DoRequest</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSSession.cpp(603): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSSession.cpp(601): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSSession.cpp(558): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSConnection.cpp(737): QFException: CCL_RETHROW: QFSConnection::Execute</bus>
<bus>1</bus>
</bus>
<bus>
<bus>QFSQuery.cpp(199): QFException: CCL_RETHROW: QFSQuery::Execute v2</bus>
<bus>1</bus>
</bus>
<bus>
<bus>CoordinationQFSQuery.cpp(4174): QFException: CCL_THROW: CoordinationPlanner</bus>
<bus>1</bus>
</bus>
</bus></detail></SOAP>
at com.cognos.portal.soap.impl.SOAPConnectionImpl.handleFault(SOAPConnectionImpl.java:289)
at com.cognos.portal.soap.impl.SOAPConnectionImpl.readResponse(SOAPConnectionImpl.java:237)
at com.cognos.portal.soap.impl.SOAPConnectionImpl.processResponse(SOAPConnectionImpl.java:196)
at com.cognos.portal.soap.impl.BusConnectionImpl.execute(BusConnectionImpl.java:131)
at com.cognos.portal.fragment.service.ServiceEnvironment.getBiBusTargetStream(ServiceEnvironment.java:410)
at com.cognos.portal.fragment.service.ServiceEnvironment.getLocalTargetStream(ServiceEnvironment.java:258)
at com.cognos.portal.fragment.Environment.getTargetStream(Environment.java:577)
at com.cognos.portal.fragment.server.document.DocumentFactoryImpl.createDocument(DocumentFactoryImpl.java:110)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:395)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:401)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.PageDocument.writeFragmentInstance(PageDocument.java:375)
at com.cognos.portal.fragment.server.document.PageDocument.writePage(PageDocument.java:245)
at com.cognos.portal.fragment.server.document.PageDocument.processDocument(PageDocument.java:170)
at com.cognos.portal.fragment.server.document.PageDocument.writeXML(PageDocument.java:83)
at com.cognos.portal.fragment.server.document.FragmentReferenceDocument.writeXML(FragmentReferenceDocument.java:55)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeFragment(FragmentDocument.java:401)
at com.cognos.portal.fragment.server.document.FragmentDocument.writeXML(FragmentDocument.java:89)
at com.cognos.portal.fragment.server.document.PageDocument.writeFragmentInstance(PageDocument.java:375)
at com.cognos.portal.fragment.server.document.PageDocument.writePage(PageDocument.java:245)
at com.cognos.portal.fragment.server.document.PageDocument.processDocument(PageDocument.java:170)
at com.cognos.portal.fragment.server.document.PageDocument.writeHTML(PageDocument.java:142)
at com.cognos.portal.fragment.server.document.FragmentReferenceDocument.writeHTML(FragmentReferenceDocument.java:68)
at com.cognos.portal.fragment.server.DashboardProcessor.writeHTML(DashboardProcessor.java:286)
at com.cognos.portal.fragment.server.DashboardProcessor.process(DashboardProcessor.java:248)
at com.cognos.portal.fragment.service.DashboardService.invokeImpl(DashboardService.java:290)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.p2plb.clerver.LoadBalanceHandler.rawForwardToSelf(LoadBalanceHandler.java:659)
at com.cognos.p2plb.clerver.LoadBalanceHandler.forwardToSelf(LoadBalanceHandler.java:625)
at com.cognos.p2plb.clerver.LoadBalanceHandler.invokeImpl(LoadBalanceHandler.java:382)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.engine.ServiceLookupHandler.invokeImpl(ServiceLookupHandler.java:116)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.logic.ChainHandler.invokeImpl(ChainHandler.java:73)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.handlers.performance.PerformanceIndicationHandler.invokeImpl(PerformanceIndicationHandler.java:143)
at com.cognos.pogo.pdk.BasicHandler.invoke(BasicHandler.java:252)
at com.cognos.pogo.impl.PogoEngineImpl.service(PogoEngineImpl.java:135)
at com.cognos.pogo.transport.PogoServlet.processRequest(PogoServlet.java:257)
at com.cognos.pogo.transport.PogoServlet.doGet(PogoServlet.java:573)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.cognos.pogo.isolation.ServletWrapper.service(ServletWrapper.java:311)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1096)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:570)
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:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
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.HttpInboundLink.ready(HttpInboundLink.java:267)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
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)

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jeffrey Liu (111●1●3●1) | answered Nov 12 '10, 11:40 a.m.
Hi,

The error messages suggests:

SQL0290N Table space access is not allowed. SQLSTATE=55039

Looks like there's some problems with your table space in DB2. Below is the explanation from DB2, try following the user responses given below.

Thanks, Jeff

Explanation: A process attempted to access a table space which is in an invalid state for which the intended access is not allowed.

- If the table space is in a quiesced state, only processes which also hold the table space in a quiesced state are allowed access to the table space.
- If the table space is in any other state, only the process which is performing the action specified is allowed access to the table space.
- A system or user temporary table space cannot be dropped which contains active system or declared temporary tables.
- The SET CONTAINER api cannot be used to set the container list unless the table space is in a "restore pending" state.

Details can be found in the system error log and/or the database manager error log.

User Response: Possible actions include:

- If the table space is in a quiesced state, attempt to acquire a quiesced share or quiesced update state on the table space. Or, attempt to quiesce reset the table space.
- If the table space is in any other state, wait until the table space has returned to normal state before attempting to access the table space.

Refer to the Administration Guide for further information about the table space states. sqlcode: -290 sqlstate: 55039

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.