General Issues and Troubleshooting
In this section, you will be able to find all the SnowConvert common issues with their respective description and possible solution.
Here is the list of generic issue codes that exist in SnowConvert across all platforms. You can learn more about each particular issue by clicking on the code.
Code | Description | Severity |
|---|---|---|
Error parsing the source code | Critical | |
Removed next statement, not applicable in SnowFlake | Low | |
Error executing a SQL conversion rule | Critical | |
Error executing a script conversion rule | Critical | |
File not generated log | Critical | |
Error writing the top-level objects file | Critical | |
Error writing the output file | Critical | |
Expression at time zone changed | Low | |
Error converting a top-level object | Critical | |
No rule for procedure statement | Critical | |
Unexpected end of the statement | High | |
Unexpected end of the statement check line | High | |
An Exception is thrown during conversion | Critical | |
Procedure body not generated | Critical | |
The input pivot/unpivot statement form is not supported | Medium | |
Error writing details file | Critical | |
Error writing summary file | Critical | |
Error writing issues file | Critical | |
Error writing the assessment report file | Critical | |
Custom UDF Inserted | Low | |
Syntax not supported | Medium | |
Parameter missing dependency | Medium | |
Loop performance review | Low | |
Check constraint commented | Low | |
Binding time variables might require a change | Low | |
Qualified variables may require a cast | Low | |
Variable with invalid query | Medium | |
Type not supported | Medium | |
No rule found for SQL node | Critical | |
No rule was found for BTEQ node | Critical | |
Function not supported | Medium | |
Cast type not supported | Medium | |
Semantic information not found | Low | |
Format removed | Low | |
CHECK statement not supported | Low | |
Data type converted to another data type | Low | |
Translation planned for the future | Medium | |
Dynamic SQL statement may be unrecognized | Low | |
Semantic information could not be loaded | Low | |
Statement Not Supported | Low | |
Crash parsing the source code file | Critical | |
Non-relevant syntax | Low | |
Translation for expression not supported | Medium | |
Type changed to Date | Low | |
Column name is a reserved keyword in Snowflake | Medium | |
Verification of functional equivalence for function is pending | Low | |
The statement was converted but its functionality is not implemented yet | Medium | |
Sequence warning. | Low | |
Not recognized function. | Low | |
Missing dependent object | Low | |
Unrecognized or unsupported parameter data type. | Medium | |
Unusable object. | Medium | |
Object may not work. | Low | |
Unsupported outer join subquery | Low | |
Data Type Not Recognized | Low | |
Custom Types Not Supported | Low | |
Create Type Variant Not Supported | High | |
Functionality is not currently supported by Snowflake Scripting | Medium | |
Non-Ansi Outer Join is not supported in OR predicate | Medium | |
Non-Ansi Outer Join to multiple tables is not supported in Snowflake | High | |
Column does not come from a Non-Ansi Outer Join Expression | Low | |
Custom type usage changed to variant | Low | |
Added statements because object used a custom type | Low | |
Referenced custom type in query not found | High | |
Columns from expression not found | High | |
Number type column may not behave similarly in Snowflake | Low | |
UDF was transformed to Snowflake procedure, calling procedures inside a query is not supported | High | |
User defined function was transformed to a Snowflake procedure | Low | |
User defined function inner logic was transformed to a single Common Table Expression | Low | |
User defined function body not generated | Critical | |
User defined function structured block was transformed to a single SQL Query | Low | |
Window frame unit was changed to Rows | Low | |
Pending Functional Equivalence Review | Medium | |
Suffixes in numeric literals were removed | Low | |
Current Of Clause is Not Supported | High | |
Constants are not supported by Snowflake Scripting. It was transformed to a variable. | Low | |
Cycle Found between CTE calls | Low | |
Output parameters are not supported by Snowflake Scripting | Medium | |
Parameter names were removed from call | Low | |
Default value is not allowed on binary columns | Low | |
Snowflake Scripting procedure cannot return more than one result set | Medium | |
Auto-Generated code in order to support the output parameters functionality in Snowflake Sripting | Low | |
Output parameters are not supported by Snowflake Scripting but their functionality is being emulated | Low | |
XMLTABLE is not supported. | High | |
Helper file generated for object | Low | |
Replaced invalid characters for new identifier | Low | |
Arguments do not match the called procedure parameters count, default parameters are not supported yet | Low | |
Default value removed | Low | |
Default value added | Low | |
Create Index Not Supported | High | |
Materialized View was converted to regular View | Low | |
On Commit not supported | Medium | |
Label declaration not supported | Low | |
Object not renamed | Low | |
TIME ZONE not supported for time data type | Medium | |
Constraint in default expression is not supported. | Low | |
Precision in milliseconds reduced to three digits. | Low | |
Create table as subquery with no data is not supported in Snowflake | Low |
Have an issue related to a specific source platform? Check out the individual pages for each source SnowConvert platform:
In this section, you could find an explanation of the severities.
Warnings for source code that there was no direct conversion to Snowflake. The code has been converted to a functionally equivalent output but should still be reviewed.
Errors that produce a functional or runtime difference. The user may have to invest a low amount of manual effort to complete the conversion.
Errors that produce a functional or runtime difference. The user may have to invest a high amount of manual effort to complete the conversion.
Parsing errors or errors that cause significant conversion exceptions in SnowConvert. If the source code is correct, a significant intervention will be required.
Reach out! Whether you need additional support working through migration or if you need an additional feature, let us know. Mobilize.Net is here to be your partner in the conversion process. You can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 2mo ago