Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error at startup - cannot find input table or query sym0
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • -OpenUtilities Substation
      • +CONNECT Edition - OpenUtilities Substation
      • +3D Layout Features - Bentley Substation
      • About Bentley Substation
      • +Administration Features - Bentley Substation
      • +Automation Features - Bentley Substation
      • +Component Management - Bentley Substation
      • +Construction Drawings - Bentley Substation
      • +Database Platform Support - Bentley Substation
      • +Grounding Grid - Bentley Substation
      • How to log Service Request
      • -Installation_Configuration - Bentley Substation
        • Application Data (per-user configuration) - Substation
        • Compatibility Chart - Bentley Substation V8i
        • Data folder archive
        • Device.mdb - Substation
        • Diagnose a program crash using Event Viewer
        • Error - user configuration file could not be updated
        • Error at startup - Boolean Init
        • Error at startup - cannot find input table or query sym0
        • Error at startup - No value given / given key not present (Multi_Language_UI.mdb)
        • Error at Startup - Operation must use an updateable query
        • Error-Data at the root level is invalid. Line 1,Position 1.
        • Evaluation version does not download
        • How to create App Data Folder Deployment in Open Utilities Substation Connect
        • How to Install Bentley Substation
        • Installing with no internet connection
        • No right-click menu appears
        • Program Folder - Substation
        • +Substation Paths
        • Updating and Upgrading Bentley Substation
      • +Interoperability - Bentley Substation
      • +PowerPlatform Support - Bentley Substation
      • +Project Management - Bentley Substation
      • +ProjectWise Integration - Bentley Substation
      • Working from home with OpenUtilities Substation
    • Promis.e Paths
    • +Promis.e Wiki
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Error at startup - cannot find input table or query sym0

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.140
      Environment: N\A
      Area: Installation_Configuration
      Subarea: N\A

    Error or Warning Message

    At startup, the following or similar error message is displayed and catalog items such as symbols cannot be inserted.

    Internal Error
    UI Error Message: ExecuteSQL error. create PROCEDURE BlkInfo AS select
    blkName,anum,blkDesc,desc_id,type,date_modify,category,0 AS FileInfo_id,blkSymXML from sym0
    The Microsoft Jet database engine cannot find the input table or query 'sym0'. Make sure it exists and that its name is spelled correctly.
    TargetSite: Void ExecuteSQL(Int32, System.String)
    DeclaringType: MDBProxy.LocalTools
    Attributes: public
    MemberType: Method...

    Explanation

    This message can indicate a problem with the Device.mdb file. In one case it occurred after incorrectly trying to rename a catalog.

    How to Avoid

    1. Refer to the following articles for the path to Device.mdb and a link to a fresh copy of this file.
      Device.mdb - Promis.e
      Device.mdb - Substation

    2. Rename or delete the suspect Device.mdb.

    3. Replace the Device.mdb with the known good copy of Device.mdb.

      Original Author: Matt_P

    Keywords: sym1, sym2, dev0, dev1, dev2, mac0, mac1, mac2, tit0, tit1, tit2

    • promis.e
    • error message
    • Bentley Substation
    • en
    • Installation_Configuration
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Fri, Feb 2 2018 1:51 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Thu, Apr 16 2020 9:27 AM
    • 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