Skip to Content
0
Jan 26, 2011 at 04:18 PM

Trouble with Write_to_file command in BPC MS 7.0 multi-server

23 Views

Hi experts,

My DataManager package Fails with the message: An error occurred while querying for the Webfolders path. Below is my package;

'DEBUG(ON)

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when running logic.",1,{"Yes, check for work status settings before running logic","No, do not check work status settings"},{"1","0"})

PROMPT(SELECTINPUT,,,,%CATEGORY_DIM%%TIME_DIM%)

PROMPT(OUTFILE,%FILE%,"Please enter a file name for Export",,
DC1-OLSTD-SVR01\BPC\DATA\Webfolders\CW_Dev_Consol\CWConsol\DATAMANAGER\DATAFILES)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,APPSET,%APPSET%)

TASK(Execute formulas,APP,%APP%)

TASK(Execute formulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\Exor_Actual_Export.lgx)

TASK(Execute formulas,FORMULASCRIPT,*WRITE_TO_FILE=%FILE%)

TASK(Execute formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,%CHECKLCK%)

I hard coded the path for the output file prompt, as letting it default yielded the same error. My datapath variable is
\OSoft\Webfolders\{AppSet}\{App}\DataManager\DataFiles Notice the 'OSOFT' rather than 'Data' in the path??

The package log shows the file path and looks OK:

FILE=
\DATA\WEBFOLDERS\{AppSet}\{app}\DATAMANAGER\DATAFILES\NEW.TXT

Clearly, I changed the actual server name, appset and app names for privacy reasons.

Any thoughts on why the Webfolders pathing error?? Thanks!