1. WebServices Installation Guide
  2. Enable Logging
  3. Enabling SQL Log for WebServices Component

5.2 Enabling SQL Log for WebServices Component

It is not recommended to enable WebServices SQL log while running in production environment. The logging should be enabled in production only for debugging purpose by following the below mentioned steps:
  1. The CMN_DEBUG_LEVEL system parameter should be enabled and set to appropriate non-zero value.
  2. The CMN_DEBUG_METHOD system parameter should be enabled and set to appropriate non-zero value.
  3. The respective package debug level for the webservice should be enabled and set to appropriate non-zero value in system parameter. Please refer the below table to for the service and debug level mapping.

    Table 5-2 Service and Debug level mapping

    Service      
    DialerIntegrator: xcsadi_em_100_01 To receive loan application from dealer track: XAEPRC_EM_100_01 To receive edocs application update : XAE­EDS_EM_100_01 To receive loan application from route one:XAEPRC_EM_100_01
    CSSAccountDetailsRequestService: XCSPRC_EM_100_01 To receive loan application/deal update from dealer track: XAEUP­D_EM_100_01 To receive edocs comment update : XAEEDS_EM_100_01 To receive loan application/deal refresh from route one : XAEUPD_EM_100_01
    CSSAccountSearchRequestService: XCSACS_EM_100_01 To receive comments from dealer track : XAEPRC_EM_100_01 To receive edocs location update : XAEEDS_EM_100_01 To receive comments from route one: XEAUPD_EM_100_01
    CSSPostTransactionsRequestService: XCSUPD_EM_100_01 To post comments to dealer track: XAECHK_EM_100_01   To post comments to route one: XAECHK_EM_100_01
    CSSAccountPayOffQuoteRequestService: N/A To post application status to dealer track: XAECHK_EM_100_01   To post applica­tion status to route one: XAECHK_EM_100_01
    LOSeApplicationRequestService: XAEEDS_EM_100_01 To post dealer details to dealer track: XPRPRC_EM_100_01   To post dealer details to dealer track: XPRPRC_EM_100_01
    LOSApplicationRequestService: XAEPRC_EM_100_01      
    LOSApplicationSearchRequestService: XAEQUE_EM_100_01      
    LOSApplicationLocationUpdateService: XAEEDS_EM_100_01      
    LOSApplicationCommentUpdateService: XAEEDS_EM_100_01      
    LOSPostStatusRequestService: XAECHK_EM_100_01      
    LOSApplicationUpdateService: XAEUPD_EM_100_01      
    LOSCheckStatusRequestService: XAECHK_EM_100_01      
    LOSEcontractService: XACPRC_EM_100_01      

Parent topic: Enable Logging