Error: unable to delete

ray.wurlod · Post by **ray.wurlod** » Sat Dec 02, 2006 5:41 pm

You probably lack write permission to the parent directory on the production server.

Write permission to its parent directory is required to delete a file because the directory (a list of contents) has to be edited to remove the file entry.

lak · Post by **lak** » Sat Dec 02, 2006 9:58 pm

Thank you.Can you please tell me whats is the parent directory?

ray.wurlod wrote:You probably lack write permission to the parent directory on the production server.

Write permission to its parent directory is required to delete a file because the directory (a list of contents) has to be edited to remove the file entry.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 03, 2006 12:00 am

The file that it can not delete is '/u01/Ascential/DataStage/asclscratch/uat_edw.MAINT_USERS_SECR.bad' therefore its parent directory is '/u01/Ascential/DataStage/asclscratch'

It may also be that the file was created by a different user ID, or is still in use. These are other potential reasons for being unable to delete a file. cd to the parent directory and execute ls -la command to garner more information.

lak · Post by **lak** » Sun Dec 03, 2006 4:55 pm

there is only single user (i.e. dsadm)running these jobs but still getting same error .

dsadm@etlprod:/u01/Ascential/DataStage> ls -la

drwxrwxr-x 2 dsadm dstage 4096 Dec 03 15:07 asclscratch

Please help me.

Thanks

ray.wurlod wrote:The file that it can not delete is '/u01/Ascential/DataStage/asclscratch/uat_edw.MAINT_USERS_SECR.bad' therefore its parent directory is '/u01/Ascential/DataStage/asclscratch'

It may also be that the file was created by a different user ID, or is still in use. These are other potential reasons for being unable to delete a file. cd to the parent directory and execute ls -la command to garner more information.

kumar_s · Post by **kumar_s** » Sun Dec 03, 2006 6:04 pm

Check the permission of the file 'uat_edw.MAINT_USERS_SECR.bad' using ls -lat. And make sure the file exist in the correct format as expected.
Check the owner of the file. Check if the file can be deleted using dsadm.
Just curious to know, if its production, shouldn't it be prod_edw.....

chulett · Post by **chulett** » Sun Dec 03, 2006 9:19 pm

kumar_s wrote:Just curious to know, if its production, shouldn't it be prod_edw.....

I think we have a winner.