Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPLANT | OpenPlant | PlantWise
  • Product Communities
  • More
AutoPLANT | OpenPlant | PlantWise
AutoPLANT | OpenPlant | PlantWise Wiki Certain AutoPLANT tables are not created when creating new project from current.
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • +OpenPlant
      • -Bentley AutoPLANT
        • AutoPLANT Product Group Compatibility
        • +AutoPLANT Modeler CONNECT Edition
        • +AutoPLANT Modeler V8i
        • +AutoPLANT Piping
        • +AutoPLANT Equipment
        • +AutoPLANT I&W
        • -AutoPLANT P&ID
          • APPID: Error 2727 - The directory entry 'ACADDIR1' does not exist in the Directory table.
          • AutoPLANT Equipment - Equipment: Setting colors
          • Certain AutoPLANT tables are not created when creating new project from current.
          • How do I change the slant of text for Piping Annotation in AutoPLANT P&ID?
          • How do I customize insulation insertion and attributes
          • How do I move a P&ID drawing to another Project?
          • How do I turn on IAREA to Automatically Populate when a Control Valve is placed?
          • How To Add New Actuators For Control Valves [TN]
          • How to configure AutoPLANT P&ID V8i SS2 for use with customized CATT dialogs [TN]
          • How To Convert PID Menu Files To AutoCADs CUI Menu System [TN]
          • How To Define Custom Layers For Custom Components [TN]
          • How to download the AutoCAD 2012 VBA Enabler for AutoPLANT P&ID Find Tag and other VBA Dialog use?
          • How to script an install for the Process and Instrumentation Workgroup?
          • Install Order For AutoPLANT PID XM Edition [TN]
          • Project database upgrade options in Project Administrator
          • ProjectDB
          • Where are AutoPLANT P&ID Assemblies stored?
        • +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
    • How to Associate the Specification Based on Service in OpenPlant Modeler Connect

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

    Certain AutoPLANT tables are not created when creating new project from current.

    Problem:

    Database Types: Oracle, SQL Server

    Software Version: AutoPLANT XM, V8i SS1 and SS2

    When creating a new project from a current project certain tables do not get creating or copied.  This problem also can manifest itself when using Project Packager on this current project.  This is caused by these tables having a datatype of VARCHAR(MAX).

    Solution:

    Modify columns in these tables so that they are not VARCHAR(MAX).  Set the datatype to properly match the amount of data that will be in the column.  The AutoPLANT software does not support VARCHAR(MAX) columns.

    • PID
    • Database error
    • error
    • P&ID
    • P&IW
    • AutoPLANT P&ID
    • Project
    • Database Attributes
    • Projects
    • AutoPlant V8i
    • Autoplant PID
    • Project Administrator
    • Database
    • errors
    • Share
    • History
    • More
    • Cancel
    • bmoberg Created by Bentley Colleague bmoberg
    • When: Thu, Dec 16 2010 10:28 AM
    • Revisions: 1
    • 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

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