Alteryx Designer

Definitive answers from Designer experts.
Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.
View full article
Unable to find the dll: "OCI.dll" Within Alteryx this error will be prompted due to a mismatch between 32/64 bit drivers and the Alteryx bit version. This error may also appear if you do not have the drivers installed. One way to troubleshoot this is to find out what drivers you have installed! You can use an input tool in the Alteryx Designer, go to Other Databases and select either ODBC/OleDB (64-bit) or 32-Bit Database Connections -> ODBC/OleDB. In the next pop out window it will populate with the available drivers for those connections. If you have no drivers in this pop out window this means you do not havethe correct drivers for 32 bit or 64 bit connection dependent upon which one you chose. Links to drivers are available from within individual data source pages here. This will take you away from the Alteryx website and onto the driver provider’s pages. Please consult with your IT to find the correct drivers for your environment.
View full article
Error: "SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE')" when connecting to DB2 using the Input Data tool.
View full article
Environment variable issue with the os.environ['PATH'] error
View full article
Customers using pre 2019.4 Designer and Insights Data need to update to the Mapbox maps or they will see this issue with Digital Globe maps.
View full article
Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool.
View full article
Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.
View full article
User is attempting to connect to Hadoop Hive with Active Directory Kerberos (Kerberos SSPI) in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information. The test button in the ODBC DSN is successful.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
An Unhandled Exception occurred when opening a workflow
View full article
When using Excel spreadsheets in Alteryx, sometimes there may be difficulty in reading the data. Viewing the spreadsheets in XML format is an excellent way to check for encoding or formatting issues.
View full article
This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.
View full article
Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.
View full article
Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article
An "Unhandled Exception" thrown when starting Designer, appears when the user clicks on the splash screen. Looking at C:\ProgramData\Alteryx\ErrorLogs reveals the following error type: System.IO.DirectoryNotFoundException Message: Could not find a part of the path 'F:\.....'
View full article
The error message appears when using System Settings in Alteryx Designer.
View full article
If you observe an error message like Error: Salesforce Input (1) File " ", line 1 os.environ['PATH'] = r"... please read on to learn how to adjust the environment variables to resolve it. This can happen with any one of several Connector tools, not just the tool mentioned in the example.
View full article
Error: "Oracle driver: You are not licensed to use this DataDirect Technologies product" when connecting to Oracle in Designer.
View full article