Wednesday, May 20, 2009

QTP issue 'Sheet already in use'.

I came up with this unique issue wherein i was receiving this 'Sheet already in use error popup when i was trying to execute my QTP scripts. The QTP scripts were upgraded from 9.2 to 10.0 wherein we had lost the association between External Reusable Actions and the main script which used to call those reusable actions. The Default.xls did not loose Data Tables for the called Reusable actions. We could not help but delete those additional sheets from Default.xls and only then the scripts started running fine. Now even today i still doubt about the upgrade issues we have faced during upgrading QTP from 9.2 to 10.0. I can list atleast 10 issues here and still many to foloow i guess.
But sometimes i feel it was good that we had issues... I get paid for resolving it :)

Tuesday, May 12, 2009

Disabling the security popup for specified hostnames or IPs.

It happens many times that we get a security pop up and we haven't handled it some of our automated QTP scripts which invoke exe files on those remote locations.
Following steps would help eliminating the issue once for all:
1) Click Start, Run and type INETCPL.CPL
2) Select the Security tab, Trusted sites
3) Click Sites button Add the IP address or hostname of the remote computer to the list(You can also add the network shares to the Local Intranet zone.)
4) Uncheck Require server verification (https:) for all sites in this zone and click Close
5) Click OK, OK and close the dialog

The methodology works only for Windows.