topic Re: I have an app on server that has stopped working since upgrading to 2023.1 in Alteryx Server Discussions

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

wwatson — Fri, 09 Jun 2023 12:45:40 GMT

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?

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

gabrielvilella — Thu, 01 Jun 2023 16:21:56 GMT

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.

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

wwatson — Thu, 01 Jun 2023 16:33:18 GMT

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.

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

wwatson — Mon, 05 Jun 2023 05:55:51 GMT

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

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

gabrielvilella — Mon, 05 Jun 2023 13:39:41 GMT

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

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

wwatson — Tue, 06 Jun 2023 07:28:52 GMT

Defect ticket raised by support team: Jira GCSE-1437

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

moinuddin — Tue, 06 Jun 2023 18:14:33 GMT

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 ?

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

davidstephenevans — Fri, 09 Jun 2023 12:40:22 GMT

Hello,

I am experiencing the same bug. I have several apps which rely upon Name:Value checkbox list interface tools, interacting with in-db and local filters to alter a IN ("","","") formula. When run on Designer (which is the same version as Server in this example), the output is correct and has been while running on previous versions of Alteryx Designer/Server. Now, the Server run outputs 'wide open' on this filter despite valid inputs during the runtime.

Based on this thread I also tried creating a checkbox interface tool with VALUE:VALUE rather than NAME:VALUE in case I could circumvent this issue, but when I save it to Gallery, Alteryx removes the first VALUE and leaves it as just a single instance.

We found that an older method of inputting a multi select interface (text input, named columns, no data in the rows) appeared to work in one instance but we have been unable to replicate it for use in other apps. In addition to this we noticed that unlike previous Alteryx versions, the auto-detect for length of metadata types appears to have been affected. V_W String fields now default to an extremely large number, while before it was 255 characters. I tried force converting these to 255 chars, 40chars or 19chars (the default forced value) after verifying that the database table this is filtering on is for the same metadata length and type.

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

SeanAdams — Sat, 10 Jun 2023 12:01:02 GMT

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!

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

AlexFR — Sat, 29 Jul 2023 13:06:30 GMT

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

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

AlbertHill — Thu, 28 Sep 2023 15:31:08 GMT

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.

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

TomHH — Mon, 13 Nov 2023 23:09:59 GMT

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

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

Jay-RDC — Mon, 15 Apr 2024 17:31:59 GMT

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