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
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.
SAP Knowledge Base Article - Preview