Visited this one before with limited success but now its time to try again.
Platform is TES 126.96.36.199 running on Solaris x86, CM is on RH linux, agent on windows server 2003.
I'm attempting to automate some MS excel work via powershell. I have a script that works fine when called interactively or via a batch file. However, when calling either through TIDAL I run into issues. I'm sure most of these are going to be security settings in windows but working out what to fix is proving somewhat problematic.
For Powershell I have "set-ExecutionPolicy RemoteSigned" and the agent has the necessary rights as defined in the install guide eg "run as a batch job" etc.
For the particular script I'm running I believe its failing because the tidal runtime user needs to have web proxy credentials supplied.
Taking that as a starting point how might those details be defined?
The script is attached if anyone wants to play with it. It will need the extension changing to from ".txt" to ".ps1" The errors seen when run via TIDAL are below.
Exception calling "Open" with "1" argument(s): "Microsoft Office Excel cannot a ccess the file 'http://www.simple-talk.com/blogbits/philf/rainfall.html'. There are several possible reasons: The file name or path does not exist. The file is being used by another program. The workbook you are trying to save has the same name as a currently open wor kbook." At C:\temp\cambridge_rain.ps1:19 char:28 + $wb = $Excel.Workbooks.Open <<<< ("http://www.simple-talk.com/blogbits/philf/ rainfall.html") + CategoryInfo : NotSpecified: (:) , MethodInvocationException + FullyQualifiedErrorId : ComMethodTargetInvocation
Exception getting "Range": "Exception calling "get_Range" with "2" argument(s): "Exception from HRESULT: 0x800A03EC"" At C:\temp\cambridge_rain.ps1:56 char:13 + $excel.Range <<<< ("H2").Select() + CategoryInfo : NotSpecified: (:) , GetValueInvocationExceptio n + FullyQualifiedErrorId : CatchFromBaseParameterizedPropertyAdapterGetValu e
Property 'FormulaR1C1' cannot be found on this object; make sure it exists and is settable.
Most of the work is fighting through windows security but they key part is installing the TIDAL agent using the user account doing the work. It needs to be installed and run as that user instead of using the local system account or being installed by a local windows administrator.
I now have a working instance of excel running completely unattended under TIDAL control.