Audit Trail Configuration Error. Unable to load Audit Trail Configuration


Product(s):ProjectWise Integration Server
Version(s):08.11.11.574
Environment: Window Server 2008 64 bit
Area: ProjectWise Administrator
Subarea: Administrative Tools
Original Author:Raul Guerrero, Bentley Technical Support Group

Problem Description

When attempting to adjust the Audit trail settings in the Administrator of the datasource, user is  getting an Audit Trail Configuration Error that states it is unable to load the Audit Trail Configuration Information.

Steps to Resolve

    1. Generate PW Admin and PW server logs
    2. Noticed in the DMSKRNL logs there was an error (pwise.database - Executing statement 'select * from dms_acfg')
    3. Ran this query in the Database and it returned information without any errors
    4. Grabbed a copy of the user database and imported it into our test environment
    5. Logged into the database to check the dms_acfg table. At that time we noticed an extra column.
    6. Deleting this extra column solved the issue