Connection to PostgreSQL db in Data Flow not working

Question

Connection to PostgreSQL db in Data Flow not working

?ukasz Bromberek 21

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.

Accepted answer

0 additional answers

Your answer

Answer 1

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi @?ukasz Bromberek ,

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.

?ukasz Bromberek 21 Reputation points

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,546 Reputation points Microsoft Employee Moderator

2022-12-16T05:36:24.553+00:00
Hi @?ukasz Bromberek , 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?
?ukasz Bromberek 21 Reputation points

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

Hi,

I can see the data preview
?ukasz Bromberek 21 Reputation points

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

AutoResolveIntegrationRuntime in both cases
?ukasz Bromberek 21 Reputation points

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,546 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