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?
Export ASCII to another server
-
- Posts: 16
- Joined: Mon Jan 09, 2012 1:59 pm
- OLAP Product: Tm1
- Version: 10.1
- Excel Version: XP
- 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
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,
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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
From http://technet.microsoft.com/en-us/libr ... 80595.aspx
Does this help?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.
-
- 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
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.
"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.
-
- 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
Nicky
Might be easier to do this through replication if you can reach both TM1 servers and they are on the same admin server
Might be easier to do this through replication if you can reach both TM1 servers and they are on the same admin server
-
- 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
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.
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.