3232531 - Hanging remote source queries through HANA SDA blocking garbage collection

• Garbage collection is getting blocked on HANA. Investigation into the indexserver traces (indexserver_host.30003.310.trc) reveals the following :
   

   [432788]{204271}[701/-1] 2022-07-26 08:00:14.554529 e FedTrace         odbccustom.cpp(00709) : Configuration file:/usr/sap/SID/HDB00/exe//config/property_orcl.ini could not be opened. 
   [474508]{201708}[34/-1] 2022-07-26 08:00:14.608691 i TraceContext     TraceContext.cpp(01269) : UserName=SAPABAP1, ApplicationUserName=PRS_ECLP_WS, ApplicationName=ABAP:SID, ApplicationSource=SAPMSSY2:16453, Client=xxx, StatementHash=e5148a79c067e24b7aede88f9c2ea016, EppRootContextId=0212410304F31EED83971F5D8DCB4671, EppTransactionId=BE653E9A925907B0E0062DF916FABAC3, EppConnectionId=62DC394AEE842E93E1000000AC17A7A4, EppConnectionCounter=1, EppComponentName=SID/host_SID_00, EppAction=PRS_ECLP_EVTQ_NEW_0040565267, StatementExecutionID=844433952197796
   [474508]{201708}[34/-1] 2022-07-26 08:00:14.608679 e FedTrace         odbccustom.cpp(00709) : Configuration file:/usr/sap/SID/HDB00/exe//config/property_orcl.ini could not be opened. 
   [432788]{204271}[1056/-1] 2022-07-26 08:00:14.937584 e FedTrace         odbcaccess.cpp(03920) : {R -1}ODBC error: connected: 0 state: HY000 code: 12514 [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

• Runtime dump traces and known garbage collection blocking threads show the below callstacks examples : ( Found from script checks : 'HANA_GarbageCollection_Overview_*' , 'HANA_GarbageCollection_Blockers_History_*' (Available in Note 1969700)) 
   
  indexserver_host.30003.rtedump.20220726-080345.2819271.longrunning_transaction.trc
   
  

   5881140971[thr=3047114]: JobWrk244234 at
    1: 0x00007efe74b47b94 in .annobin_read.c+0x40 (libpthread.so.0)
    2: 0x00007ee8dc7587ad in ntt2err+0x19 (libclntsh.so.12.1)
    3: 0x0000000000000000 in <no symbol>+0x0 (<unknown>)
  
     
  
    3698064272[thr=1769101]: SqlExecutor at
    1: 0x00007efe74b47b94 in .annobin_read.c+0x40 (libpthread.so.0)

  
   

SAP HANA, platform edition 2.0

SAP HANA, platform edition 1.0

KBA , HAN-DB , SAP HANA Database , HAN-DB-SDA , SAP HANA Smart Data Access , Problem