Links

Issues and Troubleshooting

In this section, you will find information about Errors, Warnings, and Issues on the SnowConvert.
Before we get too far down the troubleshooting road, recall that we highly recommend that you go through our training labs in order to get the most out of SnowConvert.
Conversions of any large quantity of code will likely have a few errors and warnings. Mobilize.Net has been the leading authority on code conversion for 25 years, and trust us, we understand this. When using any of our products, you can count on us to be your partner in resolving any errors you may encounter.
Below is a list of specific conversion issues for TransactSQL that you may see when you perform a conversion with SnowConvert along with a severity level for each. Some suggested solution paths based on the severity level will follow the list of codes.
Take a minute to read through the list and the troubleshooting tips to help diagnose some of the error codes you have encountered. If you have a question that cannot be answered here, please reach out! You can post in the SnowConvert forums or drop us an email at [email protected]. This is a living list, so it will grow and change as SnowConvert evolves. Updates to issue and error handling will appear on this page, and will also appear in the release notes.

Issues Code

Parsing errors, conversion exceptions caused by SnowConvert. The user should contact to Mobilize Team to fix the issue
Code
Description
Severity
​MSCEWI4001​
Transformation for USE database is disabled by default
Low
​MSCEWI4002​
Constraint in default expression not supported
Low
​MSCEWI4003​
Encrypted with not supported in Snowflake
Low
​MSCEWI4004​
Collation for values KS, WS not supported
Low
​MSCEWI4005​
Collation Albanian_bin not supported
Low
​MSCEWI4006​
Selection of variable may have runtime errors
Low
​MSCEWI4007​
Performance warning - recursion for CTE not checked. Might require recursive keyword
Low
​MSCEWI4008​
Failed to transform Unicode literal
High
​MSCEWI4009​
The default value is not supported by Snowflake.
Low
​MSCEWI4010​
Default value added.
Low
​MSCEWI4011​
Column sorting removed
Low
​MSCEWI4012​
Computed column transformed
Low
​MSCEWI4013​
The computed expression could not be upgraded
Low
​MSCEWI4014​
With partitions clause in truncate statement is not supported
Medium
​MSCEWI4015​
Database console command is not supported
Medium
​MSCEWI4016​
ODBC Scalar Function is not supported
Medium
​MSCEWI4017​
Column masking not supported
Low
​MSCEWI4018​
Object_Id replace with select statement
Low
​MSCEWI4019​
CROSS APPLY not supported
Medium
​MSCEWI4020​
Common Table Expression not supported
Low
​MSCEWI4021​
If Statement With Object ID Removed
Low
​MSCEWI4022​
PUT statement not supported on UI
Low
​MSCEWI4023​
Bulk option not supported
Low
​MSCEWI4024​
Incomplete transformation for Bulk Insert
Low
​MSCEWI4025​
ERROR_SEVERITY function transformed
Low
​MSCEWI4026​
​
Low
​MSCEWI4027​
​
Low
​MSCEWI4028​
Labels inside user-defined function were removed
Low
​MSCEWI4029​
Information for the column was not found. STRING used to match CAST operation
Medium
​MSCEWI4030​
Warning while OUTER JOIN equivalence is checked
Low
​MSCEWI4031​
Information for the expression was not found. CAST to STRING used
Medium
​MSCEWI4032​
Bulk Insert Partially Translated
High
​MSCEWI4033​
PUT not supported inside dynamic SQL
High
​MSCEWI4034​
RETURNS clause incomplete due to missing symbols
High
​MSCEWI4035​
Declaring a Cursor Variable that it is never initialized is not supported.
Medium
​MSCEWI4036​
Snowflake Scripting only supports Local Cursors.
Medium
​MSCEWI4037​
Snowflake Scripting Cursors are non-scrollable.
Medium
​MSCEWI4038​
Snowflake Scripting cursor rows are not modifiable.
Medium
​MSCEWI4039​
Multiple SET Statements for the same cursor found.
Medium
​MSCEWI4040​
Value overwritten, check function equivalence.
Medium
​MSCEWI4041​
XML data type methods are not supported in Snowflake.
Medium
​MSCEWI4042​
OPENXML clause is not supported in Snowflake.
Medium
​MSCEWI4043​
WITH XMLNAMESPACES is not supported in Snowflake.
Medium
​MSCEWI4044​
FOR XML clause is not supported in Snowflake.
Medium
​MSCEWI4045​
Labeled Statement is not supported in Snowflake Scripting.
Low
​MSCEWI4046​
System table is not supported in Snowflake.
Medium
​MSCEWI4047​
RAISERROR Error Message may differ because of the SQL Server string format.
Medium
​MSCEWI4048​
Alter Table translation planned to be delivered in the future.
Medium
​MSCEWI4049​
Multiple Line If Body translation planned to be delivered in the future.
Medium
​MSCEWI4050​
Valid Default Constraint moved to a new Alter Table Statement.
Low
​MSCEWI4051​
Some table elements may have been removed from Add clause.
Medium
​MSCEWI4052​
Some functional table elements may have been reordered to a new Alter Table statement.
Medium
​MSCEWI4053​
Multiple selects in if body were partially transformed.
High
​MSCEWI4054​
Explicit cast to DATE added to return value.
Low
​MSCEWI4055​
Default constraint was commented out and may have been added to a table definition.
Medium
​MSCEWI4056​
A MASKING POLICY was created as a substitute for MASKED WITH.
Low
​MSCEWI4057​
Masking role must be defined previously by the user.
Low
​MSCEWI4058​
One or more of the table element parts are not supported in snowflake.
Medium
​MSCEWI4059​
Column data type is not supported in Snowflake.
Medium
​MSCEWI4060​
Datetime interval not supported by Snowflake.
Medium
​MSCEWI4061​
[DEPRECATED]
​
​MSCEWI4062​
Warning Precision in Convert Date and Time Zone.
Low
​MSCEWI4063​
Time zone not supported in Snowflake.
Critical
​MSCEWI4064​
XP_LOGININFO mapped to custom UDF.
Low
​MSCEWI4065​
FORMATMESSAGE function was converted to UDF.
Low
​MSCEWI4066​
Routine option not supported in Snowflake.
Low
​MSCEWI4067​
Invalid parameters in OPENXML table-valued function.
Critical
​MSCEWI4068​
Timestamp format was not found.
Low
​MSCEWI4069​
CURRENT_DATABASE function has different behavior in certain cases.
Low

Issues Severity

In this section, you could find an explanation of the severities.

Low

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.

Medium

Errors that produce a functional or runtime difference. The user may have to invest a low amount of manual effort to complete the conversion.

High

Errors that produce a functional or runtime difference. The user may have to invest a high amount of manual effort to complete the conversion.

Critical

Parsing errors or errors that cause significant conversion exceptions in SnowConvert. If the source code is correct, a significant intervention will be required.