Datasphere Internal error: SQL View - Resource governor for 'cursors' exceeded

[mitko1994]

Hello, 

I have define an SQL View which uses a few local table variables to split up the logic and returns a union of these temporary tables.

Whenever I attempt to preview the result, I run into the following error:

internal error: Error opening the cursor for the remote database <DWC_BWBRIDGESPACE.BWBRIDGE> [SAP AG][LIBODBCHDB SO][HDBODBC] General error;403 internal error: An error occurred while opening the cursor for the remote database. The server name: "DWCHDL2" [SAP][ODBC Driver][SAP HANA Cloud, data lake Relational Engine]Resource governor for 'cursors' exceededThe problematic query: "SELECT

If return each of table variables on their own, the error doesn't appear and I can preview the data just fine.How can I debug this further? Is there a parameter I can check to see where the issue may be coming from?

[Vitaliy-R]

I am not familiar with this error, but from what I can read, it is using a connection to SAP HANA Cloud, DL RE (based on SAP IQ database technology) as a component of Datasphere. It should be related to that setting: https://help.sap.com/docs/SAP_HANA_DATA_LAKE/19b3964099384f178ad08f2d348232a9/a63e2b9784f21015983992...

I do not know if you can manipulate a number of these temporary tables to reduce the number of cursors they open simultaneously. If not, then I would suggest opening a service case to SAP Support.

Regards.

[mitko1994]

@Vitaliy-R thanks for your input. I tried reducing the number of temporary tables where possible.However, ultimately, all the data comes from 2 ADSOs on BW Bridge. There are 2 layers of views underlying the SQL view I'm working on and the dataset I'm working with is only ~1k records.

[Martin_Kuma]

where did you create the SQL view? In DSP or BW? This error looks like standard loop with cursor, where the cursor is not supported (means you cannot process batch wise, but you have to do a full-fetch). Paste the view, scrambled of course 🙂