what is tm1rawstore?

Post Reply
jonathan.d
Posts: 43
Joined: Mon May 18, 2009 8:41 am
Version: TM1 9.4 MR1
Excel Version: 2003

what is tm1rawstore?

Post by jonathan.d »

Hi All,

Couldn't get any information on the file tm1rawstore(with a timestamp) in the data folder.

Wondering what purpose does this file server, and when does it come into play when the model is running?
User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: what is tm1rawstore?

Post by LoadzaGrunt »

What is in the file ?
harrytm1
Regular Participant
Posts: 226
Joined: Thu Apr 02, 2009 2:51 pm
OLAP Product: IBM Planning Analytics
Version: Latest version
Excel Version: 2003 to 2019

Re: what is tm1rawstore?

Post by harrytm1 »

i believe this is the temporary file that stores the audit trail of users. when the defined file size is reached, a permanent file is created. this file is locked as long as the server is running.

please correct me if i'm wrong here. thanks!
Planning Analytics latest version, including Cloud
ashwinchitkara
Posts: 21
Joined: Mon Aug 09, 2010 7:52 pm
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2003

Re: what is tm1rawstore?

Post by ashwinchitkara »

My understanding is that if the parameter within tm1s.cfg called AuditLogOn=T then TM1 Server writes into a temp file called tm1rawstore.<Timestamp>, created under the database directory. The entry in this log file are then moved to the final Audit log
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: what is tm1rawstore?

Post by David Usherwood »

My understanding too.
It's a PITA because it sits in the data directory and interferes with taking server snapshots. Winzip skips open files but Windows Compressed Folders doesn't.
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: what is tm1rawstore?

Post by mattgoff »

David Usherwood wrote:My understanding too.
It's a PITA because it sits in the data directory and interferes with taking server snapshots. Winzip skips open files but Windows Compressed Folders doesn't.
You can move it out of the model directory (I put it in my logging directory) with the RawStoreDirectory parameter in tm1s.cfg.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: what is tm1rawstore?

Post by lotsaram »

It is a documentation hole that I (and I'm sure I'm not the only one) have raised with IBM but you can configure the location of the rawstore in tm1s.cfg with the parameter RawStoreDirectory. I always just set it to the same path as the logging directory (why you would ever want to do anything else is quite beyond me).

(beaten to it by Matt)
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: what is tm1rawstore?

Post by David Usherwood »

:x :x :x !
There are few things that p1$$ me off more than finding out a crucial function is not documented. Takes me back to the bad old Applix days - 'Oh, didn't you know that? Everybody knows that!'
Grrrrr.
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: what is tm1rawstore?

Post by mattgoff »

David Usherwood wrote::x :x :x !
There are few things that p1$$ me off more than finding out a crucial function is not documented. Takes me back to the bad old Applix days - 'Oh, didn't you know that? Everybody knows that!'
Grrrrr.
Well, I hate to defend Cognos, especially when it comes to documentation, but in this case it is in 9.5.1 Operations Guide under the tm1s.cfg parameters section. That's how I figured it out when I ran into the same problem after enabling the audit log and finding my automated backup zips were failing.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: what is tm1rawstore?

Post by David Usherwood »

Oh....
:oops: :oops:
I was working on a CX 9.0 aka TM1 9.4.1 system when I found it. I'll have a look to see if it was in that help file. Let's hope it wasn't a senior moment....
AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: what is tm1rawstore?

Post by AmbPin »

Hi,
Do you know if there is any guidance as to when it is safe to clean up files created in a raw store folder?
Post Reply