3743538 - SDI long-running loads fail with dberror : “invalid session id” and “remote source unable to prepare transaction id” - SAP HANA Smart Data Integration

• Data loads through smart data integration intermittently fail during large/long executions.
• Error: (dberror) [139]: current operation cancelled by request and transaction rolled back: Transaction was canceled
• Error: "SQL Error: start task error: transaction rolled back by an internal error: Remote source *** is unable to prepare transaction id ***"
• Error: invalid session id 
• Messages such as “prefetch operation was cancelled” appear in federation logs.

SAP HANA Smart Data Integration(SDI)

dberror 139, transaction was canceled, invalid session id, remote source unable to prepare transaction id, sdi dp agent, adapterSession.keepAliveTimeInHours, long running flowgraph, initial load failure, insert select virtual table, federation prefetch operation was cancelled, background job cancel, hana cloud sdi, dpagent timeout , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem