Skip to content

connector-troubleshoot-postgresql.md

Latest commit

 

History

History
41 lines (29 loc) · 2.12 KB

connector-troubleshoot-postgresql.md

File metadata and controls

41 lines (29 loc) · 2.12 KB
title Troubleshoot the Azure Database for PostgreSQL connector
titleSuffix Azure Data Factory & Azure Synapse
description Learn how to troubleshoot issues with the Azure Database for PostgreSQL connector in Azure Data Factory and Azure Synapse Analytics.
author jianleishen
ms.subservice data-movement
ms.topic troubleshooting
ms.date 01/16/2025
ms.author jianleishen
ms.custom has-adal-ref, synapse

Troubleshoot the Azure Database for PostgreSQL connector in Azure Data Factory and Azure Synapse

[!INCLUDEappliesto-adf-asa-md]

This article provides suggestions to troubleshoot common problems with the Azure Database for PostgreSQL connector in Azure Data Factory and Azure Synapse.

Error code: 23704 - AzurePostgreSqlNpgsqlPartitionColumnNameNotProvided

  • Message: Partition column name must be specified.

  • Cause: No partition column name is provided, and it couldn't be decided automatically.

Error code: 23705 - AzurePostgreSqlNpgsqlDataTypeNotSupported

  • Message: The data type of the chosen Partition Column, '%partitionColumn;', is '%dataType;' and this data type is not supported for partitioning.

  • Recommendation: Pick a partition column with int, bigint, smallint, serial, bigserial, smallserial, timestamp with or without time zone, time without time zone or date data type.

Related content

For more troubleshooting help, try these resources: