question

YihuiTeh-0769 avatar image
0 Votes"
YihuiTeh-0769 asked KranthiPakala-MSFT commented

Type=Npgsql.PostgresException,Message=42P01: relation "public.order_products__prior.csv" does not exist,Source=Npgsql,'

I created a ADF pipeline to ingest data from multiple csv files into the tables that I manually created in Postgressql database. However while running the pipeline threw me an error : "
'Type=Npgsql.PostgresException,Message=42P01: relation "public.order_products__train.csv" does not exist,Source=Npgsql,"

I have already created the tables though. Does anyone have a solution to fix this?

135320-screenshot1.jpg135423-screenshot1.jpg


135394-screenshot2.jpg


azure-data-factoryazure-database-postgresql
screenshot1.jpg (146.5 KiB)
screenshot2.jpg (33.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @YihuiTeh-0769,

Welcome to Microsoft Q&A forum and thanks for posting your query here.

From the error message my understanding is that it could be a configuration issue.

Here the 42P01 denotes an undefined table. PostgreSQL error 42P01 denotes the database query is on an undefined table. This error usually occurs due to improper database setup, unidentified table name.

From the error message 'Type=Npgsql.PostgresException,Message=42P01: relation "public.order_products__train.csv" does not exist,Source=Npgsql," it seems like your sink data set configuration or the query might be pointing to a wrong table name. Have you configured public.r_ordeproducts__train.csv as table name in your configuration? But looking at the screenshot your table name is order_products_train and the error message clearly states that you are passing public.r_ordeproducts__train.csv as your sink table name which is a mismatch with actual table name order_products_train in the database and hence you are receiving this issue.

I would recommend you to please double check your configuration to make sure table names are configured correctly in your pipeline flow to avoid this issue.

Here is an helpful article (Disclaimer: Not MSFT owned) related to PostgreSQL error 42P01 by a community volunteer : Easy fix for PostgreSQL error 42P01

Hope this info helps to resolve your issue. Do let us know how it goes.



  • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @YihuiTeh-0769,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @YihuiTeh-0769,

We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·