Share via

Issues with Purview Scanning Azure Postgres instance

Stephen Barry 0 Reputation points
2024-06-26T19:24:18.1533333+00:00

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

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. hossein jalilian 4,690 Reputation points
    2024-06-26T20:24:16.21+00:00

    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

    0 comments