sort error

arnie_nits · Post by **arnie_nits** » Tue Apr 20, 2010 8:10 am

Hi ,

I am getting the below error:

Transform_USA1_TGT_Component_test..Sort_MachinerySeqNum: Error in merging files
File '/apps/ascential/Ascential/DataStage/Projects/Shell_LubesAnalyst/soxe3UDr/opf__3' write error

I am unable to figure out the problem.Please help.

Regards,
Arnie.

ArndW · Post by **ArndW** » Tue Apr 20, 2010 10:06 am

Server sort stage, right? and are you 100% certain that you aren't running out of disk space (assume your whole file lands in that directory temporarily)

arnie_nits · Post by **arnie_nits** » Tue Apr 20, 2010 11:27 am

Yes sir,

looks like it has to do with space because I am unable to create copy of existing jobs.

Regards,
Arnie.

chulett · Post by **chulett** » Tue Apr 20, 2010 11:30 am

That is what is known as a Very Bad Thing and something you need to resolve ASAP before you corrupt your repository.

ps. The "Temporary File" location property in the Sort stage should never be left blank as that means they all go into the Project the job is running from. Always redirect it somewhere with plenty of space that you can afford to jack up - like /tmp for example.