Search This Blog

Analysing Logs

Everybody knows OW Debug Log Commander, from Everest software. Is really a great JDE geek tool to help us to start/stop a log session and also come with other cool features like Julian calendar converter (in my opinion the best julian date converter on the market now!) and deletion of Global Tables, the famous “DD” files.

And I believe most of you know or heard about Performance Workbench. Performance Workbench is a set of tools that parse a log file accordingly to some input parameters to get statistical data, like business functions timing, SQL statements, number of table access like select, delete, update, etc… You must uncompress the parse .EXE files in a separate directory (I usually use C:\PARSE) and run the main program. It does not have any other tool like in OW Debug Log Commander, but is really useful – specially for HUGE logs.

But, what if you get together the best of OW Debug Log Commander and Performance Workbench and put more amazing features all in one software??? Well, it looks like a dream, right? No, it’s real and it’s called JDE Trace, by PatWel.

It has a couple years I’m using this and once you get the philosophy, you’ll never want to use anything else!

Below, I’ll list the features for JDE Trace

The data is broken out by process/thread and displayed in a tree control.

Follow the flow of a session and find BSFN errors/warnings.

Paste business function parameters to the clipboard for use with JDE Object Browser

Dynamically control trace status (jdedebug.log) for any process

Truncate jdedebug.log files with one click

Delete global tables, dddict and ddtext spec files

Date conversion tool

SQL Analysis Pane shows the activity on all referenced tables

Cache Analysis Pane shows all cache activity

BSFN Analysis Pane shows each function reference with time statistics

Includes support for JAS debug files.

Details show the execution time of a BSFN or SQL statement

Long Tasks pane lists BSFN calls or SQL statements with a long execution time

Here's a video tutorial on how to install the newest JD Edwards 9.1 version!

In only six steps and no magic, you will have your JD Edwards up and running, including the Web version! The JD Edwards team did an outstanding job on this new version and I'm proud to be the first to document in video the installation steps and show you the system working after the installation.

By following the video you'll be able to have your own JD Edwards' instance running directly in your PC or you may also install as a Virtual Machine using Oracle Virtual Box. The base OS I'm using for this tutorial is Linux and as you can see, the Virtual Box VM works fast and is also stable. Please let me know if you need some information on how to setup a Virtual Box instanc…

You may want to install the 9.0, but I do recommend you to install and try the 9.1 with the new user interface and the "pages" feature. Click the link above and enjoy the video tutorial!

Oracle announced JDEdwards most recent version: 9.0 in September 2008.
Below, a complete tutorial of how to download and install this version.
Feel free to comment if you have any questions about this tutorial.
After that, we'll discuss many new features included in this version, as the new "Save" option. Now you can save your specs in a file and restore in another location without deployment, just using OMW.
So, let's rock!
The first step is to download the DEMO version to your machine.
Go to http://edelivery.oracle.com/ click Continue 1. Media Pack Search
Choose JDEdwards Enterprise One and your platform