Configuration Manager

Error handling

There is a virtual client available, called 'ERRORHANDLER', for handling PRODBX errors to external programs.

If you want that for instance someone to get an e-mail when the connection with the database is broken (error 5024), you can configure a tables and mappings entry in the configuration manager for this error.

Follow this procedure:

  • Go in the 'Source tables and Mapping' section of the configuration manager and select 'New...'
  • Select 'ERRORHANDLER' at the 'Source connection name' input list.
  • Type the error number in the field 'Error number'. This is a number between 5000 and 6000. Other numbers (such as the 3000 range) are not supported.
  • Enter the error attribute. This can have 4 values:
    - NUMBER: the error number itself
    - TEXT: the literal text of the error
    - LEVEL: 1= non-critical, 2= critical, 3= blocking
    - TYPE: possible values: SYSTEM, APPLICATION, SECURITY
  • All other entries are as usual.

For example: if you want to send a mail to 'gizzmo@gremlins.org' when error 5024 occurs.

  • Create a mail type client
  • Create a number of 'tables and mapping' entries with ERRORHANDLER as source connection.
  • Error number= 5024, Error attribute= NUMBER, primary key enabled, translate function= DEFAULT_STRING, parameter1= gizzmo@gremlins.org, destination table= MESSAGE, destination field= To
  • Error number= 5024, Error attribute= NUMBER, primary key disabled, multiple use number= 2, translate function= SIMPLE, destination table= MESSAGE, destination field= Subject
  • Error number= 5024, Error attribute= TEXT, primary key disabled, translate function= SIMPLE, destination table= MESSAGE, destination field= Body