ProStructures CONNECT Edition Setup Guide - ProjectWise Managed Configuration

Set Up Guide

Step 1: Create VM

  1. Create a brand new VM having recommended OS Windows Server.
  2. Take a snapshot.
Parent topic: ProStructures CONNECT Edition Setup Guide - ProjectWise Managed Configuration

Step 2: Create Database in SQL Server

  1. Install SQL Server
  2. Instance Configuration: default (MSSQLSERVER)
  3. Make sure you should install SQL Server with mixed mode authentication. For mixed mode authentication enter following credentials:
  4. Make sure SQL services running.
  5. Launch SQL server management studio and log in to database engine with above credentials.
  6. Create a new database.

Step 3: Create ODBC (System DSN) Connection from ODBC Datasource admin-64-bit

  1. Go to Control Panel>Administrative Tools> Select ODBC Datasources (64-bit)
  2. In ODBC Datasources Administrator dialog > System DNS tab.
  3. Click on Add button for Creating New Data Source.
  4. Select "SQL Server Native client 11.0" and click on Finish button.
  5. In Create New Data Source to SQL Server dialog, specify name of data source.
  6. Use the created server from the list and server name and click Next.

Note: : If expected SQL Server name is not appearing in drop-down list then please ensure that the service named "SQL Server Browser" is running.

  1. Specify, Database server login ID and Password & Click Next.
  2. Keep on clicking next by specifying parameters as required.
  3. Test the data source.

    After test is successful, Click OK.

INSTALLING BENTLEY APPLICATIONS

The install procedures are arranged in the order the applications should be installed.

Install ProjectWise Server:

Install ProjectWise Administrator:

Select the following options

Install ProjectWise Explorer:

Use default settings...

Install ProStructures CONNECT Edition

Setting-Up ProjectWise Datasource

Prior to creating ProjectWise Datasource, please start ProjectWise integration service.

GO TO Control Panel>Administrative Tools>Services>>Start "ProjectWise integration service".

Step 1: Create ProjectWise Datasource

  1. Open PW Admin and find desired Server name, go to Data sources and create a new data source from right context menu OR select existing data source.
    Specify Datasource Name
  2. Specify ODBC connection details [Created during ODBC connection].
  3. Specify database user account for client connections. Enter Username & Password
  4. Click "Next".
  5. Specify administrator account name and password.
  6. Finishing New Datasource Wizard.
  7. Uncheck "Create datasource data from template".
  8. Click on Finish.
  9. On first time creation, it will ask for creating database table for storage.

    It will start creating tables

  10. Provide path for creating storage. For e.g. C:\PWDIR\PS_ManagedWS and proceed.
    Note: Storage path is the path where the ProjectWise configuration is downloaded to local machine (dms folders). While installing ProjectWise Server application this path is defined. So, it is intended to use the same path + new folders name.
  11. The database tables will be created.
  12. After completion, the data source you have created get listed under the server name.
  13. Expand that data source. Go to the Workspace>
    Note: To access the server, it should be login in Bentley domain administrator groups

Step 2: Single Sign On

  1. Go to C:\Program Files\Bentley\ProjectWise\Bin and open dmskrnl.cfg and add SSO=1 at bottom (just after [db0]).
  2. Close the PW administrator

Step 3: Restore datasource after upgrading to newer version of ProjectWise Integration Server

When the ProjectWise integration server is upgraded to newer version, below error is displayed

To perform conversion of tables, open command prompt.

  1. Set the diirectory to C:\Program Files\Bentley\ProjectWise\bin
  2. Run dmsconv.exe
  3. Provide the required details i.e.
  4. 1. dmsconv.exe -d ODBCDataSourceName -u DatabaseUserName -p DabasePassword
  5. Hit Enter
  6. Type Yes to convert tables.
  7. Type No to update MIME type.

    Error 55049: Error copying document to client. Cannot create storage area. The storage area is not within the allowed storage locations defined for this server. Please contact your administrator.

    That mean ProjectWise working directory path has been changed/doesn't exist.

Allowable Locations for Storage Areas

Before you can create a storage area, you must now first define at least one allowable storage location, which is a local and/or network location where storage areas hosted by a ProjectWise Design Integration Server or ProjectWise Caching Server can be created.

Allowable storage locations are defined in the DMSKRNL.CFG file. If no locations are defined, you will not be able to create any storage areas on the server.

For convenience, the ProjectWise Design Integration Server and ProjectWise Caching Server installers have been modified to let you define the default allowable storage location during installation. You can also manually add, modify, or remove allowable storage locations from the DMSKRNL.CFG file.

Solution

  1. On the PW integration server, open the dmskrnl.cfg file (found in c:\program files\bentley\projectwise\bin)
  2. Find the section labeled: [FileStorageService]
  3. Add a line pointing to the path of the storage area.

Example: StorageLocation0=E:\storage