ProjectWise Administrator Help

Using Audit Trail Truncation in Load-balanced Configurations

When running ProjectWise Design Integration Servers in a load-balanced configuration and using audit trail truncation, only one of the ProjectWise Design Integration Servers should be performing the truncation, and all the other ProjectWise Design Integration Servers in the cluster should have audit trail truncation disabled.

To disable audit trail truncation on a particular ProjectWise Design Integration Server, open that server’s dmskrnl.cfg file (C:\Program Files\Bentley\ProjectWise\Bin) and add the line DisableAuditTruncation=1 to the end of the each datasource settings section ([db0], [db1]) for which audit trail is enabled and for which audit trail truncation is needed. For example:

[db0]
Description=exton-tbb-0822
DisplayName=exton-tbb-0822
Type=Microsoft SQL Server
InterfaceType=ODBC
Name=exton-tbb-0822
DBUserName=pwadmin
DBUserPassword=000544d20001556b0000a432
DBUsrPwdDecrypt=1
DisableAuditTruncation=1

[db1]
Description=exton-tbb-0216
DisplayName=exton-tbb-0216
Type=Microsoft SQL Server
InterfaceType=ODBC
Name=exton-tbb-0216
DBUserName=pwadmin
DBUserPassword=000544h20002346c0000m776
DBUsrPwdDecrypt=1
DisableAuditTruncation=1

To enable truncation on the server after adding this line, you can either change DisableAuditTruncation=1 to DisableAuditTruncation=0, or you can delete the line entirely.