cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoggieb
Helper I
Helper I

Oracle Connector Refresh Issue

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-alzhan-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Kudoed Authors
Users online (5,213)