3485118 - Jobs are getting failed with -10821 Session not connected for query

You notice job(s) are failing with the below similar outputs seen from the dev_w* traces and within the indexserver traces:

dev_w*.trc

 *** ERROR =>   execute() of C_0438, #rec=0, rc=1, rcSQL=129
dbsdbsql.cpp 2188]
 {root-id=9457A55A232A1EDF8BEDBC815FA76B03}_{conn-id=00000000000000000000000000000000}_0
 *** ERROR => EXECUTE C_0438 on connection 0, rc=129
dbslsdb.cpp  10081]
 SQLCODE    : 129
 SQLERRTEXT : transaction rolled back by an internal error: "SAPJP7"."ZCL_DBP_JD7_C1017=>UPDATE_DATA#stb2#20211116\
              120309": line 7 col 3 (at pos 129): "SAPJP7"."ZCL_DBP_JD7_C1017=>UPDATE_DATA": line 9 col 1 (at pos \
              191): internal error: Error opening the cursor for the remote database [SAP AG][LIBODBCHDB SO][HDBOD\
              BC] General error;-10821 Session not connected for query "SELECT "op6.rm.acq.rma/RMA_M189"."HQ", "op\
              6.rm.acq.rma/RMA_M189"."MARKETSEGMENT" FROM (SELECT "HQ", "MARKETSEGMENT" FROM "_SYS_BIC"."op6.rm.ac\
              q.rma/RMA_M189") "op6.rm.acq.rma/RMA_M189" "
 sc_p=7f36e83b2f70,no=438,idc_p=(nil),con=0,act=1,slen=58,smax=256,#vars=0,stmt=7f3707b666d0,table="ZCL_DBP_JD7_C1017=>UPDATE_DAT
 CALL  "ZCL_DBP_JD7_C1017=>UPDATE_DATA#stb2#20211116120309";

Indexserver.***.trc

ApplicationUserName=JP7CLNT577, ApplicationName=ABAP:JP7, ApplicationSource=ZCL_DBP_JD7_BI036=============CP:67, Client=577, StatementHash=af2e07f30ecbf3d5e36cd7bff6c71660, EppRootContextId=00110A66F9241EDC99F8AA426B6AECC8, EppTransactionId=B907483E6A7802D0E00666E00E9A33DA, EppConnectionId=66643A05AEA9DAA5E10000000A8D480D, EppConnectionCounter=1, EppComponentName=JP6/ajp6app01_JP6_00, EppAction=ZPR_GEN_JD7_BI036_BG, StatementExecutionID=844437841126661
[121143]\{301689\}[113/2642357149] 2024-06-18 15:36:42.791663 e FedTrace         odbcaccess.cpp(03944) : {R 603773}ODBC error: connected: 1 state: S1000 code: -10821 [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10821 Session not connected
[121143]\{301689\}[113/2642357149] 2024-06-18 15:36:42.792268 e EmbeddedAPI      EAPICommon.cc(00153) : [SQL-129] unexpected exception at handleException_: exception=ERROR [CODE-403] internal error: Error opening the cursor for the remote database [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10821 Session not connected for query "SELECT "AP:T_OP6.RM.SND.RSA/RSA_M044"."MATNR", "AP:T_OP6.RM.SND.RSA/RSA_M044"."KUNDE", "AP:T_OP6.RM.SND.RSA/RSA_M044"."IMEI1", "AP:T_OP6.RM.SND.RSA/RSA_M044"."SERNR", "AP:T_OP6.RM.SND.RSA/RSA_M044"."IMEI2", 

•  SAP HANA PLATFORM EDITION 1.0
•  SAP HANA PLATFORM EDITION 2.0

HANA Client, -10821 Session not connected for query , KBA , HAN-DB , SAP HANA Database , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-DB-SDA , SAP HANA Smart Data Access , Problem