Purpose

To display errors written to the System Error Log.

SubSystem

General

The error messages displayed in pop-up alert boxes on Callista screens can be broadly divided into two groups:

• Application Error and Warning Messages (and 'handled' System Errors) - messages that advise when a validation triggers an error or warning during the use of a Callista form or function. These messages are generally self-explanatory and are intended for immediate advice to the user. They are distinguishable from System Error Messages by having the words 'Message' or 'Error' in the title bar of the pop-up alert.
• System Error Messages - messages that advise when an unexpected event has occurred in the underlying Oracle Database Management System. They have the word 'Forms' in their title bar. These error messages tend to be more cryptic. They would generally be noted by the user for later investigation by a technical support person. The following is an example of a System Error Message.
  

This form is used to view details of System Errors. Most users will not have access to this form. They should record the details displayed in pop-up alerts and pass these on to their technical support people. A 'technical' person should then use this form to obtain details of the System Error.

Details of how the information displayed in this form should be used, is available in the Callista Product Centre (wiki.callista.com.au/display/CPC).

The System Error Log block contains:

• Sequence Number
• Program Unit
• SQL Error Number
• SQL Error Message
• Additional Detail
• Back Trace Detail
• Updated By
• Updated On

Rules/Notes:

The Additional Detail field allows 4000 characters to be displayed.

The Back Trace Detail function allows the user to identify the block of code in which the error was raised. The user can log the critical line number, even if the exception is re-raised further up in the stack. Having accurate line information, even of wrapped code, makes identification of error code in the database easier.

2011 - Calipso

Updated reference and link to the tech docs in the CPC wiki space.