Issues and Troubleshooting

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

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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. When using any of our tools, 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 drop us an email at [e-mail]. 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

Here is the list of issue codes that exist in the SnowConvert for the Oracle platform. A detailed description of each issue code with its respective severity level can be seen in the following table.

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	Low
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	Low
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
MSCEWI3084	Snowflake does not have a PURGE clause inside the DROP TABLE statement	Low
MSCEWI3085	CASCADE CONSTRAINTS modified inside DROP TABLE statement to CASCADE	Low
MSCEWI3086	Window frame output may not be equivalent	Low
MSCEWI3087	Ordering of the Outer Joins failed	Low
MSCEWI3088	Condition with unknown table name for outer join with (+)	Low
MSCEWI3089	REGEXP_LIKE_UDF match parameter may not behave correctly	Low
MSCEWI3090	Non-Ansi Outer Join has an invalid Between predicate	Low
MSCEWI3091	LENGTHB transformed to OCTET_LENGTH results may vary due to memory management of DBMS	Low
MSCEWI3092	Number datatype negative scale was removed from output	Low
MSCEWI3093	Number datatype smaller precision was increased to match scale	Low
MSCEWI3094	ROWID pseudocolumn is not supported in Snowflake	Medium
MSCEWI3095	Operation Between Interval and Date Type not Supported	Medium
MSCEWI3096	Interval Literal Not Supported In Current Scenario	High
MSCEWI3097	Procedure Properties are Not Supported in Snowflake Procedures	Low
MSCEWI3098	The Not Null constraint is not supported in variable declarations inside procedures in Snowflake	Low
MSCEWI3099	Exception declaration code exceeds the Snowflake Scripting exception number limits	Low
MSCEWI3100	For Loop with multiple conditions is currently not supported by Snowflake Scripting. Only first condition is used	Low
MSCEWI3101	Specific For Lopp clause is currently not supported by Snowflake Scripting	Low
MSCEWI3102	For Loop with float number as bound may not behave correctly in Snowflake Scripting	Low
MSCEWI3103	For Loop format is currently not supported by Snowflake Scripting	High
MSCEWI3104	Unusable collection variable	High
MSCEWI3105	Additional work is needed for BFILE column usage. BUILD_STAGE_URL function is a recommended workaround	Low
MSCEWI3106	Parametrized Cursor is not supported by Snowflake Scripting	High
MSCEWI3107	Label declaration not supported	Low
MSCEWI3108	The following assignment statement is not supported by Snowflake Scripting	Medium
MSCEWI3109	Expressions as arguments of using clause are not supported by Snowflake Scripting	Medium
MSCEWI3110	For update clause is not supported by Snowflake Scripting	Low
MSCEWI3111	Transaction control statement requires additional intervention	Medium
MSCEWI3112	DBMS_RANDOM.VALUE Built-In Package precision is lower in Snowflake	Low
MSCEWI3113	The error logging clause in DML statements is not supported by Snowflake	Medium
MSCEWI3114	Snowflake merge statement may have some functional differences compared to Oracle	Low
MSCEWI3115	Check UDF implementation DBMS_OUTPUT.PUTLINE	Low
MSCEWI3116	Operations between Intervals are not supported	Medium
MSCEWI3117	Day format works differently between Oracle and Snowflake.	Low
MSCEWI3118	Built-In views are not supported	Medium
MSCEWI3119	Supplemental logging clause commented out	Low
MSCEWI3120	Unnecessary built-in packages parameters	Low
MSCEWI3122	Package Variable Assignment transformation	Low
MSCEWI3123	Database Link connections not supported	Medium
MSCEWI3124	Default Value Not Found For Parameter	Medium
MSCEWI3125	Built-in package custom type changed to VARIANT	Low
MSCEWI3126	Unusable object because its built-in custom type is not supported	Medium
MSCEWI3127	Column alias removed	Low
MSCEWI3128	Boolean cursor attribute is not supported	Medium
MSCEWI3129	TYPE attribute could not be resolved	Low
MSCEWI3130	For Loop and Fetch into variable cannot be used on the same cursor	Medium
MSCEWI3131	COMMIT and ROLLBACK statements require the appropiate setup to work as intended	Low
MSCEWI3132	COMMIT and ROLLBACK option were removed because Snowflake does not require them	Low
MSCEWI3133	Cursor variable has already been assigned	Medium
MSCEWI3135	Data Retention Period May Produce No Results	Low

Issues Severity

In this section, you can 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

Errors that produce a functional or runtime difference. The user may have to invest a low amount of manual effort to complete the conversion.

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