Hi,
Visited this one before with limited success but now its time to try again.
Platform is TES 6.1.0.212 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.
