Set ADO record set CommandTimeout property for long-running queries in UFT in a Database checkpoint

While inserting a database (DB) checkpoint in a script, and in the case the SQL query requires additional time to receive the response from the DB server (For a long-time running query), it’s required to configure UFT (Unified Functional Testing) to wait additional time more than the 30 seconds (default) for the command timeout.

In order to extend the ADO record set CommandTimeout property, please do the following:

1.- Close UFT

2.- Open the registry editor (Start > Run > Regedit) with admin privileges.

3.- Do the following:

Under : HKEY_CURRENT_USER\Software\Mercury Interactive\QuickTest Professional\MicTest\DBUtils

Create : DWORD value Timeout = xxx (decimal)

4.- Close the registry editor.

5.- Reopen UFT and try again the checkpoint step.

Advertisements

One thought on “Set ADO record set CommandTimeout property for long-running queries in UFT in a Database checkpoint

  1. sean

    Hi
    I have a vbscript that installs hp uft and post install is license server. this is done by cmd or batch file. the msi installation was successful but the license server never gets installed. please advise if you have any suggestions.

    thank you
    sean

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s