Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "FATAL ERROR : An unexpected condition occurred in file [/export/home/build_root/861HotFix_build/powrmart/common/odl/oracle8/oradbcol.cpp] line [1539]. Aborting the DTM process" when a session fails in PowerCenter
Problem Description

In PowerCenter, a session fails with the following error:

2010-04-21 15:30:00 : FATAL : (18671 | ) : (IS | intg_BIG_Dev) : node01_puck001 :  :  *********** FATAL ERROR : An unexpected condition occurred in file [/export/home/build_root/861HotFix_build/powrmart/common/odl/oracle8/oradbcol.cpp] line [1539].  Aborting the DTM process.  Contact Informatica Global Customer Support. ***********

Cause
This issue occurs when the order of columns in the SELECT query does not match the order of columns in the database table.
Solution
To resolve this issue, modify the SELECT query in the SQL override to match the database column in the Oracle table.
More Information

This issue can also occur when an incorrect Oracle connection is used for the source connection.

Example

When the source table is a DB2 database type and an Oracle connection is assigned to the source connection in the workflow manager client.

To resolve this issue, assign the correct DB2 connection for the source.

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.6.1
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/9/2011 10:13 PMID:112958
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)