Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Error: 56050 Table does not exist while searchign for documents
    • Sign In

    • State Suggested Answer
    • +1 person also asked this people also asked this
    • Replies 6 replies
    • Answers 1 answer
    • Subscribers 62 subscribers
    • Views 3986 views
    • Users 0 members are here
    • ProjectWise
    • table

    Error: 56050 Table does not exist while searchign for documents

    canada18
    Offline canada18 over 8 years ago

    we are doing a search of document in projectwise which does return reults but also show an error message

    Last Error - Table column does not exist. Please consult the logs to see the details.

    Any idea what goign on/

    • Sign in to reply
    • Cancel

    Top Replies

    • Andrew Bila
      Offline Andrew Bila Fri, Jul 13 2018 1:27 PM +1 suggested
      I received Error: 56050 while trying to update an environment attribute. The cause was another attribute that was trying to update via an incorrect select statement (yes, my own fault). The select statement…
    • Jimmy Lau
      0 Offline Jimmy Lau Tue, Feb 10 2015 8:40 PM
      Hi

      I have 1 user who has similar problem. They found that their PW Environment table is corrupted. 2 columns: o_docguid and o_projectno are missing or empty. So, they rebuild the environment for all documents. The problem is resolved.

      Hope it helps.



      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • canada18
      0 Offline canada18 Wed, May 27 2015 12:52 AM in reply to Jimmy Lau
      I do not have o_docguid column in my environment table, does this table exist in all the databases?
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • canada18
      0 Offline canada18 Fri, May 29 2015 6:08 PM in reply to Jimmy Lau
      how do we rebuild the environment? Do you mean rebuild a new environment in PW administrator?
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Peter Willmen
      0 Offline Peter Willmen Sat, May 30 2015 4:48 AM
      Have you checked you views?. I have seen this error if the view is looking for an attribute field that does not exist in the environment for some of the returned results
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • canada18
      0 Offline canada18 Sun, May 31 2015 2:15 AM in reply to Peter Willmen
      Thanks Peter for the response. I have found the table DMS_DOC and its view (V_DMS_DOC) where O_version is a required field but in the table it has empty records . Could this be problem? can you suggest what exactly to look for in the views
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    >

    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