PowerExchange for LDAP User Guide for PowerCenter

10.5
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.4.0

Back Next

Error Handling for LDAP Targets

You can set the error threshold for a session. In the Stop on Errors session property, enter the number of non-fatal errors the PowerCenter Integration Service can encounter before it fails the session.

When the PowerCenter Integration Service writes data to an LDAP target, the PowerCenter Integration Service counts the duplicate and orphan rows as non-fatal errors.

The following table describes the behavior of the PowerCenter Integration Service based on the session properties:

Stop on Errors	Orphan Row Handling	Duplicate Parent Row Handling	Description
0	n/a	n/a	The PowerCenter Integration Service writes all rows except the duplicate, orphan, and invalid rows to the target.
>0	Ignore	Error	If the number of duplicate rows in the source data reaches the error threshold, the PowerCenter Integration Service does not write data to the target and the session fails.
>0	Error	First Row or Last Row	If the number of orphan rows in the source data reaches the error threshold, the PowerCenter Integration Service does not write data to the target and the session fails.
>0	Error	Error	If the sum of orphan row count and duplicate row count in the source data reaches the error threshold, the PowerCenter Integration Service does not write data to the target and the session fails.
>0	Ignore	First Row or Last Row	The PowerCenter Integration Service starts writing data into the target. If the non-fatal error count reaches the error threshold, the PowerCenter Integration Service does not write data to the target for that entry and the session fails. However, the PowerCenter Integration Service writes the data to the target for the previous entries.

Set the following values for the PowerCenter Integration Service to write data into the target:

Error threshold to a value greater than 0

Orphan row handling and duplicate parent row handling to error

The session fails when the PowerCenter Integration Service starts writing the data to the target, and the sum of duplicate row count, orphan row count, and other non-fatal error count reaches the error threshold.

When the Duplicate Parent Row Handling is set to error and the number of duplicate rows reaches the duplicate row error count, the session fails.

When the Orphan Row Handling is set to error and the number of orphan rows reaches the orphan row error count, the session fails.

The PowerCenter Integration Service does not display the number of duplicate and orphan rows for each group as part of the LDAP session load summary. When the orphan row handling is set to error, the PowerCenter Integration Service writes the total number of orphan rows in the session log. When the duplicate row handling is set to error, the PowerCenter Integration Service writes the total number of duplicate rows in the session log.

Rename Saved Search

Table of Contents

PowerExchange for LDAP User Guide for PowerCenter

PowerExchange for LDAP User Guide for PowerCenter

Error Handling for LDAP Targets

Error Handling for LDAP Targets