Problem

Create file in ProjectWise using the drag and drop method. The local time on computer when user dropped the file into ProjectWise was 2:02:10 PM CDT.

The time on the Integration servers when the file was dropped into ProjectWise was 3:02:10 PM EDT. The time on the Storage server when the files was dropped into ProjectWise was also 3:02:10 PM EDT.

Since this was a new file, the time stamps for Created by On, Updated by On and File Updated by On all match but they are two hours local time and three hours behind the server time in Oak Ridge (where the file is stored).

Solution

We gather all the info from the document and populate a structure we then get the host name of the client and PW user ID and pass this over to the ProjectWise integration server. The integration server then gets the current date time from the database using either systimestamp for Oracle or getdate() for SQL server (dsqlUtilGetCurrentDateTime). This date time is stored as GMT and is used to set the Created, Updated & File Updated for the new document.

What this means is the client’s and integration server time is not used for the creation of the document nor is the file time.

However the display of the times in PWC are coming from the integration server time. So if this PW server is on the east coast this is the time that is going to be displayed when viewing the information in ProjectWise not the GMT, unless you have that time zone set on the server.

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!