question

RamyaTangirala-4529 avatar image
0 Votes"
RamyaTangirala-4529 asked RamyaTangirala-4529 answered

Failed to encrypt sub-resource payload

There is no error message associated with this. When I test the connection , it is successful but it fails to publish. I'm trying to set up a PostgreSql (IntegrationRuntimeReference) connection. Please help resolve. Thank you so much.

azure-data-factory
· 3
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.

Hello @RamyaTangirala-4529 and welcome to Microsoft Q&A.

I am a little confused, if there was no error message, how did you get the message "Failed to encrypt sub-resource payload" ?

0 Votes 0 ·

Hello Martin! Thanks so much for responding. Please see the message I get (it says no error code at the very bottom) 140332-azure-error.png


0 Votes 0 ·
azure-error.png (10.8 KiB)

I see, it looks like no error message for this specific case was written. Possibly an oversight, there are far too many possible errorCodes to give each and every one a custom message. If I can get a little more info, I will submit this to the product team for correction.

Are you able to reproduce this problem reliably, @RamyaTangirala-4529 ?

If so can you share with me the steps?
Does a small change to the credential / connection string change the error?

If you are not comfortable sharing the details publicly, let me know and I will give you an email address to keep it more private.

0 Votes 0 ·

1 Answer

RamyaTangirala-4529 avatar image
0 Votes"
RamyaTangirala-4529 answered

Yes, I am able to reproduce it reliably.

Manage --> Connections -> Linked Services --> New -->DataStore --> PostgreSQL --> and put in the settings for IR and Server name / pwd etc with the right encryption method.

Then when I hit on Test connection --> it says "successful" and then when I try to hit "Create" - its shows the above message (consistently every single time with this server)

There are many other connections set up this way with other servers that work perfectly fine - so I'm unable to figure out where I went wrong.

If you need other details, feel free to share an address. Thanks a million for your help Martin!

Regards,
Ramya

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.