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.
In this section, you will find a short description of all the SnowConvert common issues. To get more information about them, please click on the code on each one of them.
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
Medium
The statement was converted but its functionality is not implemented yet
Medium
MSCEW1048
Sequence warning.
Low
MSCEW1049
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
Referenced Custom Type not found
Low
Custom Types Not Supported
Low
Create Type Variant Not Supported
High
Snowscript functionality is not supported
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
Last modified 4d ago
Copy link