Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | AXSYS | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | AXSYS | OpenPlant | PlantWise
AutoPLANT | AXSYS | OpenPlant | PlantWise Wiki Can I Audit the Plant Project Database?
    • Sign in
    • -Plant Design and Engineering - Wiki
      • OpenPlant Product Compatibility
      • +CONNECT Services - OpenPlant
      • +OpenPlant Modeler CONNECT
      • +OpenPlant PID CONNECT
      • +OpenPlant Isometrics Manager CONNECT
      • +OpenPlant Orthographics Manager CONNECT
      • +OpenPlant Support Engineering CONNECT
      • +OpenPlant Project Administrator CONNECT
      • +OpenPlant Modeler v8i
      • +OpenPlant Isometrics Manager v8i
      • +OpenPlant Project Administrator v8i
      • +OpenPlant PID v8i
      • +OpenPlant Orthographics Manager v8i
      • +OpenPlant Support Engineering v8i
      • +OpenPlant ModelServer v8i
      • +OpenPlant Reporting v8i
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • -Plant Project Tools
        • Can I Audit the Plant Project Database?
        • How do I Manually add a New Column to the Database Property Mapping?
        • How do I Script Installs of Bentley Plant Applications?
        • Microsoft Access can't Find the Object 'dbo.<table name>'
        • Migrating the Plant Project and ProjectWise databases to a new server
        • New Tool to Resolve ProjectWise and Plant Products Installation Order Problems
    • i-model Composition Service for S3D

     
     Questions about this article, topic, or product? Click here. 

    Can I Audit the Plant Project Database?

       
      Applies To 
       
      Product(s): OpenPlant PID V8i
      Version(s): 08.11.10.523 & Higher
      Environment:  Windows 7/8 (64 Bit)
      Area:  DB Audit Tool
      Subarea:  N\A
      Original Author: Brandon Moberg, Bentley Product Advantage Group
       

    Background

    The Plant applications such as OpenPlant PID sync and push data to the Plant Project Database.  Many users then update this data with other applications such as DataManager, I&W or Datasheets.  What happens though if a corruption happens with the data itself in the database.  How does the administration of the project report that the data is correct or repair it when something has happened?  This is where the DB Audit Tool comes into place and helps report and resolve such issues.

    Installed with the OpenPlant PID application is a tool named DBAUDITTOOL.EXE.  This file is located in the following file folder:

    C:\Program Files (x86)\Bentley\OpenPlantPID (SS5)\OpenPlantPID

    Shown below is the Database Audit Tool:

    Please note this same tool can be launched through the OpenPlant Project Administrator SS6 version:

    Once the tool is open follow the steps below to begin the audit process:

    1. Select Login to connect to the OpenPLANT Project's PCF file.

    2. Once loaded select the options in "Select Errors" section to define the audit range.

    3. Select the Audit button to begin the audit.  Please note you can see which classes are mapped and defined in the Mapped Classes dropdown list.

    4. Notice below that a report is generated to show the user the data anomalies in the project:



    5. Select Save and a report is generated so the project administration teams can review and resolve the issues.

    Comments or Corrections?

    Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!

    • PID
    • v8i
    • OPPID
    • Audit
    • Openplant
    • Tools
    • Share
    • History
    • More
    • Cancel
    • bmoberg Created by Bentley Colleague bmoberg
    • When: Thu, May 26 2016 12:11 PM
    • Rahul Kumar Last revision by Bentley Colleague Rahul Kumar
    • When: Wed, Jun 1 2016 8:27 AM
    • Revisions: 4
    • Comments: 0
    Anonymous
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • User Management
    • Licensing Manager
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2019 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies