To capture database tier session debug information for a classic Web UI application

  1. Append the following to the URL for the Web UI application:

    &context.session.key.dbsessiondebug="true"

    For example:

    http://mymachine.lawson.com:6005/hcm/ManagerSelfService/controller.servlet?service=page&webappname=ManagerSelfService&name=ManageMySubordinates&panel=MySubordinates&dataarea=hcm&context.session.key.dbsessiondebug="true"

    Note: 

    You can also specify the level of detail for the capturing of the database tier session debug by also appending the following to the URL:

    &context.session.key.dbsessiondebuglevel=level , where level is minimal, basic, standard, or verbose.

  2. Then use the procedures below to identify the DBSessionDebug record where you can view, export, or email it. (Session debug will only be activated for the duration of the query; no action is required to deactivate it.)