Export ASCII to another server

Post Reply
nickykoller
Posts: 16
Joined: Mon Jan 09, 2012 1:59 pm
OLAP Product: Tm1
Version: 10.1
Excel Version: XP

Export ASCII to another server

Post by nickykoller »

I export perfectly to a local drive on the server, but can't write to a folder on another server (I can write manually to this folder from the server).
I have read in detail post : TI error - File not found (8078 )

In light of this:
Tm1 is running as a service (local System)
Tried initially mapping the drive (which I believe doesn't work)
I have tried the following path combinations:
Dir = '\\servername\Groups\Accounts\Financials\2011\' ;
Dir = '\\servername\f$\Groups\Accounts\Financials\2011\' ;
Dir = '\\serverIPaddress\f$\Groups\Accounts\Financials\2011\' ;

I started this one, but didn't seem right to me:
Dir = '\\' | serverIPaddress| '\ | 'f$ | '\' | Groups\Accounts\Financials\2011\' ;

Any ideas?
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Export ASCII to another server

Post by Steve Rowe »

You need to check that the account the TM1 Service is running under has the rights to location your are writing too. If you are running with the default service account it probably won't have.

Cheers,
Technical Director
www.infocat.co.uk
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Export ASCII to another server

Post by Duncan P »

From http://technet.microsoft.com/en-us/libr ... 80595.aspx
About the Local System Account/Computer$ in Configuration Manager
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

The Local System account is a powerful account that has full access to the computer. In Microsoft System Center Configuration Manager 2007 it is used to start services and provide security context for those services, and to perform many Configuration Manager 2007 operations on the site server, site systems, and client computers.

The actual name of the account is NT AUTHORITY\System.

The Local System account does not have any rights to access the network. When network access is necessary, Local System uses the account Domain\computername$.[my emphasis]

With the release of Windows Server 2003, two new built-in account types similar to Local System were added: the Network Service account and the Local Service account. For more information about how Configuration Manager 2007 uses these accounts, see About the Local Service Account in Configuration Manager and About the Network Service Account in Configuration Manager. For more information about these accounts, see http://go.microsoft.com/fwlink/?LinkId=93067.
Does this help?
nickykoller
Posts: 16
Joined: Mon Jan 09, 2012 1:59 pm
OLAP Product: Tm1
Version: 10.1
Excel Version: XP

Re: Export ASCII to another server

Post by nickykoller »

yes - it does help.
"The Local System account does not have any rights to access the network." is clearly my problem.
I will see if I can get IT to change it.
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Export ASCII to another server

Post by John Hammond »

Nicky

Might be easier to do this through replication if you can reach both TM1 servers and they are on the same admin server
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: Export ASCII to another server

Post by PlanningDev »

Check these settings.

1. Did you share the location from the other server?
2. What are the SHARE permissions for the service account that TM1 is running under
3. Have you checked the folder security on the server itself?

You will need to not only assign rights when sharing the folder but the local folder security itself must be set to allow write access to the TM1 service account.
Post Reply