Issues and Troubleshooting
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 |
In this section, you could find the 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.
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 high amount of manual effort to complete the conversion.v
Parsing errors or errors that cause significant conversion exceptions in SnowConvert. If the source code is correct, a significant intervention will be required.
​
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.