Excluding TM1 Files From Virus Scanning

Post Reply
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Excluding TM1 Files From Virus Scanning

Post by Alan Kirk »

This is one that comes up occasionally, usually coincident with unexplained server crashes and glitches. I thought that I'd add it in as a post for search purposes.

It's long been a rule of thumb that the TM1 data directory should be excluded from virus scans. The results if a virus scanner has a lock on a file that TM1 is trying to write to can be... unfortunate.

Yesterday IBM published a more expansive technote on this point which can be found here.

In a nutshell the folders that they recommend excluding are:
- The TM1 data directory
- The TM1 logging directory (if not in the data directory)
- The directory where the tm1s.cfg file is located (if not in the data directory)
- The directory where any Excel sheets (or other docs) are located and uploaded to the TM1 server as a reference
- The directory where any flat files may be written to (output from a TI process, for example) or pulled from (import into a TI process, for example)
- Any other databases being used by a TM1 process (Oracle, SQL Server, MSAS, etc.)
- The TM1Web/TM1WebEx files - by default located at: C:\Inetpub\wwwroot\
I'm not sure that a lot of IT departments would be crazy about excluding all of these, and I suspect that the exclusion of the databases scan is more an issue of performance than stability.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Excluding TM1 Files From Virus Scanning

Post by Olivier »

Thanks for this Interresting update.
Another area to be looked at in case of perf / stability issues...
HTH
Olivier
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Excluding TM1 Files From Virus Scanning

Post by David Usherwood »

I can't imagine any sensible security wonk agreeing to exclude a folder (}Externals) holding Excel workbooks from a periodic virus scan. What tripe.
Post Reply