Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleNo result from the DB sources
Info
  1. Connection The connection string may not be correct. You should test it before saving the project. You , which you can do it now.

  2. Check the permissions

  3. Index error logs should be checked. You can examine the errors received in the scan with the developer report via GEODI.

  4. DBmetas may not be correct.

  5. Jsettings files should be syntax validated, you can use https://jsonformatter.curiousconcept.com/ site for this validation.

  6. Check the correctness of the column, table, and GEODI project names and their names on the Table/Column/Project database.

Expand
titleI have no DB connection but results shows many rowstables(*.geodi_table) and rows(*.geodi_rows)
Info

GEODI , by default, crawls file-based databases like SQlite or Access. These files are processed like office or PDF files. You may set to ignore themSQLite or Access by name in default settings. You may install a module from DECE-STORE to override this setting and discover rows.

Expand
titleEmbedded or linked files does not shown
Info
  1. You should define DB meta to do that. This page explains ho to create DB metas.

Expand
titleIndexing is slow
Info
  1. By default, GEODI crawls all table tables and all rows. You may use sampled discovery , or narrow the target.

  2. Your DB might also be serving another application.

  3. GEODI indexing speed options might be at low, increase it.

  4. The GEODI Server might be running on a low-capacity machine , with insufficient memory or a slow disk. Please check the system requirements page.

Expand
titleDB row version are increasing
Info

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.

Expand
titlePermissions are not affective
Info

GEODI, by By default, GEODI reads all rows with the same persmissionspermissions. To set a row-based permission, please use DB meta.

FAQ

Expand
titleCan i discover permissons on rows or files?

Yes. Using DBmeta, you can read rows or embedded file permissions from a database.

Expand
titleCan I index embedded files in the tables?
Info

Yes. with With a few simple DBmeta definitions, you may index those files. In this case, GEODI will show the row and file separately. You will be able to query the file using DB attributes.

Expand
titleHow can I open CRM application through GEODI search?
Info

It is possible. You index the CRM database and with a simple DB meta and set a link that opens the original CRM apps. The CRM app should have a simple URL(query string) that can be build built using the attributes.

...

DB Meta Definitions

...