3225658 - Getting timeout issue during read from SDI File Adapter

• Intermittent timeouts or stalled queries while reading from very large text files (millions of rows or over 1 GB in size) using the FileAdapter.
• framework.trc log example:
  • 2022-07-13 11:21:35,316 [ERROR] [140afa51-d774-4115-85f3-06cf406b60cf29947] DPFramework | AsyncHandler.processStreamingExecuteStatement  - AH(240): com.sap.hana.dp.adapter.sdk.AdapterException: adapter reading got interrupted Context: adapter reading got interrupted
                                    at com.sap.hana.dp.fileadapter.tableloaders.TableLoaderWithAllFilters.getNextRowData(TableLoaderWithAllFilters.java:266)
                                    at com.sap.hana.dp.adapter.sdk.adapterbase.BaseAdapterClass.getNext(BaseAdapterClass.java:1014)
                                    at com.sap.hana.dp.adapter.sdk.decorator.AdapterCDCDelegate.getNext(AdapterCDCDelegate.java:118)
                                    at com.sap.hana.dp.adapter.framework.core.AsyncHandler.fetchRows(AsyncHandler.java:483)
                                    at com.sap.hana.dp.adapter.framework.core.AsyncHandler.processStreamingSelect(AsyncHandler.java:431)
                                    at com.sap.hana.dp.adapter.framework.core.AsyncHandler.processStreamingExecuteStatement(AsyncHandler.java:359)
                                    at com.sap.hana.dp.adapter.framework.core.AsyncHandler.run(AsyncHandler.java:686)
                                    at java.lang.Thread.run(Thread.java:836)

SAP HANA Smart Data Integration

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem