Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Deal with Postgresql Error -canceling statement due to conflict with recovery

diegosantos
8 - Asteroid

Hi guys,

 

I'm using a Dynamic Input with CTE (Common Table Expression), and i'm getting this error:

 

cte_error.png

 

I noticed there are 3 execution of Dynamic input, the first 2 with same quantity of record and the last one with 1  plus record. First off all i don't know why the tool is executed 3 times, and the last one with one plus record.

cte_execution.png

 

Is there something that i can do to avoid this error? Someone can help me?

2 REPLIES 2
diegosantos
8 - Asteroid

Hi @apathetichell 

Thank you for your aswner.

Unfourtuly the database's owner ins't my organization, so i can't modify those parameters.


After several tests, i realized that where clause in the dymanic input was the problem. I don't know why, but after remove it, it worked fine. In this case i used replace string.

Labels
Top Solution Authors