Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error inserting symbol - Query is too complex
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • -Component Features - Promis.e
        • Columns missing from dialogs, error messages
        • +Device Cross Referencing - Component Features - Promis.e
        • +Edit Components - Component Features - Promis.e
        • +Family Usage - Component Features - Promis.e
        • How to Add Spare Parts in Promis.e Connect
        • +Insert Field - Component Features - Promis.e
        • +Insert Symbol By ID - Component Features - Promis.e
        • -Insert Symbol By Name - Component Features - Promis.e
          • Delete Remnants of a Symbol
          • Error - Physical file does not exist, Insert Symbol
          • Error inserting symbol - Invalid cell library
          • Error inserting symbol - Query is too complex
          • Error inserting symbols - Record is deleted
          • Error inserting symbols - The symbol mismatched between drawing file and the catalog.mdb
          • Error inserting symbols from shared catalog - Microsoft Jet
          • Error Message: The Microsoft Jet database engine cannot find the input table or query 'BlkInfo'
          • Error, big red X on Insert Symbol
          • Insert Symbol By Name
          • Reset Insert Symbol/Macro Dialog
          • Symbols and wires offset at pointer until placed
          • Symbols are rotated, mirrored, or scaled when inserted
          • Wrong appearance when inserting or modifying a catalog item
        • +Insert Symbol By Part Number - Component Features - Promis.e
        • +Symbol on the Fly - Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Error inserting symbol - Query is too complex

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.12.137
      Environment: N/A
      Area: Component Features
      Subarea: Insert Symbol By Name

    Error or Warning Message

    A "Query is too complex" message is displayed when the Insert Symbol By Name tool is selected. Other error messages may also appear and at different times, including at start up or when clicking Apply or OK on Setup.

    Internal Error
    Error Message: Query is too complex.
    TargetSite: System.Data.DataTable GetTable(Int32, System.String)
    DeclaringType: MDBProxy.ConnectionManager
    Attributes: internal
    MemberType: Method

    Explanation

    The error message indicates that the query for gathering data from the catalogs specified in Setup > Catalog Paths is too long.  This can be caused by the long paths of deeply "buried" catalog folders, long folder names in the catalog path, or a large number of catalog paths present in Catalog Paths.

    How to Avoid

    Only load necessary catalogs

    Only keep catalogs necessary for current work in Setup > Catalog Paths.  Multiple setup configurations can be created with different sets of catalogs loaded in Catalog Paths.  A setup configuration could apply to a type of job, a certain client, a standard, etc.

    Shorten catalog paths

    Consider moving catalog folders so they are less buried and closer to the root, so the paths to them are not as long.  The folders would need to be moved using Windows Explorer and then added again to Setup > Catalog Paths.

    Consolidate catalogs

    Consider consolidating catalogs so there are fewer catalogs necessary in Setup > Catalog Paths.  For example, all the components of a manufacturer could be in one catalog, or a certain part type from various manufacturers could be in one catalog, or even all the parts for a particular type of job could be in one catalog. 

    It may be practical to consolidate the items that are used into one catalog and remove the remaining catalogs and the unused items they contain from Catalog Paths.  This is frequently applicable when there are many downloaded manufacturer catalogs in Catalog Paths but only some items are used in each.

    See Also

    Copy items to another catalog

      Original Author: Matt_P
    • Insert Symbol By Name
    • Setup
    • Catalog Manager
    • Configuration Features
    • promis.e
    • error message
    • Bentley Substation
    • en
    • Administration Features
    • Component Management
    • Component Features
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Thu, May 8 2014 4:55 PM
    • Jesse Dringoli Last revision by Bentley Colleague Communities MVP Jesse Dringoli
    • When: Fri, Mar 27 2020 3:12 PM
    • Revisions: 5
    • 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