DRAFT KB-XXXX How to Enable SQL Query Statements in WebLogic Logs

Purpose

The purpose of this article is to explain how to enable SQL logging in WebLogic to troubleshoot issues related to running SQL queries in Appian.

Instructions

1. Open the Administration Console of WebLogic. This is normally located at <WEBLOGIC_SERVER_FQDN>:7001/console.
2. In the left pane of the Administration Console, click on Servers.
3. Select the server that is running the Appian application (for example: AdminServer).
4. Select the debug tab.
5. Click the dropdown on the WebLogic scope
6. Click the dropdown on JDBC scope.
7. Click the dropdown on SQL scope.
8. Click the checkbox for Debug JDBCSQL.
9. Click enable.
10. This enables SQL statements to be printed on the YOUR_SERVER_NAME.log file.

Affected Versions

This article applies to all versions of Appian using WebLogic as the application server.