1.9

Release Notes

Date: October 23, 2024

New Features

• Initial Cobol Trace Processor Implementation:

  • Introduced a new processor to handle COBOL trace files, expanding the tool's capabilities to process and analyze COBOL trace SQL extractions. This includes refactoring how processors are selected, with various quality-of-life improvements to streamline the workflow.
  • Commit: initial cobol trace processor implementation. refactoring how processors are selected and various QoL fixes

• Support for AE Traces in Compare Tool:

  • Enhanced the compare tool to include support for App Engine (AE) traces, enabling more comprehensive comparison functionality.
  • Commit: Support AE traces in compare tool

Enhancements

• Refactor SQL Statement Handling:

  • Improved SQL processing to account for multiple executions, a common scenario in COBOL traces, ensuring more accurate SQL statement analysis.
  • Commit: Refactor SQL Statements to account for multiple executions of it (common in cobol traces)

• Processor Class Refactoring:

  • Simplified the structure of processor classes to reduce duplicate code, particularly in the detection and handling of different trace file types. This refactor aims to enhance maintainability and performance.
  • Commit: Refactor processor classes and reduce duplicate code for creating/detecting the type of trace file

• Support for Processing AE Trace SQL Execution Paths:

  • Added functionality to handle AE traces, including processing execution paths, allowing users to better understand the sequence of operations in App Engine traces.
  • Commit: Support processing AE tracesql for execution path

Bug Fixes

• Fix Path Execution Bug:

  • Addressed a bug related to execution path processing, ensuring the accurate representation of execution sequences.
  • Commit: Fix path execution bug

• Regex Updates for App Engine Start/Step Markers:

  • Corrected regex patterns used to detect start and step markers in App Engine traces, enhancing trace file parsing accuracy.
  • Commit: Fix app engine start/step marker regexes

Technical Updates

• Upgrade to .NET Framework 4.8:
  • Updated the application to use .NET Framework 4.8, providing better performance, security, and compatibility with modern development standards.
  • Commit: Update to .NET 4.8

Trace Wizard 1.8

Put trace filename at top of window
You can now double click SQL statements in the execution path to be taken to that SQL statement
Improved "from" clause detection/display for SQL statements
Bugfix for return stack processing
Fix version information discrepancy
Add support for AE Peoplecode in PPC Objects tab
Add new statisitcs for execution times

Trace Wizard 1.7

This release contains the initial support for both .trc and .aet files from Application Engine tracing. All basic functionality should be present such and search/compare as well as generating SQL scripts or grouping/sorting SQL statements.

TRC files showing all SQL statements:

Execution Path for AET files:

AET files allow you via right click on the execution path to see the current values of the state record at that location.

Example of comparing an AET file to another, this shows a call happened on the left but didn't happen on the right:

Trace Wizard now makes use of BasicSQLFormatter library with is licensed LGPL. Source is available here

Trace Wizard 1.6.1

Quick update to fix internal version number
Allow for copying out of details pane.

Trace Wizard 1.6

Improved execution path parsing algorithm

Experimental support for parameters/return values for Application Class methods

Trace compare bugfixes

Ability to generate .sql files from a trace (thanks @iversond from psadmin.io)

Trace Wizard 1.5

This is a small update to remove the automatic update check on load. There is now a menu option in Help -> Check for update to trigger this check manually.

Trace Wizard 1.4

New diffing algorithm
Improved StackTrace Processor
Force TLS 1.2 for Update checks

Trace Wizard 1.3

Changes

• Trace Comparison Support #11
• Support for resume/reend #12
• Bug fixes in Execution Path processor

Trace Wizard 1.2

Changes

• Fixed bug in SQL View sorting
• Fixed parsing issue when given incomplete tracesql files
• Added view of all SQL Tables in a Trace.

Trace Wizard 1.1

Changes

• Initial Mono Support (Linux/OSX) on Mono 4.2.1
• Saving Trace Data to compact format for faster opening (.twiz files)
• Execution Tree is lazy-loaded for a more responsive UI
• Copy to Clipboard support for OSX
• Various improvements