Correcting pipeline errors

If the pipeline cannot pipe certain rows to the destination table for some reason, PowerBuilder displays the following information for the error rows:

• Name of the table in the destination database

• Pipeline operation you chose in the Option box

• Error messages to identify the problem with each row

• Data values in the error rows

• Source and destination column information

The following screen shot displays this information:

You can correct the error rows by changing one or more of their column values so the destination table will accept them, or you can ignore the error rows and return to the Data Pipeline painter workspace. If you return to the workspace, you cannot redisplay the error rows without re-executing the pipeline.

1. Click the Design button.

1. Change data values for the appropriate columns in the error rows.

2. Click the Update DB button, or select Design>Update Database from the menu bar.

   PowerBuilder pipes rows in which errors were corrected to the destination table and displays any remaining errors.

3. Repeat steps 1 and 2 until all errors are corrected.

   The Data Pipeline painter workspace displays.

Sometimes you cannot see an entire error message because the column is not wide enough. Move the pointer to the error message and press the Right Arrow key to scroll through it. You can also drag the Error Message column border to the width needed.