PeopleSoft Trace Insights

Next-Gen Browser-Based Diagnostic Engine for PeopleTools

A fully client-side trace analyzer for PeopleSoft .tracesql, .trc, and .aet files.

Runs 100% locally in-memory inside your browser—no uploads, no servers, zero network egress.

Key Features

Local-Only Execution: HTML5 FileReader + TypedArrays, no external calls.
Multi-Parser Pipeline: SQL, PeopleCode, Stack, Variable, AE, COBOL.
Automated RCA & Health Score: 0–100 score with linked evidence.
SQL Analytics & N+1 Detection: Fingerprinting, bind substitution, slow/repeated pattern detection.
Execution Path Diffing: Myers-based baseline vs. target trace alignment.
Variable-to-Bind Correlation: PeopleCode variables → SQL bind parameters.
Multi-RDBMS Error Normalization: Oracle, SQL Server, DB2 mapped to unified categories.

Architecture Overview

+----------------------------------------------------------------------------------+
|                             BROWSER RUNTIME SANDBOX                             |
+----------------------------------------------------------------------------------+
| Trace Input (.tracesql/.trc/.aet) → FileReader → Multi-Parser → Heuristics → UI |
+----------------------------------------------------------------------------------+
| SQL Grid | Exec Tree | Diagnostics | Diff | Variable Flow | RCA Overview        |
+----------------------------------------------------------------------------------+

Getting Started

Prerequisites

Modern desktop browser: Chrome, Edge, Firefox, or Safari.

Run the Analyzer

git clone https://github.com/sudheersagar/PSoft-Trace-Insights.git

Open PSoft-Trace-Insights.html directly in your browser.
No web server, build step, Node.js runtime, or external dependencies required.

Workflow Overview

Step 1	Load trace (`.tracesql`, `.trc`, `.aet`) via drag-and-drop.
Step 2	Review Health Score & automated RCA on the Overview dashboard.
Step 3	Analyze SQL hotspots, N+1 loops, and bind-substituted statements.
Step 4	Inspect Execution Tree, Diagnostics, Variable Flow, and export CSV telemetry.

Recommended Trace Settings

Flag	Use Case
`TraceSQL=3`	SQL + bind values (standard performance tracing).
`TraceSQL=7`	SQL + binds + commit/rollback markers.
`TracePC=1`	PeopleCode flow and call hierarchy.
`TracePC=13`	PeopleCode + variable tracking.
`TraceAE=131`	App Engine step timings.
`TraceAE=387`	Complete AE diagnostics.

Multi-RDBMS Error Mapping

Classification	Oracle	SQL Server	DB2
`UNIQUE_CONSTRAINT`	ORA-00001	Msg 2627, Msg 2601	SQL0803N
`NULL_INSERT`	ORA-01400	Msg 515	SQL0407N
`OBJECT_NOT_FOUND`	ORA-00942	Msg 208	SQL0204N
`INVALID_IDENTIFIER`	ORA-00904	Msg 207	SQL0206N