Database Validation Tool

Tarun Pandey shared this idea 2 months ago
Idea Logged

We're run into multiple issues in the past that we were unable to resolve as we do not have a deep understanding of the Yellowfin DB structure. Rather than try to understand the DB, can we have a tool that can validate the Yellowfin DB health? This would check for;

-Orphaned records (records where parent records are deleted/changed)

-NULL values where there shouldn't be. E.g. a NULL value in one particular row could cause UI export issues.

-Key Generator Tables and ID's. We had a case where a DB was migrated, though the key generator tables were not re-created so the new DB was overriding existing data.

-Disconnected Fields on views. While we have queries to identify this, this should be included in the overall DB health check.

-Table indexes. We know indexes get created as part of the install, though would be good to check that all indexes are present based on latest release.

Comments (1)


Hi Tarun,

I've logged this idea on your behalf to help with fixing broken DB's and records.

While we can all agree this is a good idea and something we want to work forwards, I'm also very aware this is a large task so no ETA's can be provided at this point in time.

I'll keep you posted on any updates, though don't expect any, anytime soon!