General Issues and Troubleshooting

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
​MSCEWI1001​
Error parsing the source code
Critical
​MSCEWI1002​
Removed next statement, not applicable in SnowFlake
Low
​MSCEWI1003​
Error executing a SQL conversion rule
Critical
​MSCEWI1004​
Error executing a script conversion rule
Critical
​MSCEWI1005​
File not generated log
Critical
​MSCEWI1006​
Error writing the top-level objects file
Critical
​MSCEWI1007​
Error writing the output file
Critical
​MSCEWI1008​
Expression at time zone changed
Low
​MSCEWI1009​
Error converting a top-level object
Critical
​MSCEWI1010​
No rule for procedure statement
Critical
​MSCEWI1011​
Unexpected end of the statement
High
​MSCEWI1012​
Unexpected end of the statement check line
High
​MSCEWI1013​
An Exception is thrown during conversion
Critical
​MSCEWI1014​
Procedure body not generated
Critical
​MSCEWI1015​
The input pivot/unpivot statement form is not supported
Medium
​MSCEWI1016​
Error writing details file
Critical
​MSCEWI1017​
Error writing summary file
Critical
​MSCEWI1018​
Error writing issues file
Critical
​MSCEWI1019​
Error writing the assessment report file
Critical
​MSCEWI1020​
Custom UDF Inserted
Low
​MSCEWI1021​
Syntax not supported
Medium
​MSCEWI1022​
Parameter missing dependency
Medium
​MSCEWI1023​
Loop performance review
Low
​MSCEWI1024​
Check constraint commented
Low
​MSCEWI1025​
Binding time variables might require a change
Low
​MSCEWI1026​
Qualified variables may require a cast
Low
​MSCEWI1027​
Variable with invalid query
Medium
​MSCEWI1028​
Type not supported
Medium
​MSCEWI1029​
No rule found for SQL node
Critical
​MSCEWI1030​
No rule was found for BTEQ node
Critical
​MSCEWI1031​
Function not supported
Medium
​MSCEWI1032​
Cast type not supported
Medium
​MSCEWI1033​
Semantic information not found
Low
​MSCEWI1034​
Format removed
Low
​MSCEWI1035​
CHECK statement not supported
Low
​MSCEWI1036​
Data type converted to another data type
Low
​MSCEWI1037​
Translation planned for the future
Medium
​MSCEWI1038​
Dynamic SQL statement may be unrecognized
Low
​MSCEWI1039​
Semantic information could not be loaded
Low
​MSCEWI1040​
Statement Not Supported
Low
​MSCEWI1041​
Crash parsing the source code file
Critical
​MSCEWI1042​
Non-relevant syntax
Low
​MSCEWI1043​
Translation for expression not supported
Medium
​MSCEWI1044​
Type changed to Date
Low
​MSCEWI1045​
Column name is a reserved keyword in Snowflake
Medium
​MSCEWI1046​
Verification of functional equivalence for function is pending
Medium
​MSCEWI1047​
The statement was converted but its functionality is not implemented yet
Medium
​MSCEW1048​
Sequence warning.
Low
​MSCEW1049​
Not recognized function.
Low
​MSCEWI1050​
Missing dependent object
Low
​MSCEWI1051​
Unrecognized or unsupported parameter data type.
Medium
​MSCEWI1052​
Unusable object.
Medium
​MSCEWI1053​
Object may not work.
Low
​MSCEWI1054​
Unsupported outer join subquery
Low
​MSCEWI1055​
Referenced Custom Type not found
Low
​MSCEWI1056​
Custom Types Not Supported
Low
​MSCEWI1057​
Create Type Variant Not Supported
High
​MSCEWI1058​
Snowscript functionality is not supported
Medium
​MSCEWI1059​
Non-Ansi Outer Join is not supported in OR predicate
Medium
​MSCEWI1060​
Non-Ansi Outer Join to multiple tables is not supported in Snowflake
High
​MSCEWI1061​
Column does not come from a Non-Ansi Outer Join Expression
Low
​

Roadmap

MSCEWI1001

Last modified 4d ago

Copy link