3547908 - "Error while fetching a row" while extracting data from Oracle database to HANA database through SDA

You encountered the following error when extracting data from an Oracle database to HANA database via connection type "SAP HANA Smart Data Access":

"internal error: Error while fetching a row Cannot retrieve why the ODBC API has failed for query ...". 

Turning on SDA trace as "debug" and you can see the following error message in HANA DB indexserver trace file: 

-------------------------------------------------------------------------------------------------------------------------------
...
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613183 d FedTrace         odbcresult.cpp(00210) : Row status: SQL_ROW_ERROR
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613193 d FedOdbcTrace     Service.cpp(01086) : SQLGetConnectAttr(0x00ffff99b2cdd000,1209,0x00007fc75689c40c,-5,0x0000000000000000)
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613364 d FedTrace         odbcaccess.cpp(01275) : {R -1} Connection attribute SQL_ATTR_CONNECTION_DEAD checked. Returned code: 0, closed: 0
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613372 i FedTrace         FederationContext.cpp(01641) : FederationException created 0x00ffff970867cbc0: Exception 10000: (BI_ORACLE) Cannot retrieve why the ODBC API has failed 
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613386 d FedTrace         FederationContext.cpp(01652) : FederationException destroyed 0x00ffff970867cbc0
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613454 d FedTrace         FederationCursor.cpp(02562) : Closing cursor 0x00ffffbcabb34000
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613546 d FedOdbcTrace     Service.cpp(00837) : SQLFreeStmt(0x00ffffc5181d7800,1)
[14772]\{304635\}[131/346809311] 2024-11-19 11:15:15.613744 d FedTrace         FederationCursor.cpp(02574) : Cursor closed 0x00ffffbcabb34000 
-------------------------------------------------------------------------------------------------------------------------------
 

Source DB: Oracle database
Target DB: HANA database
SAP HANA Smart Data Access

DML mode, SDA, Smart Data Access, SQL_ATTR_CONNECTION_DEAD, ODBC API has failed, Error while fetching a rowCannot retrieve why the ODBC API has failed , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem