SAP Knowledge Base Article - Preview

3384024 - ADSO activation fails with error transaction rolled back by an internal error: generic. setColumns() is not allowed

Symptom

After upgrading to SAP HANA 2.0 SPS06 or higher, ADSO activation or request activation fails with the following error:
Could not activate in step SAP HANA optimized activation
Serious error occurred: transaction rolled back by an internal error: generic. setColumns() is not allowed
Error during in-memory activation

The affected statement is a DML Statement (Update/Insert/Upsert) that is also visible in indexserver traces.

E.g.:[14557] 2025-09-18 10:35:39.230671 SQL statement: UPDATE "SAPHANADB"."/BIC/AZD_MMIM062" SET "RECORDMODE" = ?, "RECORDTP" = ?, "QUANTITY" = ?, "RECTOTSTCK" = ?, "ISSTOTSTCK" = ?, "RECVALSTCK" = ?, "ISSVALSTCK" = ?, "RECCNSSTCK" = ?, "ISSCNSSTCK" = ? WHERE "$rowid$" = ?, 

exception  1: no.70041002  (BW_DataStoreObject/TableUpdate/DSOTableUpdateViaEAPI.cpp:189) TID: 14557
    transaction rolled back by an internal error: generic. setColumns() is not allowed at ptime/query/plan_executor/dml/proc/qe_proc_trex.cc:404
exception throw location:
   0: 0x00007fa090b03977 in DSOImpl::DSOException::DSOException(int, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const&, char const*, int)+0x73 at BW_DataStoreObject/DSOException.cpp:166 (libhdbcsdsocommon.so)
   1: 0x00007f96fce8afdb in DSOImpl::DSOTableUpdateViaEAPI::executeUpdate() [clone .cold]+0x727 at BW_DataStoreObject/TableUpdate/DSOTableUpdateViaEAPI.cpp:189 (libhdbcsdso.so)
   2: 0x00007f96fc9146e5 in DSOImpl::ActivationQueuePackage::executeUpdates(DSOImpl::ColumnLayoutOfDSOTables const&, DSOImpl::ActiveDataUpdateColumnData const&, bool, DSOImpl::Entities const&, DSOImpl::DSOPrepareFromColumnLayout&)+0x231 at BW_DataStoreObject/activation/DSOActivationQueuePackage.cpp:575 (libhdbcsdso.so)
   3: 0x00007f96fc91c765 in DSOImpl::ActivationQueuePackage::updateActiveData(ltt::smartptr_handle<TRexCommonObjects::InternalTableBase> const&, TrexBase::IndexName const&, TrexBase::IndexName const&, DSOImpl::NewValueCalculatorContainer const&, DSOImpl::MultiColumnValues const&, DSOImpl::ColumnLayoutOfDSOTables const&, DSOImpl::DSOIndex const&, DSOImpl::DetailedChangeLogAndActiveDataCalculator&)+0x13e1 at BW_DataStoreObject/activation/DSOActivationQueuePackage.cpp:889 (libhdbcsdso.so)
   4: 0x00007f96fc9189e2 in DSOImpl::ActivationQueuePackage::run()+0x330 at BW_DataStoreObject/activation/DSOActivationQueuePackage.cpp:315 (libhdbcsdso.so)
   5: 0x00007f96fcaff7b6 in DSOImpl::SimpleTaskAdapterBase<DSOImpl::ActivationRowPackage, DSOImpl::TaskAdapter<DSOImpl::ActivationRowPackage> >::operator()()+0x32 at BW_DataStoreObject/threading/DSOJobRunner.h:498 (libhdbcsdso.so)
   6: 0x00007f96fcaff8d9 in DSOImpl::DSOJobRunner<DSOImpl::TaskAdapter<DSOImpl::ActivationRowPackage> >::TaskListProcessorJob::run(Execution::Context&, Execution::JobObject&)+0xf5 at BW_DataStoreObject/threading/DSOJobRunner.h:429 (libhdbcsdso.so)
   7: 0x00007fa0667d7a2b in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x13d7 at Basis/Execution/impl/JobExecutorRunJob.cpp:772 (libhdbbasis.so)
   8: 0x00007fa0667df32a in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x8a6 at Basis/Execution/impl/JobExecutorThreads.cpp:379 (libhdbbasis.so)
   9: 0x00007fa0667e1018 in Execution::JobWorker::run(Execution::ThreadRC&)+0x744 at Basis/Execution/impl/JobExecutorThreads.cpp:1382 (libhdbbasis.so)
  10: 0x00007fa066821cf4 in Execution::Thread::staticMainImp(Execution::Thread*)+0x610 at Basis/Execution/impl/Thread.cpp:612 (libhdbbasis.so)
  11: 0x00007fa0668282df in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x1eb at Basis/Execution/impl/ThreadInterposition.cpp:684 (libhdbbasis.so)
  12: 0x00007fa0658a6f6c in start_thread+0x2ba (libc.so.6)
  13: 0x00007fa06592e338 in __clone3+0x26 (libc.so.6)


Read more...

Environment

SAP BW systems on SAP HANA 2.0 SPS06 or higher

Product

SAP HANA, platform edition 2.0

Keywords

rhs table parts, SQLExcept ion generic, $DSO TaskMethod$=ActivationQueuePackage, $DSOTaskDetail, failed to activate dso with persisted changelog, DSOTableUpdate, generic,setColumns() , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.