Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Capture a Stored Procedure error when running a PowerCenter session
Solution

Although the repository validates and saves the mapping, the PowerCenter Designer does not validate whether or not the Stored Procedure expression runs without an error.

If the stored procedure expression is not configured properly, the session will fail. When testing a mapping using a Stored Procedure, do the following: 

  1. Set the Override Tracing session option to a verbose mode.
  2. Configure the On Stored Procedure session option to stop running if the stored procedure fails.

Configure these session options on the Error Handling settings of the Config Object tab in the session properties.

More Information
Reference
For more information, see "Stored Procedure Transformation" in the Transformation Guide.
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:5/22/2012 1:12 AMID:20457
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)