SAP Knowledge Base Article - Preview

3221178 - csddl/RedefineAttributeData: handle for SID::Schema:Table (t xxx) failed with exception: exception  1: no.1000000  (CS/DDL/impl/RedefineAttributeData.cpp:522) TID: xxx unsupported operation in online ddl mode; $condition$=!_online

Symptom

  • Call SE11 and choose the menu path “Utilities” > “Database Object” > “Check”. When trying to re-activate the table in question, the activation log results in the following errors :
Activate table VBAK                                                                                                                 
     Warning Enhancement category 3 possible (include or subtype not yet classified)                                                             
     Warning Index esh:ftx~userid~vbak~ktext~001 was not created with ABAP DDIC                                                               
        Analysis strategy: CL_DD_DIST_STRATEGY_SHARED_BG                                                                                    
        Decided by handler class CL_DD_DISTHANDLER_CMP_FLDS_BG                                                                              
        VBAK: Structure change at field level (DB is adjusted)                                                                              
        Adjust table in DB >>>                                                                                                              
          sql:                                                                                                                              
          ALTER TABLE "SAPHANADB"."VBAK" ADD
           .............

                                     
         "SDM_VERSION" NVARCHAR (000002)) ONLINE PREFERRED                                                    
     Error Message SQL Exception: SQL code: 2.048; SQL message: column store error: modify attribute error: [10000                                     
     Error Message Table VBAK (Error adjusting the database)                                                                                           
        Table VBAK was not activated
Synchronous processing: 3 sec., 487 objects, 487 costs                                                                                                      

  

   

   

  

  • The indexserver trace belonging to the underlying HANA tenant DB reveals a failed DDL operation on the same table triggered by SE11 tcode from the DDIC user  :
indexserver_hostname.3xx00.000.trc
++++++++++++++++++++++++++++++++++++++

[30167]{306333}[41/574252958] 2022-06-13 17:44:35.283328 i TraceContext     TraceContext.cpp(01269) : UserName=<>, ApplicationUserName=DDIC, ApplicationName=ABAP:SID, ApplicationSource=CL_SQL_STATEMENT==============CP:717, Client=000, StatementHash=d2e5bf66eace2ae11065e81363fb30e5, EppRootContextId=6045BDA55DD01EECBAE24183DDFC36B6, EppTransactionId=BAD7E25B5D830360E0062A6B2DF260B5, EppConnectionId=00000000000000000000000000000000, EppConnectionCounter=0, EppComponentName=SID/hostname, EppAction=SE11, StatementExecutionID=844439383482035
[30167]{306333}[41/574252958] 2022-06-13 17:44:35.283305 e cs_ddl           RemoteRequestExecutor.cpp(00081) : csddl/RedefineAttributeData: handle for SID::<HANA user_id>:VBAK (t 192933) failed with exception: exception  1: no.1000000  (CS/DDL/impl/RedefineAttributeData.cpp:522) TID: 30167
    unsupported operation in online ddl mode; $condition$=!_online
exception throw location:
 1: 0x00007fbeb1a350a3 in CS::DDL::RedefineAttributeData::handle(CS::DDL::RedefineAttributePartInput const&, TRexCommonObjects::TRexApiError&) const+0xca0 at RedefineAttributeData.cpp:522 (libhdbddlrequests.so)
 2: 0x00007fbeb1a3d7db in CS::DDL::DataRequestBase<CS::DDL::RedefineAttributePartInput, TRexCommonObjects::TRexApiError>::handleAndCheck(CS::DDL::RedefineAttributePartInput const&, TRexCommonObjects::TRexApiError&) const+0x37 at DataRequestBaseImpl.cpp:460 (libhdbddlrequests.so)
 3: 0x00007fbeb1a3e1ff in CS::DDL::DataRequestBase<CS::DDL::RedefineAttributePartInput, TRexCommonObjects::TRexApiError>::handle()+0x76b at DataRequestBaseImpl.cpp:203 (libhdbddlrequests.so)
 4: 0x00007fbeb1a38fa8 in CS::DDL::DataRequestBase<CS::DDL::RedefineAttributePartInput, TRexCommonObjects::TRexApiError>::handleSplitTable()+0x414 at DataRequestBaseImpl.cpp:515 (libhdbddlrequests.so)
 5: 0x00007fbeb1a371ec in CS::DDL::RedefineAttributeData::execute()+0x18 at RedefineAttributeData.cpp:336 (libhdbddlrequests.so)
 6: 0x00007fbeb1a6fb06 in CS::DDL::DDLRequestTemplate<CS::DDL::RedefineAttributeData, false>::execute() [clone .lto_priv.0]+0x252 at RequestTemplate.h:52 (libhdbddlrequests.so)
 7: 0x00007fbeb1a45bb4 in CS::DDL::RedefineAttribute::execute()+0x20 at RedefineAttribute.cpp:120 (libhdbddlrequests.so)
 8: 0x00007fbca7f36c14 in SQLDDL::CSDDLWrapperImpl::createRedefineAttributeRequest(Metadata::CSTableInfo*, Metadata::MDWriter&, ltt::smart_ptr<TRexCommonObjects::TRexAttributeDefinition, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >, TRexEnums::RedefineAttributeOption, bool, TRexEnums::RedefineQueueOption, bool, CS::DDL::ChangeOption, unsigned int&, ltt_adp::vector<ltt::pair<unsigned int, unsigned int>, ltt::integral_constant<bool, true> >&, bool&, TRexCommonObjects::TRexApiError&)+0xf0 at WrapperImpl.cpp:630 (libhdbcsddlwrapperimpl.so)
 9: 0x00007fbe971a962a in ptime::QueryExecutor::modifyAttribute(ltt::smart_ptr<TRexCommonObjects::TRexAttributeDefinition, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >, bool, ptime::TriState, bool, bool, Metadata::CSTableInfo*, Metadata::MDWriter&, CS::DDL::ChangeOption, unsigned int&, ltt_adp::vector<ltt::pair<unsigned int, unsigned int>, ltt::integral_constant<bool, true> >&, bool&)+0x1a6 at qx_cs_ddl.cc:166 (libhdbrskernel.so)
10: 0x00007fbe97250564 in ptime::QueryExecutor::trex_modify_attribute(ptime::ClassPtr<Metadata::TableInfo>, ptime::qp_alter_table const*)+0x3050 at qx_trex.cc:3845 (libhdbrskernel.so)
11: 0x00007fbe97259538 in ptime::QueryExecutor::trex_alter_table(ptime::qp_alter_table const*, ptime::Query::result_t*)+0xf44 at qx_trex.cc:1887 (libhdbrskernel.so)
12: 0x00007fbe972ca01d in ptime::QueryExecutor::alter_table_common(ptime::qp_alter_table const*, ptime::ClassPtr<Metadata::TableInfo>, ptime::Query::result_t*)+0x299 at qx_table.cc:6419 (libhdbrskernel.so)
13: 0x00007fbe972cb481 in ptime::QueryExecutor::alter_table(ptime::qp_alter_table const*, ptime::ClassPtr<Metadata::TableInfo>, ptime::Query::result_t*)+0x2a0 at qx_table.cc:6310 (libhdbrskernel.so)
14: 0x00007fbe972cb806 in ptime::QueryExecutor::alter_table(ptime::qp_alter_table const*, ptime::Query::result_t*)+0x162 at qx_table.cc:6226 (libhdbrskernel.so)
15: 0x00007fbe974daca4 in ptime::QueryExecutor::execute(ptime::Transaction&, char const*, ptime::qp_parse_tree const*, ptime::Query::Plan*, ptime::Query::result_t*, ptime::QueryExecutor*)+0xf10 at qx.cc:600 (libhdbrskernel.so)
16: 0x00007fbe967ff6e6 in ptime::Query::execute(ptime::Transaction&, char const*, ptime::Query::param_t*, ptime::Query::Plan*, ptime::Query::result_t*, ptime::Statement*, bool, bool, char const*, ptime::QueryExecutor*)+0x852 at query.cc:4706 (libhdbrskernel.so)
17: 0x00007fbe96559a04 in ptime::Statement::execute_(Execution::Context&, EAPI::CursorHoldability const&, bool, bool, bool)+0x710 at Statement.cc:2726 (libhdbrskernel.so)
18: 0x00007fbe965ac654 in ptime::PreparedStatement::execute(Execution::Context&, EAPI::CursorHoldability const&, bool, bool, bool, ptime::Statement::BatchProcessingState, bool, bool, bool)+0x270 at PreparedStatement.cc:544 (libhdbrskernel.so)
19: 0x00007fbea00562b5 in ptime::ActionExecutor::executeQuery(Execution::Context&, ptime::Action&)+0x181 at sm_action_executor.cc:1327 (libhdbsqlsession.so)
20: 0x00007fbea0053150 in ptime::ActionExecutor::executeString(Execution::Context&, ptime::Action&)+0x20 at sm_action_executor.cc:1212 (libhdbsqlsession.so)
21: 0x00007fbea0053a88 in ptime::ActionExecutor::executeAction(Execution::Context&, ptime::SessionEvent*, ptime::Action&)+0x1f4 at sm_action_executor.cc:675 (libhdbsqlsession.so)
22: 0x00007fbe9ffd6ff3 in ptime::SessionHandler::executeAction(Execution::Context&, SessionLayer::SessionEvent*, ptime::Action&)+0x2d0 at sm_handler.cc:2498 (libhdbsqlsession.so)
23: 0x00007fbe9ffd72b3 in .LTHUNK390.lto_priv.1+0x170 at sm_handler.cc:2218 (libhdbsqlsession.so)
24: 0x00007fbe9ffdf93b in ptime::SessionHandler::receiveMessage_(Execution::Context&, ptime::ThreadStatusCallbackBase&, SessionLayer::CommEvent*, bool)+0xb27 at sm_handler.cc:1967 (libhdbsqlsession.so)
25: 0x00007fbe9ffe0d4f in ptime::SessionHandler::receiveMessage(Execution::Context&, SessionLayer::CommEvent*, bool)+0x2b at sm_handler.cc:1795 (libhdbsqlsession.so)
26: 0x00007fbe9ffa5e06 in ptime::TcpReceiver::doWork(Execution::Context&, SessionLayer::CommMgr*)+0xae2 at tcp_receiver.cc:388 (libhdbsqlsession.so)
exception type information:
 - 0: public Diagnose::ThrowAssertError@0x7fbe88eea9a8 SI
   - 0: public ltt::logic_error@0x7fbe87f1b608 SI
     - 0: public ltt::exception@0x7fbe87f1bba8

 


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , BC-DB-HDB-POR , Dictionary & Consistency checks for SAP HANA , HAN-DB , SAP HANA Database , BC-EIM-ESH , NetWeaver Enterprise Search , 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.