Page tree
Skip to end of metadata
Go to start of metadata

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

ItemDescription
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 ProceduresDoes 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 RightsDo each role exist, and does it contain the right


Here is a description of the errors and warnings.

Issue typeDescription
Error CriticalThese are critical errors found in the current database, that needs to be fixed, for the CapaInstaller system to be running correctly.
ErrorThese are errors found in the current database, that needs to be fixed for the CapaInstaller system to be running correctly.
WarningThese 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.



  • No labels