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.
MessageID	Unique agent message id, each error would start with the agent prefix followed by a three-digit number. 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 PS_OracleSQL agent error messages:


Message ID	Severity	Message Text	User Action
PS_ORA_100	Informational	Using DB Share Library Version %s	Check if the Shared Library Version is as described in the online help.
PS_ORA_101	Informational	PeopleTools version is %s	None.
PS_ORA_102	Critical	PeopleTools version is not 7 or 8	Ensure that PeopleTools version is 7.x to 8.x.
PS_ORA_103	Informational	Successfully connected to Database	None.
PS_ORA_104	Warning	Expensive SQL has been identified and recorded	Check if this SQL has undue impact on the computer by tracking the resources used by PSProcessID from the UserData table.
PS_ORA_105	Warning	%s	Message contents point to action if needed.
PS_ORA_106	Critical	Failed to Load DB Share Library. %s	Check if the Dell Shared Library named exists.
PS_ORA_107	Critical	Failed to set Environment for ... %s	Check if required database client libraries are available.
PS_ORA_108	Critical	Failed to Create Object ... %s	Check if client computer is low on available physical memory.
PS_ORA_109	Critical	Database Connection Error: OTL Message Error: %	Message contents point to action if needed.
PS_ORA_109	Informational	Agent successfully reconnected to Database	None.
PS_ORA_110	Informational	%s	None.
PS_ORA_110	Warning	%s	Message contents point to action if needed.
PS_ORA_110	Critical	%s	Message contents point to action if needed.
PS_ORA_111	Informational	%s %s	None.
PS_ORA_111	Warning	%s %s	Message contents point to action if needed.
PS_ORA_111	Critical	%s %s	Message contents point to action if needed.
PS_ORA_112	Informational	%s %s %s	None.
PS_ORA_112	Warning	%s %s %s	Message contents point to action if needed.
PS_ORA_112	Critical	%s %s %s	Message contents point to action if needed.
PS_ORA_113	Critical	Agent property Oracle version mismatch, client version is newer than server	Use compatible database client version.
PS_ORA_114	Warning	Can not open the logfile: %s. Log SQL output switched off	The file path needs to be fixed.
PS_ORA_115	Critical	%s Database Type is not supported	If possible, reconfigure the agent properties to connect to a lower version of the database type desired.
PS_ORA_116	Informational	ResourceBundle initialized. Resource File Path = %s	None.
PS_ORA_117	Critical	Failed to initialize ResourceBundle. Resource File Path = %s	The resource file, PS_OracleSQL_en.res, may need to be replaced if missing.
PS_ORA_999	Critical	Failed to initialize icu adapter validate resource file.	Contact Dell Support and verify installation status.

PS_OracleSQL UserData Data Table

The UserData table contains information about the PeopleSoft user activity in the database. It collects information on which users are running what SQL statements along with the relevant application server domain and SQL metrics.


	NOTE: The DB_Monitoring value should be set to one in the application server domains connected to the PeopleSoft database instance being monitored, in order to get all the information in the UserData table. If “NA” displays in a field, then the information for that field is not available for that collection period. The logic for collecting SQL statements is changed as follows: SQL Statement logic: If SQL statement executions > 0 AND buffergets >0 AND HitRatio < n (n = agent property if enabled) If SQL statement executions > 0 AND buffergets >0 AND HitRatio < n (n = agent property if enabled) The user sees data in the UserData table only if Executions > 0 AND BufferGets > 0 and HitRatio < n (n = agent property if enabled, for example, if the Enable SQL Criteria Filter option is selected for the Oracle SQL Criteria agent properties. Otherwise, the UserData table does not post any data.