How to enable hooks and prevent auto-disablement when runtime errors are encountered in TIBCO Data Virtualization?

How to enable hooks and prevent auto-disablement when runtime errors are encountered in TIBCO Data Virtualization?

book

Article ID: KB0072200

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

This article provides details to enable hooks and prevent auto-disablement when runtime errors are encountered in TIBCO Data Virtualization (TDV). 

Issue/Introduction

How to enable hooks and prevent auto-disablement when runtime errors are encountered in TIBCO Data Virtualization?

Environment

All Supported Operating Systems

Resolution

Follow the below steps: 
1. Hooks can be enabled by tuning the Server Configuration "Enable Hooks" to "True" (By default this is set to False). This setting can be accessed via Studio - Administration -> Configuration -> Server -> Configuration -> Hooks -> Enable hooks.
Restart (reopen) Studio for this to take effect.
Note: If true, then installed hooks will be applied to all incoming SQL and procedure requests. This also disables all performance advantages from prepared statements. If false, hooks are not used even if present, and prepared statements run normally. The use of hooks is strongly discouraged in production systems as they can lead to performance and stability problems with the server depending on the logic in installed hooks. You may be requested to disable hooks when contacting TIBCO Support.

2. Once hooks are enabled, select the menu item Administration -> Custom hooks, to choose any hooks that have been created.

3. When there are runtime errors encountered, the hooks will be disabled automatically. To prevent this auto-disablement, you need to tune the setting "Prevent Disablement" to True. By default this option is set to "False".

Screenshot of the configuration for reference:
User-added image