Oracle Connector Refresh Issue

[yoggieb]

Hi,

I am trying to insert rows into an Oracle table that I just created. When using Power Automate or Power Apps, I am unable to retrieve the table. I get an error, "Error executing the api '/$metadata.json/datasets/default/tables/XXX". XXX refers to my table name.

Usually there's a delay before I am able to retrieve the table. However, it has been more half a day and I am still getting an error.

I have tried the following;

1. Re-created my connection
2. Dropping and creating tables again in SQL
3. Restarting data gateway

None of the above methods work. Has anyone encountered this issue before? How do I resolve the issue?

[v-alzhan-msft · Accepted solution]

Hi @yoggieb ,

Does your flow works well before?

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.