DSXchange

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.

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)

Yes sir,

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

Regards,
Arnie.

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.