Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,198 questions
HELP how to fix "Message": "Failure happened on 'Source' side. 'Type=Npgsql.PostgresException,Message=42601: syntax error at or near \"FROMpublic\"\r\n\r\nPOSITION: 10,Source=Npgsql,'"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 39%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Chris
0
Reputation points
I created a ADF pipeline to ingest my tables in bulk to azure data lake storage from my postgres database . However while running the pipeline threw me an error : "Message": "Failure happened on 'Source' side. 'Type=Npgsql.PostgresException,Message=42601: syntax error at or near "FROMpublic"\r\n\r\nPOSITION: 10,Source=Npgsql,'"
It seems like this error is pointing to an issue in the query syntax on the source side. I am assuming that source side means the source side of the copy activity within the ForEach activity of my pipeline. Also, when i preview the output of each of the iterations of my ForEach activity, none of the data from the corresponding table in my postgres database was read (0). Granite, some of the tables are unpopulated but the tables are present from a CREATE TABLE statement. Even though some tables are empty, the pipeline shouldn't crash. I am not sure why. I don't see what could be wrong with the query. Does anyone have a solution to fix this?