Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Users might experience few discrepancies in Search results. We are working on this on our side. We apologize for the inconvenience it may have caused.
New Member

Tidal vs Powershell

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.
 

1 REPLY
New Member

Success! Most of the work is

Success!

 

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.

 

322
Views
0
Helpful
1
Replies
CreatePlease to create content