Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 16 Processing in Standard Execution Mode : System Log

System Log
When a rule fails in its execution and the exception is not handled, error messages and debugging information for that transaction (and parent transactions) are supplied in the system log. Using the information from the system log, you can make corrections to your rule so that it can execute successfully. If you require more debugging capabilities, you can use the Rule Debugger. Refer to Chapter 18, Processing in Debug Mode for more information.
Sample Rule
The following is an example of a rule that could produce the system log information shown in Sample System Log.

 
RULE EDITOR ===> SCROLL: P
NEWMANAGER(YEAR, DEPT#);
_
_ ---------------------------------------------------------------------------
_ YEAR < 96; | Y N N
_ YEAR > 97; | Y N
_ ------------------------------------------------------------+--------------
_ CALL ENDMSG('95 IS THE EARLIEST VALID YEAR'); | 1
_ CALL ENDMSG('THIS AN INVALID YEAR'); | 1
_ FORALL EMPLOYEES WHERE REGION = 'MIDWEST' & DEPTNO = DEPT# | 1
_ : |
_ EMPLOYEES.MGR# = EMPLOYEES.EMPNO; |
_ REPLACE EMPLOYEES; |
_ END; |
_ ---------------------------------------------------------------------------
PFKEYS: 1=HELP 3=END 12=CANCEL 13=PRINT 14=EXPAND 2=DOCUMENT 22=DELETE

 
Sample System Log

 
-------------------------- INFORMATIONAL MESSAGE LOG --------------------------
COMMAND ===> SCROLL ===> P
Error detected in rule ”NEWMANAGER” at action 3 FORALL statement 2
Access error on TABLE ”EMPLOYEES”
REPLACE EMPLOYEES
Invalid number of parameters supplied for table ”EMPLOYEES”
Traceback of rules called at time of error
NEWMANAGER(96,10)
End of traceback
-------------------------------------------------------------------------------
No local variables
Dump of active tables
Table EMPLOYEES
EMPNO = 44385
LNAME = 'SOUZA'
POSITION = 'SALES'
MGR# = 44385
DEPTNO = 10
SALARY = 719.00
ADDRESS = ''
CITY = ''
STATE_PROV = ''
PFKEYS: 2=NEXT LOG 3=EXIT 5=REPEAT 12=EXIT 13=PRINT 4=PRS

 
What Output is Available?
The system log is cleared if the transaction ends and a new transaction begins (for example, as with the TRANSFERCALL statement). Only output from the most recent transaction is available to display. The following types of output appear:
Event Logging
The system log can also contain an event log for event rules. This information identifies the location, cause, and dump of active tables and local variables at the time of an error in a derivation, trigger, or validation rule for a table. The following is an example of an event log.

 
=========== Trigger for table "DEPARTMENTS" ==== level 1 ==========
Trigger rule "INSERTDEPTNO" for table "DEPARTMENTS" failed at action 3
Traceback of rules called at time of error
INSERTDEPTNO
End of traceback
------------------------------------------------------------
No local variables
Dump of active tables
Table DEPARTMENTS
DEPTNO = 30
DEPTNAME = 'CUST SUPPORT'
End of table dump
 
 
PFKEYS: 2=NEXT LOG 3=EXIT 5=REPEAT 12=EXIT 13=PRINT 4=PRS

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved