Foglight for PeopleSoft 5.6.11 - User and Reference Guide


Field	Description
Spawning (%)	The percent of process spawning found during the collection interval. Zero percent should be the normal value if MinInstances = MaxInstances, which is the recommended configuration by PeopleSoft.
InstancesFound	The number of instances the agent found.
LogicalId	The logical machine on which servers associated with this queue are active.
MaxInstances	The max instances that defined in the .ubb file. The agent alerts once through the agent message table about min != max && current == max.
MinInstances	The minimum instances that defined in the .ubb file.
PS_Domain	The name of the domain containing the application process being monitored.
PctFound	The number of process instances found, expressed as a percentage of instances expected.
Percent_CPU	The percentage of CPU resources used by all the instances of a process in an application.
Percent_Memory	The percentage of memory used by all the instances of a process in an application.
Process	The scheduler server process (PSDSTSRV, PSAESRV, and so on) configured to service a particular queue.
RequestsEnqueued	The number of requests enqueued from the TA_SOURCE logical machine during the collection period at the time of data collection. A value greater than zero for the Requests enqueued indicates a queuing state where some requests or services are active and waiting in a queue for the corresponding application server process to process those requests. If request enqueued values greater than zero are observed for a number of consecutive collection cycles, it might indicate an insufficient number of instances of that application server process are configured within the application server domain to process requests from clients. NOTE: If the T_DOMAIN:TA_LDBAL attribute is N or the T_DOMAIN: TA_MODEL attribute is MP, this field does not return a value. Therefore, when this field does return a value, TA_LMID and TA_SOURCE have the same value. These values can be configured in the psappsrv.ubx configuration file.
ResidentSetSize	The total amount of physical memory used for the monitored processes.
TotalEnqueued	Typically, the number of requests that is currently being processed by the application server process belonging to its queue at the time of data collection.
VirtualSetSize	The total amount of swap space used for the monitored processes.

PS_Scheduler Agent Tables

The PS_Scheduler agent contains the following tables. Select the table name to view the field definitions.

•

PS_Scheduler AgentMsgs Data Table

•

PrcsTypeSummary Data Table

•

QueueJobs Data Table

•

QueueJobSummary Data Table

•

QueuePrcs Data Table

•

QueuePrcsSummary Data Table

•

ReportDistributionAgent Data Table

•

ReportDistributionPrcs Data Table

•

ReportDistributionPrcsSummary Data Table

•

RunPrcs Data Table

•

SchedConfig Data Table

•

SchedProcess Data Table

PS_Scheduler AgentMsgs Data Table

The AgentMsgs (Agent Messages) Table logs information about the PS_Scheduler agent.


Field	Description
Message	The text provided by the agent describing the error condition. This text is displayed in the agent status rule.
MessageCnt	Number of Identical Messages for a current collection cycle.
MessageID	Unique agent message id, each error would start with an agent prefix followed by a three-digit number. For example, Oracle = ORA001, Sybase = SYB002, Weblogic6 = WLS6001. Each agent would be responsible for providing help text describing the possible error conditions to be associated with an agent error rule.
Severity	Severity of the agent error condition, for example, Informational, Warning, Critical, Fatal.

The following are database SQL query errors:


Message ID	Severity	Message Text	User Action
PS_OEXP_002	Critical	PS_Scheduler Agent: OEXP SQLERROR	Contact Dell Support.
PS_OEXP_002	Critical	PS_Scheduler Agent: OEXP SQLERROR STATE	Contact Dell Support
PS_OEXP_003	Critical	PS_Scheduler Agent: OEXP SQLERROR MSG	Contact Dell Support.
PS_OEXP_004	Critical	PS_Scheduler Agent: OEXP SQLERROR STATEMENT	Contact Dell Support.
PS_OEXP_005	Critical	PS_Scheduler Agent: OEXP SQLERROR VAR	Contact Dell Support.
PS_OEXP_006	Critical	PS_Scheduler Agent: OEXP UNDEFINED ERROR	Contact Dell Support.

The following are DCM/agent property related messages:


Message ID	Severity	Message Text	User Action
PS_SCH_100	Critical	PS_Scheduler - DCMs / Binary are NOT version compatible	Validate that the Foglight for PeopleSoft installation is successful. For further assistance, contact Dell Support.
PS_SCH_101	Critical	Invalid ASP - Database Login or Password not defined. Agent Exiting.	Validate agent property Database Login and Password.
PS_SCH_102	Critical	Invalid ASP - PeopleSoft Home Directory Does Not Exist	Validate agent property PeopleSoft Home directory.
PS_SCH_103	Critical	Invalid ASP - Database(DB2/Oracle/MSSQL) Home Directory Does Not Exist	Validate agent property Database Home.
PS_SCH_104	Critical	Invalid ASP - DB2 Instance is Empty. Agent Exiting.	Validate agent property DB2 Instance.
PS_SCH_105	Critical	Invalid ASP - DB2 Home Directory is Invalid...failed to find	Validate agent property DB2 Home Directory.
PS_SCH_200	Informational	Agent agent property: PeopleSoft Home = [PS_Home]	N/A
PS_SCH_201	Informational	Found PS Scheduler Configuration File File_Name	N/A
PS_SCH_202	Critical	Failed to read PS Scheduler configuration file.	Validate Scheduler configuration path. See Agent ShowLog for more information.
PS_SCH_203	Warning	Failed to read the updated configuration.	Validate Scheduler updated configuration path.
PS_SCH_220	Critical	Mismatched DBType Sched Config=DBType	Validate agent property database type is the same as what is defined in PeopleSoft configuration file.
PS_SCH_221	Warning	Found multiple db owners for database & using first found.	No action required. Agent uses first database owner found.
PS_SCH_222	Critical	Failed to find a db owner for database	Contact your PeopleSoft administrator for support.
PS_SCH_223	Informational	DB Owner Found	N/A
PS_SCH_224	Critical	Database Type is not supported	Validate database type is supported for your platform.
PS_SCH_225	Critical	Failed to load the Quest DB Shared Library.	Validate Database Home Directory. See Agent ShowLog for more information.
PS_SCH_226	Informational	Successfully loaded DB Shared Library	N/A
PS_SCH_227	Informational	Successfully Connected to Database	N/A
PS_SCH_228	Critical	Failed to Connect to Database	Validate Login name and password. See Agent ShowLog for more information.
PS_SCH_229	Warning	The Oracle Version Selected in agent property Does Not Match Database Version.	Validate that agent property Oracle version matches database server.
PS_SCH_240	Informational	People tools version is	N/A
PS_SCH_241	Critical	Failed to determine the people tools version	See Agent ShowLog for more information.
PS_SCH_250	Warning	Failed to open Batch PID File	See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_251	Warning	Failed to read Batch PID File	See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_252	Warning	Failed to stat Log PID File	See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_253	Warning	Failed to open Log PID File	See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_254	Warning	Failed to stat Log PID File	See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_255	Warning	No PID Log File Found	See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_256	Informational	Scheduler is Running	N/A
PS_SCH_257	Informational	Scheduler is Online & process found	N/A
PS_SCH_258	Warning	Scheduler process not found	Validate Scheduler is running. See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_259	Informational	Report Distribution is online & process found	N/A
PS_SCH_260	Warning	Report Distribution & process not found	Validate Report Distribution Process is running. See Agent ShowLog for more information. For further assistance, contact Dell Support.
PS_SCH_270	Warning	Max detail rows per cycle agent property value has exceeded the max limit	Reset agent property value to Max Limit.
PS_SCH_271	Warning	Number of scheduler jobs exceeded max details rows limit.	For the complete list of jobs check the PeopleSoft Scheduler.
PS_SCH_272	Warning	Number of scheduler processes exceeded max details rows limit.	For the complete list of processes check the PeopleSoft Scheduler.
PS_SCH_273	Warning	Number of report distribution processes exceeded max details rows limit.	For the complete list of processes check the PeopleSoft Report Distribution.
PS_SCH_300	Informational	Successful Data Collection	N/A
PS_SCH_999	Critical	Failed to initialize icu adapter validate resource file.	Contact Dell Support and verify installation status.

PrcsTypeSummary Data Table

The PrcsTypeSummary (Process Type Summary) Table logs information about the PS_Scheduler Agent.


Field	Description
Count	The number for a specific job.
PrcsType	The process type, for example, SQR, Query, COBOL, AE, and so on.
QueueDatabase	Concatenation of QueueName and Database Name.

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

SchedServer_Queue_Process_Totals Data Table

PS_Scheduler Agent Tables

PS_Scheduler AgentMsgs Data Table

PrcsTypeSummary Data Table