Enable SQL Logging

Follow this procedure to enable SQL logging and exceptions in PM Compass.

Make sure that all users are logged out of PM Compass before making these changes. When changes are made, all users will automatically be logged out.

To enable SQL logging and exceptions:

  1. Create the folder to store logging.

    2. The logging folder must be shared. Deltek recommends creating a new logs folder called SqlLogs on the same level as the folder where you store your Integration Process logss. For example, if this is your Integration Files folder: \\<servername>\<Deltek folder>\ProcessLogs, then you create your SqlLogs folder here: \\<servername>\<Deltek folder>\SqlLogs.

    To see the location of your Integration Process logs, log into PM Compass and click Administration » System Settings » File Folders tab.

  2. Locate the web.config file, which is located in the Web folder of the PM Compass installation location.

  3. Open the web.config file using Notepad or any other text editor.

  4. In the <appSettings> section, add or locate the following lines:

    5. <add key="SQLLogDirectory" value="<log path>" />

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

  5. In the web\bin directory, open the Deltek.PMCompass.ProcessServer.Server.exe.config file.

  6. Directly beneath the <configSections> element, add an <appSettings> element if it is not already available. otherwise,simply add the following keys under the <appSettings> section. Your end result should loo like the following:

    7. <configSections>

    sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

          <section name="Deltek.PMCompass.ProcessServer.Server.My.MySettings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

        </sectionGroup>

      </configSections>

      <appSettings>

        <add key="SQLLogDirectory" value=<"log path"> />

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

      </appSettings>

  7. Restart IIS by performing the following actions:

    8. a. On the Start menu, click Run.

    b. Enter inetmgr and click OK to open IIS.

    c. Locate the PM Compass web application and restart it. By default, this is under Default Web Site.

Learn more about...