SnowConvert AI - Missing Objects Report¶

What is a “Missing Object”?¶

Missing object is the term used to refer to missing DDL definitions inside the source code that are being referenced by code units. The table below shows which elements could be missing objects in each supported language.

Where can I find it?¶

The missing objects report can be found in a folder named “reports”, in the output folder of your conversion. The name of the file itself starts with “MissingObjectReferences” so it can easily be located.

The format of the file is .CSV.

What information does it contain?¶

The missing objects report contains the following information about all the missing objects found while converting:

Known Issues¶

export myDB=exampleDatabase
bteq < example.bteq

:force:
.LABEL EX_SQE

create multiset volatile table DR as
   select * from ${myDB}.myTable;

Original Code

CREATE package Schema1.Package1
IS
  CREATE TABLE Table1 (
    col1 INTEGER
  );

  CREATE PROCEDURE Proc1
    BEGIN
      SELECT * FROM Schema1.Table1;
    END

END

Notice that in this case, Table1 is automatically created within the schema Schema1, so the reference in line 9 resolves correctly. However, if a package split process is executed prior to the migration and the resulting files are like these ones:

Modified Code after a package split process

  CREATE TABLE Table1 (
    col1 INTEGER1
  );

CREATE PROCEDURE Proc1
    BEGIN
        SELECT * FROM Schema1.Table1;
    END

The reference on line 3 of the file Schema1_Proc1.sql will be marked as a missing reference, because Table1 was not explicitly created within the schema Schema1.