Validate data in the database
(Created page with "The MDrivenServer has a built in feature to check for database consistency. * Log in to the MDrivenServer * Goto Settings->Admin There are two buttons there; # Validate Admi...") |
No edit summary |
||
| Line 11: | Line 11: | ||
Click to run a check on all the tables in the databases. | Click to run a check on all the tables in the databases. | ||
You will get an error report and an SQL statement to run to see the problem data; | |||
Single link dupes(38146711), execute select PublisherAgreementPeriodID,Count(PublisherAgreementPeriodID) from AgreementImport where not PublisherAgreementPeriodID is null group by PublisherAgreementPeriodID having Count(PublisherAgreementPeriodID)>1 | |||
Revision as of 21:46, 20 February 2023
This page was created by Lars.olofsson on 2023-02-20. Last edited by Edgar on 2025-01-20.
The MDrivenServer has a built in feature to check for database consistency.
- Log in to the MDrivenServer
- Goto Settings->Admin
There are two buttons there;
- Validate Admin DB Data
- Validate A0DB Data
Admin DB is the database internal the the MDrivenServer containing model information
A0DB is the internal or external database containing the application data.
Click to run a check on all the tables in the databases.
You will get an error report and an SQL statement to run to see the problem data;
Single link dupes(38146711), execute select PublisherAgreementPeriodID,Count(PublisherAgreementPeriodID) from AgreementImport where not PublisherAgreementPeriodID is null group by PublisherAgreementPeriodID having Count(PublisherAgreementPeriodID)>1