SAP Knowledge Base Article - Preview

3060896 - Upgrade using SUM fails with error SQL error "129" during "<table_name>" access: "transaction rolled back by an internal error"

Symptom

During upgrade of an SAP system using SUM, 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 ONE Support launchpad (Login required).

Search for additional results

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