Issues and Troubleshooting

In this section, you will find information about Errors, Warnings, and Issues on the SnowConvert.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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. When using any of our tools, 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 drop us an email at [e-mail]. 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

Here is the list of issue codes that exist in SnowConvert for SQL Server platform. A detailed description of each issue code with its respective severity level can be seen in the following table.

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
MSCEWI4070	CURRENT_TIMESTAMP in the At Time Zone statement may have a different behavior in certain cases.	Low
MSCEWI4071	CURRENT_USER function does not support a user ID as a parameter.	Medium
MSCEWI4072	The RETURN statement will be ignored due to the previous RETURN statement	Low
MSCEWI4073	Error message could be different in Snowflake	Low

Issues Severity

In this section, you can 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.

Need more support?

As has been mentioned previously in this article, please reach out to us if you need more support. Snowflake wants to be your partner in the conversion process, so let us know how we can help. You can email us at [e-mail]. If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.