SAP Knowledge Base Article - Preview

3060896 - SQL error "129" during "<table_name>" access: "transaction rolled back by an internal error"

Symptom

During an object activation, it fails with error

invalid cursor 65535 specified for database operation

SQL error "129" during "<table_name>" access: "transaction rolled back by an internal error

In the HANA indexserver trace, you find the following entries matching the time of the error in SUM:

failed to encode cursor: ERROR [SQL-129] transaction rolled back by an internal error

...

1: 0x00007fe99a00e7f6 in ptime::NLocator::checkPtrValidity(ptime::NLocator&, unsigned long, unsigned long)+0xa2 at NLocator.h:131 (libhdbrskernel.so)
2: 0x00007fe99a012159 in ptime::NLocator::read(char*, unsigned long, unsigned long)+0x185 at NLocator.cc:725 (libhdbrskernel.so)
3: 0x00007fe99a00f15a in ptime::operator<<(ptime::orawstream&, ptime::NLocator const&)+0x2f6 at NLocator.cc:1196 (libhdbrskernel.so)
4: 0x00007fe99a02c509 in expr::types::Copy_lob(ptime::Env*, ptime::NLocator&)+0x95 at RsTypeIntegrationExt.cc:37 (libhdbrskernel.so)
5: 0x00007fe98a4c6c9d in __copy__NLocator+0x9 at RsTypeIntegrationExt.h:342 (libhdbrsfunctions.so)
6: 0x00007fe9918f498a in expr::Invoker1<expr::param::Q, expr::param::R>::RunE(expr::Evaluator&, expr::Expression const&)+0xb6 at Invoke.h:95 (libhdbexpression.so)
7: 0x00007fe99190045b in expr::Dispatcher<7>::Dispatch(expr::Evaluator&, expr::Expression const&)+0x77 at Evaluator.h:301 (libhdbexpression.so)
8: 0x00007fe99a185a13 in expr::Evaluator::DoRun(expr::Expression const&)+0x30 at Evaluator.h:301 (libhdbrskernel.so)
9: 0x00007fe99967d674 in ptime::CopyExpression::operator()(ptime::orawstream&, ptime::Env&, void**) const+0x50 at ExpressionWrapper.h:177 (libhdbrskernel.so)
10: 0x00007fe9998d3a02 in void ptime::Project_copy::fetch_into_stream<ptime::orawstream>(ptime::Env&, ptime::orawstream&, ptime::Buffer::iterator&, ptime::Buffer::iterator&) const+0x120 at qe_project.cc:55 (libhdbrskernel.so)


" access: "transaction rolled back by an internal error""> Read more...

Environment

 SAP HANA

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-LM-UPG-DB , Upgrade of HANA Database , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.