error in ACS

[mmbb110]

Hello experts,

I am seeing below error in ACS for one of our deliveries.

PGS-220000 PostgreSQL error: ERROR: canceling statement due to user request 

can someone please explain more about this error and what caused it.

[SatheeskannaK]

@mmbb110 It looks like this is related to a session timeout error.

https://forum.knime.com/t/error-cancelling-statement-due-to-user-request/7112

I suggest opening a ticket with Adobe support to determine the root cause. Not sure does it require any db maintenance.

[aggabhi]

Hi @mmbb110 ,

This error happens for database temporary error but here there must be some cause for the same error in delivery.

Can you please add the logs in detail for delivery failure and see if personalization fields you are using getting data correctly from activities before query activity??

[mmbb110]

Hello @aggabhi 

In the logs I can see it has selected records 

06/23/2023 7:05:29 AM

296,417 record(s) result from the union '' (step 'Combination of personalization data')

also it inserted the delivery logs but the delivery logs created step did not occur and it directly showed the error 

PGS-220000 PostgreSQL error: ERROR: canceling statement due to user request

[Sukrity_Wadhwa]

Hi @aggabhi, 

Could you please help @mmbb110 further here?

Thanks!

[aggabhi]

Hi @mmbb110 ,

As per my understanding delivery might have get corrupted and leading to error in delivery.

Try to create and configure a new delivery and it should work definately.

I have encountered similar error and got resolved by same.

Hope it helps.

Regards

Abhishek

[Sukrity_Wadhwa]

Hi @mmbb110,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!