Within the ribbon for Matrices, you can enable logging of each Matrix execution. This is useful when matrices are taking too long to return results, or are showing incorrect results.
This setting causes MooD to print out details of the variables used to a debugging window on the computer where the execution occurred. Viewing this output requires a tool from Microsoft called DebugView. In versions of MooD post 16.082.x, this information is also output to the MooD section of the Windows Event Log, and thus, installation of DebugView is unnecessary.
The output can be copied from the debug window and pasted back into Business Architect to test the result in a controlled environment, and explore to the elements used in the variables.
- Download DebugView from Microsoft.
- Copy it to your target environment.
- If you wish to debug executions of an Active Enterprise site, then the logs are produced where the Internet Information Service is hosted.
- If you are debugging from Business Architect/Web Preview, then the output is produced on the machine hosting Business Architect.
- Extract the zip file
- Run the executable as Administrator
- Inside DebugView, make sure Capture Global Win32 is ticked.
- It may also help if you turn Auto-scroll OFF, as there will be a lot of continual output.
Configuring your matrix
- Go to your matrix in Business Architect and click Enable Logging on the Performance section of the Home Ribbon.
- In this example, I have created a matrix on a model showing items for sale in each department. There's also a drop down list for the department, and a box to dictate the minimum number of items we need. The default values for the boxes are (any) and 1, depicted here.
Viewing logging details
- Viewing this web page for the first time, and then looking at debug view, we should see a small grid of information as follows:
- If I now change the department filter to Clothing and the minimum filter to 500, I find the following in the Debug View Log - one entry for each change:
- If you notice - In addition to the time taken to execute each matrix, there's an XML-like line after each table.
- In DebugView, If you click on the line with the <VARIABLES> text, and press Ctrl+C to copy to your clipboard, this information can be pasted back into Business Architect
- This is also available in the source query windows, and in other similar places in MooD.
- Remember to stop DebugView when you no longer need it, as it will consume server memory.
- The result of each matrix with unique variables may result in data being cached. This will mean that you may not see every execution of the matrix, when the same variable values have been specified more than once.
- Remember to turn off matrix logging when not required.