Thursday, November 29, 2007

conflict between auditing flag of table and its auditing components in data source

If you come across the following error with CFR Auditing, you might need to check the output components of the BSFN CheckAuditComponentStatus and determine the cause of the error.Becasue there are several reasons behind this message in the jde.log.
"JDB9901001 - There is a conflict between auditing flag of table: F0101 and its auditing components in data source: Business Data".
You need to check the value of "mnComponentStatus" in the output of the
CheckAuditComponentStatus BSFN.
A value of 0(Zero) for
mnComponentStatus means Auditng is OFF for this table
A value of 1(one) for mnComponentStatus means Auditng is ON and
A value of 2(Two) for mnComponentStatus means the components in the database are not proper.Means your previous attempt to Enable/Disable Auditing was not successful.Most possibly you will have an _ADT table without a view.

No comments: