TM1 Forum

Hi,

I am using TM1 9.4 FP2. I have a TI process which outputs the data to a CSV file:

ASCIIOutput('\\servername\foldername\ReportExtract.csv',Source,Version,Market,Code,Project,RespCode,Yr,Mth,Value);

The same process is getting executed successfully in one environment and in another environment, I am getting the below error:

"Corporate","Actual","AMGCL","8102","3719","00000000","2009","Mar","1.e-002",Data Source line (1) Error: Data procedure line (5): File "\\servername\foldername\ReportExtract.csv" not found.

I have necessary Change permissions for the above target folder. Could someone help in finding out what the problem is? Thanks.

Hi,

ASCIIOutput('\\servername\foldername\ReportExtract.csv',Source,Version,Market,Code,Project,RespCode,Yr,Mth,Value);

In this instance are 'servername', 'foldername' avriables that you specify in your TI ?

If yes, you need to rebuild the string inside the function by using the concatenation command |

ASCIIOutput('\\' | servername | '\' | foldername | ' | \ReportExtract.csv',Source,Version,Market,Code,Project,RespCode,Yr,Mth,Value);

Hope this helps,

Olivier

Sandhya Kumar wrote:Hi,

I am using TM1 9.4 FP2. I have a TI process which outputs the data to a CSV file:

ASCIIOutput('\\servername\foldername\ReportExtract.csv',Source,Version,Market,Code,Project,RespCode,Yr,Mth,Value);

The same process is getting executed successfully in one environment and in another environment, I am getting the below error:

"Corporate","Actual","AMGCL","8102","3719","00000000","2009","Mar","1.e-002",Data Source line (1) Error: Data procedure line (5): File "\\servername\foldername\ReportExtract.csv" not found.

I have necessary Change permissions for the above target folder. Could someone help in finding out what the problem is? Thanks.

You have the permissions, or the login that the TM1 server is running under (on a remote server?) has the permissions?

It's the latter which will determine whether the server can write to the network share, even if you're the one triggering the process. If the server is running as a Local System service, it may not have the permissions needed to access network resources.

Hi

I take it you replaced your real servername with "servername" for the post because otherwise this probably wouldn't be working in one environment and not in another. I'll also assume that the two are separate server machines, correct me if I am wrong.

Your personal access rights to the folder won't change anything unless you run the TM1 server in 'the other environment' under your login. this is because it is not your windows login that tries to write to the file.

Maybe check if the user which runs the TM1 Server on the server box actually can 'see' the file (eg the share name for the foldername) ?

Cheers

Alan, you again.
I should be submitting these right away when I wrote them or maybe check right before I do whether Alan wrote something.

Gregor Koch wrote:Alan, you again.
I should be submitting these right away when I wrote them or maybe check right before I do whether Alan wrote something.

Option 1 wouldn't do you any good; I'd just fire up the De Lorean and set the flux capacitors to land me 2 minutes before your posting.

(If it's any consolation I'm off to the gym in about 10 minutes so you've got a clear run for the next couple of hours. )

I seem to recall having a similar problem that we solved in the end by substituting a full file path (e.g. e:\tm1data\file.csv) for the UNC type path you are using

Hi all...

Thanks for the inputs...

Yes.. i have replaced the original server name and folder name as \servername\foldername. In the other environment, it is a different server. I am a part of the group which has WRITE permission to this folder in both the servers. I am able to manually create folders and files inside \servername\foldername using my Windows ID.

My Windows ID is SKUMAR and I log in to TM1 using the client name SKUMAR and run the process in both the environments. Still one works and the other doesn't...

John Hobson wrote:I seem to recall having a similar problem that we solved in the end by substituting a full file path (e.g. e:\tm1data\file.csv) for the UNC type path you are using

Just one thing to be wary of with that; in later versions (certainly by 9.1) you can't use a mapped network drive letter as a path. If it's not a local drive path (eg C:\BlahBlah or D:\BlahBlah, assuming two partitions) then it has to be a UNC reference.

8.2.12 doesn't care; it'll use either a mapped drive or a local one or a UNC one, but I recall that when we implemented Web under 9.1 we had to change all of the values in our control cube which used a mapped drive letter. Can't find a reference to it in the manuals at the moment, but I'm pretty sure that I read it; certainly I'm sure that any processes which used a mapped drive letter didn't work under 9.1, even though the server could see it.

Hi

As Alan hopefully is in the gym...

Again, your Windows ID and how you log onto the TM1 Server (not the server machine) hasn't really anything to do with what seems to be going on. So just for now, forget your Windows ID.

Please check which user, this can be a local system account or a domain user which has been created just for this purpose, runs the tm1 service on the server machine, again I'll make an assumption that your TM1 Server runs as a service.

Cheers

In the server where my process aborts, the TM1 service is running under an admin user account. I do not have necessary permissions to check the services in the other server where I am able to run successfully.

And one more thing- I just tried writing into another folder in the same server and the process is successful..

ASCIIOutput('\\servername\d$\temp\test.csv',Source,Version,Market,Code,Project,RespCode,Yr,Mth,Value);

Notice the different syntax for the location ..d$...
Go with Alan's and John's lead.

Yes it worked when i replaced the actual path as E:\Foldername\test.csv
But I am not convinced why my earlier path reference worked in one server and did not in another!!

Thanks greg, Alan and John I'm loving this forum!

One other thing that happens in my work environment is that for "security reasons" a particular server cannot see itself using it's own UNC path.

So all the clients can use \\tm1prod\blah\ but "tm1prod" itself cannot access that path and I have to use the local drive path name. I'm told this is because tm1prod is an alias for the server so that we can switch to our hot backup tm1 environment without requiring the users to change their TM1 host parameters.

I'm not convinced this makes sense but it's what I've been told by the IT people that look after the infrastructure....
Cheers,

Came across this the other day on a new build when i was trying to transfer data from one box to another.

server A has a service called TM1-A running using a local account called TM1admin.
server B has a service called TM1-B running using a local account called TM1admin.

server A tries to create an ascii file on server B using UNC paths and fails as mentioned. The security that is relevant is that of the local account TM1admin, not anything else. What you cannot do is add //serverA/TM1admin to the security of anything on server B - it just won't know what you are talking about as its a local account. Windows security has this odd behavoiur in this case where if 2 servers try to talk and the account on one exists on the other, then it'll work only if the passwords on both accounts are identical.

I think this is possibly what you are seeing. Ask IT to find out what account the TM1 service is running with then check if the same named account is on the other server. If it is then the passwords must be different, so you then have to convince them to change one to match the other