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.
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 | |
ERROR_SEVERITY function transformed | Low | |
| Low | |
| Low | |
Labels inside user-defined function were removed | Low | |
Information for the column was not found. STRING used to match CAST operation | Medium | |
Warning while OUTER JOIN equivalence is checked | Low | |
Information for the expression was not found. CAST to STRING used | Medium | |
Bulk Insert Partially Translated | High | |
PUT not supported inside dynamic SQL | High | |
RETURNS clause incomplete due to missing symbols | High | |
Declaring a Cursor Variable that it is never initialized is not supported. | Medium | |
Snowflake Scripting only supports Local Cursors. | Medium | |
Snowflake Scripting Cursors are non-scrollable. | Medium | |
Snowflake Scripting cursor rows are not modifiable. | Medium | |
Multiple SET Statements for the same cursor found. | Medium |
In this section, you could find an explanation of the severities.
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.
Errors that produce a functional or runtime difference. The user may have to invest a low amount of manual effort to complete the conversion.
Errors that produce a functional or runtime difference. The user may have to invest a high amount of manual effort to complete the conversion.
Parsing errors or errors that cause significant conversion exceptions in SnowConvert. If the source code is correct, a significant intervention will be required.
Last modified 10d ago