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

"Error message: Incompatible data types in stream operation
Bad SQL : select /*+ NOPARALLEL */ /* FastReader */ Var info : Column: 11<UNKNOWN>, datatype in operator <</>>: otl_long_string()" while performing Fast Clone unload
Problem Description
Informatica Fast Clone (IFC) unload is failing with the following error:

* Contact support at support@informatica.com

* Fast Clone is running on host [XXXX] system [SunOS]

* Release [5.10] version [Generic_147147-26]

* Machine [XXX] CPU cores [64]

 

( 03:39:46.238818) First checkpoint ...

( 03:39:46.240170) First checkpoint complete ...

( 03:39:46.240275) Second checkpoint ...

( 03:39:46.240844) Second checkpoint complete ...

 

Error message: Incompatible data types in stream operation

Bad SQL : select /*+ NOPARALLEL */ /* FastReader */ AAA,BBB,STATUS,DATE_CREATED,CCC,GG_STATUS,DDDD,EEEEEE,TTTTT,YYYYYY,REQUEST,WE,XXXXX,SSSS,PURCHASE_DATE,EXPIRATION_DATE,
CANCELLATION_DATE,BBBB,NNNN,HHHH,DELETED_TS,LAST_UPDATED from QQQ.XXXXX where rowid between :XXXXand :YYY

Var info : Column: 11<UNKNOWN>, datatype in operator <</>>: otl_long_string()

 

The table : ZZZZ, failed to unload.

Total number of rows : 0

Unload duration is : 67 second


​​
Cause
This issue occurs because IFC cannot recognize the format of the custom XML columns during the indirect unload.
Solution
To resolve this issue, set the format for each XML column manually as follows where XXX.YYY and ZZZ.RRRR are XML columns:

[SOURCE_INDIRECT_TABLES_COLUMNS_LIST]


TABLE1_COLUMN_LIST=XXX,YYYY,ZZZZ, XXX.YYY.getClobVal() as XXXX,ZZZ.RRRR.getClobVal() as XXXXX,ZZZ

 

More Information
​There is no impact on performance​ due to this.
Applies To
Product: Universal Data Replication
Problem Type: Configuration
User Type: Developer
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:1/15/2020 2:41 AMID:578783
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)