Using xSQL Builder

Error Handling

 

The executable package you create with xSQL Builder contains the code to capture, save, report and handle any error that might occur when it runs on the client machine. The following rules apply to error handling:

• If an error occurs during the package execution, the error is logged and the entire process stops. An email notification is sent to the designated email account if the “Send on Failure” or “Send on Completion” email notification has been configured. The error log file is appended to the failure email notification by default.
• If a step fails, only that step is rolled back. You might have specified a set of post-sync script to run after the synchronization, which is treated as one step. If one of the scripts fails, the entire set of post-sync scripts is rolled back. All the steps that have completed successfully prior to the failing step are committed to the database, they are not rolled back.
• In the package fails, it returns a specific error code that identifies the type of exception. You can inspect all the error codes in the code template project.

The Appendix B contains the list of the error codes that can be retuned by the executable package.