ECMT Workflow - Error Log Tables

The ECMT WF Error log is one of the most useful things you can use when troubleshooting an issue inside of your ECMT environment.

ECMT logs information into the below database tables, each of which can help in diagnosing and triaging a problem.

• wf_systemchangelog

  • This table logs any system change.

  • Logs who made changes to what, and when these changes happened

• wf_diagnostics

  • Diagnostic messages related to your ECMT environment

• wf_errorlog

  • Logs instances of errors happening within the workflow, this could be when importing new workitems or at any point during the workflow within your environment.

It is recommended to use a combination of the wf_diagnostics table and the wf_errorlog table when troubleshooting an issue as the combination of these two should help point you in the correct direction to find the problem.

It should be noted that these tables are only viewable through SQL Server Management Studio inside of your ECMT database. Whoever is researching the error would need to be technically savvy and familiar with SQL Server Management Studio, SQL Queries, Stack trace messages, etc.