Hi,
I am getting the below error when pulling data from Oracle to SQL Server 2008
Unknown error in transform <TF_DIRECT_MAP_STG_PO_REQUISITION_LINES_ALL>.
Can anybody help me up with this
Thanks in advance
SK.Nid (BOB member since 2011-09-24)
Can you please post the full error and the monitor + trace log. And a screenshot of the dataflow. At the moment there is just little information to solve something that is of unknown error.
Werner Daehn 
(BOB member since 2004-12-17)
Please find the Screen shot of the dataflow
SK.Nid (BOB member since 2011-09-24)
Hi Werner Daehn,
Please find the below details of the error that i am getting
ERROR:
13340 14196 RUN-050505 12/12/2011 9:01:15 PM |Data flow DF_STG_PO_REQUISITION_LINES_ALL_TRUNC|Loader TF_DIRECT_MAP_STG_PO_REQUISITION_LINES_ALL
13340 14196 RUN-050505 12/12/2011 9:01:15 PM Unknown error in transform <TF_DIRECT_MAP_STG_PO_REQUISITION_LINES_ALL>.
Monitor:
/DF_STG_PO_REQUISITION_LINES_ALL_TRUNC/Loader1 for table ‘TF_DIRECT_MAP_STG_PO_REQUISITION_LINES_ALL’ PROCEED 5000 6.777 69.490
/DF_STG_PO_REQUISITION_LINES_ALL_TRUNC/Loader2 for table ‘TF_DIRECT_MAP_STG_PO_REQUISITION_LINES_ALL’ PROCEED 5000 6.778 69.500
/DF_STG_PO_REQUISITION_LINES_ALL_TRUNC/Round_Robin_Split PROCEED 16000 7.224 69.931
/DF_STG_PO_REQUISITION_LINES_ALL_TRUNC/TF_DIRECT_MAP PROCEED 16000 7.229 69.926
/DF_STG_PO_REQUISITION_LINES_ALL_TRUNC/TF_DIRECT_MAP_STG_PO_REQUISITION_LINES_ALL PROCEED 5000 6.827 69.537
and also please find the attached screen shot of DF
SK.Nid (BOB member since 2011-09-24)
Since no error specific to SQL Server or Oracle are in your log then I suspect the error is within DS. Check over all your code to make sure columns are mapped correctly. If you have DOP > 1 or Number of Loaders > 1 then set them back to 1 and try again.
eganjp 
(BOB member since 2007-09-12)
Hi , We have encountered with the same issue and we are using Oracle as our target. This issue was resolved by changing the commit size in the target option to 1000 from 10000000.
srilibian 
(BOB member since 2010-09-08)
Ha! I didn’t even know you could set the commit size that large.
FYI, what was likely happening is that the target table attempted to allocate a memory buffer for the 10000000 rows. If the failure happens as soon as the Dataflow is started then there simply was insufficient memory available to create the buffer.
eganjp 
(BOB member since 2007-09-12)
Hi Jim,
Your explanation sounds meaningful. In one of my job, i have faced Unknown error and it results to virtual memory error. I understand the commit size would have resulted in the virtual memory error. Can you please provide some solution for the Unknown error case? It occurs only when the data flow through a specific query transform and i have dropped and recreated the same query transform with different name which gives the same error.
srilibian (BOB member since 2010-09-08)
I don’t have enough information. You’ll have to provide a full description of your Dataflow, version, data load, environment, etc.
eganjp (BOB member since 2007-09-12)