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;

1. Validate Admin DB Data
2. 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