PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Collapse]Program
     [Expand]Document Types
     [Expand]Reports in PANTHEON
      Document Texts
      Delivery Methods
     [Expand]Loyalty Cards
     [Collapse]Administration Panel
      [Expand]Right click on Administration panel tree
      [Expand]Settings
      [Expand]Security
       Menu
      [Expand]Users and Groups
      [Expand]Versions/Upgrades
      [Collapse]Database
       [Expand]Company Settings
       [Expand]Backup
        Statistics
       [Expand]Performance
        Referential Integrity Check
       [Expand]Import/Export Data
       [Expand]Document Links and Transfers
        System Log
       [Expand]Changelog Settings
        Report Log
        Event Log
        Document archiving
       [Expand]Workflow Log
      [Expand]ZEUS
      [Expand]OTOS
     [Expand]Dashboard Components
      Dashboard Reports
      Ad-hoc analysis
     [Expand]ARES
      SQL urejevalnik
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 656.2568 ms
"
   1693 | 2158 | 341619 | Updated
Label

Referential Integrity Check

Referential Integrity Check

    

 

 

Using this function you can check for possible errors in database (e.g. account put in use in Document Types register does not exist in the Chart of Accounts). Run check for individual across the entire database.

Furthermore, the checl can be restricted by the following criteria:

Master Selecting the name of the main table (e.g. invoice header) from the selection table. If you leave the field empty, the check is run across all tables in database.
Detail Selecting the name of the linked table (e.g. lines in invoice) from the selection table.
Status In this box you can observe the progress indicator and displayed names of tables for which the check is run.
44935.gifShow Empty Strings If checked, the records containing emty strings are displayed.
(window for displaying results) Displays results of referential integrity check.
Check By clicking you run a check of referential integrity.
Auto-Fix By clicking it reestablished referential integrity.
Cancel It is visible after running check (see the above fields).

Referential integrity check run on large databases can take long. So you can cancel the operation by clicking the Cancel button. You have to confirm or reject the operation (see Do you really want to cancel the operation?).

Types of report:

1. "SM" in table POSLDOG does not exist in master table ODDEL

Teh error of this type telss you that the value in inverted commas ("SM") contained in the string (POSLDOG) of the table (POSLDOG) does not exist in register or parent table (ODDEL). This disrupts the referential integrity of the database you use. In such a case it is recommended that you call your support provider.

2. Error in Master=ODDEL-USERID, Detail=POSLDOGPROMET-DATUMSPRE, Error: "[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

Error returned by the SQL server. With errors of this type contact your support provider.

 

44815.gif The function is designated mainly for running referential integrity check in case of errors in database (after first consulting your support provider). Results are later sent via e-mail or in any other way to the support provider.

How does this get done?

Mark all records in the window for displaying results. Select the text you want to copy and use the function for copying (44816.gif 44817.gif). Then ope n a new e-mail message or word processor (attach it to your e-mail message) and select the paste function (44818.gif 44819.gif).

 

 


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!