Power Platform Community Forum Thread Details

Hi there,

I seem to be having difficulty pulling back all schema/tables when using the Db2 action Get Rows. Admittingly we do have quite a few tables as the system is used pretty heavily:

I've tried using a custom value, such as keying in the SCHEMA.TABLE name, even trying an expression using string("SCHEMA.TABLE"), but when I do this I receive the following error:

The dynamic operation request to API 'db2' operation 'GetTable' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "flow-apim-msmanaged-na-westus2-01.azure-apim.net", "clientRequestId": "theclientrequestID", "message": "BadGateway", "innerError": { "status": 502, "message": "We're sorry, an error occurred during evaluation.\r\n inner exception: We're sorry, an error occurred during evaluation.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\nclientRequestId: theclientrequestID", "error": { "message": "We're sorry, an error occurred during evaluation.\r\n inner exception: We're sorry, an error occurred during evaluation.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added.\r\n inner exception: An item with the same key has already been added." }, "source": "db2-eus2.azconn-eus2-01.p.azurewebsites.net" } } }

I tried using Get Tables, but that didn't seem to help much either, but I may not know the context behind using it.

Any thoughts?

-Doug

Categories:

Using connectors