Issues with Purview Scanning Azure Postgres instance

Question

When scanning a Azure PostgreSQL instance - getting the following. We connect but are unable to scan. We are using a Sysadmin Postgres account for scanning. Here is the logs:

Timestamp ErrorCode OperationName OperationItem Message

2024-06-21T09:35:37.006Z SystemError GetMetadata postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant Arithmetic operation resulted in an overflow.

2024-06-21T09:35:37.008Z SystemError GetMetadata postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant Connection is not open

2024-06-21T09:35:37.009Z SystemError GetMetadata postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant Connection is not open

2024-06-21T09:35:37.009Z SystemError GetMetadata postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant Connection is not open

2024-06-21T09:35:37.010Z SystemError GetMetadata postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant Connection is not open

2024-06-21T09:35:37.010Z SystemError GetMetadata postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant Connection is not open

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

• Verify that the connection string (postgresql://prod-postgres-bi.postgres.database.azure.com/postgres/dt_dev_savant) is correct and includes all necessary parameters such as username, password, host, port, and database name
• Ensure that the firewall settings on your Azure PostgreSQL instance allow connections from the IP address or range where your scanning tool is hosted.
• Try connecting to the Azure PostgreSQL instance using a PostgreSQL client with the same credentials to verify if you can establish a connection and query metadata manually. This can help isolate whether the issue lies with the scanning tool or the connection parameters.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful