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 Oracle that you may see when you perform 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 and conversion exceptions caused by SnowConvert. The user should contact to Mobilize Team to fix the issue
Code
Description
Severity
The create sequence 'start with' statement value can not be LIMIT VALUE
Medium
Foreign key mismatch
Medium
OUTER JOIN syntax changed
Low
Syntax not supported
High
The format may be needed
Low
Timestamp output format
Low
Different output
Low
Unknown format
Medium
JSON_TABLE not supported
High
XMLTABLE not supported
High
Format parameter not supported
Medium
Call specification not supported
Medium
NLS Parameter not supported
Medium
NLSSORT not supported
Medium
NLSSORT transformed
Low
Xml not supported
Medium
DBTIMEZONE removed
Low
Snowflake does not support occurrence parameter
Low
USING NCHAR_CS not supported
Low
Negative values not supported for function
Medium

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

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.

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. Mobilize.Net wants to be your partner in the conversion process, so let us know how we can help. You can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.