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

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