Failed to encrypt sub-resource payload

Question

Failed to encrypt sub-resource payload

Ramya Tangirala 1

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.

MartinJaffer-MSFT 26,161 Reputation points

2021-10-12T23:11:55.16+00:00

Hello @Ramya Tangirala 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" ?
Ramya Tangirala 1 Reputation point

2021-10-13T15:45:14.087+00:00

Hello Martin! Thanks so much for responding. Please see the message I get (it says no error code at the very bottom)
MartinJaffer-MSFT 26,161 Reputation points

2021-10-18T16:40:17.683+00:00

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, @Ramya Tangirala ?

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.

2 answers

Your answer

MartinJaffer-MSFT 26,161 Reputation points

2021-10-12T23:11:55.16+00:00

Hello @Ramya Tangirala 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" ?
Ramya Tangirala 1 Reputation point

2021-10-13T15:45:14.087+00:00

Hello Martin! Thanks so much for responding. Please see the message I get (it says no error code at the very bottom)
MartinJaffer-MSFT 26,161 Reputation points

2021-10-18T16:40:17.683+00:00

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, @Ramya Tangirala ?

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.

Answer 1

Angel Felipe Lavid Arboleda 11

Almost 3 years and there is no answer.
Is there any workaround we can apply to solve this problem?

Answer 2

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

Share via

Failed to encrypt sub-resource payload

2 answers

Your answer