Learn which troubleshooting guide to look at based on the error you see when transpiling from Alteryx to Databricks SQL
This page maps common Transpiler errors encountered when migrating Alteryx workflows to Databricks SQL to the correct troubleshooting guides. Match the exact error text from your run to quickly jump to the fix.
If you are having trouble with an issue not listed here, contact us through the Prophecy Support Portal.
Cannot resolve routine <FunctionName> on search path [`system`, `builtin`, `system`.`session`, `hive_metastore`.`default`]. Verify the spelling of <FunctionName>, check that the routine exists, and confirm you have `USE` privilege on the catalog and schema, and EXECUTE the routine. SQLSTATE: 42883;
If you encounter one or more of the following errors:
Copy
Unable to load associated entities.
Copy
Following files have incorrect format: <filePath>
Copy
Transpilation failed with exception: org.xml.sax.SAXParseException; lineNumber: <num> columnNumber: <num> The element type "<elementType>" must be terminated by the matching end tag "<endElementType>".