MSCEWI1039

Sematic information could not be loaded.

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

Severity

Low

Description

This warning lets the user know that SnowConvert was not able to load semantic information for a specific object. This is most likely caused because the creation of such an object depends on another one that is missing, and therefore SnowConvert could not complete the analysis of the original object.

Example Code

In the following example, it can be seen that the creation of VIEW1 depends on TABLE1 , but if this table was not found in the input code, then SnowConvert cannot complete the semantic analysis for VIEW1 and will add the following warning on the output code.

Input Code:

CREATE VIEW VIEW1 AS SELECT FUN2(COL2) FROM TABLE1;

Output Code:

/*** MSC-WARNING - MSCEWI1039 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR VIEW1. CHECK IF THE NAME IS INVALID OR DUPLICATED. ***/
CREATE OR REPLACE VIEW PUBLIC.VIEW1
AS
SELECT
PUBLIC.FUN2(COL2)
FROM PUBLIC.TABLE1;

Recommendations

• Review the input code for undefined objects and check if all the source code was included in the input folder for SnowConvert.

• If you need more support, you can email us at [email protected]