How to view the database queries in the PASOE log files

This guide provides information on how to view the database queries in the PASOE log

1. Summary
2. Result
3. Step by Step Guide
3.1 Step 1
3.2 Step 2
3.3 Step 3

1. Summary

There are cases where you want to check the query that is sent to the database, from OpenEdge (ex. checking which indexes are being used)

2. Result

Once enabled, the PASOE log file will be populated with the following data fetch entries:

DataAccess     Client-Query: FOR EACH eSmartObjectType WHERE  BY eSmartObjectType.ObjectTypeGuid
DataAccess     Default-Query: FOR EACH SmartObjectType INDEXED-REPOSITION
DataAccess     Prepare-Query: FOR EACH SmartObjectType BY SmartObjectType.ObjectTypeGuid INDEXED-REPOSITION
DataAccess     Index Information on Buffer SmartObjectType: WHOLE-INDEX,ObjectTypeGuid
DataAccess     Restart-Rowid for Table eSmartObjectType: ?
DataAccess     Next-Rowid for Table eSmartObjectType: ?
DataAccess     Last-Batch for Table eSmartObjectType: yes

3. Step by Step Guide

3.1 Step 1

Open src/backend/startup.json file (or create it, if it doesn’t exist); it should have the following content:

{
  "basedOn": "Akioma/Swat/Server/startup_swat_appserver.json",
  "inheritStaticProperties": true,
  "staticProperties": {
    "Consultingwerk.OERA.DataAccess:LogFetchDataDetails": false,
    "Consultingwerk.SmartFramework.Menu.MenuBusinessEntity:CacheMenuAtStartup": false,
    "Consultingwerk.SmartFramework.System.MessageBusinessEntity:CacheMessagesAtStartup": false
  },
  "applicationSettings": ".restapplicationsettings",
  "inheritLoadServices": true,
  "loadServices": ["services.xml"],
  "inheritManagers": true,
  "managers": {},
  "inheritCustomLogEntries": false,
  "customLogEntries": [],
  "inheritAliases": true,
  "aliases": {},
  "sessionExport":  null,
  "environment": {
    "ensureAbsolutePropath": true,
    "applicationPropath": []
  }
}

3.2 Step 2

Change the following settings inside the file:

Inside staticProperties change the Consultingwerk.OERA.DataAccess:LogFetchDataDetails to true

And add a new entry to customLogEntries: DataAccess

The content of the file should now be:

{
  "basedOn": "Akioma/Swat/Server/startup_swat_appserver.json",
  "inheritStaticProperties": true,
  "staticProperties": {
    "Consultingwerk.OERA.DataAccess:LogFetchDataDetails": true,
    "Consultingwerk.SmartFramework.Menu.MenuBusinessEntity:CacheMenuAtStartup": false,
    "Consultingwerk.SmartFramework.System.MessageBusinessEntity:CacheMessagesAtStartup": false
  },
  "applicationSettings": ".restapplicationsettings",
  "inheritLoadServices": true,
  "loadServices": ["services.xml"],
  "inheritManagers": true,
  "managers": {},
  "inheritCustomLogEntries": false,
  "customLogEntries": ["DataAccess"],
  "inheritAliases": true,
  "aliases": {},
  "sessionExport":  null,
  "environment": {
    "ensureAbsolutePropath": true,
    "applicationPropath": []
  }
}

3.3 Step 3

Trim the PASOE so that the changes are registered.

Back to Use Cases

Back to Build.One Help-Center Home