Configuring Input Source Error Handling for View Models

Choose how data services deployed from this view model will behave if this input source is unavailable or unresponsive.

By default, a data service fails and returns an error if any of its input sources fails to respond. You can configure this Input Source element so that data services deployed from this view model run even when this input source is unavailable, or return an error upon receiving an empty result set.

  1. Double-click an Input Source element. The Input Source Properties dialog appears.
  2. Click the Error Handling tab in the Input Source Properties dialog. The dialog displays the error handling options for this view model.


  3. Select one of the options.
    • Stop the data service on errors from this input source.

      This is the default behavior. Choose this option if you don’t want the data service to run when this input source is unavailable.

    • Stop the data service on an empty result set or errors from this input source.

      Choose this option if you don’t want the data service to run when it receives an empty result set from this input source, or when this input source is unavailable.

    • Don’t stop the data service on errors from this input source; return an empty result set.

      Choose this option if you want the data service to run with an empty result set for this input source when this input source is unavailable.

  4. (Optional) If you chose Stop the data service on an empty result set, you can enter your own error message in the Empty Result Set Message field. If you chose Stop the data service on an empty result set and you don’t enter an error message here, Data Federation uses a default error message that says “<data-source> returned no rows.”
  5. Click OK to save your changes and close the dialog.
Next 

If your Input Source has parameters, map them to global view model parameters.

Related concepts
Specify Global Parameters
Related tasks
Configuring a Database Operation Input Source
Configuring a Data Service Input Source
Configuring a File Input Source
Configuring an HTTP Input Source
Configuring a Web Service Input Source
Configuring Transformations for Nonrelational Input Sources
Configuring a Delimited File Transform

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.