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
Transformation for USE database is disabled by default
Low
Constraint in default expression not supported
Low
Encrypted with not supported in Snowflake
Low
Collation for values KS, WS not supported
Low
Collation Albanian_bin not supported
Low
Selection of variable may have runtime errors
Low
Performance warning - recursion for CTE not checked. Might require recursive keyword
Low
Failed to transform Unicode literal
High
The default value is not supported by Snowflake.
Low
Default value added.
Low
Column sorting removed
Low
Computed column transformed
Low
The computed expression could not be upgraded
Low
With partitions clause in truncate statement is not supported
Medium
Database console command is not supported
Medium
ODBC Scalar Function is not supported
Medium
Column masking not supported
Low
Object_Id replace with select statement
Low
CROSS APPLY not supported
Medium
Common Table Expression not supported
Low
If Statement With Object ID Removed
Low
PUT statement not supported on UI
Low
Bulk option not supported
Low
Incomplete transformation for Bulk Insert
Low
Last modified 11d ago
Copy link
Contents
Issues Code