Highlighted
Micro Focus Expert
Micro Focus Expert
132 views

(SM) Support Tip: How to troubleshoot a single schedule record

Sometimes it is necessary to troubleshoot a specific schedule record that is processed and deleted too fast to be manually updated, and to stop a background process to start a trace is not possible because a trace can be too big.

In order to take a trace for a specific schedule record, the following actions can be done:

1.   Create a trigger for schedule table and add the following script. The trigger should be “before add”.

if(record._class=="sla" && record.application=="sla.refresh.active.wrapper" && record.name.substr(0,30)=="SLA Refresh for probsummary:IM")   //This condition can be adjusted based on the schedule record characteristics

//The two values assigned below are the name of the debug background process that will be started.
record._class="sladebug";
record.sched_class="sladebug";
}

NOTE: Notice that this is an example of a schedule record that is processed by SLA, but it can be adjusted to any schedule record. Just determine what is a characteristic of the schedule record you are trying to troubleshoot and adjust the condition and assign the _class and sched_class values.

2.   Start the background process from command line with the debug parameters, for example:  

sm -bg scheduler sladebug 60 1 -RTM:4 -debugdbquery:999 -log:sladebug.log

NOTE: notice that sladebug above, is the name of the background process and is the same as the one assigned in the trigger in step 1.

3.   Once the traces is reviewed and it is confirmed that the data is valid, disable the trigger and the command line.
4.   The trace can be reviewed now to determine what the problem is.

 

Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.