Alteryx Designer Knowledge Base

Platform Product: Designer Issues – Working with Alteryx Customer Support Engineers (CSEs) (for use by CSEs and Alteryx Customers)   To EXPEDITE the resolution of your case please include following:       *** Suggestion:  Copy/Paste the questions below and e-mail to support@alteryx.com   Database Connectors  - Requested Information *** Suggestion: copy/paste the questions below and email the supporting documentation to support@alteryx.com   1. Detailed Description of the Issue 2. Screenshot of Alteryx Version 3. Screenshot of Error  4. Please send a copy of your workflow (*.yxmd or *.yxzp) 5. Have there been any changes made recently? Update to Alteryx, Server, etc.?  6. Windows Event Logs 7. AlteryxGUI Logs     *** Designer issues involve the configuration of the XML of the workflow, as well as interface issues.   Designer– Requested Information (Detailed Instructions):   1.  Detailed Description of the Issue – What issues are you having?  Has it worked in the past?  When did the issue start?  Are all users affected or just some?  What are the steps to reproduce your issue?  What have you tried to resolve the issue?  Have you searched the Alteryx Community ?     2.   Screenshot of Alteryx Version– Our CSEs need to know precise version of Alteryx so we can replicate any issues.   In Alteryx, click Help >> About and provide a screenshot. The screenshot will include whether it is Server or Designer.  In addition, whether it is “Running Elevated” Admin vs. Non-Admin.     3.  Screenshot of Error or Exact Text of Error- Click CTRL-Print-screen to capture the error and paste into your e-mail.  Also include where was the error encountered – Gallery, Designer, Scheduler?     Note: You may wish to Google the error text research the issue. The Knowledgebase is also a great place to search the error text as well!    4.  Please send a copy of your workflow (*.yxmd or *.yxzp) and sample data if possible. Either create a .yxzp and include macros and data by clicking Options>Export Workflow.  Or, include the workflow *.yxmd and sample data if possible.       5.  Have there been any changes made recently? Update to Alteryx, Server, etc.?  What do you think may have caused the issue?  What have you done to try to resolve the issue?   6. Windows Event Logs (Optional)- Event logs provide historical information that can help you track down system and security problems. Provide System and Application logs in evtx format.   From the Windows Start menu, search for “event” and choose Event Viewer. Expand the Windows Logs and right-click on ‘Application’ and select ‘Save All Events As…’ and save as *.evtx file Right-click on ‘System’ and select ‘Save All Events As…’ and save as *.evtx file     7. AlteryxGUI Logs - Please send a copy of your most recent AlteryxGui Logs.  The default path is C:\ProgramData\Alteryx\ErrorLogs\AlteryxGUI.    

Platform Product: Spatial Issues – Working with Alteryx Customer Support Engineers (CSEs) (for use by CSEs and Alteryx Customers)   To EXPEDITE the resolution of your case, please include the below information.   Spatial - Requested Information: *** Suggestion: copy/paste the questions below and email the supporting documentation to support@alteryx.com   1. Detailed Description of the Issue 2. Screenshot of Alteryx Version 3. Screenshot of Error or Exact Text of Error 4. Spatial File type 5. Please send a copy of your workflow (*.yxmd or *.yxzp) 6. Have there been any changes made recently? Update to Alteryx, Server, etc.?     Spatial – Requested Information (Detailed Instructions):   1.  Detailed Description of the Issue – What issues are you having?  Has it worked in the past?  When did the issue start?  Are all users affected or just some?  What are the steps to reproduce your issue?  What have you tried to resolve the issue?  Have you searched the Alteryx Community ?     2.  Screenshot of Alteryx Version– Our CSEs need to know the precise version of Alteryx so we can replicate any issues.   In Alteryx, click Help >> About and provide a screenshot.  The screenshot will include whether it is Server or Designer.  In addition, whether it is “Running Elevated” Admin vs. Non-Admin.       3.  Screenshot of Error or Exact Text of Error- Click CTRL-Print-screen to capture the error and paste into your e-mail.  Also include where was the error encountered – Gallery, Designer, Scheduler? Note: You may wish to Google the error text research the issue. The Knowledgebase is also a great place to search the error text as well!    4.  Spatial File type – What type of file are you working with? How many records?   5.  Please send a copy of your workflow (*.yxmd or *.yxzp) and sample data if possible. Either create a .yxzp and include macros and data by clicking Options>Export Workflow.  Or, include the workflow *.yxmd and sample data if possible.         6.  Have there been any changes made recently? Update to Alteryx Designer, Server, etc.?  What do you think may have caused the issue?  What have you done to try to resolve the issue?     Suggested links: Spatial Functions  

Platform Product: Database Connections Issues – Working with Alteryx Customer Support Engineers (CSEs) Database Connections Issues – Working with Alteryx Customer Support Engineers (CSEs) To EXPEDITE the resolution of your case, please include the below information.   Database Connections- Requested Information  *** Suggestion: copy/paste the questions below and email the supporting documentation to support@alteryx.com   1. Detailed description of the Issue 2. Is this a Production Issue? What is the urgency? 3. Have there been any changes made recently? Update to Alteryx, Server, etc.? 4. Alteryx Version Server, Connect or Designer? 5. Screenshot of Error and the Configuration of the Input tool. 6. What is your Database Type and Version?  Is your database/version supported?  http://www.alteryx.com/technical-specifications 7. What is your Driver Version 8. Do you have 32bit or 64bit? 9. Are you able to connect to their databases with something else like TOAD, SQL Developer, Tableau? If you are using ODBC, does the test button in ODBC dsn work? 10. Please send a copy of your workflow (*.yxmd or *.yxzp) 11. Have any changes made recently, such as update to Alteryx, Server, etc.? 12. Have you successfully connected to the database before? Are your colleagues able to connect? 13. Have you searched for this issue on the Community? 14.  What have you tried? 15.  ODBC Trace Log file?     Database Connections – Requested Information (Detailed Instructions): ***All of the below are not required, but please send what you can provide.   1.  Detailed Description of the Issue – What issues are you having?  Has it worked in the past?  When did the issue start?  Are all users affected or just some?  What are the steps to reproduce your issue?  What have you tried to resolve the issue?  Have you searched the Alteryx Community?     2.  Is this a Production Issue? What is the urgency? How many people is this affecting?  Are you able to complete most of your work?  Do you have a time frame that you need to resolve the issue?     3.   Have there been any changes made recently? Update to Alteryx, Server, etc.?  What do you think may have caused the issue?  What have you done to try to resolve the issue?     4.  Alteryx Version – Our Customer Support Engineers need to know the precise version so we can replicate any issues.   In Alteryx, click Help >> About and provide a screenshot, or the exact version number.     5.  Exact Text of Error or Screenshot of error- Click CTRL-Print-screen to capture the error and paste into your e-mail. Note: You may wish to Google the error text research the issue. The Knowledgebase is also a great place to search the error text as well!  Where was the error encountered?  Gallery?   6.  What is your Database Type and Version?   Is your database/version supported?  http://www.alteryx.com/technical-specifications       7. What is your Driver Version?  Click Start - ODBC Datasources 64 bit<Drivers.  Highlight the driver you are using and send a screen shot.  Do you know if it is 32 bit?  Have you tried a different driver?  OLEDB instead of ODBC will be faster.       8.  Do you have 32bit or 64bit?   9.  Are you able to connect to the databases with something else like TOAD, SQL Developer, Tableau? If you are using ODBC, does the test button in ODBC DSN work?  Click Start>ODBC Data Source Administrator>System DSN.  Highlight the Driver.  Click Configure and Test.       10.  Please send a copy of your workflow (*.yxmd or *.yxzp) and sample data if possible. Either create a .yxzp and include macros and data by clicking Options>Export Workflow.  Or, include the workflow *.yxmd and sample data if possible.   11.  Have any changes been made recently, such as an update to Alteryx Designer, Server, etc.?  Migrated the database to the cloud?  What is the physical location of the database?   12.  Have you successfully connected to the database before?  Are your colleagues able to connect now?     13.  Have you searched for this issue on the Community? https://community.alteryx.com   14.  What have you tried?  Do fewer records run?  Does a simple query run with just one column in the table?     15.  ODBC Trace Log file.  Click Start<ODBC Data Source Administrator<System DSN.  Highlight the Driver.  Click Configure and Test.    Suggested Links: Troubleshooting Database Connections Creating an In-Database Connection FAQ: How Do the In-Database tools Work? How To: Connect to an Oracle Database in Alteryx