Using an Exceptions Table as a Source Table

If you want to publish data from an exceptions table and also want to use this exceptions table as the source table, you cannot use the ADB_ERROR_TEXT or ADB_OPCODE column names. Instead, follow these guidelines:

To resolve this issue, perform the following operations:
  1. Create a database view that mirrors the exceptions table, but rename the ADB_ERROR_TEXT and ADB_OPCODE columns so that they do not begin with "ADB_."
  2. Use the Publish by Reference Object feature and select your view as the reference object. For details about Publish by Reference, see Specifying a Reference Object.