Page 1 of 1
lookup failure
Posted: Wed Sep 13, 2006 2:44 pm
by samsuf2002
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
Posted: Wed Sep 13, 2006 2:55 pm
by ray.wurlod
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.
lookup failure
Posted: Fri Sep 15, 2006 9:18 am
by samsuf2002
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
Posted: Fri Sep 15, 2006 6:55 pm
by kumar_s
What is the job design? And how did you split it ?