SnowConvert AI - Issues Report

什么是“问题”？

An issue is a message that provides relevant information about the transformations done by SnowConvert AI.

我在哪里可以找到它？

问题报告可以在名为 "Reports" 的文件夹中找到，该文件夹位于转换的输出文件夹中。文件本身的名称以 "Issues" 开头，因此可以轻松找到。

文件的格式为 .CSV。

它包含什么信息？

问题报告包含有关转换期间添加的所有问题的以下信息：

ColumnDescription
Session IDThe session ID of the transformation. This is a unique identifier for the transformation session.
SeverityOne of the following values: Critical, High, Medium, Low, or None. This is an indicator of how much effort it takes to manually solve the problem. The None severity does not punish the conversion rate of the code unit.
CodeA unique identifier for the issue.
NameThe name of the issue message.
DescriptionThe final message that was added to the output code. Something important to take into account is that some of the issues might have slightly different descriptions even though they have the same issue code, this happens because some of the descriptions have dynamic values.
Parent FileThe relative path of the file where the issues is generated.
LineThe text line within the parent file where the issue is generated.
ColumnThe column within the line where the issue is generated.
Code Unit DatabaseThe database name (if applicable) of the code unit that contains the issue message. It might be empty because the generated issue has no explicit database name or it is not generated inside a code unit with a name that identifies it.
Code Unit SchemaThe schema name (if applicable) of the code unit that contains the issue message. It might be empty because the generated issue has no explicit schema name or it is not generated inside a code unit with a name that identifies it.
Code Unit PackageThe package name (if applicable) of the code unit that contains the issue message. It might be empty because the generated issue has no explicit schema name or it is not generated inside a code unit with a name that identifies it. This column only applies to Oracle SQL migrations.
Code Unit NameThe name of the code unit, without database and or schema qualification. This column only applies to code units that have a name that identifies them.
Code Unit IDA string that uniquely identifies the code unit. The name of the object, without database and or schema qualification.
Code UnitThe code unit that contains the issue.
Code Unit SizeA size classification of the code unit, based on its line of code. The available measurements are XS, S, M, L, and XL.
LanguageThe programming language or SQL dialect of the source code unit.

报告示例

Given the following Oracle SQL input code, SnowConvert AI will add the SSC-FDM-OR0035 conversion issue.

CREATE OR REPLACE PROCEDURE schema1.procedure1
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE('hello world');
END;
Copy
CREATE OR REPLACE PROCEDURE schema1.procedure1 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
  BEGIN
    --** SSC-FDM-OR0035 - CHECK UDF IMPLEMENTATION FOR DBMS_OUTPUT.PUT_LINE_UDF. **
    CALL DBMS_OUTPUT.PUT_LINE_UDF('hello world');
  END;
$$;
Copy

问题报告中有关 SSC-FDM-OR0035 转换问题的行将包含以下信息：

列

值

会话 ID

不可用

严重性

低

代码

SSC-FDM-OR0035

名称

插入的自定义 UDF

描述

CUSTOM UDF 'DBMS_OUTPUT.PUT_LINE_UDF' INSERTED。

父文件

sample.sql

Line

4

列

3

代码单元数据库

不适用

代码单元架构

schema1

代码单元包

不适用

代码单元名称

procedure1

代码单元 ID

schema1.procedure1

代码单元

CREATE PROCEDURE

代码单元大小

XS
语言: 中文