Page 1 of 1

Export ASCII to another server

Posted: Fri Jan 13, 2012 11:11 am
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?

Re: Export ASCII to another server

Posted: Fri Jan 13, 2012 11:20 am
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,

Re: Export ASCII to another server

Posted: Fri Jan 13, 2012 12:21 pm
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?

Re: Export ASCII to another server

Posted: Mon Jan 16, 2012 8:16 am
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.

Re: Export ASCII to another server

Posted: Mon Jan 16, 2012 3:25 pm
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

Re: Export ASCII to another server

Posted: Wed Jan 18, 2012 8:54 pm
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.