Issues and Troubleshooting

Definitions

SnowConvert generates different kinds of messages in the output code indicating additional effort that needs to be made in order to achieve functional equivalence in Snowflake.

EWI (Errors, Warnings and Issues)

If SnowConvert is unable to fully convert a piece of code, then an EWI is generated. Any EWI will have a negative impact on the conversion rate for a code unit. Reasons why SnowConvert may be unable to fully convert the code include:

• A conversion rule has not been implemented yet

• Missing dependent code that is required for the conversion rule to be applied.

• There is not currently an equivalent statement available in Snowflake and/or a UDF has not been developed yet to emulate the functionality required.

Since they typically represent issues that should be addressed before deploying the output code, SnowConvert generates a !!!RESOLVE EWI!!! before each EWI in order to break the compilation.

The SnowConvert team uses internal metrics to classify EWIs into four severity levels (Low, Medium, High, and Critical) based on how much effort, on average, it takes to correct the code.

FDM (Functional Difference Messages)

In the course of converting a legacy platform code to Snowflake, it is essential to acknowledge that such platforms (Teradata, Oracle, SqlServer) and Snowflake are different, each with its unique set of features, functions, and capabilities. In many cases, full functional equivalence cannot be achieved through automation, and involvement is required to bridge those functional differences.

An FDM is generated when SnowConvert is able to output converted, syntactically correct code but that code may not provide exact functional equivalence to the original legacy code. Reasons for functional in-equivalence may be due to features that are not available within Snowflake and require re-solutions beyond what can be done with straight code conversion. Many times, business or architectural input will be required to determine further course of action needed (if any) related to FDMs; since FDMs are added to converted code that should not break the code compilation they do not punish the conversion rate.

PRF (Performance Review)

These types of messages are added to the converted code to let the user know that while the code is translated correctly, it might have performance issues in some scenarios. Some refactoring might be needed to fully take advantage of the Snowflake capabilities.

OOS (Out Of Scope)

As described in the conversion scope page and in the out of scope messages section some code units are considered out of scope for conversion reasons. SnowConvert generates these types of messages to let the user know that the whole code unit was not converted.

---

New Codes Format

We have improved the format of the EWIs to make it more user-friendly and easier to understand the type of message and the language it belongs to. The following will explain the change with examples.

General

General EWIs were previously mapped using the codes 1000. Now, General EWIs will be those that do not have any abbreviation referring to any of the languages supported by SnowConvert.

Example

New Code	Old Code
SSC-EWI-0001	MSCEWI1001

Teradata

Teradata EWIs were previously mapped using the codes 2000. Now, Teradata EWIs will be mapped with a 'TD' at the beginning of the numeric part of the code.

Example

New Code	Old Code
SSC-EWI-TD0001	MSCEWI2001

Oracle

Oracle EWIs were previously mapped using the codes 3000. Now, Oracle EWIs will be mapped with a 'OR' at the beginning of the numeric part of the code.

Example

New Code	Old Code
SSC-EWI-OR0012	MSCEWI3012

SQL Server

SQL Server EWIs were previously mapped using the codes 2000. Now, SQL Server EWIs will be mapped with a 'TS' at the beginning of the numeric part of the code.

Example

New Code	Old Code
SSC-EWI-TS0003	MSCEWI4003

Changed Category To FDM

Dialect	New code	Old code
General	SSC-FDM-0001	MSCINF0001
General	SSC-FDM-0002	MSCINF0002
General	SSC-FDM-0003	MSCINF0003
General	SSC-FDM-0004	MSC-GP0001
General	SSC-FDM-0005	MSCEWI1096
General	SSC-FDM-0006	MSCEWI1066
General	SSC-FDM-0007	MSCEWI1050
General	SSC-FDM-0008	MSCEWI1093
General	SSC-FDM-0009	MSCCP0002
General	SSC-FDM-0010	MSCEWI1044
General	SSC-FDM-0011	MSCEWI1045
General	SSC-FDM-0012	MSCEWI1097
General	SSC-FDM-0013	MSCEWI1008
General	SSC-FDM-0014	MSCEWI1035
General	SSC-FDM-0015	MSCEWI1064
General	SSC-FDM-0016	MSCEWI1076
General	SSC-FDM-0022	MSCEWI1072
General	SSC-FDM-0023	SSC-EWI-0049
General	SSC-FDM-0024	MSCEWI1058
General	SSC-FDM-0026	MSCEWI1028
General	SSC-FDM-0029	SSC-EWI-0068
Teradata	SSC-FDM-TD0001	MSCEWI2013
Teradata	SSC-FDM-TD0002	MSCEWI2014
Teradata	SSC-FDM-TD0003	MSCEWI2073
Teradata	SSC-FDM-TD0004	MSCEWI2074
Teradata	SSC-FDM-TD0005	MSCEWI2058
Teradata	SSC-FDM-TD0006	MSCEWI2045
Teradata	SSC-FDM-TD0007	MSCEWI2018
Teradata	SSC-FDM-TD0008	MSCEWI2080
Teradata	SSC-FDM-TD0009	MSCEWI2019
Teradata	SSC-FDM-TD0010	MSCEWI2042
Teradata	SSC-FDM-TD0011	MSCEWI2064
Teradata	SSC-FDM-TD0012	MSCEWI2004
Teradata	SSC-FDM-TD0013	MSCEWI2075
Teradata	SSC-FDM-TD0014	MSCEWI2023
Teradata	SSC-FDM-TD0015	MSCEWI2020
Teradata	SSC-FDM-TD0016	MSCEWI2021
Teradata	SSC-FDM-TD0018	MSCEWI2063
Teradata	SSC-FDM-TD0019	MSCEWI2084
Teradata	SSC-FDM-TD0020	MSCEWI2062
Teradata	SSC-FDM-TD0021	MSCEWI2030
Teradata	SSC-FDM-TD0022	MSCEWI2086
Teradata	SSC-FDM-TD0025	MSCEWI2054
Teradata	SSC-FDM-TD0026	SSC-EWI-TD0087
Teradata	SSC-FDM-TD0027	MSCEWI2061
Teradata	SSC-FDM-TD0028	MSCEWI2060
Teradata	SSC-FDM-TD0029	SSC-EWI-TD0055
Teradata	SSC-FDM-TD0030	SSC-EWI-TD0070
Oracle	SSC-FDM-OR0001	MSCINF0004
Oracle	SSC-FDM-OR0002	MSCEWI3068
Oracle	SSC-FDM-OR0003	MSCEWI3038
Oracle	SSC-FDM-OR0004	MSCEWI3022
Oracle	SSC-FDM-OR0005	MSCEWI3025
Oracle	SSC-FDM-OR0006	MSCEWI3041
Oracle	SSC-FDM-OR0007	MSCEWI3056
Oracle	SSC-FDM-OR0008	MSCEWI3071
Oracle	SSC-FDM-OR0009	MSCEWI3086
Oracle	SSC-FDM-OR0010	MSCEWI3093
Oracle	SSC-FDM-OR0011	MSCEWI3066
Oracle	SSC-FDM-OR0012	MSCEWI3131
Oracle	SSC-FDM-OR0013	MSCEWI3039
Oracle	SSC-FDM-OR0014	MSCEWI3002
Oracle	SSC-FDM-OR0015	MSCEWI3091
Oracle	SSC-FDM-OR0016	MSCEWI3132
Oracle	SSC-FDM-OR0017	MSCEWI3017
Oracle	SSC-FDM-OR0018	MSCEWI3134
Oracle	SSC-FDM-OR0019	MSCEWI3086
Oracle	SSC-FDM-OR0020	MSCEWI3051
Oracle	SSC-FDM-OR0021	MSCEWI3102
Oracle	SSC-FDM-OR0022	MSCEWI3100
Oracle	SSC-FDM-OR0023	MSCEWI3099
Oracle	SSC-FDM-OR0024	MSCEWI3114
Oracle	SSC-FDM-OR0025	MSCEWI3021
Oracle	SSC-FDM-OR0026	MSCEWI1065
Oracle	SSC-FDM-OR0025	MSCEWI3098
Oracle	SSC-FDM-OR0028	MSCEWI3031
Oracle	SSC-FDM-OR0029	MSCEWI3059
Oracle	SSC-FDM-OR0030	MSCEWI3094
Oracle	SSC-FDM-OR0031	MSCEWI3113
Oracle	SSC-FDM-OR0037	MSCEWI3004
Oracle	SSC-FDM-OR0038	SSC-EWI-OR0128
Oracle	SSC-FDM-OR0040	SSC-EWI-OR0062
Oracle	SSC-FDM-OR0043	SSC-EWI-OR0005
Oracle	SSC-FDM-OR0044	SSC-EWI-OR0089
Oracle	SSC-EWI-OR0039	SSC-FDM-OR0013
Oracle	SSC-FDM-OR0045	SSC-EWI-OR0006
SQL Server	SSC-FDM-TS0001	MSCEWI4005
SQL Server	SSC-FDM-TS0002	MSCEWI4004
SQL Server	SSC-FDM-TS0003	MSCEWI4064
SQL Server	SSC-FDM-TS0004	MSCEWI4022
SQL Server	SSC-FDM-TS0005	MSCEWI4074
SQL Server	SSC-FDM-TS0006	MSCEWI4066
SQL Server	SSC-FDM-TS0007	MSCEWI4066
SQL Server	SSC-FDM-TS0008	MSCEWI4065
SQL Server	SSC-FDM-TS0009	MSCEWI4003
SQL Server	SSC-FDM-TS0010	MSCEWI4069
SQL Server	SSC-FDM-TS0011	MSCEWI1088
SQL Server	SSC-FDM-TS0017	SSC-EWI-TS0071
SQL Server	SSC-FDM-TS0020	SSC-EWI-TS0055

Dialect	New code	Old code
General	SSC-FDM-0001	MSCINF0001
General	SSC-FDM-0002	MSCINF0002
General	SSC-FDM-0003	MSCINF0003
General	SSC-FDM-0004	MSC-GP0001
General	SSC-FDM-0005	MSCEWI1096
General	SSC-FDM-0006	MSCEWI1066
General	SSC-FDM-0007	MSCEWI1050
General	SSC-FDM-OR0039	MSCEWI1057
General	SSC-FDM-0008	MSCEWI1093
General	SSC-FDM-0009	MSCCP0002
General	SSC-FDM-0010	MSCEWI1044
General	SSC-FDM-0011	MSCEWI1045
General	SSC-FDM-0012	MSCEWI1097
General	SSC-FDM-0013	MSCEWI1008
General	SSC-FDM-0014	MSCEWI1035
General	SSC-FDM-0015	MSCEWI1064
General	SSC-FDM-0016	MSCEWI1076
General	SSC-FDM-0022	MSCEWI1072
General	SSC-FDM-0024	MSCEWI1058
General	SSC-FDM-0026	MSCEWI1028
Teradata	SSC-FDM-TD0001	MSCEWI2013
Teradata	SSC-FDM-TD0002	MSCEWI2014
Teradata	SSC-FDM-TD0003	MSCEWI2073
Teradata	SSC-FDM-TD0004	MSCEWI2074
Teradata	SSC-FDM-TD0005	MSCEWI2058
Teradata	SSC-FDM-TD0006	MSCEWI2045
Teradata	SSC-FDM-TD0007	MSCEWI2018
Teradata	SSC-FDM-TD0008	MSCEWI2080
Teradata	SSC-FDM-TD0009	MSCEWI2019
Teradata	SSC-FDM-TD0010	MSCEWI2042
Teradata	SSC-FDM-TD0011	MSCEWI2064
Teradata	SSC-FDM-TD0012	MSCEWI2004
Teradata	SSC-FDM-TD0013	MSCEWI2075
Teradata	SSC-FDM-TD0014	MSCEWI2023
Teradata	SSC-FDM-TD0015	MSCEWI2020
Teradata	SSC-FDM-TD0016	MSCEWI2021
Teradata	SSC-FDM-TD0018	MSCEWI2063
Teradata	SSC-FDM-TD0019	MSCEWI2084
Teradata	SSC-FDM-TD0020	MSCEWI2062
Teradata	SSC-FDM-TD0021	MSCEWI2030
Teradata	SSC-FDM-TD0022	MSCEWI2086
Teradata	SSC-FDM-TD0025	MSCEWI2054
Teradata	SSC-FDM-TD0027	MSCEWI2061
Teradata	SSC-FDM-TD0028	MSCEWI2060
Oracle	SSC-FDM-OR0001	MSCINF0004
Oracle	SSC-FDM-OR0002	MSCEWI3068
Oracle	SSC-FDM-OR0003	MSCEWI3038
Oracle	SSC-FDM-OR0004	MSCEWI3022
Oracle	SSC-FDM-OR0005	MSCEWI3025
Oracle	SSC-FDM-OR0006	MSCEWI3041
Oracle	SSC-FDM-OR0007	MSCEWI3056
Oracle	SSC-FDM-OR0008	MSCEWI3071
Oracle	SSC-FDM-OR0009	MSCEWI3086
Oracle	SSC-FDM-OR0010	MSCEWI3093
Oracle	SSC-FDM-OR0011	MSCEWI3066
Oracle	SSC-FDM-OR0012	MSCEWI3131
Oracle	SSC-FDM-OR0013	MSCEWI3039
Oracle	SSC-FDM-OR0014	MSCEWI3002
Oracle	SSC-FDM-OR0015	MSCEWI3091
Oracle	SSC-FDM-OR0016	MSCEWI3132
Oracle	SSC-FDM-OR0017	MSCEWI3017
Oracle	SSC-FDM-OR0018	MSCEWI3134
Oracle	SSC-FDM-OR0019	MSCEWI3086
Oracle	SSC-FDM-OR0020	MSCEWI3051
Oracle	SSC-FDM-OR0021	MSCEWI3102
Oracle	SSC-FDM-OR0022	MSCEWI3100
Oracle	SSC-FDM-OR0023	MSCEWI3099
Oracle	SSC-FDM-OR0024	MSCEWI3114
Oracle	SSC-FDM-OR0025	MSCEWI3021
Oracle	SSC-FDM-OR0026	MSCEWI1065
Oracle	SSC-FDM-OR0025	MSCEWI3098
Oracle	SSC-FDM-OR0027	MSCEWI3029
Oracle	SSC-FDM-OR0028	MSCEWI3031
Oracle	SSC-FDM-OR0029	MSCEWI3059
Oracle	SSC-FDM-OR0030	MSCEWI3094
Oracle	SSC-FDM-OR0031	MSCEWI3113
Oracle	SSC-FDM-OR0038	SSC-EWI-OR0128
Oracle	SSC-FDM-OR0041	MSCEWI307
Oracle	SSC-FDM-OR0040	SSC-EWI-OR0062
SQL Server	SSC-FDM-TS0001	MSCEWI4005
SQL Server	SSC-FDM-TS0002	MSCEWI4004
SQL Server	SSC-FDM-TS0003	MSCEWI4064
SQL Server	SSC-FDM-TS0004	MSCEWI4022
SQL Server	SSC-FDM-TS0005	MSCEWI4074
SQL Server	SSC-FDM-TS0006	MSCEWI4066
SQL Server	SSC-FDM-TS0007	MSCEWI4066
SQL Server	SSC-FDM-TS0008	MSCEWI4065
SQL Server	SSC-FDM-TS0009	MSCEWI4003
SQL Server	SSC-FDM-TS0010	MSCEWI4069
SQL Server	SSC-FDM-TS0011	MSCEWI1088
SQL Server	SSC-FDM-TS0017	SSC-EWI-TS0071
SQL Server	SSC-FDM-TS0020	SSC-EWI-TS0055

Changed Category To PRF

Dialect	New code	Old code
General	SSC-PRF-0001	MSCCP0005
General	SSC-PRF-0002	MSCCP0007
General	SSC-PRF-0003	MSCCP0006
General	SSC-PRF-0004	MSCCP0003
General	SSC-PRF-0005	MSCCP0010
General	SSC-PRF-0006	MSCCP0011
Teradata	SSC-PRF-TD0001	MSCEWI2008
SQL Server	SSC-PRF-TS0001	MSCEWI4007

Deprecated EWIs

Dialect	Code
General	MSCEWI1008
General	MSCEWI1016
General	MSCEWI1017
General	MSCEWI1019
General	MSCEWI1029
General	MSCEWI1055
General	MSCEWI1037
General	MSCEWI1042
General	MSCEWI1043
General	MSCEWI1048
General	MSCEWI1059
General	MSCEWI1069
General	MSCEWI1074
General	MSCEWI1079
General	MSCEWI1081
General	MSCEWI1082
General	MSCEWI1083
General	MSCEWI1085
General	MSCEWI1087
General	MSCEWI1089
General	MSCEWI1090
General	MSCEWI1091
General	MSCEWI1097
General	MSCEWI1098
General	MSCEWI1099
General	MSCEWI1108
General	MSCINF0001
General	MSCINF0002
General	MSCINF0003
Teradata	MSCEWI2002
Teradata	MSCEWI2006
Teradata	MSCEWI2007
Teradata	MSCEWI2016
Teradata	MSCEWI2018
Teradata	MSCEWI2026
Teradata	MSCEWI2028
Teradata	MSCEWI2032
Teradata	MSCEWI2033
Teradata	MSCEWI2038
Teradata	MSCEWI2044
Teradata	MSCEWI2047
Teradata	MSCEWI2050
Teradata	MSCEWI2056
Teradata	MSCEWI2065
Teradata	MSCEWI2078
Teradata	MSCEWI2081
Teradata	MSCEWI2085
Teradata	MSCEWI2088
Teradata	MSCEWI2089
Teradata	MSCEWI2090
Oracle	MSCEWI3003
Oracle	MSCEWI3007
Oracle	MSCEWI3015
Oracle	MSCEWI3019
Oracle	MSCEWI3024
Oracle	MSCEWI3027
Oracle	MSCEWI3028
Oracle	MSCEWI3037
Oracle	MSCEWI3043
Oracle	MSCEWI3044
Oracle	MSCEWI3054
Oracle	MSCEWI3058
Oracle	MSCEWI3061
Oracle	MSCEWI3063
Oracle	MSCEWI3064
Oracle	MSCEWI3065
Oracle	MSCEWI3077
Oracle	MSCEWI3083
Oracle	MSCEWI3084
Oracle	MSCEWI3085
Oracle	MSCEWI3088
Oracle	MSCEWI3096
Oracle	MSCEWI3117
Oracle	MSCEWI3119
Oracle	MSCEWI3122
Oracle	MSCEWI3125
Oracle	SSC-EWI-OR0130
SQL Server	MSCEWI4002
SQL Server	MSCEWI4006
SQL Server	MSCEWI4008
SQL Server	MSCEWI4011
SQL Server	MSCEWI4012
SQL Server	MSCEWI4014
SQL Server	MSCEWI4018
SQL Server	MSCEWI4019
SQL Server	MSCEWI4020
SQL Server	MSCEWI4026
SQL Server	MSCEWI4028
SQL Server	MSCEWI4030
SQL Server	MSCEWI4040
SQL Server	MSCEWI4042
SQL Server	MSCEWI4050
SQL Server	MSCEWI4052
SQL Server	MSCEWI4054
SQL Server	MSCEWI4056
SQL Server	MSCEWI4068
SQL Server	SSC-EWI-TS0048

Dialect	New code	Old code
General	SSC-FDM-0001	MSCINF0001
General	SSC-FDM-0002	MSCINF0002
General	SSC-FDM-0003	MSCINF0003
General	SSC-FDM-0004	MSC-GP0001
General	SSC-FDM-0005	MSCEWI1096
General	SSC-FDM-0006	MSCEWI1066
General	SSC-FDM-0007	MSCEWI1050
General	SSC-FDM-OR0039	MSCEWI1057
General	SSC-FDM-0008	MSCEWI1093
General	SSC-FDM-0009	MSCCP0002
General	SSC-FDM-0010	MSCEWI1044
General	SSC-FDM-0011	MSCEWI1045
General	SSC-FDM-0012	MSCEWI1097
General	SSC-FDM-0013	MSCEWI1008
General	SSC-FDM-0014	MSCEWI1035
General	SSC-FDM-0015	MSCEWI1064
General	SSC-FDM-0016	MSCEWI1076
General	SSC-FDM-0022	MSCEWI1072
General	SSC-FDM-0023	SSC-EWI-0049
General	SSC-FDM-0024	MSCEWI1058
General	SSC-FDM-0026	MSCEWI1028
General	SSC-FDM-0029	SSC-EWI-0068
Teradata	SSC-FDM-TD0001	MSCEWI2013
Teradata	SSC-FDM-TD0002	MSCEWI2014
Teradata	SSC-FDM-TD0003	MSCEWI2073
Teradata	SSC-FDM-TD0004	MSCEWI2074
Teradata	SSC-FDM-TD0005	MSCEWI2058
Teradata	SSC-FDM-TD0006	MSCEWI2045
Teradata	SSC-FDM-TD0007	MSCEWI2018
Teradata	SSC-FDM-TD0008	MSCEWI2080
Teradata	SSC-FDM-TD0009	MSCEWI2019
Teradata	SSC-FDM-TD0010	MSCEWI2042
Teradata	SSC-FDM-TD0011	MSCEWI2064
Teradata	SSC-FDM-TD0013	MSCEWI2075
Teradata	SSC-FDM-TD0014	MSCEWI2023
Teradata	SSC-FDM-TD0016	MSCEWI2021
Teradata	SSC-FDM-TD0019	MSCEWI2084
Teradata	SSC-FDM-TD0020	MSCEWI2062
Teradata	SSC-FDM-TD0021	MSCEWI2030
Teradata	SSC-FDM-TD0022	MSCEWI2086
Teradata	SSC-FDM-TD0025	MSCEWI2054
Oracle	SSC-FDM-OR0001	MSCINF0004
Oracle	SSC-FDM-OR0004	MSCEWI3022
Oracle	SSC-FDM-OR0005	MSCEWI3025
Oracle	SSC-FDM-OR0006	MSCEWI3041
Oracle	SSC-FDM-OR0007	MSCEWI3056
Oracle	SSC-FDM-OR0009	MSCEWI3086
Oracle	SSC-FDM-OR0010	MSCEWI3093
Oracle	SSC-FDM-OR0011	MSCEWI3066
Oracle	SSC-FDM-OR0012	MSCEWI3131
Oracle	SSC-FDM-OR0013	MSCEWI3039
Oracle	SSC-FDM-OR0014	MSCEWI3002
Oracle	SSC-FDM-OR0015	MSCEWI3091
Oracle	SSC-FDM-OR0016	MSCEWI3132
Oracle	SSC-FDM-OR0017	MSCEWI3017
Oracle	SSC-FDM-OR0018	MSCEWI3134
Oracle	SSC-FDM-OR0019	MSCEWI3086
Oracle	SSC-FDM-OR0020	MSCEWI3051
Oracle	SSC-FDM-OR0021	MSCEWI3102
Oracle	SSC-FDM-OR0022	MSCEWI3100
Oracle	SSC-FDM-OR0023	MSCEWI3099
Oracle	SSC-FDM-OR0024	MSCEWI3114
Oracle	SSC-FDM-OR0025	MSCEWI3021
Oracle	SSC-FDM-OR0026	MSCEWI1065
Oracle	SSC-FDM-OR0025	MSCEWI3098
Oracle	SSC-FDM-OR0027	MSCEWI3029
Oracle	SSC-FDM-OR0029	MSCEWI3059
Oracle	SSC-FDM-OR0030	MSCEWI3094
Oracle	SSC-FDM-OR0031	MSCEWI3113
Oracle	SSC-FDM-OR0037	MSCEWI3004
Oracle	SSC-FDM-OR0041	MSCEWI307
Oracle	SSC-FDM-OR0040	SSC-EWI-OR0062
SQL Server	SSC-FDM-TS0001	MSCEWI4005
SQL Server	SSC-FDM-TS0002	MSCEWI4004
SQL Server	SSC-FDM-TS0003	MSCEWI4064
SQL Server	SSC-FDM-TS0004	MSCEWI4022
SQL Server	SSC-FDM-TS0005	MSCEWI4074
SQL Server	SSC-FDM-TS0006	MSCEWI4066
SQL Server	SSC-FDM-TS0007	MSCEWI4066
SQL Server	SSC-FDM-TS0008	MSCEWI4065
SQL Server	SSC-FDM-TS0009	MSCEWI4003
SQL Server	SSC-FDM-TS0010	MSCEWI4069
SQL Server	SSC-FDM-TS0011	MSCEWI1088
SQL Server	SSC-FDM-TS0017	SSC-EWI-TS0071
SQL Server	SSC-FDM-TS0019	SSC-EWI-TS0047
SQL Server	SSC-FDM-TS0020	SSC-EWI-TS0055
SQL Server	SSC-FDM-TS0021	SSC-EWI-TS0056
SQL Server	SSC-FDM-TS0022	SSC-EWI-TS0057
SQL Server	SSC-FDM-TS0023	SSC-EWI-TS0073