I have an app on server that has stopped working since upgrading to 2023.1

I have an app that uses a drop down list and an action tool to update the sql statement in an in-db tool.

This work fine running the app in designer. It was working fine on server in 2022.1 but since we upgraded to 2023.1 it is not working.

It looks like the action tool is not updating the sql in the in-db tool any more.

Has anyone seen this behaviour and can advise how to fix it?

Server

Apps

Accepted answers

All comments

gabrielvilella

Does it work fine on Designer version 23.1? If it's just failing when running on the Server 23.1, maybe try replicating it on another workflow. If it's consistent, then there might be a bug. If not, maybe try just deleting and re-adding the tool on the original workflow, or create a new one.

wwatson

The app works fine in designer 2023.1. I have created multiple simplified versions to try to fix it but no luck.

I suspect a bug, have a ticket open with support, will try to get a call to show the behaviour.

wwatson

After further testing the action tool is passing the NAME not the VALUE from the NAME:VALUE pair. This is definitely a bug.

gabrielvilella

That is good to know, thank you! And a major bug in my opinion.

wwatson

Defect ticket raised by support team: Jira GCSE-1437

moinuddin

Please check if you are using same driver version on the DEsigner and Server machine.

Did you try launching Alteryx Designer on the server machine and tested if that works ?

SeanAdams

Hey @wwatson - we experienced something similar with some tools - and turning off AMP helped.

Have you tried running this on the server with / without AMP?

Also - thank you for posting the case number - that is very helpful and gives the entire community something to look out for!

AlexFR

Hi,

I also believe that’s a major issue. Any news on it ?

We are stuck on many apps.

we tried by disabling the AMP and it didn’t work for us.

alex

AlbertHill

Good morning,

We're having a similar issue. Interactive apps work fine in Designer and when I run the application on server in my workspace. However when I add the app to a collection, it does not work.

TomHH

Hi all, I had the same issue and managed to get it working by swapping the Name:Value / Value:Name. This only works if Value and Name aren't identical. If the Value field data is intuitive enough for the user to select from this may be the way forward until the bug is fixed.

Alternatively, if the Value field data is not intuitive as a multiselect field (such as codes), you could potential create an additional filter field in your data that you can use for Value filtering (ie XYZ corresponds to "New York" value, so Value:Name would be New York:XYZ).

Jay-RDC

Same here. Please update us with a fix. Have to manually run workflows in designer now because of this.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703