Enable SQL Logging

This setting logs SQL calls. You can use it to identify long running queries and determine the parameters used when making calls to the Cobra Web Services.

Since it involves significant overhead, Deltek recommends that you only use it in a limited test mode.

To turn on SQL Logging:

  1. Confirm that all users are logged out of PM Compass.

  2. Log into the PM Compass Web Server as Administrator.

  3. Browse to the C:\Program Files\Deltek\PMCompass\Web folder and make a copy of the web.config file as a precaution.

  4. Use Notepad to open the web.config file.

  5. Locate the <appSettings> section, and add or edit the following line:

    6. <appSettings>

              <add key"SQLLogging" value="Y">

    </appsettings>

  6. Save the web.config file.

  7. Launch PM Compass and try to replicate the issue.

  8. Log out of PM Compass.

To turn off SQL Logging:

  1. Confirm that all users are logged out of PM Compass.

  2. Log into the PM Compass Web Server as Administrator.

  3. Browse to the C:\Program Files\Deltek\PMCompass\Web folder and make a copy of the web.config file as a precaution.

  4. Use Notepad to open the web.config file.

  5. Locate the <appSettings> section, and add or edit the following line:

    6. <appSettings>

              <add key"SQLLogging" value="N">

    </appsettings>

  6. Save the web.config file.

Sending Logs to Deltek Support

With logging, you can perform the functions or actions for which you want to capture logging information. When finished, use the following procedure to send the log file to Deltek Support.

To send the log to Deltek Support:

  1. On the PM Compass Web Server, browse to C:\Program Files\Deltek\PMCompass\Web.

  2. Locate and copy the Methodcall(datestamp).log file.

  3. Email the file to support or attach it to your support case.

In addition, turn off the logging to ensure that the PM Compass performance is not negatively affected.

The log file contains one line for each action taken in the application, including success/fail indicators, date, time, method call, username, machine name, and database name.

The Deltek team can review the log to determine if there are any issues.