error in ACS | Community
Skip to main content
mmbb110
Level 9
Jun 24, 2023 3:19 PM UTC
Question

error in ACS

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

6 replies

Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
Aug 3, 2023 9:50 AM UTC

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!

Translate
Sukrity Wadhwa
aggabhi
Level 5
Jun 24, 2023 8:52 PM UTC

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??

Translate
mmbb110Author
Level 9
Jun 26, 2023 2:36 PM UTC

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
 
Translate
Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
Jul 13, 2023 8:40 AM UTC

Hi @aggabhi, 

Could you please help @mmbb110 further here?

Thanks!

Translate
Sukrity Wadhwa
    SatheeskannaK
    SatheeskannaK
    Level 1
    Jun 24, 2023 5:21 PM UTC

    @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.

    Translate
    Thanks, Sathees
    Terms & ConditionsAccessibility statement

    Loading footer...