Designer 2023.1 Release Notes
Release Note Product Versions | |||
|---|---|---|---|
Version | Release Date | Release | End of Support |
2023.1.1.123 | May 17, 2023 | Major | May 17, 2025 |
2023.1.1.200 (Minor) 2023.1.1.1.200 (Patch 1) | June 21, 2023 | Minor/Patch | May 17, 2025 |
2023.1.1.247 (Minor) 2023.1.1.2.247 (Patch 2) | August 22, 2023 | Minor/Patch | May 17, 2025 |
2023.1.1.281 (Minor) 2023.1.1.3.281 (Patch 3) | October 11, 2023 | Minor/Patch | May 17, 2025 |
2023.1.1.306 (Minor) 2023.1.1.4.306 (Patch 4) | November 21, 2023 | Minor/Patch | May 17, 2025 |
2023.1.1.336 (Minor) 2023.1.1.5.336 (Patch 5) | January 16, 2024 | Minor/Patch | May 17, 2025 |
2023.1.1.361 (Minor) 2023.1.1.6.361 (Patch 6) | March 7, 2024 | Minor/Patch | May 17, 2025 |
2023.1.1.392 (Minor) 2023.1.1.7.392 (Patch 7) | May 16, 2024 | Minor/Patch | May 17, 2025 |
2023.1.1.422 (Minor) 2023.1.1.8.422 (Patch 8) | July 18, 2024 | Minor/Patch | May 17, 2025 |
2023.1.1.437 (Minor) 2023.1.1.9.437 (Patch 9) | August 8, 2024 | Minor/Patch | May 17, 2025 |
2023.1.1.460 (Minor) 2023.1.1.10.460 (Patch 10) | October 3, 2024 | Minor/Patch | May 17, 2025 |
Upgrade Considerations
Urgent: Reinstall AIS 23.1
We've made a change to the Alteryx Intelligence Suite (2023.1) installer due to a compiling issue in Build 2023.1.17039. Please download and reinstall the latest Alteryx Intelligence Suite Build 2023.1.0.17033 from the license portal.
Warning: Known Issue
Do not install Alteryx Designer FIPS in the same location as your non-FIPS Admin Designer.
By default, the FIPS installer recommends a different install location than the non-FIPS installer, but you can manually change it. If you change the install location, ensure it is NOT the same location as the non-FIPS Designer. If you install Alteryx Designer FIPS to the same location as a non-FIPS Admin Designer, your installation, as well as custom files and data that might be within that folder, will be significantly corrupted.
Important
Alteryx Designer version 2023.1 offers separate GA and FIPS 140-2 capable products. For more information about FIPS, go to the NIST FIPS FAQ page.
The general release version of Alteryx Designer is not FIPS capable. A separate release (and installer) is available under separate license terms for our FIPS 140-2 customers.
Feature and Tool Differences
Please note that specific tools and features might be limited or unavailable in Alteryx Designer-FIPS . Over time, we will continue to evaluate which tools and features to make available again in future Alteryx Designer-FIPS releases.
New Features: Designer
Cloud Execution for Desktop
Cloud Execution for Desktop is now available for Designer version 2023.1 (included in the 2023.1.1.200 Patch 1 release).
Schedule and run your Designer Desktop-built workflows in the cloud. Cloud Execution for Desktop lets you link your Alteryx Designer Desktop instance to an Alteryx Analytics Cloud Platform (AACP) workspace and then save your desktop-built workflows to the AACP library (which belongs to your AACP workspace). Once saved to the library, you can navigate to AACP and schedule those workflows to run.
New Tool: Control Containers
The Control Container tool is a brand new tool available via the Developer tool category in Designer. Control Containers allow you to build more dynamic and complex processes with better orchestration, logging, and conditional execution.
Here are just some of the capabilities of Control Containers:
Manage the sequence in which tools run in your workflow. For example, you can use Control Containers to sequence outputs to different sheets within the same Excel workbook or even output a file in a workflow and use that same file as input later in the same workflow!
Conditionally execute workflow branches—use a Filter tool to execute a branch of your workflow depending on whether records pass through the True or False outputs.
Use information about the tools that are run, either as logging information or as data to use in your workflow. For example, you can use Control Containers to create an output log for a workflow. Place all tools inside the container, and then output a file from the container’s Logging Output anchor to display the messages from your workflow execution.
AMP Only
The Control Container tool is only compatible with Alteryx Multi-threaded Processing (AMP) .
New Formula Functions
We’ve added several new formula functions:
AverageNonNull (Math Category)
Between (Min/Max Category)
Ceil and Floor functions have a new optional parameter to let you raise/lower numeric values to the nearest specified multiple (Math Category).
Factorial (Math Category)
ToRadians and ToDegrees (Conversion Category)
You can use these anywhere functions are available.
Higher Precision DateTime
You can now specify additional precision for your DateTime and Time data types. This allows for higher precision than seconds—for example, milliseconds, microseconds, nanoseconds, etc.
A new f parameter is now available via the DateTime tool and lets you set time precision.
A new %1-%18 date-time specifier is available with the DateTimeFormat and DateTimeParse functions.
Higher precision is available via the DateTimeAdd, DateTimeDiff, DateTimeFormat, DateTimeNow, DateTimeParse, and DateTimeSeconds functions. Go to DateTime Functions for details.
A new DateTimeNowPrecise function is now available. This function returns your operating system's current date-time with digits of precision that you specify via the parameter.
You can now also use the Select tool (and other tools with embedded select functionality) to adjust the size of DateTime and Time data to contain your desired precision. This functionality is also available via other tools where you can select field size, like Formula and Generate Rows.
Force SQL WChar Support via Output Data Tool
The Force SQL WChar Support option is now available via the Output Data tool for Oracle OCI connections. This option lets you force all char fields to output to WString to handle multi-byte characters.
Render Tool Data Truncation Fixes
We’ve made an update to help prevent unexpected data truncation in the Render tool. You’ll now encounter an error message when you try to output to PDF when the page size is too small to accommodate the data in your dataset.
Field Name Case Change Updates
To improve the workflow creation process, we've made updates to ensure that changes to the case of a field/column name will propagate to downstream tools without the need for manual reconfiguration. This update doesn’t apply to tools that are macros and doesn’t affect tools that use a pop-out configuration dialog (for example, the Insight and Interactive Chart tools).
Note that this change doesn't affect the Engine, nor does it affect how a workflow executes. Field names have always been case-insensitive from an Engine perspective unless otherwise specified.
Dark Mode BETA
Alteryx Designer now lets you select a Dark Mode option as your Designer theme! Preview Dark Mode via the Customization tab of Designer's User Settings.
Beta Release
The initial release of Dark Mode is a Beta release. Only certain Designer interface components have been converted to Dark Mode. Additionally, you might see certain components (including many tool configurations) that are currently only partially converted to Dark Mode. We will continue to include additional elements for Dark Mode in future releases.
Denodo Support
Alteryx now supports the Denodo platform connection. You can use standard workflow processing and In-Database workflow processing tools to read and write your data. For more information, go to Denodo.
Okta Authentication Support for SAP HANA
The 2023.1 release brings Okta authentication support, single sign-on (SSO), for SAP HANA. You can now authenticate to SAP HANA Cloud with Okta accounts.
AWS Secrets Manager
You can now connect DCM to your AWS Secrets Manager instance and then fetch authentication data from AWS Secrets Manager for your workflow. For information on how to configure AWS Secrets Manager, go to AWS Secrets Manager Configuration.
DCM as Default Option
DCM is now set as Enabled and Default in System Settings and Enabled in User Settings. Also, SDK is set to Allow, and the DCM check box is checked on a tool level.
If you upgrade from versions after 21.4, your DCM settings reflect the setup from your previous installation.
Microsoft Access Support
Alteryx now supports the MS Access 2016 Runtime and the MS Access 365 Runtime for reading ACCDB files.
IAM Role Support for S3 Tools
In the S3 Download and S3 Upload tools, you can now select the Assume Role option as a new authentication method to fully leverage roles in your AWS IAM.
New in 23.1 Patch 3
We implemented DSN-less connection strings for Snowflake bulk loading for local staging and staging in Amazon S3.
New Features: Predictive Tools
R Tool Upgrade
Upgraded R to 4.2.3 from 4.1.3 in Patch 2023.1.1.200. Go to CRAN to find out what is new in R. Follow this guide to download and install the new version to make use of custom R code in Designer. The new version lets you continue to download R packages from CRAN.
New Features: Intelligence Suite
Machine Learning Integration Tools Update
Moved the Machine Learning Predict tool from the Laboratory tool category to the Machine Learning tool category.
Updated the Machine Learning Predict and Send tool icons to represent cloud connections.
Download the latest 2023.1 version of the ML integration tools here. To locate the download, go to Alteryx Intelligence Suite > Download > Alteryx Intelligence Suite 2023.1 > Next > Alteryx Machine Learning Designer Integration Tools.
Installer Updates
As of the 2023.1 release, Alteryx Intelligence Suite uses new installer technology. The updated installer detects your operating system language and installs the product in that language (if applicable).
Text Classification Tool
Use the Text Classification tool to build a custom model that classifies text. Label your text data with categories to train a model and then classify new text with the Predict tool.
Enhance Step in Image Processing Tool
Added an image enhancement step to the Image Processing tool. Enhance increases image resolution of your scanned documents. Use Enhance to improve the results of your computer vision tasks.
Auto Option Added to Alignment Step in Image Processing Tool
Auto to automatically align your scanned documents in your OCR workflows.
Apply Annotations to All Pages
Added an Apply First Page of Annotations in Image Template to All Pages checkbox to the PDF to Text and Image to Text tools. Use this checkbox to apply the first page of annotations from the Image Template tool to all pages in batch processing.
End of Support
End of Extended Support Period for 32-bit Connections
For a period of two years from the date of release of Alteryx version 2021.2 (the "Extended Support Period"), Alteryx was providing customer technical support for 32-bit connections. If you currently use 32-bit connections, you will get an error message and will no longer be able to use those connections. Go to End of Support for 32-Bit Database Connections FAQs for more details.
Fixed Issues
Fixed Major Release Version 2023.1.1.123 | |||
|---|---|---|---|
ID | Description | Version | Issue Status |
TCPE-387 DE24215 | The Render tool continues to produce a warning when fonts use the default style. | 2023.1.1.123 | Fixed |
TCPE-409 GCSE-730 | Issues with loading DLLs when using Alteryx 2022.1 .NET API. | 2023.1.1.123 | Fixed |
TCPE-417 GCSE-686 | Row rule to add a tab, space, or pad left as prefix of a column value doesn’t work when rendering table output to a Word document. | 2023.1.1.123 | Fixed |
TCPE-423 GCSE-714 | The Tile tool doesn’t work correctly on the original Engine if the tile method is “Smart Tile” and the tile numeric column value is 0. | 2023.1.1.123 | Fixed |
TCPE-456 | 404 error and code loss in the Python tool in workflows downloaded from Server. | 2023.1.1.123 | Fixed |
TCPE-469 GCSE-847 | Adding a less than (<) symbol in the "Output Message" or the "No Output Files Message" in the Interface Designer Properties window causes an error. | 2023.1.1.123 | Fixed |
TCPE-484 GCSE-965 | Python code in Jupyter Notebook still doesn’t save the code after you save the workflow (and apply known workarounds). | 2023.1.1.123 | Fixed |
TCPE-498 GCSE-966 | The Data Quality bar in the Results window doesn’t function correctly. | 2023.1.1.123 | Fixed |
TCPE-515 GCSE-1004 | The Input Data tool doesn’t rename duplicate fields (that have a number at the end) in a logical fashion. | 2023.1.1.123 | Fixed |
TCPE-516 GCSE-1010 | Designer shows a blank screen after you authenticate with Okta set up with AWS Load Balancer. | 2023.1.1.123 | Fixed |
TCPE-525 GCSE-1030 | The Insights tool can’t be configured when using the Chinese version of Designer. | 2023.1.1.123 | Fixed |
TCPE-526 GCSE-1036 | Can’t find macros that are in a file path with double-byte characters in the path name. | 2023.1.1.123 | Fixed |
TCPE-527 GCSE-1034 | After updating to Designer 2022.3 the SQL Editor Query fails with ORA-error on workflows that it previously succeeded on. | 2023.1.1.123 | Fixed |
TCPE-565 GCSE-1101 | The Help button on the Analytic App window doesn’t function properly. | 2023.1.1.123 | Fixed |
TCPE-569 GCSE-1106 | Link in Interface Designer doesn’t work for file paths. | 2023.1.1.123 | Fixed |
TCPE-575 GCSE-1086 | A job won’t run in the scheduler when the Engine is set to “AMP Engine Only” in Designer. | 2023.1.1.123 | Fixed |
TCPE-583 GCSE-1084 | Designer crashes when publishing Analytic App to Server. | 2023.1.1.123 | Fixed |
TCPE-615 GCSE-1181 | All rows are not being read from Excel file. | 2023.1.1.123 | Fixed |
TCPE-639 GCSE-1253 | Google Drive Input tool only returns/writes out a faction of records in Designer 22.3.1. | 2023.1.1.123 | Fixed |
TDALI-4451 | Remove the Behavior Analysis option from the Summarize tool. | 2023.1.1.123 | Fixed |
TDCB-1647 DE33959 | OCI writes garbled characters for Chinese (multi-byte) characters. | 2023.1.1.123 | Fixed |
TDCB-4188 GCSE-590 | SpatialObj type is not recognized when doing a UNION with the PostgreSQL database. | 2023.1.1.123 | Fixed |
TDCB-4221 GCSE-675 | Connecting to HIVE in the 2022.1 version of both Server and Designer (using MIT authentication) results in an error. The resolution for this defect requires an additional step from the user. Reach out to Customer Support via Mission Control for instructions on how to apply the fix. | 2023.1.1.123 | Fixed |
TDCB-4233 GCSE-713 | Designer shows truncated string value for binary column read from a database. | 2023.1.1.123 | Fixed |
TDCB-4236 | Designer shows truncated string value for binary column read from a database. | 2023.1.1.123 | Fixed |
TDCB-4359 | XLSX: Corrupt file after overwriting range when original data has gaps. | 2023.1.1.123 | Fixed |
TDCB-4382 GCSE-1062 | Excel file breaks after you save a range of cells in a workflow with 2 or more Output Data tools to an Excel file. | 2023.1.1.123 | Fixed |
TDCE-4 GCSE-535 | Stored Procedures in a Dynamic Input tool error: “Unable to find Stored Procedure” when the procedure isn’t created in the DBO schema. | 2023.1.1.123 | Fixed |
TDCE-6 GCSE-766 | Input Data tool “Out of Memory” error for small XLSX files. | 2023.1.1.123 | Fixed |
TDCE-26 GCSE-779 | SQL Server data type money shows as V_String when connected via OLEDB. | 2023.1.1.123 | Fixed |
TDCE-36 GCSE-808 | When connecting to IBM DB2 and editing a query that contains WHERE condition with != , the SQL Editor adds a space between the exclamation point and the equals sign causing the query to fail. | 2023.1.1.123 | Fixed |
TDCE-37 | Syntax error: Expected something like '(' between Left and '.'... with Join In-DB if Table/FieldName SQL Style set as “None”. | 2023.1.1.123 | Fixed |
TDCE-44 DE30000 | Snowflake error on Join In-DB tool with the same Connect In-DB tool: “SQL compilation error: duplicate alias “Tool1_7c8a”. | 2023.1.1.123 | Fixed |
TDCE-48 GCSE-968 | Error "Get Stored Procedure List Error. ' ' is an unexpected token. The expected token is ',', Line 632 position 28.” when viewing Stored Procedures for SQL Server. | 2023.1.1.123 | Fixed |
TDCE-49 GCSE-962 | When attempting to write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row. | 2023.1.1.123 | Fixed |
TDCE-56 GCSE-456 | ESRI ArcGIS SHP file doesn’t open correctly in 2021.4.2: lat/lon are reversed in polygons in some SHP files, Browse tool error, Report Map tool error. | 2023.1.1.123 | Fixed |
TDCE-57 GCSE-984 | With Oracle OCI connection, receive an error “ORA-06576: not a valid function or procedure name” when executing Store Procedures in the Pre or Post SQL statements in the Input Data tool. | 2023.1.1.123 | Fixed |
TDCE-59 GCSE-991 | Amazon S3 Upload problem: S3 download tool results in an error when utilizing the VPC endpoint. | 2023.1.1.123 | Fixed |
TDCE-67 GCSE-1006 | When attempting to write to PostgreSQL with the output option "Update: Insert if New" you get an error if the table has a serial field as the primary key. | 2023.1.1.123 | Fixed |
TDCE-68 GCSE-1002 | "An Unhandled Exception Occurred" when using OleDB with SQL Server In-DB connections. | 2023.1.1.123 | Fixed |
TDCE-79 GCSE-1044 | .hyper files read into Alteryx as the largest size field possible. | 2023.1.1.123 | Fixed |
TDCE-83 GCSE-1066 | Input Data tool trailing spaces removed if size is less than 40. NCHAR and CHAR from Oracle are now translated as WString and String. Varchar2, Varchar, and LONG are translated as V_String and V_WString. | 2023.1.1.123 | Fixed |
TDCE-88 GCSE-1083 | Changing the table name clears the selected Object ID when outputting to ESRI GeoDatabase. | 2023.1.1.123 | Fixed |
TDCE-98 GCSE-1112 | The Output Data tool failed to write a GML file when there was a double-byte character in the path or the filename. | 2023.1.1.123 | Fixed |
TDES-4595 | Designer canvas context menu’s Choose Tool Version option doesn’t work. | 2023.1.1.123 | Fixed |
TDSL-4444 GCSE-315 | Render tool PDF reverses Arabic, Hebrew, and other right-to-left languages. | 2023.1.1.123 | Fixed |
TDSL-4448 DE19725 | PNG doesn’t render correctly to PDF from the Render tool. | 2023.1.1.123 | Fixed |
TDSL-4618 | Dynamic save to PDF stopped working with AMP 2022.3. | 2023.1.1.123 | Fixed |
TDSL-4627 GCSE-1050 | In 2022.3, with AMP enabled, the Render tool doesn’t work correctly when you create an Excel file via the Group Data Into Separate Reports option. | 2023.1.1.123 | Fixed |
TDSL-4633 GENG-2965 | Both engines fail to convert 2^63 Float value to Integer. | 2023.1.1.123 | Fixed |
TDSL-4686 GCSE-1046 | AMP engine bug: Summarize tool with Mode action. | 2023.1.1.123 | Fixed |
TDSL-4698 GCSE-1071 | 2022.3 Table tool: Column Styling rules aren’t applied to the header. | 2023.1.1.123 | Fixed |
TDSL-4721 TELC-3231 DE19776 | AMP Union tool: Error input “#1” was not initialized. | 2023.1.1.123 | Fixed |
TDSL-4740 GCSE-1177 | With AMP enabled, when a Batch macro error occurs on one iteration, the macro doesn't finish the rest of the iterations. | 2023.1.1.123 | Fixed |
TDSL-4743 GENG-3078 | The Unique tool doesn't give correct data while using AMP engine with larger data sets. | 2023.1.1.123 | Fixed |
TDYN-447 | If you encounter this error: "Error: Select (8): Internal Error: Attempt to read past the end of a blob.", you can address it in Simba MongoDB ODBC driver. Increase the value for "Advanced option | Binary column size" from default to a higher value, like 262136. | 2023.1.1.123 | Fixed |
TELC-3108 | AMP Fuzzy Match discrepancy in results as compared to the original Engine. | 2023.1.1.123 | Fixed |
TELC-3239 GCSE-837 | AMP creates excessive temp files. | 2023.1.1.123 | Fixed |
TELC-3262 GCSE-1000 | The Create Points tool failed with “You have found a bug.” when creating 500k points in the AMP engine. | 2023.1.1.123 | Fixed |
TELC-3272 GCSE-970 | Python tool: Alteryx.getWorkflowConstants() fails to return any User-defined constants in the AMP engine. | 2023.1.1.123 | Fixed |
TELC-3276 GCSE-976 | Join Multiple and Select tools error with Fixed Decimals of size 258.0 when AMP is enabled. | 2023.1.1.123 | Fixed |
TELC-3278 GENG-2955 | AMP Summarize tool: Group By the same field, wrong results. | 2023.1.1.123 | Fixed |
TELC-3378 GCSE-937 | Combine Vertical option of Summarize tool corrupts 2 multi-byte characters. | 2023.1.1.123 | Fixed |
TELC-3545 | Internal Error: AddRecord() - MetaInfo must be successfully set before adding records. | 2023.1.1.123 | Fixed |
TGAL-7785 | Designer can't connect directly to a remote controller to create or manage schedules (Desktop Automation/Scheduler). | 2023.1.1.123 | Fixed |
TINST-389 | Non-Admin User Settings don’t migrate with the 22.3 upgrade. | 2023.1.1.123 | Fixed |
TINST-503 TDES-4841 | Patch version doesn’t show on the About window in Designer after you install a patch update on full GA version. | 2023.1.1.123 | Fixed |
TISE-222 TDST-3571 | The Alignment step in the Image Processing tool crops your images after rotation. | 2023.1.1.123 | Fixed |
TISE-251 | The PDF to Text tool allows language selection when you select Read Text Content Only. | 2023.1.1.123 | Fixed |
TSIM-1856 GCSE-646 | Simba Snowflake ODBC Driver v2.25 results with the error: "CURLerror (curl_easy_perform() failed) code=52 msg = 'Server returned nothing (no headers, no data)". This is resolved with a new driver version. Download and install driver version 2.25.8.1020 or newer from downloads.alteryx.com to resolve the error. | 2023.1.1.123 | Fixed |
TML-5503 | Incorrect state update and duplication of triggering DCM window for the Machine Learning Predict and Send tools. | 2023.1.1.123 | Fixed |
TML-5673 | Python error messages returned instead of normal error messages for Machine Learning Predict and Send tools. | 2023.1.1.123 | Fixed |
Minor Release Version 2023.1.1.200 | |||
TDCB-4655 | Access 32-bit drivers fail in tool configuration but runtime works for XLSB and ACCDB files. | 2023.1.1.200 | Fixed |
TDCB-4662 | Active Query Builder doesn't work with Access 2016 and 365 64-bit drivers. | 2023.1.1.200 | Fixed |
TDCB-4669 | XLSB not available in the Windows dropdown after you select in SiAP (No Office/Win 10/365 Runtime/64-bit). | 2023.1.1.200 | Fixed |
TDCB-4843 | Spatial with PostgreSQL fails from the Input Data tool when the selection is only a table as input. | 2023.1.1.200 | Fixed |
TDES-4555 | Multi-anchor Caching error with macros. | 2023.1.1.200 | Fixed |
TDES-4836 | Improve how Auto-Route Bezier and Auto-Route Perpendicular connections between Control Containers (CC) and other tools/CCs are rendered. Straight connections aren't affected. | 2023.1.1.200 | Fixed |
TDES-4906 | Double-clicking a tool in the tool palette should place the tool to the right of Control Containers. | 2023.1.1.200 | Fixed |
TDES-5430 | Action tool connected to a Control Container is missing action types. | 2023.1.1.200 | Fixed |
TDES-5637 | Compare Workflows feature doesn't work with Control Containers. | 2023.1.1.200 | Fixed |
TDSL-4785 | Int64 fails in Formula Add-In functions. | 2023.1.1.200 | Fixed |
TDES-6197 | There is an error when opening Designer, potentially affecting the Most Recently Used list. | 2023.1.1.200 | Fixed |
Minor Release Version 2023.1.1.247 | |||
TCPE-647 GCSE-1301 | Numbers formatted in Reporting tools are exported as strings randomly after upgrade. | 2023.1.1.247 | Fixed |
TDALI-4803 | Data type change to forced type is defaulting the size as 19. | 2023.1.1.247 | Fixed |
TDALI-4809 | Forced data type gets the Unhandled Exception error. | 2023.1.1.247 | Fixed |
TDALI-4972 GCSE-1443 | Unexpected error occurs when attempting to choose non-English data type in the Output data type in the Multi Field Formula tool with Designer version 2023.1. | 2023.1.1.247 | Fixed |
TDES-6186 | When opening a workflow from an Alteryx Analytics Cloud Platform workspace, if there is an unpackaging error and you select Yes, the Workflow Dependencies window doesn't open. | 2023.1.1.247 | Fixed |
TDYN-520 | Email tool authentication not working with Office365. | 2023.1.1.247 | Fixed |
TELC-3558 | If a data stream going into an activated Control Container (CC) was stopped by a CC that was never activated, or a disabled Tool Container or CC, an error is thrown. | 2023.1.1.247 | Fixed |
TELC-3636 GENG-3111 | Tool Container nested inside Control Container (CC) produces an error. As a workaround, use a Control Container instead of Tool Container. | 2023.1.1.247 | Fixed |
TELC-3637 GENG-3108 | If there are 2 Detour tools fully contained within a Control Container (and the connection between them doesn’t pass across the boundary of a CC), the second Detour tool produces an error. It shouldn’t do this as long as the connection doesn’t cross the boundary of a Control Container. | 2023.1.1.247 | Fixed |
TELC-3695 TDES-6283 | Error when the connection to a Browse tool inside a Control Container crosses the Control Container boundary. | 2023.1.1.247 | Fixed |
TELC-3759 | Control Container: App and standard workflow error when disabling all Browse tools. | 2023.1.1.247 | Fixed |
Minor Release Version 2023.1.1.281 | |||
GDCM-3128 | Data Connection Manager (DCM): NetSuite data source doesn't display when accessed via the Input Data tool. | 2023.1.1.281 | Fixed |
TDCB-4940 | Postgres throws an error if GEOMETRY_COLUMNS is in a different schema. | 2023.1.1.281 | Fixed |
TDSL-4862 GCSE-1424 | Macro in a folder with a Japanese name (multi-byte characters): The macro returns an error in Designer 2023.1.1.123. | 2023.1.1.281 | Fixed |
TELC-3768 | Tools inside non-active Control Containers shouldn't process and output any data. | 2023.1.1.281 | Fixed |
TELC-3819 GENG-3195 | AMP performance issue with Cross Tab tool. | 2023.1.1.281 | Fixed |
Minor Release Version 2023.1.1.306 | |||
GENG-3010 | AMP: Sum Action in the Summarize tool adds leading 0’s to the Fixed Decimal between -999 to 999. | 2023.1.1.306 | Fixed |
GENG-3243 GCSE-1669 | Error “Cannot find macro ‘XXX’ when calling nested macros in subfolders. | 2023.1.1.306 | Fixed |
GENG-3264 | AMP and date-time precision: The Union tool incorrectly truncates data. | 2023.1.1.306 | Fixed |
GENG-3270 / GENG-3273 | AMP doesn’t put record swap files in workflow session temp directory / e2Temp Files are not limited and can fill drive. | 2023.1.1.306 | Fixed |
GENG-3289 | AMP doesn’t read Server TempFiles directory parameter from RunParameters. | 2023.1.1.306 | Fixed |
TCPE-648 GCSE-1269 | WorkflowFilePath tag doesn’t populate correctly for workflows in Customer Managed Telemetry XML. | 2023.1.1.306 | Fixed |
TDYN-632 GCSE-1789 | DCM connections: Typo sends incorrect connection parameter to Snowflake. | 2023.1.1.306 | Fixed |
TELC-3711 GCSE-1427 | FindReplace doesn’t work with UTF8 on AMP. | 2023.1.1.306 | Fixed |
TGAL-8978 | Collection owners are unable to see the workflows added by other users in Designer. | 2023.1.1.306 | Fixed |
Minor Release Version 2023.1.1.336 | |||
GENG-3132 | The Select tool throws AMP conversion errors when the data type changes from Fixed Decimal 12.0 to Int32. | 2023.1.1.336 | Fixed |
GENG-3254 GCSE-1739 | DCM connection on the Dynamic Input tool generates a different number of rows than a non-DCM connection with AMP enabled. | 2023.1.1.336 | Fixed |
GENG-3313 | Dynamic Input: Internal error in RecordReader::ReadFields: Too many fields. | 2023.1.1.336 | Fixed |
GENG-3351 GCSE-1632 | Int64 still fails in Formula Add-In functions in certain cases. | 2023.1.1.336 | Fixed |
GENG-3374 GCSE-1466 | Depending on upstream mail server configuration, attaching files to an email sent with the Email tool or Email Events in Designer/Server 2022.3+ can result in unsent emails, possibly with attendant Non-Delivery Report (NDR) Delivery Status Notifications coming back from addressee mail servers (example: "550 5.6.11 The mail client submitted this message with bare line feeds, which cannot be sent via SMTP protocol DATA command and receiving system does not support BDAT"). | 2023.1.1.336 | Fixed |
GENG-3381 | Macros that contain a Control Container and a nested macro with a relative path cause an error. | 2023.1.1.336 | Fixed |
GENG-3382 | Zero records through Control Container with a macro that contains Control Container with DB Output. | 2023.1.1.336 | Fixed |
GENG-3422 | After upgrading to 2023.1, Designer crashes frequently. | 2023.1.1.336 | Fixed |
TDCE-270 GCSE-1746 | Table name is garbled in Query Builder with Oracle OCI. | 2023.1.1.336 | Fixed |
TDCE-288 GCSE-1833 | Receive error "CREATE TABLE permission denied in database" when trying to create a temporary table in Microsoft Azure SQL Data Warehouse using the Data Stream In tool. | 2023.1.1.336 | Fixed |
TDSL-4801 GCSE-894 | AMP: Error opening the file. The filename, directory name, syntax is incorrect. | 2023.1.1.336 | Fixed |
Minor Release Version 2023.1.1.361 | |||
GENG-3257 GCSE-1661 | Workflow hangs infinitely when AMP is enabled without any error. | 2023.1.1.361 | Fixed |
GENG-3372 GCSE-1578 | Message tool set to Error and Stop Passing Records still creates an empty file when no file should be created. | 2023.1.1.361 | Fixed |
GENG-3404 GCSE-1828 | Control Container with a nested disabled Control Container inside it causes an error. | 2023.1.1.361 | Fixed |
GENG-3407 GCSE-1850 | Find Replace tool fails with special characters when AMP is enabled. | 2023.1.1.361 | Fixed |
GENG-3476 | Output errors with invalid connection for a macro with a Control Container inside. | 2023.1.1.361 | Fixed |
GENG-3478 GCSE-1862 | Control Container error: "Internal Error - Anchor (###:Log) was not closed" when activated Control Container contains a Run Command tool with no Read Results input specified. | 2023.1.1.361 | Fixed |
GENG-3489 GCSE-1064 | If Cancel Running Workflow on Error is selected, an email is sent when the workflow fails, but there is no mention of it in the Results window. | 2023.1.1.361 | Fixed |
GENG-3490 | Crash with a batch macro when some of the input connections are invalid. | 2023.1.1.361 | Fixed |
TCPE-525 GCSE-1030 | When using Designer localized to Chinese or French, the Insights tool can’t be configured and causes Designer to hang with an error message. | 2023.1.1.361 | Fixed |
TDES-5864 | Convert to Macro Input causes an unhandled exception. | 2023.1.1.361 | Fixed |
TDES-9579 | When you save to an AACP workspace, the dialog window might generate this error message: "Unexpected character encountered while parsing value…". This error is due to an updated compression algorithm enabled in AACP. The desktop workflow still saves to the AACP workspace despite the error. We recommend that you upgrade to 23.1 Patch 6 to avoid this error. | 2023.1.1.361 | Fixed |
TUC-239 TUC-530 | AWS S3 Output with Signature V4 authentication errors with upload greater than 5 GB. | 2023.1.1.361 | Fixed |
Minor Release Version 2023.1.1.392 | |||
GENG-3775 GCSE-2014 | Regex_Replace function causes issue when matching case with a variable pattern. | 2023.1.1.392 | Fixed |
GENG-3804 GCSE-2069 | Append tool error in 22.1 E1 Analytic App that doesn't appear with AMP or when run as a workflow: "The source stream was not properly initialized". | 2023.1.1.392 | Fixed |
GENG-3812 TELC-3867 | Crash in WorkflowContext::CloseErroredTool(). | 2023.1.1.392 | Fixed |
GENG-3893 GCSE-2171 | Formula tool returns '0' for calculation of - [Null] on Designer version 2023.1 (Returns 'Null' on 21.4.2). | 2023.1.1.392 | Fixed |
GENG-3922 GCSE-2187 | Macro returns "You have found a bug" in AMP engine for defined range when one does not exist. | 2023.1.1.392 | Fixed |
TDCB-4645 | Workflows with operations on SQL server are running slower on 2022.1. | 2023.1.1.392 | Fixed |
TDCE-382 GCSE-2110 | Error with Iterative Macro using S3 tool: "Account Number is a required field". | 2023.1.1.392 | Fixed |
Minor Release Version 2023.1.1.422 | |||
GENG-3946 | The Fuzzy Match tool has a different number of matches with Compatability Mode enabled in AMP. | 2023.1.1.422 | Fixed |
GENG-3504 GCSE-1900 | Macro returns “You have found a bug” in the original Engine when the output connection is missing metainfo. | 2023.1.1.422 | Fixed |
Minor release Version 2023.1.1.437 | |||
GENG-3214 GCSE-1677 | Bug found while generating chart via the Interactive Chart tool. | 2023.1.1.437 | Fixed |
GENG-3676 GCSE-2001 | Running a workflow with a Join tool as an Analytic App generates an error and crash report if the AMP engine is disabled in the Runtime settings. | 2023.1.1.437 | Fixed |
GENG-4132 TDCB-5502 | Crash when no upstream metainfo is provided. | 2023.1.1.437 | Fixed |
TDCE-477 GCSE-2383 | Denodo error: Unexpected error while parsing ODBC column 1 description types. | 2023.1.1.437 | Fixed |
Minor Release Version 2023.1.1.460 | |||
GENG-4097 GCSE-2365 | The Summarize tool produces different values for Median when the incoming data is sorted versus not sorted. | 2023.1.1.460 | Fixed |
GENG-4117 | Potential bug in Action UpdateValue with the R tool. | 2023.1.1.460 | Fixed |
GENG-4150 | Control Container should not be executed if it’s located inside a disabled container. | 2023.1.1.460 | Fixed |
GENG-4272 | Message tool: Crash in ‘After Last Record’ and ‘After All Down Stream Tools have completed.’ | 2023.1.1.460 | Fixed |
GENG-4313 GCSE-2588 | Results of relative paths are different between relative paths inside and outside of Control Containers. | 2023.1.1.460 | Fixed |
TDYN-789 TDCE-528 | Amazon S3 Input fails without an error using AVRO with a record limit applied. | 2023.1.1.460 | Fixed |
Known Issues
Known Major Release Version 2023.1.1.123 | |||
|---|---|---|---|
ID | Description | Version | Issue Status |
GENG-3179 | When you use a DateTimeAdd formula with a large number of subseconds, the formula results in conversion errors/null values. | 2023.1.1.123 | Known |
TCPE-633 GCSE-1240 | The Interactive Chart tool doesn’t display large values correctly. | 2023.1.1.123 | Known |
TDALI-4972 GCSE-1443 | An unexpected error occurs when you attempt to choose a non-English data type in the Change Output Type to field in the Multi-Field Formula tool. | 2023.1.1.123 | Known |
TDCB-4640 GDCM-2901 | OleDB tool setup proceeds even if canceled. | 2023.1.1.123 | Known |
TDCB-4655 | Access 32bit drivers fail in tool configuration but runtime works (XLSB, ACCDB). | 2023.1.1.123 | Known |
TDCB-4662 | Active Query Builder doesn't work with Access 2016 and 365 64-bit drivers. | 2023.1.1.123 | Known |
TDCE-78 GCSE-1045 | ADLS Input generates a Malformed CSV file error. | 2023.1.1.123 | Known |
TDCE-82 GCSE-1055 | ADLS Connector on Gallery fails when the DCM credentials are used (specifically with the "Shared Key" authentication type). | 2023.1.1.123 | Known |
TDCE-121 GCSE-1173 | Flow parameters don’t work in the Power Automate tool. | 2023.1.1.123 | Known |
TISE-437 | The selectable area for the Term Frequency question mark icon in the Text Classification tool might be very small. | 2023.1.1.123 | Known |
Control Container Known Issues | |||
GENG-3623 | Related to TELC-3768 which was previously reported as fixed. Control Containers are not being inactivated when zero records are received and a Control Container contains a CSV file. | 2023.1.1.123 | Known |
TDES-4700 | Insert After and Add Browse After options don't work with Control Containers. | 2023.1.1.123 | Known |
TDES-4836 | Improve how Auto-Route Bezier and Auto-Route Perpendicular connections between Control Containers (CC) and other tools/CCs are rendered. Note that straight connections aren't affected. | 2023.1.1.123 | Known |
TDES-4906 | Double-clicking a tool in the tool palette should place the tool to the right of Control Containers. | 2023.1.1.123 | Known |
TDES-5430 | Action tool connected to a Control Container is missing action types. | 2023.1.1.123 | Known |
TDES-5637 | Compare Workflows feature doesn't work with Control Containers. | 2023.1.1.123 | Known |
TDES-5811 | The Anchor drag hitbox for Control Container Control Input anchor is too large when you connect from a tool inside that Control Container. | 2023.1.1.123 | Known |
TDES-5955 | Inserting Control Containers via Insert in Connection doesn't auto-move tools to make space. | 2023.1.1.123 | Known |
TDES-6029 | The Cache and Run Workflow feature has unexpected results in workflows that have Control Containers. | 2023.1.1.123 | Known |
TELC-3627 GENG-3113 | Analytic App with Control Container and Tree tool generates an error. | 2023.1.1.123 | Known |
TELC-3636 GENG-3111 | Tool Container nested inside Control Container (CC) produces an error. As a workaround, use a Control Container instead of Tool Container. | 2023.1.1.123 | Known |
TELC-3637 GENG-3108 | If there are 2 Detour tools fully contained within a Control Container (and the connection between them doesn’t pass across the boundary of a CC), the second Detour tool produces an error. It shouldn’t do this as long as the connection doesn’t cross the boundary of a Control Container. | 2023.1.1.123 | Known |
Minor Release Version 2023.1.1.200 Cloud Execution for Desktop Known Issues | |||
GCMD-28TGAL-8245 | The Interactive Chart tool throws an error and doesn't render a chart. | 2023.1.1.200 | Known |
TDES-6186 | When opening a workflow from an Alteryx Analytics Cloud Platform workspace, if there is an unpackaging error and you select Yes, the Workflow Dependencies window doesn't open. | 2023.1.1.200 | Known |
Security Updates
Fixed Patch/Minor Release Version 2023.1.1.281 | |||
|---|---|---|---|
ID | Description | Version | Issue Status |
TGAL-8498 GVM-584 | Potential XSS in Designer/Server Open Workflow interaction. | 2023.1.1.281 | Fixed |
Patch/Minor Release Version 2023.1.1.306 | |||
TCUD-4231 | Updated Chromium Embedded Framework library (CEF) to address potential vector for CVE-2023-4863 (libwebp). | 2023.1.1.306 | Fixed |
Patch/Minor Release Version 2023.1.1.336 | |||
TBO-1139 | Updated embedded OpenSSL versions to 3.0.8 (Engine, AMP) and 1.1.1t (v1 SDK). Addresses the following CVEs:
Go to https://www.openssl.org/news/openssl-3.0-notes.html and https://www.openssl.org/news/openssl-1.1.1-notes.html. Note: Alteryx Server relies upon the native Windows SChannel implementation for inbound TLS/HTTPS and TLS Service Layer communications. In a networking context, OpenSSL is used only in 1) outbound connections occurring as a result of Engine/AMP/SDK-tool execution during workflow runs, and 2) outbound connections to alteryx.com and flexnetoperations.com for licensing and activation. | 2023.1.1.336 | Fixed |