Correcting pipeline errors – PB Docs 2017

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

What you can do

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.

Before you return to the workspace

You might want to print the list of errors or save them in a
file. Select File>Print or File>Save As from the menu
bar.

To return to the Data Pipeline painter workspace without
correcting errors:

  • Click the Design button.

To correct pipeline errors:

  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.

Viewing an error message

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.

Making the error messages shorter

For ODBC data sources, you can set the MsgTerse database
parameter in the destination database profile to make the error
messages shorter. If you type MsgTerse = ‘Yes’, then the SQLSTATE
error number does not display. For more information on the MsgTerse
parameter, see the section called “MsgTerse” in Connection Reference.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x