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 WebLogic dropdown.
6. Click the JDBC dropdown.
7. Click the SQL dropdown..
8. Check the Debug JDBCSQL checkbox.
9. Click Enable button.
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.