Execute External Command

[Suniti Suniti]

Hi All,

 

Please help!!

 

I am trying to execute vbs file from execute external command Step. When I am trying to run from local path its working fine. But when tried providing server path it failed saying Could not create directory Z.....(path to my vbs file)

 

Thanks for help in advance!!

[Mike_Gavaghan]

Hi,

 

Is it failing when you try to execute the test from the Simulator or from the Workstation?

 

If you're trying to run from the simulator, the problem might be:

1. The executable does not exist at that location on the server, or
2. The ID the Simulator is executing under might not have permission to read the executable.

 

--Mike

[Suniti Suniti]

Hi Mike,

 

file is present on server as well as on local also. I tried to run it from workstation as well as from Server but no luck.

Please find the snapshot of what I am trying to do. I mapped my server location to Z drive and then pressed execute button

 

 

but when iam trying to run it from server or trying to run from ITR it giving cant create the path (path in execute from directory).

[Mike_Gavaghan]

Is "Invoke.vbs" on the classpath?

 

"Execute from directory" simply indicates the "current working directory" that should be used when running the executable..  It doesn't indicate where to find the executable.

 

Please try using a fully qualified path to Invoke.vbs.

 

--Mike

[Suniti Suniti]

Mike,

 

I had already tried that also, when i execute/ test it by execute button in test step..it ran properly but when i tried to run it through ITR ...it again gave error could not create directory at path...

 

Thanks for your patience and helping me out

[Mike_Gavaghan]

Hmmm.  I'm stumped.

 

Does the vbs executable need to create a file?  I'm trying to figure out if it's Workstation that can't create something, or if it's your executable that can't create something.  Either way, it seems permissions related.

 

Are you seeing a stack trace in Workstation.log?  If so, can you share it?

 

--Mike

[Suniti Suniti]

Mike,

please my comments and help .. Thanks in Advance!!

[Marcy Nunns]

Can you share what the error is showing in the ITR?

[Suniti Suniti]

Hi Mike and Marcy,

 

Mike you are not stumped but you were right

I could remove that "could not create directory" error by giving blank value for execute from directory field.

But you were right, I have next error as "could not open the Excel file".

In my vbs script, I am trying to open an Excel file, so just wanted to check whether i need to set any special permission in LISA. however, I had provided the PATH value = place where vbs file and Excel file is present(both have same location as of now). Please find the attached snapshot for more clarity.

 

 

FYI, file is present at location and its not used by any other program

Thanks in Advance for help!! have a great weekend.

[Marcy Nunns]

You probably do not have access to the network drive.  Is it mapped so that the application can access it?

[Suniti Suniti]

No its still not resolved.

I do have access to network drive, even if i have my test case at server location and when iam trying to run test case using LISA Invoke, it giving timeout error .

 

As Iam getting error : Error while opening file 1004 Microsoft Excel cant access the file.

[Marcy Nunns]

Make sure you have the right permissions on the Server.  Also are you just reading the file or having to write to it?

[Suniti Suniti]

Hi Marcy,

Thanks a lot  

you were 100% right, My bad

there was some issue in server permissions...I tried on different server and it worked fine...Thanks a lot