Learn how to tackle the following common Data Observability issues you may face while accessing Data Integrity Suite.
Profile or observer run failures
Error message: In the following example, the column name is "id" and the table names are "test3" and "test_double"
Save observer Failed. tables[0].columns[].name has invalid value “id"|tables[0].name has invalid value “test3".
Save observer Failed. tables[0].name has invalid value "test_double".
Workaround: Review your data assets for tables or columns with single or double quotes in their names, such as ‘TableName’ or “ColumnName”. Quoted database objects can cause Profile or Observer runs to fail. Consider renaming affected objects without quotes.
Missing individual profile statistics
An individual profile does not display statistics after a successful run.
You can create an individual profile from the Profilers page. When you try viewing the statistics immediately after a successful profile run, having a large number of tables, it displays a message No Statistics available.
Workaround:- After the profile run is complete, wait for a few minutes before you view the statistics.
- On the Profiling Results page, switch between selecting different tables or columns. The statistics for all assets will be displayed within 10 to 20 seconds.