Introduction

The Database Checker is used to verify that the CapaInstaller database layout is correct according to the released version. The Database Checker will download an XML file from the web, which is the released version, and compare it with your currently running CapaInstaller database. Your running CapaInstaller database layout is referred to as the Currentdatabase, and the released database layout from the XML file downloaded from the web is referred to as XmlLayout.

Database Checker is meant to be used when unexpected SQL errors are found in log files. Then run the Database Checker to make sure the database I compliant.

Database Checker will check the following items in the database

Item	Description
Tables	First, check if each table exist, and then for each table checking the following items Columns exist Columns datatype and datatype size is equal Primary key exists Index exist Unique Constraint exist Foreign key exists Trigger exist
Views	Does the view exist, and are the script identical
Stored Procedures	Does the Store Procedure exist, and are the script identical
User-Defined Functions	Does the User-Defined Function exist, and are the script identical
Roles and Rights	Do each role exist, and does it contain the right

Here is a description of the errors and warnings.

Issue type	Description
Error Critical	These are critical errors found in the current database, that needs to be fixed, for the CapaInstaller system to be running correctly.
Error	These are errors found in the current database, that needs to be fixed for the CapaInstaller system to be running correctly.
Warning	These warnings are issues found in the current database, that should not exist in the layout. It could be tables, columns, etc. added by the user.
OK

Step	Action
1	Go to System Administration, and click Actions and then the Database Checker menu item.
2	Opening the Database Checker will look like this
3	Click on Check Database to start comparing the current database layout, with the layout from the XML file from the web. If no errors or warnings are found, the Database Checker will look like this
4	The Database Checker will look like this if errors or warnings are found in the database layout.
5	Click Save to file, to save the errors and warnings into a text file. You choose the location of the file, and then you can send the text file to CapaInstaller Support.