Connection to PostgreSQL db in Data Flow not working

Question

Connection to PostgreSQL db in Data Flow not working

Anonymous

I'm trying to connect my Azure DB for PostgreSQL (flexible server) with ADF data activity. The dataset related to PSQL is working nice with copy activity. When I'm trying to reach PSQL Dataset in Data Flow I'm receiving:

Operation on target InitDBContributionParquet failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'StoreInPSQL': The connection attempt failed.","Details":"shaded.msdataflow.org.postgresql.util.PSQLException: The connection attempt failed.\n\tat shaded.msdataflow.org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:297)\n\tat shaded.msdataflow.org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)\n\tat shaded.msdataflow.org.postgresql.jdbc.PgConnection.

Answer accepted by question author

0 additional answers

Your answer

Answer 1

ShaikMaheer-MSFT 38,556 Microsoft Employee Moderator

Hi @Anonymous ,

Thanks for posting query in Microsoft Q&A Platform.

When actually you are getting this error? While performing data preview in dataflow? Or while running dataflow using Dataflow activity?

If it's in dataflow activity, then could you please cross check and make sure correct IR there under settings tab?

You mean to say link liked service still connection is getting successful? If yes, note which IR is getting used there and use same in data flow activity.

Please let me know how it goes. Thank you.

Anonymous

2022-12-15T16:30:32.757+00:00

Hi, thanks for answering

I was using the same settings in copy activity to connect to PostgreSQL database.
I've just runned it again in data preview (debug mode) in authoring mode, and then used debug in pipeline containing activity, and last but not least -> triggered a pipeline run.

The result was

I've tripple checked the parameters, they are ok. The error message is not giving me any lead.
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-12-16T05:36:24.553+00:00
Hi @Anonymous , Thank you for details, but could you please help with below asks?

Are you able to see data preview inside dataflow? If yes, please share screenshot.

Which IR we are using under settings tab of dataflow activity? Is it the same one which is getting used in linked service? Kindly share screenshots if possible?
Anonymous

2022-12-19T15:47:48.067+00:00

Hi,

I can see the data preview
Anonymous

2022-12-19T15:53:56.883+00:00

AutoResolveIntegrationRuntime in both cases
Anonymous

2022-12-20T15:49:52.67+00:00

That was nice one, honestly.

In linked service postgres fully qualified domain name I've provided dynamic content.
There was a line break, and it messed things only for data flow.

Some minor bug you can fix for the future. Have a nice day!
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-12-22T09:41:37.317+00:00

oh okay got you. Glad that your issue resolved and thanks for sharing details.

-----------

Please consider hitting Accept Answer button. Accepted answers help community as well.

Share via

Connection to PostgreSQL db in Data Flow not working

0 additional answers

Your answer