Skip to content
logo Knowledgebase

How to generate a SQL trace for one user session

Created on  | Last modified on 

Summary

Ordinarily you can enable SQL Server tracing from within an X3 User session, by navigating to Help> Diagnostics and then selecting “Activation Timing” There are several reasons why SQL tracing may not be able to be launched using this method. For example, if your database is on a different server to the X3 Process server, then you will see an error message “Error accessing database server (-138)” The simplest way to overcome this message is to manually identify and trace the X3 user session using the database tools, either SQL Server Extended events, or the Oracle SQL trace

Description

Cause

Resolution

The attached documents explain the process to generate a SQL trace for one user session

Attachment: 485_20230425110356_SetupSQLtrace_Oracle.pdf
Attachment: 485_20230425110356_SetupSQLtrace_SQLServer.zip