Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Update : Insert if New Option is not working on Server Gallery 2022.3

PPillai
7 - Meteor

Hi,

 

I have an SQL Server table where the Primary Key is and identity key and I am trying to insert record into this table using Alteryx Workflow. I am running this workflow from the designer (2021.4) on laptop and the workflow executes perfectly fine without the need to explicitly select the Primary Key field in the Output Tool.

 

We are in the middle of upgrading our Alteryx Server to 2022.3 and have upgraded the UAT server and the workflow is failing when running from the Upgraded UAT Server Gallery.(2022.3).

 

The Error I am getting is No Key Available to Update.

 

What I understood is that if the record doesn't exists it should insert the record and Primary key will be automatically created in the database table using the identity value defined on the column.

 

Please note that this workflow works perfectly fine in the 2021.4 Server Gallery.

 

Does anyone know if there is an issue with the Update: Insert If New option for the Output tool in 2022.3 version?

 

Kind Regards

Praseeja

 

 

 

2 REPLIES 2
gabrielvilella
14 - Magnetar

I encourage you to open a support ticket, this sounds like a bug.

PPillai
7 - Meteor

Thank you I have raised the support ticket now.