TM1 Server termination due to Write error on Sandboxlog

[sophie]

Hi,

Our TM1 server is 64 bit with 64 GB RAM.It crashed today with the below error in tm1server.log.
This error has not occurred before.

4112 [6a1] FATAL 2014-04-30 02:06:12.829 TM1.System.File TM1 Server Abort: sf_Write() - Write error on file "e:\tm1_data\tm1_test\logs\sandboxlogs\ABC/User\c\tm1s.log". Error = The handle is invalid.
buffer = 0x00000001405B1EBC, len= 1

Could somebody help me with this error and a solution for it?

Thanks
Sophie

[dan.kelleher]

Hi Sophie,

Is your user called something like "ABC/User\c", "User\c", or "ABC/User"?

From what I can work out, TM1 10.2 uses the following folder structure to store sandboxlog:

[LogFileDirectory]\sandboxlogs\[UserName]\[sandbox index]\tm1s.log

Looking at your set up it may be slightly different but the issue you have is that you have a "/" or a "\" in the user name. "\" is a forbidden character for a file path, and using "\" means the path will add an additional folder, which it can't find. This is clearly an error that IBM haven't trapped.

My advice is to avoid using special characters where at all possible throughout your TM1 model code and naming conventions.

Hope that resolves your issue.

Dan

[failurehappening]

Following on from what Dan says, 10.1 has the following structure:

[LogFileDirectory]\sandboxlogs\[namespace]\[UserName]\[sandbox index]\tm1s.log

it looks like you have a namespace called "ABC/User" and a user called "c".

As Dan says "/" is reserved...

[sophie]

Hi All,

The file path is e:\tm1_data\tm1_test\logs\sandboxlogs\ABC\User\c\tm1s.log.
Sorry for the confusion.
ABC is the namespace.
User is the username.
c is another folder where tm1s.log file is present
Hope this clears.

Thanks
Sophie

[failurehappening]

Hi Sophie

Do you have a virus checker running on the server?

[sophie]

Yes, but it skips the data directory folder.

Thanks
Sophie