Issues and Troubleshooting

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 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
​MSCEWI3001​
The create sequence 'start with' statement value can not be LIMIT VALUE
Medium
​MSCEWI3002​
Foreign key mismatch
Medium
​MSCEWI3003​
OUTER JOIN syntax changed
Low
​MSCEWI3004​
Syntax not supported
High
​MSCEWI3005​
The format may be needed
Low
​MSCEWI3006​
Timestamp output format
Low
​MSCEWI3007​
Different output
Low
​MSCEWI3008​
Unknown format
Medium
​MSCEWI3009​
JSON_TABLE not supported
High
​MSCEWI3010​
XMLTABLE not supported
High
​MSCEWI3011​
Format parameter not supported
Medium
​MSCEWI3012​
Call specification not supported
Medium
​MSCEWI3013​
NLS Parameter not supported
Medium
​MSCEWI3014​
NLSSORT not supported
Medium
​MSCEWI3015​
NLSSORT transformed
Low
​MSCEWI3016​
Xml not supported
Medium
​MSCEWI3017​
DBTIMEZONE removed
Low
​MSCEWI3018​
Snowflake does not support occurrence parameter
Low
​MSCEWI3019​
USING NCHAR_CS not supported
Low
​MSCEWI3020​
Negative values not supported for function
Medium
​MSCEWI3021​
SQL implicit cursor values may differ
Low
​MSCEWI3022​
Siblings not supported
Low
​MSCEWI3023​
RANK AGGREGATE function not supported
High
​MSCEWI3024​
Table properties not required
Low
​MSCEWI3025​
Synonyms not supported
Low
​MSCEWI3026​
Rowid not supported
Medium
​MSCEWI3027​
Rownum not supported
Medium
​MSCEWI3028​
Multiset operator not supported
Medium
​MSCEWI3029​
The default value on conversion error, not supported
Medium
​MSCEWI3030​
Keep statement used to indicate that only the first or last values of the aggregate function will be returned is not supported
Medium
​MSCEWI3031​
Not suitable function found to replace the input parameter for SYSCONTEXT
Medium
​MSCEWI3032​
The specified parameter for the function is not supported
Medium
​MSCEWI3033​
PLDeclaration in WITH statement not supported
Medium
​MSCEWI3034​
Package Procedure/Function declaration heading not necessary
Low
​MSCEWI3035​
The table collection expression is not supported
High
​MSCEWI3036​
Arithmetic types not supported
Medium
​MSCEWI3037​
Using index constraint state removed
Low
​MSCEWI3038​
Search clause removed
Low
​MSCEWI3039​
Cycle clause removed
Low
​MSCEWI3040​
Statements and keywords removed from the column definition
Low
​MSCEWI3041​
Enable or disable constraint state removed
Low
​MSCEWI3042​
Model clause removed
Low
​MSCEWI3043​
Create table statements removed
Low
​MSCEWI3044​
Sequence option removed
Low
​MSCEWI3045​
Missing dependencies objects
Low
​MSCEWI3046​
Alter Table syntax is not applicable in Snowflake
Medium
​MSCEWI3047​
TO_NCHAR transformed to TO_VARCHAR
Low
​MSCEWI3048​
Function language not supported.
High
​MSCEWI3049​
Package member not supported
Medium
​MSCEWI3050​
Call to User Defined function not supported inside queries
High
​MSCEWI3051​
PRAGMA EXCEPTION_INIT Not Supported
Low
​MSCEWI3052​
Exception declaration is handled by the raise function
Low
​MSCEWI3053​
User defined function was transformed to Snowflake procedure
Low
​MSCEWI3054​
Package constant declaration
Low
​MSCEWI3055​
Wrapped element not supported
Medium
​MSCEWI3056​
Object versioning is not supported
Low
​MSCEWI3057​
Nested Procedure or Function not supported
Medium
​MSCEWI3058​
Date format session parameter
Low
​MSCEWI3059​
Alter session configuration is not supported
Medium
​MSCEWI3060​
Default value for SYSDATE is CURRENT_TIMESTAMP
Low
​MSCEWI3061​
Column was transformed from DATE to TIMESTAMP
Low
​MSCEWI3062​
NLS_NUMERIC_CHARACTERS session parameter not supported
Medium
​MSCEWI3063​
Query using WITH TIES clause is missing ORDER BY
Low
​MSCEWI3064​
Snowflake default calendar is Gregorian. It is not necessary to specify as a parameter
Low
​MSCEWI3065​
NOCYCLE property is not supported
Medium
​MSCEWI3066​
Add to stack of errors is not supported, boolean argument was removed
Low
​MSCEWI3067​
Multiple Constraint Definition in a single statement is not supported in Snowflake
Medium
​MSCEWI3068​
The create sequence 'start with' statement value exceeds the max value allowed by Snowflake.
Medium
​MSCEWI3069​
CURRVAL property is not supported in Snowflake
Medium
​MSCEWI3070​
Binary Operation Not Supported
Medium
​MSCEWI3071​
Set Quantifier Not Supported
Low
​MSCEWI3072​
Procedural Member not supported
Medium
​MSCEWI3073​
Create Database Link Not Supported
High
​MSCEWI3074​
Create Index Not Supported
High
​MSCEWI3075​
Labels in statements not supported
Medium
​MSCEWI3076​
Built In Package Not Supported
Medium
​MSCEWI3077​
Semantic information missing for ROWTYPE attribute
Low
​MSCEWI3078​
Unable to parse dynamic SQL statement inside Execute Immediate
Medium
​MSCEWI3079​
INSTR function converted to REGEXP_INSTR
Low
​MSCEWI3080​
Create Type Not Supported
High
​MSCEWI3081​
Snowflake Non-Ansi Outer Join has some functional differences compared to Oracle
Low
​MSCEWI3082​
Cannot Convert Nested Type Attribute Expression
Medium
​MSCEWI3083​
Unsupported format used for Trunc function
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
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.v
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.

For Oracle - Previous

SQL Translation Reference

General Issues

Last modified 19h ago

Copy link

Contents