Hi,
I have around 800,000 records in a table and I do some transformations on these and then putting the columns into another table.
During this if I run the job it gives me an error saying:Fatal Error: Tsort merger aborting: Scratch space full
AND
Fatal Error: Pipe read failed: short read
Also if I run the same job for say 10,000 records it runs fine.
I know that it is because of the scratch space issue, but is there a way to avoid it, also what is the second error?
Please help.
Thanks!
Harsh
Tsort merger aborting: Scratch space full
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am