How to fix Data dictionary is inconsistent.

Posted By Shemu Sinkala over 4 years ago

I am having errors in AP Payment. I cant open the Payment batch list or Payment entry keep getting error :

Description: Damaged data. Payments/Adjustment. Data dictionary is inconsistent
Description: Error occurred when opening view AP0031.
Description: Damaged data. Payments/Adjustment. Data dictionary is inconsistent.

When i run data integrity, i get an error on the report :

Data dictionary is inconsistent.
E: open: OpenOneView failed (386 APINTCKD.C).
E: SET-SYSACCESS-AP0031 (2924 APINTCK1.C).

Kindly assist how i can resolve this issue

Regards

0 Patty Dube over 4 years ago

Please check that your AntiVirus software is not blocking Sage 300 files. You may want to exclude the Sage 300 Folder from the Antivirus Check list. You may want to Run a repair installation of the AP module or the entire Sage 300 Install the latest Product update for this version. Run RegAcc as Admin. If this does not help, create new DBase IDs, do a Database dump from the damaged company and load into clean database containers/IDs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shemu Sinkala over 4 years ago in reply to Patty Dube

Hi Patty

The issue is on the specific database where other databases are working fine. This SAGE 300 version(6.6A) 2019. I had tried loading damaged DBdump files into a clean database but still not lack.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shemu Sinkala over 4 years ago in reply to Shemu Sinkala

Product update 2 is also installed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Patty Dube over 4 years ago in reply to Shemu Sinkala

What happens if you load the data on your machine, off the environment?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300cloud Africa and Middle East

How to fix Data dictionary is inconsistent.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING