Data Errors

06-04-09 12:30

Dear users,

It has come to our attention that many errors that occur in PANTHEON are caused by data errors. Those have most likely accumulated over time and must now be cleaned in order for the system to function optimally, We have integrated some data health mechanisms into PANTHEON's database to prevent further data errors. 

If the following message appears after upgrading: 

The database is missing some links between tables. Redo the upgrade or contact your support provider.

it means that your data has errors.

Data errors are often non-ciritical!

The system functions normally with such errors. It could be that you had those data errors for quite a time. Such errors might cause unpredictable software behavior.

We will be integrating data health mechanisms based on upgrade logs of problematic databases.

Referential integrity in PANTHEON is now enforced more strictly. The following are checked:

* whether primary keys of master tables are created;

* whether there are duplicate primary keys;

* whether all records in detail tables are also written to master tables (missing records);

* whether indexes (foreign keys) of dependent tables are created.

Many errors can be fixed in the upgrade process after we analyze how they occur and classify them. For other errors we will develop tools for fixing them.

If you get the above message, first try repeating the upgrade. If the message still appears, send the upgrade log to your support provider so he can check the severity of errors.

It is recommended to fix the errors as soon as possible to improve performance.