TM1 Forum

Here's a strange one: I cannot get UNC files working as data sources in Turbo Integrator.

If I specify (on both the "Data Source Name" and "Data Source Name on Server" lines) a path like:

\\10.200.1.7\d$\basket-details-2-12-10.csv

TM1 will Preview the file just fine. But, as soon as I try to run the process, it immediately aborts with:

Error: Prolog procedure line (0): Unable to open data source "\\10.200.1.7\d$\basket-details-2-12-10.csv".

It's a normal network share mounted from a admin account. If I browse for the file, I can navigate just fine to it and TM1 fills in the exact same path.

Thoughts?

Thanks,
-- John

image2x wrote:Here's a strange one: I cannot get UNC files working as data sources in Turbo Integrator.

If I specify (on both the "Data Source Name" and "Data Source Name on Server" lines) a path like:

\\10.200.1.7\d$\basket-details-2-12-10.csv

TM1 will Preview the file just fine. But, as soon as I try to run the process, it immediately aborts with:

Error: Prolog procedure line (0): Unable to open data source "\\10.200.1.7\d$\basket-details-2-12-10.csv".

It's a normal network share mounted from a admin account. If I browse for the file, I can navigate just fine to it and TM1 fills in the exact same path.

Thoughts?

When you say that you can preview it and can browse for it, where are you doing that? On your own desktop, or while you're proxied on to the server? If it's on your desktop then all you're showing is that you have access to that share... that doesn't mean that the server does, and it's the server's access that determines whether TI can access the file when the process is executed. (Even if you're the one triggering the execution.)

Also, even if you are proxied on to the server, are you sure that the TM1 server service is running under the same login as you're using? If it's running as a Local System service, it most likely won't have the required network permissions to access the share.

Make sure the file you are trying to use as a data source is not open too.

Alan Kirk wrote:
When you say that you can preview it and can browse for it, where are you doing that? On your own desktop, or while you're proxied on to the server? If it's on your desktop then all you're showing is that you have access to that share... that doesn't mean that the server does, and it's the server's access that determines whether TI can access the file when the process is executed. (Even if you're the one triggering the execution.)

Also, even if you are proxied on to the server, are you sure that the TM1 server service is running under the same login as you're using? If it's running as a Local System service, it most likely won't have the required network permissions to access the share.

I'm remote desktoping into the TM1 server and am running Perspectives locally. By preview, I mean I can click the Preview button in TI and the file data appears without a problem in the preview pane. The TM1 Service is running as a domain admin account. Strange, eh?

ItsPat -- yup, the file isn't open.

Thanks. -- John

image2x wrote:

Alan Kirk wrote:
When you say that you can preview it and can browse for it, where are you doing that? On your own desktop, or while you're proxied on to the server? If it's on your desktop then all you're showing is that you have access to that share... that doesn't mean that the server does, and it's the server's access that determines whether TI can access the file when the process is executed. (Even if you're the one triggering the execution.)

Also, even if you are proxied on to the server, are you sure that the TM1 server service is running under the same login as you're using? If it's running as a Local System service, it most likely won't have the required network permissions to access the share.

I'm remote desktoping into the TM1 server and am running Perspectives locally. By preview, I mean I can click the Preview button in TI and the file data appears without a problem in the preview pane. The TM1 Service is running as a domain admin account. Strange, eh?

Not if that's a different account to the one that you're using in the RD session it isn't...

The preview button only proves anything if it's being used on exactly the same user account that the server is using to run.

Not if that's a different account to the one that you're using in the RD session it isn't...

The preview button only proves anything if it's being used on exactly the same user account that the server is using to run.

Yes, I'm logged in with the same domain account that TM1 is using. I suppose I could venture into the bowels of Windows Security log next...

Not if that's a different account to the one that you're using in the RD session it isn't...

The preview button only proves anything if it's being used on exactly the same user account that the server is using to run.

Yes, I'm logged in with the same domain account that TM1 is using. I suppose I could venture into the bowels of the Windows Security log next...

image2x wrote:

Not if that's a different account to the one that you're using in the RD session it isn't...

The preview button only proves anything if it's being used on exactly the same user account that the server is using to run.

Yes, I'm logged in with the same domain account that TM1 is using. I suppose I could venture into the bowels of the Windows Security log next...

One other thing that you might consider is trying FileExists() in a separate process and writing the result via AsciiOutput; at least that will tell you whether the issue your process can't see the file, or whether it just can't open it.

Does anyone else have a recollection, it may have been way, way back in the Applix forum, about an issue with using D$ styles of reference in network shares? I can't find any reference to it but there's just something niggling in the back of my mind about it. It may be nothing or something unrelated, but I know I've seen something relating to it before...

Does anyone else have a recollection, it may have been way, way back in the Applix forum, about an issue with using D$ styles of reference in network shares? I can't find any reference to it but there's just something niggling in the back of my mind about it. It may be nothing or something unrelated, but I know I've seen something relating to it before...

When I read this the first time that seemed to ring a bell with me too Alan.

Something I have encountered as well is that the server cannot see itself if the computer name is an "alias". If 10.200.1.7 is the pc that the TM1 server is running, try specifying a local path for the server side path. This may resolve any strange network issues.....
HTH