Skip to content

Files

Latest commit

 

History

History
42 lines (30 loc) · 2.03 KB

connector-troubleshoot-postgresql.md

File metadata and controls

42 lines (30 loc) · 2.03 KB
title titleSuffix description author ms.service ms.subservice ms.topic ms.date ms.author ms.custom
Troubleshoot the Azure Database for PostgreSQL connector
Azure Data Factory & Azure Synapse
Learn how to troubleshoot issues with the Azure Database for PostgreSQL connector in Azure Data Factory and Azure Synapse Analytics.
jianleishen
data-factory
data-movement
troubleshooting
10/20/2023
jianleishen
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: 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.

Error code: AzurePostgreSqlNpgsqlPartitionColumnNameNotProvided

  • Message: Partition column name must be specified.

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

Related content

For more troubleshooting help, try these resources: