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 .

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 Greenplum 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 drop us an email at . 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.

Issues Code

Here is the list of error codes that SnowConvert might generate for Greenplum conversions. A description of the severity levels and some troubleshooting suggestions will follow this list of codes.

Code

Description

Severity

Data storage is automatically handled by Snowflake

LOW

External table translated to regular table

LOW

MSC-GP002

Non-Returning Function Translated to Stored Procure

LOW

Returning Function Translated to Stored Procure

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

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.

PreviousTranslation Reference NextMSC-GP0000

Last updated 1 year ago

Issues Code

Here is the list of error codes that SnowConvert might generate for Greenplum conversions. A description of the severity levels and some troubleshooting suggestions will follow this list of codes.

Code

Description

Severity

Data storage is automatically handled by Snowflake

LOW

External table translated to regular table

LOW

MSC-GP002

Non-Returning Function Translated to Stored Procure

LOW

Returning Function Translated to Stored Procure

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

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.