Foglight for PeopleSoft 5.6.11 - User and Reference Guide


Field	Description
Message	The text provided by the agent describing the error condition. This text is displayed in the agent error rule.
MessageCT	Number of identical messages during the polling cycle.
MessageID	Unique agent message id, each error would start with the agent prefix followed by a three-digit number. For PeopleSoft, it would be PSFT_000, PSFT_001, and so on. Refer to the tables below for the PeopleSoft Agent Message Numbers and descriptions.
Severity	Severity of the agent error condition, for example Informational, Warning, Critical, Fatal.

The following are the PPMI error codes, along with the severity and type of error for each:


Error Code	Severity	Message Text
PPMI_10	Fatal	Login Failure
PPMI_11	Fatal	Object Not Found
PPMI_20	Fatal	Invalid Object
PPMI_30	Fatal	Malformed URL
PPMI_100	Fatal	Internal Error
PPMI_101	Warning	Invalid Session
PPMI_200	Fatal	Invalid Request

The following are the error codes and messages defined internally in the PS_PPMI Agent along with the type of each error code:


Error Code	Type	Message Text
PSFT_1000	Informational	Successfully Registered with PPMI Server
PSFT_1001	Informational	Successfully Registered PS_Listener
PSFT_1002	Informational	Successfully Started and Pinged PS_Listener
PSFT_1100	Warning	Invalid PPMI Session...Re-registering Notification Interest
PSFT_1101	Warning	Invalid Max Number of Notification Objects agent property. Must be between 100 and 200
PSFT_1200	Critical	Failed to Connect...Communication Failure
PSFT_1300	Fatal	Internal Error: Failed to Initialize EnterpriseSummaryBridge:
PSFT_1301	Fatal	Internal Error: Failed to Initialize PPMIController
PSFT_1302	Fatal	Internal Error: Failed to Initialize Notification Set
PSFT_1303	Fatal	Internal Error: Failed to Initialize DescriptionSet
PSFT_1500	Fatal	Invalid Listener Port
PSFT_1501	Fatal	Invalid SSL Certificate Password Phrase
PSFT_1502	Fatal	Invalid SSL Randon File Path
PSFT_1503	Fatal	Invalid SSL Randon File Byte Size
PSFT_1504	Critical	Failed to Get Root Object
PSFT_1505	Critical	Failed to Register Notification
PSFT_1506	Critical	Failed to Register Listener
PSFT_1507	Critical	Failed to Ping PPMI Server
PSFT_1508	Critical	Failed to Get Description Set from PPMI Server
PSFT_1509	Fatal	Failed to Post Listener Collect Command
PSFT_1510	Critical	Failed to Stop PS_Listener Process
PSFT_1511	Critical	Failed to Start PS_Listener Process
PSFT_1512	Fatal	Failed to Ping PS_Listener

PPMPeoplesoftAppServerSummary Data Table

The PPMPeoplesoftAppServerSummary table provides the following metrics for a detailed analysis of PeopleSoft application servers:


Field	Description
AvgDurationTime	The average execution time for completed 400 PMUs per PeopleSoft domain during a collection interval, in seconds.
AvgPeopleCodeBuiltInSQLTime	The total PeopleCode BuiltIn SQL Execution Time, in seconds. The average time spent executing built-in SQL statements in a single application server request per PeopleSoft domain. Built-in SQL requests are generated within a PeopleCode built-in function and are executed when that function is called. This value includes the time required for SQL Prepare, Execute, Fetch, and Commit.
AvgPeopleCodeExecTime	The execution time for PeopleCode from completed 400 PMUs per PeopleSoft domain during a collection interval, in seconds.
AvgPeopleCodeSQLTime	The execution time for SQLExec and SQL object, in seconds. The average time spent executing SQL statements initiated from PeopleCode in a single application server request per PeopleSoft domain. This value includes the time required for SQL Prepare, Execute, Fetch, and Commit. PeopleCode SQL statements are executed by application code written using PeopleCode and submitted to the database by way of SQLEXECs and/or SQL Objects.
AvgPeopleToolsSQLTime	The SQL time excluding PeopleCode and BuiltIn SQL, in seconds. The average time spent executing PeopleTools SQL statements in a single application server request per PeopleSoft domain. This includes the time required for SQL Prepare, Execute, Fetch, and Commit. PeopleTools SQL statements are all non-PeopleCode and non-Built-in SQL statements executed by the PeopleTools runtime. For example, this includes SQL executed for cache management and component processing.
AvgSQLExecCount	The SQL Execute Count per PeopleSoft domain during a collection interval.
AvgSQLFetchCount	The total number of rows fetched from the database per PeopleSoft domain during a collection interval.
CacheMisses	The manager cache misses resulting in object fetches from the database, aggregated per PeopleSoft domain during a collection interval.
FileCacheHits	The manager cache hits resulting in object fetches from file, aggregated per PeopleSoft domain during a collection interval.
LoadPct	The PeopleSoft domain's percentage of contribution to the total PeopleSoft enterprise load during a collection interval.
MemCacheHits	The manager cache hits resulting in object fetches from memory, aggregated per PeopleSoft domain during a collection interval.
PeoplesoftAppServer	The name of the PeopleSoft application domain, which comprises all 400 PMUs aggregated across the PeopleSoft enterprise.
PMUCount	The number of completed 400 PMUs executed per PeopleSoft domain during a collection interval.

PPMPeoplesoftEnterpriseSummary Data Table

The PPMPeoplesoftEnterpriseSummary table provides the following metrics for a detailed analysis of a PeopleSoft enterprise:


Field	Description
AppServerAvgDurationTime	The average execution time for all completed PMUs aggregated at the application server tier level during the collection interval, in seconds.
AvgDurationTime	The average execution time for all completed 101 and 100 PMUs at the PeopleSoft enterprise level during the collection interval, in seconds.
AvgPeopleCodeBuiltInSQLTime	The average time spent executing built-in SQL statements for all completed 101 and 100 PMUs at the PeopleSoft enterprise level during the collection interval, in seconds.
AvgPeopleCodeSQLTime	The average time spent executing SQL statements initiated from PeopleCode for all completed 101 and 100 PMUs at the PeopleSoft enterprise level during the collection interval, in seconds.
AvgPeopleToolsSQLTime	The average time spent executing PeopleTools SQL statements for all completed 101 and 100 PMUs at the PeopleSoft enterprise level during the collection interval, in seconds.
DurationTimeServiceLevel	For the enterprise, the percentage of duration times that meet the service level for the enterprise duration time.
DurationTimeServiceLevelThreshold	For the enterprise, the service level used in calculating DurationServiceTimeLevel.
LongPMUCount	The number of long PMUs per collection interval determined by agent property Long Running PMU Threshold.
PeopleSoftEnterpriseName	The name of the PeopleSoft enterprise.
PMUCount	The number of 101 and 100 PMUs executed during the collection period.
PMUDistributionCount1	The count of PMU requests with an average duration time between zero to two seconds.
PMUDistributionCount2	The count of PMU requests with an average duration time between two to four seconds.
PMUDistributionCount3	The count of PMU requests with an average duration time between four to eight seconds.
PMUDistributionCount4	The count of PMU requests with an average duration time between eight to 16 seconds.
PMUDistributionCount5	The count of PMU requests with an average duration time greater than 16 seconds.
PMUDistributionPercent1	The percent of PMU requests with an average duration time between zero to two seconds.
PMUDistributionPercent2	The percent of PMU requests with an average duration time between two to four seconds.
PMUDistributionPercent3	The percent of PMU requests with an average duration time between four to eight seconds.
PMUDistributionPercent4	The percent of PMU requests with an average duration time between eight to 16 seconds.
PMUDistributionPercent5	The percent of PMU requests with an average duration time greater than 16 seconds.
UserCount	The number of unique users to execute a completed PMU at the PeopleSoft enterprise level during the collection interval.
WebServerAvgDurationTime	The average execution time for all completed PMUs aggregated at the web server tier level during the collection interval, in seconds.

PPMPeoplesoftLongPMUs Data Table

The PPMPeoplesoftLongPMUs table provides the following metrics for analysis of captured long running PMUs (Performance Monitoring Units).


Field	Description
ClientAction	Client action status of the long running PMU.
ClientActionData	Data executed by the long running PMU.
ClientIP	Client IP address.
DurationTime	Duration time of the PMU.
Instance	Self instance of the transaction.
LastTime	PMU's last time.
PeoplesoftUserID	ID of the PeopleSoft user.
ResponseSize	Size of the response in bytes.
StartTime	PMU start time.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

PS_PPM PPMAgentMsgs Data Table

PPMPeoplesoftAppServerSummary Data Table

PPMPeoplesoftEnterpriseSummary Data Table

PPMPeoplesoftLongPMUs Data Table