Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki ADTB307: Error executing the SQL statement Alter Table PIPING Alter Column INTEGER
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • +OpenPlant
      • -Bentley AutoPLANT
        • AutoPLANT Product Group Compatibility
        • +AutoPLANT Modeler CONNECT Edition
        • -AutoPLANT Modeler V8i
          • +AutoPLANT Modeler [FAQ]
          • +Component - AutoPLANT Modeler
          • +Customization - AutoPLANT Modeler
          • +Database - AutoPLANT Modeler
          • -Errors, Logs, Messages, Crashes - AutoPLANT Modeler
            • +"Olemanager was not found" Error while loading Support Topwork Browser and Componet Preference
            • ADTB307: Error executing the SQL statement Alter Table PIPING Alter Column INTEGER
            • ATDB0107:Error executing the SQL statement
            • ATDB0312: Database error the source and target databases have inconsistent structures
            • ATDB0702: Unable to create an instance of the project Database
            • ATDB0726: Relationship Manger error code reported -2147467261 BPObjRel19: Object reference not set to an instance of an object
            • AutoCAD Message “loadpiping.scr” Can’t find the file While Opening AutoPLANT
            • AutoPLANT Install Fails with Error 1723
            • AutoPlant Modeler SS5 installation issue "Failed to create an instance of the Bentley Security object"
            • Blank Line Number Error message in AutoPLANT modeler
            • CONNECTION Client (Error -2760)
            • Error on uninstalling, repairing, updating or installing AutoPLANT Modeler Prerequisites or AutoPLANT Modeler: Failed to create an IPC Port: Access is denied.
            • Error XCHG0000: User Cancelled
            • Error: Publish i-model is not available. Please install AutoPLANT i-model Composer
            • Failed to Enable AutoPLANT Project for OpenPlant
            • Failed to initialize Project for OpenPlant
            • FATAL ERROR: Unhandled e0434352h Exception at fd38a06dh while loading Component Preferences
            • How to Enable Missing .NET Framework v3.5 required for Bentley's Class Editor installation
            • Invalid Pointer Error While Generating Report in AutoPLANT Modeler
            • Old format or invalid type library. (Exception from HRESULT: 0x80028019)
            • Project is Locked for Exclusive Mode Error Appears when opening Project in Project Administrator
            • Project packager error 'DynaZip Unzip Error: No files to test, extract, etc. (No items match filespec)'
            • Run time error ‘5’ Invalid Procedure call or Argument
            • Runtime Error After Removing Newer AutoPLANT Version
            • Runtime Error… File name or class name not found during OLE Automation operation Line: 231
            • Startup Dialog: File Loading - Security Concern
            • To Populate the Missing Line Number of the Piping Model in the AutoPLANT Modeler
            • “Enter name of the customization file to load:” Error When Loading Piping or Equipment Menu in AutoPLANT Modeler
          • +General - AutoPLANT Modeler
          • +Installation - AutoPLANT Modeler
          • Processing - AutoPLANT Modeler
          • +Settings/Attributes - AutoPLANT Modeler
          • +Tools - AutoPLANT Modeler
        • +AutoPLANT Piping
        • +AutoPLANT Equipment
        • +AutoPLANT I&W
        • +AutoPLANT P&ID
        • +AutoPLANT Isometrics
        • +AutoPLANT AutoISOGEN
        • +Bentley Data Manager
        • +Vision/Document Manager
        • +Drawing Flattener
        • +DataSheets
        • +Specification Generator
        • +ProjectWise Integration
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

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

    ADTB307: Error executing the SQL statement Alter Table PIPING Alter Column INTEGER

    Applies To AutoPLANT Modeler
    Product(s): AutoPLANT Modeler
    Version(s): 08.11.XX.XXX
    Environment: Windows 7/8.1/10 (64 bit)
    Area: Error/Logs
    Subarea: 
    Original Author: Abhijeet Shinde, Bentley Product Advantage Group

    Overview

    In AutoPLANT Modeler while placing pipe user may following error

    Problem Description

    When using SQL/Oracle data base with AutoPLANT Project and select distributed Project mode instead of Central Mode user may face this issue.

    For ORACLE & SQL Databases Project Mode should be Central Mode and for Access Database you can select Distributed Mode.

    This Wiki Article explains the steps to resolve this issue

    Steps to Resolve

    1. Open the Project Administrator and select the Project

    2.Go to Edit and select Preferences

    3.Go to Tools and select  Project Conversion Wizard

    4.Convert the Distributed Mode to Central Mode

    5.Project State will convert

    See Also

    Errors, Logs, Messages, Crashes - AutoPLANT Modeler
    Applies To Product(s): AutoPLANT Modeler Version(s): 08.11.09.XXX & Others Environment: Windows 7/ 8.1/ 10 (64 bit) Area: - Subarea: - Original Author: …
    Last edited over 5 years ago in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki

    Still a Problem?

    If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround. 

    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!

    • SQL database
    • AutoPLANT Modeler
    • ATDB0307
    • Project Mode
    • Central Mode
    • AutoPLANT Piping
    • Share
    • History
    • More
    • Cancel
    • Abhijeet Shinde Created by Bentley Colleague Abhijeet Shinde
    • When: Mon, Sep 30 2019 5:00 PM
    • Abhijeet Shinde Last revision by Bentley Colleague Abhijeet Shinde
    • When: Mon, Sep 30 2019 5:02 PM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

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