2136595 - Runtime error DBIF_DSQL2_SQL_ERROR occurrent during BW data load | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2136595 - Runtime error DBIF_DSQL2_SQL_ERROR occurrent during BW data load

Symptom

  • BW Data load fails while executing with runtime dump "Runtime error DBIF_DSQL2_SQL_ERROR occurred"
  • The nameserver trace file on the HANA Database shows a crash stack similar to the following:

[146385]{-1}[-1/-1] 2016-01-20 10:30:36.106031 e TNS_Timing       WatchDog.cpp(00197) : LocalWatchDog takes 102 seconds for 'indexserver@ukgfsdbqh001:30203'. Communication problem or interval (10 seconds) too short?
[146385]{-1}[-1/-1] 2016-01-20 10:32:41.728371 e TrexNet          Channel.cpp(00364) : active channel 180 from xxxxx to 127.0.0.1:30203: reading failed with rc=15 (connection broken)
[146385]{-1}[-1/-1] 2016-01-20 10:32:41.728399 e TrexNetBuffer    BufferedIO.cpp(01151) : erroneous channel 180 from xxxxx to 127.0.0.1:30203: read from channel failed; resetting buffer
29805[thr=146385]: LocalWatchDog at
 1: 0x00007ff081988b30 in Execution::ContextFunctions::dumpInfo(Execution::Context&, ltt::basic_ostream<char, ltt::char_traits<char> >&, bool, bool, bool, bool, bool)+0x310 at ContextFunctions.cpp:623 (libhdbbasis.so)
 2: 0x00007ff0832c168a in TrexNet::BufferedIO::fillBuffer(bool)+0x406 at BufferedIO.cpp:1152 (libhdbbasement.so)
 3: 0x00007ff0832ca59a in TrexNet::BufferedIO::peekBuffer()+0x46 at BufferedIO.cpp:1326 (libhdbbasement.so)
 4: 0x00007ff0832ca762 in TrexNet::BufferedNetInput::peek()+0x30 at BufferedIO.cpp:4331 (libhdbbasement.so)
 5: 0x00007ff0849bcbaf in NameServer::TREXNameServer::pingService(NameServer::ServiceType, char const*, unsigned short, NameServer::PingServiceAction, NameServer::LoadHistory_SV&, NameServer::TrexNetRequestHolder*)+0x47b at Request.h:392 (libhdbns.so)
 6: 0x00007ff084a182bb in NameServer::LocalWatchDog::callback()+0x1467 at WatchDog.cpp:183 (libhdbns.so)
 7: 0x00007ff084a0ac00 in NameServer::TimerThread::run(void*)+0xe0 at ThreadBase.cpp:98 (libhdbns.so)
 8: 0x00007ff0833199e3 in TrexThreads::PoolThread::run()+0x980 at PoolThread.cpp:278 (libhdbbasement.so)
 9: 0x00007ff08331b798 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (libhdbbasement.so)
10: 0x00007ff0819ce64b in Execution::Thread::staticMainImp(void**)+0x627 at Thread.cpp:475 (libhdbbasis.so)
11: 0x00007ff0819ce7ed in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:543 (libhdbbasis.so)

Read more...

Environment

Netweaver 7.4, SAP HANA Database 1.0

Product

SAP NetWeaver 7.4

Keywords

CL_RSDRS_SQL_QUERY, TCP Connectivity, idle_connection_timeout, dbs/hdb/connect_property,  CONNECTTIMEOUT , 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 ONE Support launchpad (Login required).

Search for additional results

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