COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Cognosy on 30 Aug 2018 01:50:13 AM

Title: Report on HANA Views as Data Source Throwing Server Error
Post by: Cognosy on 30 Aug 2018 01:50:13 AM
Hi,
Certain report could not run because a server error occurred. PFB for detailed error. Could somebody direct me the approach to debug the same.

QuoteXQE-DAT-0001 Data source adapter error: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [2048]: column store error: search table error:  [9] Memory allocation failed
RSV-SRV-0042 Trace back:
RSReportService.cpp(766): XQEException: CCL_CAUGHT: RSReportService::processImpl()
RSReportServiceMethod.cpp(253): XQEException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_Request
RSASyncExecutionThread.cpp(873): XQEException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(317): XQEException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_Request
RSASyncExecutionThread.cpp(918): XQEException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_Request
Execution/RSRenderExecution.cpp(582): XQEException: CCL_RETHROW: RSRenderExecution::execute
Assembly/RSDocAssemblyDispatch.cpp(346): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSLayoutAssembly.cpp(79): XQEException: CCL_RETHROW: RSLayoutAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(455): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
Assembly/RSReportPagesAssembly.cpp(185): XQEException: CCL_RETHROW: RSReportPagesAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSPageAssembly.cpp(314): XQEException: CCL_RETHROW: RSPageAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSTableRowAssembly.cpp(177): XQEException: CCL_RETHROW: RSTableRowAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSTableCellAssembly.cpp(151): XQEException: CCL_RETHROW: RSTableCellAssembly::assemble
Assembly/RSDocAssemblyDispatch.cpp(455): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForward
Assembly/RSDocAssemblyDispatch.cpp(391): XQEException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssembly
Assembly/RSAssembly.cpp(698): XQEException: CCL_RETHROW: RSAssembly::createListIterator
Assembly/RSAssembly.cpp(766): XQEException: CCL_RETHROW: RSAssembly::createListIterator
RSQueryMgr.cpp(809): XQEException: CCL_RETHROW: RSQueryMgr::getListIterator
RSQueryMgr.cpp(881): XQEException: CCL_RETHROW: RSQueryMgr::getResultSetIterator
RSQueryMgr.cpp(989): XQEException: CCL_RETHROW: RSQueryMgr::createIterator
RSQueryMgrBasic.cpp(296): XQEException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommand
RSQueryMgrExecutionHandlerImpl.cpp(168): XQEException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()
QFSSession.cpp(1238): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1236): XQEException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1197): XQEException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSConnection.cpp(854): XQEException: CCL_RETHROW: QFSConnection::Execute
QFSQuery.cpp(213): XQEException: CCL_RETHROW: QFSQuery::Execute v2
XQEConnector.cpp(300): XQEException: CCL_THROW: XQEConnector::send
Title: Re: Report on HANA Views as Data Source Throwing Server Error
Post by: MFGF on 30 Aug 2018 02:44:13 AM
Quote from: Cognosy on 30 Aug 2018 01:50:13 AM
Hi,
Certain report could not run because a server error occurred. PFB for detailed error. Could somebody direct me the approach to debug the same.

Hi,

I'm not an expert on SAP Hana by any stretch of the imagination, but googling "SAP DBTech JDBC: [2048]: column store error: search table error:  [9] Memory allocation failed." points to this being an error from Hana telling you it is out of memory.

http://sapkbs.blogspot.com/2016/02/1999997-faq-sap-hana-memory.html

I'd be looking at your Hana indexserver trace files to see what they are saying, and also asking SAP support if they can help you with this. I have seen a couple of posts online saying that people with this error have been successful by moving to a newer Hana revision, too, so it might be a limitation of the revision you are using? Bottom line is that this isn't a Cognos error - it's Hana running out of memory. My guess is the report is trying to retrieve a huge amount of data?

Good luck!

MF.
Title: Re: Report on HANA Views as Data Source Throwing Server Error
Post by: Cognosy on 30 Aug 2018 05:03:34 AM
Thank you very Much. Resolved
Title: Re: Report on HANA Views as Data Source Throwing Server Error
Post by: MFGF on 30 Aug 2018 05:14:32 AM
Quote from: Cognosy on 30 Aug 2018 05:03:34 AM
Thank you very Much. Resolved

What did you do to fix the issue? Might be useful to others in the future with the same problem if you can point them in the right direction?

Cheers!

MF.
Title: Re: Report on HANA Views as Data Source Throwing Server Error
Post by: Cognosy on 31 Aug 2018 01:05:20 AM
Hi,
I talked to the BASIS team to allocate more memory. Also since I was loading all the data in the prompt page, the Query was taking longer memory hence more time to load.
1. Allot more memory
2. Run only the required queries