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 Invalid Catalog Selected Issues in OpenPlant Specification Generator
    • Sign in
    • -AutoPLANT | Bentley Raceway and Cable Management | OpenPlant | PlantWise Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • -OpenPlant Modeler v8i
          • +Component - OpenPlant Modeler
          • +Drawing Generation- OpenPlant Modeler
          • -Errors, Logs, Messages, Crashes - OpenPlant Modeler
            • "Failed to Find Cell Library for Diagram" Error While Placing Equipment
            • "No Component Found With Initial Selection From Specs" Appears While Placing Component
            • Attach OpenPlant Modeler Objects in ProSteel
            • Deleting User Data Files Local and Roaming
            • Duplicate Key Tags Message in OpenPlant Modeler
            • Graphics Issue- Distorted graphics- Display Graphics in OpenPlant Modeler
            • How To Fix "Unable to Load Schema For StressApp" Error in OpenPlant Modeler
            • Invalid Catalog Selected Issues in OpenPlant Specification Generator
            • Invalid Joint Error while Validating Joint for Custom Components
            • Line 241 Error-Launching OpenPlant Modeler
            • Property is Read Only Error in OpenPlant Modeler
            • Selected Spec is Incompatible With the Current Project
            • +Spec Validation Report Error: Some Properties in Spec Do Not Match in Component
            • Standard Preferences Dialog Disappeared from OpenPlant Modeler
            • StartUp Error-Launching OpenPlant Modeler
            • Structural Synchronizer Engine Not Found Message when Selecting Repository from Structural tab
            • Tap Port Connection On Blind Flange Placement Issue
            • To Fix Incorrect Property Update while using AutoMatch Option
            • To Fix Joint Connection Error While Modeling Component
            • To Fix Missing Ports Information for PIPE_ELBOW_5_DEGREE in OpenPlant Modeler
            • To Fix Pro Steel Models Referenced in OpenPlant using Object Enabler
            • To Fix Support Rotation Issue By Manual Rotation or By placing supports using OpenPlant Support Engineering .
            • To Fix Unhandled Exception Error while Launching Pipeline Manager in OpenPlant Modeler V8i
            • To Fix Unhandled Exception Error “Index was outside the bounds of the array”
            • Too Many Results (XXXX).Select this to see items in details
            • Unable to Delete Corrupt Component in OpenPlant Modeler
            • Unable to Find Catalog Issue in OpenPlant Specification Generator
            • Wafer Joint on Components with Different Facing and Rating Shows Error While Placement
          • +Import/Export- OpenPlant Modeler
          • +Installation - OpenPlant Modeler
          • OpenPlant HVAC-OpenPlant Modeler
          • OpenPlant Modeler [FAQ]
          • +OpenPlant Specification Generator
          • +ProjectWise - OpenPlant Modeler
          • +Properties - OpenPlant Modeler
          • +Release Notes - OpenPlant Modeler
          • +Schema - OpenPlant Modeler
          • +Settings/Attributes - OpenPlant Modeler
          • +Structural Modeling Components (SMC)- OpenPlant Modeler
          • +Tasks - OpenPlant Modeler
          • +Training - OpenPlant Modeler
        • +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
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
      • +Bentley AutoPLANT
      • +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. 

    Invalid Catalog Selected Issues in OpenPlant Specification Generator

      Applies To 
       
      Product(s): OpenPlant Modeler
      Version(s): 08.11.09.440/08.11.09.564/08.11.11.87
      Environment:  Windows 7 (64 bit)
      Area:  -
      Subarea:  -
      Original Author: Rahul Kumar, Bentley Product Advantage Group
       

    Overview

    To fix ‘Invalid Catalog Selected’ error message in OpenPlant Specification Generator.

    Problem Description

    In OpenPlant Specification Generator, while creating a catalog using MS Access files, some of the fields or Data Types mismatches with respect to its specs. Further opening the spec using OpenPlant Specification Generator, it throws an error stating Invalid Catalog Selected along with the list of Fields which got problems with the Data Types and its Fields. See below image. Error In table: PIPE Column:THD_ENG_R is defined as System.String instead of System.Double 

                       

    To fix this problem user need to open the corresponding mdb file using ms access and edit the Data Types and Fields. Below steps will describe the matter significantly. 

    Steps to Resolve

    1. Navigate to Project path for Catalog Databases folder.

    2. Open Corresponding Catalog to fix the issue.

    3. Open MDB file, say ASME.mdb here.

    4. Go to PIPE table.

    5. Set the View as Design View. 



    6. Check THD_ENG_R, COMP_LEN, & WEIGHT_DRY classes. 



    7. Change the Data Type to NUMBER and Field Size as Double like shown below for WEIGHT_DRY. 



    8. Similarly change it for other Fields.

    9. Save & close the Catalog.

    10. Launch OpenPlant Specification Generator and verify results. 

    Problem Description - Bolt issue

    In OpenPlant Specification Generator, while creating a new catalog for Bolts & further when it gets updated for a spec along with default Bentley catalog, an Error message prompts for "Invalid Catalog Selected"

              

    Steps to Resolve

    1. Navigate to Project path for Catalog Databases folder.

    2. Open Corresponding Catalog to fix the issue.

    3. Open newly created mdb file which is causing an issue

    4. Go to BOLT table.

    5. Set the View as Design View. 



    6. Check QTY_PERSET field for default value.



    7. Change the Data Type and Field Size as Double like shown below. 



    8. Save & close the Catalog.

    9. Launch OpenPlant Specification Generator and verify results. 

    See Also

    See Help Menu for additional information.

    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!

    • OpenPlant Modeler
    • QTY_PERSET
    • OpenPlant Specification Generator
    • 08.11.09.440
    • 08.11.09.404
    • 08.11.09.564
    • #OPM
    • Share
    • History
    • More
    • Cancel
    • Rahul Kumar Created by Bentley Colleague Rahul Kumar
    • When: Wed, Sep 9 2015 12:18 PM
    • Rahul Kumar Last revision by Bentley Colleague Rahul Kumar
    • When: Wed, Jun 15 2016 10:16 AM
    • Revisions: 2
    • 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