English

How To: Set up an SDEINTERCEPT log file on a client machine for ArcGIS Desktop and ArcGIS Server

Summary

Users need a way to identify issues occurring on the client side of the database connection when attempting to troubleshoot errors or perform diagnostics related to an enterprise geodatabase. The SDEINTERCEPT log file contains detailed information and records of the transactions performed, including associated errors. For more information on how the SDEINTERCEPT log file works, refer to the Esri knowledge base article, How To: Diagnose ArcSDE connection and performance issues using SDEINTERCEPT.

Procedure

The instructions provided describe how to set up the SDEINTERCEPT log file on the client machine for both ArcGIS Desktop and ArcGIS Server.

  • ArcGIS Desktop
  1. Click Start > right-click My Computer > Properties > Advanced System Settings.
  2. In the System Properties window, click the Advanced tab, and select Environment Variables.
  3. Under System Variable, click New and type the following in the respective fields:
    1. For Variable Name, type sdeintercept
    2. For Variable Value, type crwTf.
    3. Click OK.
  4. Repeat Step 3 to create a new variable:
    Note:
    Ensure the target directory and folder exists prior to creating the variable.
    
  1. For Variable Name, type sdeinterceptloc
  2. For Variable Value, type C:\temp\sde_client.
  3. Click OK and close the System Properties and Advanced System Settings windows.
  1. Reproduce the error or issue.
  2. Navigate to the directory specified in Step 4 (ii) to verify and review the sde_client files created.
  3. Upon completing these diagnostics, repeat Steps 1 and 2 and delete the variables created in Steps 3 and 4 from the System Variable list.
  • ArcGIS Server
  1. Click Start, and right-click My Computer > Properties > Advanced System Settings.
  2. In the System Properties window, click the Advanced tab, and select Environment Variables.
  3. Under System Variable, click New and type the following in the respective fields:
    1. For Variable Name, type sdeintercept.
    2. For Variable Value, type crwTf.
    3. Click OK.
  4. Repeat Step 3 to create a new variable:
    Note:
    Ensure the target directory and folder exists prior to creating the variable and that the ArcGIS Server account has access to the directory. 
    
    1. For Variable Name, type sdeinterceptloc
    2. For Variable Value, type C:\temp\sde_client.
    3. Click OK and close the System Properties and Advanced System Settings windows.
  5. Restart the ArcGIS Server service from the Windows services directory.
  6. Reproduce the error or issue.
  7. Navigate to the directory specified in Step 4 (ii) to verify and review the sde_client files created.
  8. Upon completing diagnostics, repeat Steps 1 and 2 and delete the variables created in Steps 3 and 4 from the System Variable list.

Related Information