issue connecting to oracle database using oracle connector in logic app

Question

Hi,

I am trying to connect to an oracle database on-premise from logic apps using the oracle connector. we have an on-premise data gateway setup and all prequisites in place as given in the document.

https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-oracledatabase

.NET 4.8 is presinsatalled and i have installed .NET 6 on the OPDGW.

when trying to create a service connection in the logic app, i am getting the below error

Failed to create connection: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' inner exception: An error happened while reading data from the provider: 'Object reference not set to an instance of an object.' clientRequestId: xxxxxx-xxxxxx-xxxxx

is there a way i can see where tha actual error is happening, i have the application insights hooked up to logic app but i cannot see anything there and neither in the on-premise data gateway server.

Any advice what coudl be causing the issue as the error infomation is quite generic.

Answer 1

@Sumit Gaur Based on the error message you provided, it seems like there might be an issue with the provider or the data being read from it.

To troubleshoot this issue, I would recommend checking the following:

1. Verify the connection details:
   1. Double-check that the connection details you provided in the service connection are correct and match the details of your Oracle database. This includes the server name, port number, database name, username, and password.
      1. Make sure that the username and password you provided have the necessary permissions to access the database1.
      If you're not sure about the correct connection details, you can try connecting to the database using a different tool or client to verify the details.
2. Check the Oracle connector version:
   1. Make sure that the version of the Oracle connector you're using is compatible with the version of your Oracle database. You can check the compatibility matrix in the Oracle connector documentation.
   If the connector version is not compatible, you can try upgrading or downgrading the connector to a compatible version.
3. Verify the on-premise data gateway:
   1. Check if the on-premise data gateway is running and connected to the internet. You can check the status of the gateway in the on-premise data gateway management portal.
      1. Make sure that the gateway is installed on a machine that has access to the Oracle database.
      If the gateway is not running or connected, you can try restarting the gateway or reinstalling it2.
4. Check firewall rules:
   1. Verify that there are no firewall rules blocking the connection between the on-premise data gateway and the Oracle database. You can check the firewall rules on the machine where the Oracle database is installed.
   Make sure that the port number used by the Oracle database is open in the firewall.
5. Test the connection:
   1. Try to test the connection using a different tool or client to see if the issue is specific to Logic Apps or if it's a general connectivity issue. For example, you can try using SQL*Plus or SQL Developer to connect to the Oracle database.
   If you're able to connect using a different tool or client, then the issue might be specific to Logic Apps.
6. Check the logs:
   1. Enable diagnostic logging in your Logic App and on the on-premise data gateway to get more detailed error messages. You can find instructions on how to enable diagnostic logging in the Azure documentation.
      1. Check the logs on the on-premise data gateway server to see if there are any errors or warnings related to the Oracle connector. You can find the logs in the on-premise data gateway management portal under the "Logs" tab. Look for any errors or warnings related to the Oracle connector or the connection to the database.