Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki ProjectWise connection to datasource freezing/hanging with no error message to Oracle database.
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • +ProjectWise Explorer Client
    • +ProjectWise Administrator
    • +ProjectWise Integration Server
    • -ProjectWise Caching Server
      • 4 hour evaluation license Caching server is running in Evaluation mode
      • Using Fetch Files to Pre-populate File Cache [TN]
      • NAS for Storage With ProjectWise [TN]
      • How to Configure ProjectWise Caching Server [TN]
      • Enhancing Performance With ProjectWise File Caching [CS]
      • Configuring ProjectWise V8 2004 Edition Caching Server [CS]
      • Configure a Caching Server to a hosted environment
      • +Explorer - ProjectWise Caching Server
      • +File Transfer Svr - Caching Svr - ProjectWise Caching Server
      • +MISC - ProjectWise Caching Server
      • +Projects - ProjectWise Caching Server
      • ProjectWise SS4 Thumbnails Not Appearing
      • Reference files are not attached when checking out a file from ProjectWise
      • Restricting Access to your ProjectWise Storage area's
      • +Security - ProjectWise Caching Server
      • Application Usage Reporting Wrong License Usage
      • Caching Server configuration not working with servers located in different domains
      • Caching Server Service stoppage
      • ProjectWise connection to datasource freezing/hanging with no error message to Oracle database.
      • projectwise configurations to change the ip address of the File Transfer server
      • Fetchfiles does not recognize folders with spaces in the name
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services

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

    ProjectWise connection to datasource freezing/hanging with no error message to Oracle database.

    If suddenly you cannot connect to ProjectWise datasource and connection just seems to be "frozen' please check if you are using Oracle database.

    If that is the case, please try to test your ODBC connection, in case during test phase it will show that user is expired proceed to change the password in oracle and set it to non expiring if it's allowed by your security policy.


    If the password was changed please open PWIS dmskrnl.cfg file (located in:C:\Program Files\Bentley\ProjectWise\bin) and find this section:


    [db0]
    Description=PW Datasouce Name
    Type=Oracle Server
    InterfaceType=ODBC
    Name=ODBC name
    DBUserName=DB_user_name
    DBUsrPwdDecrypt=4
    DBUserPassword=#A5H/X/Qae2lHlOqpEgNBNN9/TtkBUTmgopyZrBulgP3Ea2qFst8Sx1l8pUo=

    Change last two lines:

    DBUsrPwdDecrypt=1
    DBUserPassword=new_pass

    Please restart PWIS service afterwards and the new password will be re-encrypted.

    • Oracle
    • ProjectWise
    • connection
    • Share
    • History
    • More
    • Cancel
    • Arturas Baranauskas Created by Arturas Baranauskas
    • When: Tue, Dec 9 2014 3:34 AM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Mon, Oct 10 2022 3:45 PM
    • Revisions: 6
    • 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