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 for Me (Login required).

Search for additional results

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