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)

photo
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!


Thanks,

David