Using Audit Trail Truncation in Load-balanced Configurations
When running ProjectWise Integration Servers in a load-balanced configuration and using audit trail truncation, only one of the ProjectWise Integration Servers should be performing the truncation, and all the other ProjectWise Integration Servers in the cluster should have audit trail truncation disabled.
To disable audit trail truncation on a particular ProjectWise 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.