After the initial index, each subsequent indexing (scheduled or manual) can create versions for tables without a primary key. This does not affect discovery results or reports but only impacts the GEODI index size. GEODI indexing logs errors for such tables. Check the error log to see which tables are affected. By default, GEODI requires a primary key (PK) column to be present. This situation does not occur unless otherwise specified. Additionally, you can choose to add a PK to your tables (best practice). For GEODI, a PK column is one that has a unique value in each row. If your table has a PK but you are still encountering errors, then the primary key column name must be recorded in GEODI by defining a DB meta. |