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


Chapter 5 Processing External DBMS Data : Error Handling and Recovery

Error Handling and Recovery
The TIBCO Object Service Broker runtime environment signals system exceptions, permitting an application to recover from an error. A three-level hierarchy of exceptions exists. The ERROR exception is the top of the hierarchy and is intended to be a catchall exception. Each exception traps the exceptions that appear below it in the hierarchy. All errors encountered when accessing external data through the Gateways are trapped under one of the TIBCO Object Service Broker exceptions listed below.
ERROR
An error is detected and no lower-level exception handler exists in the application.
ACCESSFAIL
An error is detected and no lower-level exception handler exists in the application.
INTEGRITYFAIL
An attempt to violate data integrity is detected and no lower-level exception handler exists in the application.
Permission for the requested action on the TIBCO Object Service Broker object is denied. This occurs if the connection ID does not have permission to perform the requested action on the specified object in TIBCO Object Service Broker. This can also occur if SECLEVEL=1 and the EXTERNALUSERID parameter is set to GROUP and the group name is greater than eight characters long.
A new transaction requested a Gateway and no Gateway is available. Control is passed back to the rule, so that the rule can try the transaction again. If this exception is raised too often, consider requesting more Gateways or reviewing the amount of work being done in your transactions.
The Gateways made a request to the external DBMS and got an error code that does not map to one of the specific TIBCO Object Service Broker exceptions. The ON SERVERERROR handler can call @SERVERERROR to parse the error message (contained in ENDMSG). You must pass @SERVERERROR the contents of RETURN_MESSAGE, which is in the following format:
pppSLnnnx serverid serveruserid: Message
The type of message (E for error, W for warning, and I for information).
The server user ID (IDPREFIX + ###) of the the Gateway.
A transaction is in progress when the connection to a Gateway breaks or the Gateway fails. Control is passed back to the rule for transaction cleanup.
See Also
TIBCO Object Service Broker Shareable Tools for more information on the @SERVERERROR and RETURN_MESSAGE tools.

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