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 Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
Quick Connect: Internal-Error-Unable-to-add-new-Alias-to-the-Alias-Manager
View full article
Display issues when reading data with unicode characters from Oracle
View full article
Understand and troubleshoot the "No error handle available to report exact OCI_ERROR" error message
View full article
An OCI error may occur when running a workflow from a network location with many OCI inputs: OCIEnvCreate Error: No error handle available to report exact OCI_ERROR.
View full article
Exception handling may be needed so that a scheduled workflow continues even if a pre or post Oracle SQL statement has an error.
View full article
Characters that are not on a standard English keyboard may need translation into Unicode or a language-specific code page for Designer and database drivers to read them correctly. Characters with incorrect encoding will often appear as boxes or question marks in the Designer Results screen and error messages. Unicode characters take more bytes than English ASCII characters. Changing the column type and increasing the column size may be needed. In Designer, the column size is the number of characters, not the number of bytes.
View full article
Oracle database character set is AL32UTF8. The field defined is VARCHAR2. Writing back some Chinese characters to this field using OCI ends with garbled characters.
View full article
Error: "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP" in workflow connected to Oracle.
View full article
Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.
View full article
The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.
View full article
Alteryx doesn't read some unicode characters correctly
View full article
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
Numeric values show "[Null]" instead of a blank cell using the Input Data tool.
View full article
Importing Thai data from Oracle Database using Oracle ODBC driver is displaying the Thai characters as garbled characters in Alteryx. This can be addressed by setting a parameter in the driver to unconditionally change the data type to support Unicode.
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
Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".
View full article
Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article