You are here:

Rejected Source Rows Tab

Use the Rejected Source Rows tab in the DTS Settings dialog to create an output table or file (rejected row log) to capture rejected rows when running a job. This feature enables you to save any rejected rows to a table from which you can reprocess only the rejected rows, rather than reprocessing the entire source.

To select the location for the rejected row table

Select Output Rejected Source Rows to enable rejected row logging.
Either select a connection from the Connection drop-down list, or click New to create a new connection. While you can select any write-enabled connection; TIBCO suggests using the default, Scribe Internal Database.
If the table requires a table owner to create a table, enter the name in the Table Owner field. If you select Scribe Internal Database as the connection, the table owner must be SCRIBE; in this case, the Table Owner is set to SCRIBE and this field is disabled.
Select how you want to save the rejected rows:
- Always append rejected rows to the same table — Creates a table that will contain all of your rejected rows.
  Enter the table name in the Table field and click Create Table Now. If the "You must save your changes... message displays, click Yes.
  Optionally, click View Data Objects to select from the list of available data objects in the rejected row data source.
- Always create a new table for rejected rows — Creates a new table every time you run a job.
  Enter a prefix for the table. The prefix can be up to 8 characters in length. The resulting table name is the prefix appended to a 10 character name that represents the time the table was created.
  The rejected row table is not created until Insight encounters the first rejected row.
Note: If your site is upgrading to Version 7 or later of TIBCO Scribe® Insight and Output Rejected Source Rows is set to Output to Other, Insight automatically creates a new connection called REJECTEDROWS that is used to store the rejected row table.