}bedrock.server.executecommand

[ak-cube]

Describe the bug
CMD version of the command line doesn't work

The current line
sCommand = 'CMD.EXE /C "' | sCommand | '" 1> ' | cCmdOutputFile | ' 2>&1';

Expected line
sCommand = 'CMD.EXE /C "' | sCommand | ' > "' | cCmdOutputFile | '" 2>&1"';

Description of changes

• 1> - it doesn't make sense in CMD
• The whole statement after CMD.EXE /C should be included in double quotes, not the only sCommand
• cCmdOutputFile may contain spaces, so it also needs to be enclosed in double quotes

[ak-cube]

# Check if the pCommand parameter is enclosed in quotes and remove it if it is

The line
If( Subst(pCommand, 1, 1) @= '"' );

should be replaced by
If( Subst(pCommand, 1, 1) @= '"' & Subst(pCommand, Long(pCommand), 1) @= '"' );

It is OK to execute command line started from double quote, for ex. "C:\Program Files\7-Zip\7z.exe"

[ak-cube]

Every execution with the parameter pWait = 1 and pLogOutput = 1 raises the error:

#Execute the command in the TM1 server
ExecuteCommand ( sCommand, pWait );

#If pLogOutput is true then define the command output file as data source
If( pLogOutput = 1 );
DataSourceType = 'CHARACTERDELIMITED';
DatasourceNameForServer = cCmdOutputFile;
EndIf;

Here we're trying to read the file that has not been generated yet.