sf_DeleteFile

[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

[EvgenyT]

Looks like that file is still locked by another process

What is the chain of events here please?

Thanks

Evgeny

[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.

[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

[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

[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...

[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...