error in ACS | Community
Skip to main content
M
mmbb110
Level 9
June 24, 2023
Question

error in ACS

  • June 24, 2023
  • 3 replies
  • 1970 views

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.

3 replies

SatheeskannaK
Community Advisor
SatheeskannaKCommunity Advisor
Community Advisor
June 24, 2023

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

Thanks, Sathees
A
aggabhi
Level 5
June 24, 2023

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

M
mmbb110Author
Level 9
June 26, 2023

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
Community Manager
Sukrity_WadhwaCommunity Manager
Community Manager
July 13, 2023

Hi @aggabhi, 

Could you please help @mmbb110 further here?

Thanks!

Sukrity Wadhwa
    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    August 3, 2023

    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!

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...