CSA Database logical consistency checker

CSA Database logical consistency checker

 
Brief Description
Possibility to verify the internal logic of the CSA Database is correct.
over the runtime of CSA (we do run a production instance with DB created with CSA 3.2) we observed several occassions of DB logic corruptions. due to several issues.
e.g. Cross cluster logic issues (e.g. Organisations dublicated in DB). Programming issues. orphraned objects due to incomplete deletion process in old CSA versions. Uprade procedures not correctly upgrading legacy Data.
 
Benefits / Value
We observe several Issues due to DB inconsistencies resulting in Downtimes of CSA and unnecessary Incidents/cases with Microfocus. verifying DB consistency would allow proactive checking and reduce Downtime and Amount of cases
Design details
An extra support tool that verifys that in the DB logically is everything consistent as far as it is possible to be checked. e.g. checking for dublicates in tables where no dublicates should be. check for orphraed objects that are not linked any more. etc. as a result the Tool should show a status and a potential list of issues identified.
 
Tags (2)
1 Comment
Micro Focus Contributor
Micro Focus Contributor
Status changed to: Waiting for Votes
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.