SnowConvert: Problembericht

Was ist ein „Problem“?

Ein Problem ist eine Meldung, die relevante Informationen über die von SnowConvert durchgeführten Transformationen enthält.

Wo kann ich es finden?

Der Problembericht befindet sich in einem Ordner namens Reports im Ausgabeordner Ihrer Konvertierung. Der Name der Datei selbst beginnt mit Issues, sodass sie leicht gefunden werden kann.

Das Format der Datei ist .CSV.

Welche Informationen sind darin enthalten?

Der Problembericht enthält die folgenden Informationen über alle Problemmeldungen, die während der Konvertierung hinzugefügt wurden:

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.

Berichtsbeispiel

Mit dem folgenden Oracle SQL-Eingabecode fügt SnowConvert die Konvertierungsproblemmeldung SSC-FDM-OR0035 hinzu.

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

Die Zeile im Problembericht für das Konvertierungsproblem SSC-FDM-OR0035 enthält die folgenden Informationen:

Spalte

Wert

Sitzung ID

Not available

Schweregrad

Niedrig

Code

SSC-FDM-OR0035

Name

Custom UDF inserted

Beschreibung

CUSTOM UDF ‚DBMS_OUTPUT.PUT_LINE_UDF‘ INSERTED.

Parent File

sample.sql

Line

4

Spalte

3

Code Unit Database

N/A

Code Unit Schema

schema1

Code Unit Package

N/A

Code Unit Name

procedure1

Code Unit Id

schema1.procedure1

Code Unit

CREATE PROCEDURE

Code Unit Size

XS
Sprache: Deutsch