lookup failure

samsuf2002 · Post by **samsuf2002** » Wed Sep 13, 2006 2:44 pm

Hi

i am getting this "Lookup_459,0: Fatal Error: fstat() failed: Object is too large for operation" error i am using sqlserver

can any one help
thanks
Sameer

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 2:55 pm

The message is fairly obvious; something in your query is generating a value that is too large. Assuming you are using ODBC, there is a maximum row size and a maximum number of columns that can be transferred. These maxima can be configured in uvodbc.config using the MAXFETCHBUFF and MAXFETCHCOLS parameters.

samsuf2002 · Post by **samsuf2002** » Fri Sep 15, 2006 9:18 am

the solution what i found is we can split the job and run it and it worked fine but the issue is its taking more time this will be gud for one time initial load

kumar_s · Post by **kumar_s** » Fri Sep 15, 2006 6:55 pm

What is the job design? And how did you split it ?