ASCIIOUTPUT From one server to another

Post Reply
MT1
Posts: 1
Joined: Mon Jul 23, 2018 7:28 pm
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: Excel 2016

ASCIIOUTPUT From one server to another

Post by MT1 »

Hi
We have two tm1 instances, Instance 1 running in Server A and Instance 2 running in Server B.
I am trying to asciioutput some cube data from Instance 1 ( which is running in server A) to a folder location in server B.

Here is what I am doing
sCube='Sales Reporting';
sFileName='InterserverDataOutput.csv';
sFilePath= '\\servername\D:\Inbound';


ExecuteProcess('Bedrock.Cube.Data.Export'
, 'pCube', sCube
, 'pView', ''
, 'pFilter', ''
, 'pDimensionDelim', '&'
, 'pElementStartDelim', ':'
, 'pElementDelim', '+'
, 'pSkipRules', 1
, 'pSkipCons', 1
, 'pZeroSource', 0
, 'pDestroyTempObj', 1
, 'pFilePath', sFilePath
, 'pFileName', sFileName
, 'pDebug', 1
);

This is the error message I am getting
Invalid export directory: \\servername\D:\Inbound

Also note
Inbound Folder is a shared folder
The service account used in running the TI has full control for Inbound folder.
Any pointers as to what I am missing.
User avatar
gtonkin
MVP
Posts: 1265
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: ASCIIOUTPUT From one server to another

Post by gtonkin »

The UNC specified in "sFilePath= '\\servername\D:\Inbound';" is not valid.
If you paste this into Explorer it probably will not work.

Depending on how you have set up your share, it may be:
sFilePath= '\\servername\D\Inbound';
or
sFilePath= '\\servername\D$\Inbound';
(D$ is used when you have not specifically shared but are accessing as an administrator i.e. an administrative share).

You may also need to confirm if Bedrock expects a trailing slash on the folder e.g.
sFilePath= '\\servername\D\Inbound\';
BR, George.

Learn something new: MDX Views
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: ASCIIOUTPUT From one server to another

Post by tomok »

MT1 wrote: Wed Apr 15, 2020 3:22 am sFilePath= '\\servername\D:\Inbound';
This is not a valid path. When you use a UNC path like this, it is in the form of:

\\ServerName\ShareName\Path

I highly doubt that you have a share named "D:". That is a mapped drive letter not a share name.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply