Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lookup Transformation Error

Status
Not open for further replies.

mckutlu

Technical User
Sep 23, 2006
2
US
Hi,

I am using a lookup transformation with the following SQL Override:

SELECT MCIX.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID, MCIX.ATTRIBUTE1 AS ATTRIBUTE1, MCIX.ATTRIBUTE2 AS ATTRIBUTE2, MCI.CUSTOMER_ID AS CUSTOMER_ID, MCI.CUSTOMER_ITEM_NUMBER AS CUSTOMER_ITEM_NUMBER

FROM MTL_CUSTOMER_ITEMS MCI, MTL_CUSTOMER_ITEM_XREFS MCIX, MTL_SYSTEM_ITEMS_B MSI

WHERE MCI.CUSTOMER_ITEM_ID = MCIX.CUSTOMER_ITEM_ID AND MCIX.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = 81 AND MCIX.INACTIVE_FLAG = 'N'
--

I am using the first selected field as an output and the remaining 4 in my conditions. My ports have 5 lookup ports (first one also being output), and 4 input port to be used within the condition. My lookup ports have the same name as the selected fields and they are in the same order in the conditions as they are in the select (except the first selected field is not included in the select, cus I want to return it). The datatypes also match with the datatypes of the selected field within the Oracle server.

I am still getting this error:

TRANSF_1_2_1> DBG_21079 Creating Lookup Cache : (Wed Oct 04 14:10:23 2006)
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1022 Database driver error...
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1057 Error in fetching lookup data from database
TRANSF_1_2_1> DBG_21641 lkp_ORA_WARR_ID: Index cache size = [1000000], Data cache size = [2000000]
TRANSF_1_2_1> Wed Oct 04 14:10:23 2006
TRANSF_1_2_1> CMN_1062 Error creating lookup cache.
TRANSF_1_2_1> DBG_21524 Transform : lkp_ORA_WARR_ID

It seems it can't fetch the data. So I guess there is still something wrong with my sql. Any help is greatly appreciated. Thanks a lot...

-Mustafa
 
Can you do a successful preview data on that lookup table?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top