Issues and Troubleshooting

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

Issues Code

Parsing errors, conversion exceptions caused by SnowConvert. The user should contact to Mobilize Team to fix the issue

Code

Description

Severity

MSCEWI3002

Foreign key mismatch

Medium

MSCEWI3003

OUTER JOIN syntax changed

Low

MSCEWI3004

Syntax not supported

Low

MSCEWI3005

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

Expression at time zone changed

Low

MSCEWI3019

USING NCHAR_CS not supported

Low

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

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

MSCEWI3047

TO_NCHAR transformed to TO_VARCHAR

Low

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 raise function

Low

MSCEWI3053

User defined function was transformed to Snowflake procedure

Medium

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

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

Issues Severity

In this section, you could find the 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.