Hi Sandhya, Thanks for your response, it is based on Trafodion 2.0, so why caused this issue and is there any way to solve this?
Best regards, Yuan Email: [email protected]<mailto:[email protected]> Cellphone: (+86) 13671935540 发件人: Sandhya Sundaresan [mailto:[email protected]] 发送时间: 2017年4月17日 12:13 收件人: [email protected] 主题: RE: How to deal with SQL 10007 Hi, Error 28 means it has run out of space on /tmp. Which version of Trafodion are you using ? Thanks Sandhya From: Liu, Yuan (Yuan) [mailto:[email protected]] Sent: Sunday, April 16, 2017 7:39 PM To: [email protected]<mailto:[email protected]> Subject: How to deal with SQL 10007 Hi trafodioners, When I executed “upsert using load into …”, I encountered the SQL 10007 error as below, *** ERROR[10007] Sort failed while writing to a scratch file with error 28. Details: SQScratchFile::executeVectorIO [2017-04-15 10:52:34] My current STFS_HDD_LOCATION is $MY_SQROOT/tmp set in ms.env. Can anyone help on how to solve this issue? Best regards, Yuan Email: [email protected]<mailto:[email protected]> Cellphone: (+86) 13671935540
