Skip to Content
0
Sep 15, 2019 at 11:36 PM

Error opening the cursor for the remote database Request timed out. for query

7467 Views

Hi Experst!

I am try run this query in SAP HANA using SDI, and ODP Connector:

call "ODS"."ODSLAYER.XXX::XX_XX_FACTURACION_SP"();

This call a Flowgraph and run a Select a virtual table and insert in a table in Hana

Always see this error:

Could not execute 'call "ODS"."ODSLAYER.XXX::XX_XX_FACTURACION_SP"()' in 10:03.178 minutes . SAP DBTech JDBC: [403]: internal error: "ODS"."ODSLAYER.XXX::XX_XX_FACTURACION_SP"(): line 4 col 1 (at pos 152): internal error: Error opening the cursor for the remote database Request timed out. for query

I have applied these notes:

2363544 - Remote execution error Prefetch timed out - SAP HANA Smart Data Integration Version

2495654 - "Error opening the cursor for the remote database TABLE_WITHOUT_DATA for query..." - SAP HANA Smart Data Integration

And I have changed the times in the SDI Framework, and restart the service more times.

And the error persists!

Thank You!