Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange Adapters for PowerCenter 10.5.1
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: Data Integration Using PowerExchange for SAP Dynamic ABAP Table Extractor
  4. Part 3: Data Integration Using ABAP
  5. Part 4: IDoc Integration Using ALE
  6. Part 5: Data Integration Using BAPI/RFC Functions
  7. Part 6: Data Migration
  8. Part 7: Business Content Integration
  9. Part 8: SAP BW Data Extraction
  10. Part 9: Loading Data to SAP BI
  11. Appendix A: Data Type Reference
  12. Appendix B: Code Pages and Unicode Support
  13. Appendix C: Glossary

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Back Next

Error Handling

Error Handling

In the Error Handling section of the Config Object tab, you must configure the SAP IS-U/CCS session to handle any error that occurs during data migration. The PowerCenter Integration Service increments the error count when it processes the following row types:
  • Duplicate row. Any legacy key that is not unique results in a duplicate row. Duplicate row handling is applicable to the parent group or the control input group.
  • Orphan row. Any value of the field data that does not match the value of the LegacyKey results in an orphan row. If the legacy key in the auto structure group is not present in the control input group, it results in an orphan row.
The following table describes the error handling properties that you can configure for an SAP IS-U/CCS transformation in a session:
Property
Description
Duplicate Parent Row Handling
Determines how the PowerCenter Integration Service handles duplicate parent rows. Choose one of the following values:
  • First Row. The PowerCenter Integration Service passes the first duplicate row to the target. The PowerCenter Integration Service rejects rows with the same primary key that it processes after this row.
  • Last Row. The PowerCenter Integration Service passes the last duplicate row to the target.
  • Error. The PowerCenter Integration Service passes the first row to the target. Rows that follow with duplicate primary keys increment the error count. The session fails when the error count exceeds the error threshold.
Default is First Row.
Orphan Row Handling
Determines how the PowerCenter Integration Service handles orphan rows during a session. Choose one of the following values:
  • Ignore. The PowerCenter Integration Service ignores orphan rows.
  • Error. The session fails when the error count exceeds the error threshold.
Default is Ignore.
Validate Field MetaData
Determines whether the metadata imported from the SAP System is current during run time. You have to provide the connection details for the specific SAP application server to be able to validate field metadata.
0 COMMENTS
We’d like to hear from you!