Page 1 of 1
sf_DeleteFile
Posted: Mon Mar 16, 2015 2:41 am
by deskylim
Hi,
I am currently encountering a situation where TM1 is attempting to delete what-looks-like nothing and is throwing out error messages in the log:
Code: Select all
sf_DeleteFile: Error on file 'd:/tm1/data\'. Error = error code:5 reason:'Access is denied.
sf_Rename: Failed to rename (d:/tm1/data\$) to (d:/tm1/data\). Error: error code:183 reason:'Cannot create a file when that file already exists.
Has anyone else encountered this issue or has any thought about why this is the case?
It's popping up in a Cognos Express 10.2.1 install.
~des
Re: sf_DeleteFile
Posted: Mon Mar 16, 2015 3:39 am
by EvgenyT
Looks like that file is still locked by another process
What is the chain of events here please?
Thanks
Evgeny
Re: sf_DeleteFile
Posted: Mon Mar 16, 2015 4:37 am
by deskylim
If you're familiar with Bedrock, the error is occurring within the Bedrock.Cube.Data.ZeroOut process.
If you're unfamiliar with it, it is a TI process that builds a temporary view of a single cube that is to be zeroed out.
And it is somewhere embedded in the TI process where the sf_deletefile is issued and presumably as part of a TI function. And I can only guess that it may involve "SubsetDeleteAllElements" function.
Re: sf_DeleteFile
Posted: Tue Apr 07, 2015 7:46 am
by holger_b
Hi,
I came across this error message just this morning. There is an asciioutput in the epilog of a process, and the server log says: sf_DeleteFile: Error on file ... (Here comes the name of the output file). It continues like this:
9856 [] ERROR 2015-04-07 04:30:25.414 TM1.Server sf_SafeDeleteFile() could not delete file, "d:\tm1\rc-detail\log\60100_Run_process_with_RunTI.log$" after 10 retrys in 20 seconds
9856 [] ERROR 2015-04-07 04:30:25.445 TM1.Process Process "60100_Run_process_with_RunTI": : Execution was aborted
I took out the asciioutput in order to overcome this, but can anyone explain what actually happens here?
Regards
Holger
Re: sf_DeleteFile
Posted: Tue Apr 07, 2015 10:43 am
by BariAbdul
Hi,
I came across this error message just this morning. There is an asciioutput in the epilog of a process, and the server log says: sf_DeleteFile: Error on file ... (Here comes the name of the output file). It continues like this:
9856 [] ERROR 2015-04-07 04:30:25.414 TM1.Server sf_SafeDeleteFile() could not delete file, "d:\tm1\rc-detail\log\60100_Run_process_with_RunTI.log$" after 10 retrys in 20 seconds
9856 [] ERROR 2015-04-07 04:30:25.445 TM1.Process Process "60100_Run_process_with_RunTI": : Execution was aborted
I took out the asciioutput in order to overcome this, but can anyone explain what actually happens here?
Sorry holger,I am confused here ,At the beginning you said you had an error during asciioutput and in last sentence you said you resolved it through asciioutput.
How did you resolved,Since it appears to be more to do with object locking.Thanks
Re: sf_DeleteFile
Posted: Wed Apr 08, 2015 8:02 am
by holger_b
I took out the asciioutput
I meant to say, I deactivated the asciioutput
Seems like the process ran twice at the same time, maybe it is all that easy...
Re: sf_DeleteFile
Posted: Wed Apr 08, 2015 9:45 pm
by deskylim
Holger, is the file still there (60100_Run_process_with_RunTI.log$)? It may be a permission issue in your case. Does the account running TM1 have local admin rights?
In my case, a file name isn't mentioned in the log. So it's either a logging issue (ie/ there is a file but for whatever reason TM1 is unable to capture it in the log) or a TM1 (internal) process issue...