Cannot Load CSVs when TM1 is running as a service

[DNA_DC]

Hello,

I have been trying to load CSV (and other flat files) but I cannot load them when TM1 is running as a service (as localsystem). I have no problems when i run it directly on the desktop.

Any ideas why this is and how to fix that?

Thanks,
DNA

[Alan Kirk]

Hello,

I have been trying to load CSV (and other flat files) but I cannot load them when TM1 is running as a service (as localsystem). I have no problems when i run it directly on the desktop.

Any ideas why this is and how to fix that?

At a guess, you've been stung by the issue that I raised in my "Installing Services" thread

The 9.4 Operations Manual states that "If you do not provide a user name, the current user account is used by default." While I'd be reluctant to make a categorical statement for all versions of Windows or TM1, I can say that that's not my experience. Rather, the TM1 server will be installed to run under the Local System account. (Though you can change this later as discussed in the next section.)

Some claim that this is unimportant, and indeed in most cases, on most systems and most versions it seems that the server will run under the Local System account without any problems. On a Windows server which is largely self contained and doesn't access any external resources it probably doesn't matter. However my own experience is that some network resources will not be accessible when the server is running under the Local System account and you won't discover this until something that you expected to work (such as a TI process which accesses an ASCII file on a network share), doesn't. My preference is therefore to create all services under a domain account which is known to have the correct permissions. After all, why take the risk?

I'd get the service running under a proper account which has all relevant permissions.

[Andy Key]

Further to what Alan has said, and assuming that you have a co-operative IT department, a good way to test the permissions once you have changed away from using LocalSystem is to log on to the TM1 server itself using the user id that the TM1 service is now running as. If your csv files are on a share, map that share in the same way that you would if you were logging on to your own pc as yourself, then try and access the csv files through the mapped share. Even if the share is on the same machine as the TM1 server, and even if you are running TM1 as the Administrator user of that machine, you may well find that you, and therefore the TM1 service do not have access to the share.