If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report on HANA Views as Data Source Throwing Server Error

Started by Cognosy, 30 Aug 2018 01:50:13 AM

Previous topic - Next topic

Cognosy

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

MFGF

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.
Meep!

Cognosy


MFGF

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.
Meep!

Cognosy

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