The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP / Mercury LoadRunner

Pages: 1
PerfArch
Member


Reged: 07/02/04
Posts: 84
Loc: UK
QTP Vuser not able to pickup values from datatable
      #457157 - 02/12/08 02:02 AM

QTP VUSER Problem
*****************
ENV - QTP 9.2, LR 9.0, JAVASwing based Application

I am trying to run QTP Vuser script from LR Controller and it's failing when script tries to pickup the value from the runtime datatable. (i have imported 2 external worksheets to default.xls for DATA)
My QTP script works fine without any errors using QTP Tool but It fails only when i run it from controller saying

" Line(1): ''****************************************************************************************************************** [MsgId: MMSG-23001]
Error: Line(1): The retrieve DataTable.Value operation failed. The <DialogName> column does not exist. [MsgId: MERR-23001]
Ending action Action1. [MsgId: MMSG-15918]
Ending Vuser... [MsgId: MMSG-15966]
Vuser Terminated. [MsgId: MMSG-15963]
Vuser 0 (thread 3740), ended OK." [MsgId: MMSG-10695]
On the main thread, COM was initialized with CoUninitialize(MTA). [MsgId: MMSG-10555] "
''******************************************************************************************************************
From the above error <DialogName> supposed to be a coulmn name and i picking up the first row value of that column using strWinObj=trim(DataTable.Value ("DialogName", "Action1"))

When i run it from QTP it pickups the dialogname coumn value from the datatable but it's not doing from QTP Vuser.
Are there any limitations here with QTP Vusers?
I didnt see any problems wiht QTPVuser picking my own env files and loading libraries etc...but it only fails to get the datat table values at runtime. Why is itso?

Any comments and ideas ..please

Thanks

--------------------
Arch


Post Extras: Print Post   Remind Me!   Notify Moderator  
kiranbadi1991
Super Member


Reged: 12/03/06
Posts: 1937
Re: QTP Vuser not able to pickup values from datatable [Re: PerfArch]
      #457184 - 02/12/08 03:32 AM

Seems like you are not able to access the datatable from controller machine.i am not sure how QTP scripts handle datatable, but LR Scripts needs that data should be in Scripts directory and also on generator machines.

Post Extras: Print Post   Remind Me!   Notify Moderator  
PerfArch
Member


Reged: 07/02/04
Posts: 84
Loc: UK
Re: QTP Vuser not able to pickup values from datat [Re: kiranbadi1991]
      #457218 - 02/12/08 05:11 AM

I am using the same machine for Controller, loadgenerator and script folder right now.I have all my data files in my script folder.
The interesting part is that my Vuser script loading my own data tables into global and Action1 sheets and it also gets the rowcount of that using below

DataTable.ImportSheet strDataFilePath , 1, 1
DataTable.ImportSheet strActionFilePath, 1, 2
Reporter.ReportEvent micPass,"Row Count", "Global Sheet Row Count" & DataTable.GetSheet("Global").GetRowCount

BUT SCRIPT FAILS WHEN IT COMES TO NEXT LINE

Reporter.ReportEvent micPass,"Dialogname", "Dialogname :- " & trim(DataTable.Value ("DialogName", "Global"))

DataTable.Value
DataTable.RawValue

the above 2 functions are not working from Controller(Vuser script). As eeveryone knows these are proven functions from QTP tool.

Why these are not working from Vuser script?

Any thoughts or ideas?

--------------------
Arch


Post Extras: Print Post   Remind Me!   Notify Moderator  
JakeBrake
Moderator


Reged: 12/19/00
Posts: 15290
Loc: St. Louis - Year 2025
Re: QTP Vuser not able to pickup values from datat [Re: PerfArch]
      #457223 - 02/12/08 05:19 AM



Post Extras: Print Post   Remind Me!   Notify Moderator  
PerfArch
Member


Reged: 07/02/04
Posts: 84
Loc: UK
Re: QTP Vuser not able to pickup values from datat [Re: JakeBrake]
      #457230 - 02/12/08 05:29 AM

1. What version of LoadRunner (LR) or PerformanceCenter (PC) are you using? (specify which tool LR or PC)
LR 9.0
QTP9.2
2. What is the protocol you are recording?
QTP Vuser

2.1 If .NET, which version of .NET does the app require?
N/A
2.2 If .NET, which version of .NET do you have installed?
N/A
3. If HTML - are you using HTML-Advanced with URLs or,
(indicate yes/no)
N/A
4. If URL mode:
- Concurrent groups, or
- Without Concurrent groups?
N/A

5. Which LoadRunner/PerformanceCenter feature (FPs) or service packs are you using?
9.0.0.0

6. VuGen Recording - are you using Old or New Recording Engine?
N/A

7. What kind of LoadRunner license do you have -
- Evaluation?
planning to buy QTP Vusers licences
(choose the one that fits your license model - (substitute your answer here))

8. If subscription, is subscription current or expired?
N/A

9. What platform(s) (PCs) and Operating Systems (Windows-XP, etc.)? Include version and service packs (SP1 or 2, etc.)
Win Xp service pack2

10. If you have filed a service request with HP/Mercury, what have they told you at this point with respect to your issue?
Not filed
*********************************************************
I am using the same machine for Controller, loadgenerator and script folder right now.I have all my data files in my script folder.
The interesting part is that my Vuser script loading my own data tables into global and Action1 sheets and it also gets the rowcount of that using below

DataTable.ImportSheet strDataFilePath , 1, 1
DataTable.ImportSheet strActionFilePath, 1, 2
Reporter.ReportEvent micPass,"Row Count", "Global Sheet Row Count" & DataTable.GetSheet("Global").GetRowCount

BUT SCRIPT FAILS WHEN IT COMES TO NEXT LINE

Reporter.ReportEvent micPass,"Dialogname", "Dialogname :- " & trim(DataTable.Value ("DialogName", "Global"))

DataTable.Value
DataTable.RawValue

the above 2 functions are not working from Controller(Vuser script). As eeveryone knows these are proven functions from QTP tool.

Why these are not working from Vuser script?

Any thoughts or ideas?

--------------------
Arch


Post Extras: Print Post   Remind Me!   Notify Moderator  
JakeBrake
Moderator


Reged: 12/19/00
Posts: 15290
Loc: St. Louis - Year 2025
Re: QTP Vuser not able to pickup values from datat [Re: PerfArch]
      #457233 - 02/12/08 05:33 AM

These are QTP issues and have nothing to do with LoadRunner. In this case, LR is just trying to drive a QTP script that is not working.

Post Extras: Print Post   Remind Me!   Notify Moderator  
PerfArch
Member


Reged: 07/02/04
Posts: 84
Loc: UK
Re: QTP Vuser not able to pickup values from datat [Re: JakeBrake]
      #457241 - 02/12/08 05:42 AM

Yes, LR only drives QTP script but LR runs this script as GUI Vuser script.
I believe there are some limitations or diffrences between QTP script and QTP Vuser script.
In this case i wont blame QTP Tool but i do with Controller which uses Silent Test Runner to run Vuser scripts.
***Might be a problem with SilentTestRunner.
I am still researching...
Please let me know if you have experienced these cases...

--------------------
Arch


Post Extras: Print Post   Remind Me!   Notify Moderator  
JakeBrake
Moderator


Reged: 12/19/00
Posts: 15290
Loc: St. Louis - Year 2025
Re: QTP Vuser not able to pickup values from datat [Re: PerfArch]
      #457245 - 02/12/08 05:51 AM

It would seem that it is more of file location. Do you have your QTP scripts setup with respect to file pointers such that the scripts can be run anywhere? A simple experiment:

Attempt to run the script directly via QTP and outside of the LR harness.


Post Extras: Print Post   Remind Me!   Notify Moderator  
James PulleyModerator
Moderator


Reged: 08/01/01
Posts: 5551
Loc: NC
Re: QTP Vuser not able to pickup values from datat [Re: PerfArch]
      #457247 - 02/12/08 05:53 AM

Script developed on Computer A and environment A.

Script is being executed as a GUI Virtual User on Computer B with Environment B(?)

Perhaps an initial condition (or dependency) of your script on host A|Environment A, is not present on Computer B|Environment B. An example, if you referenced a hard and fast location for your datafile and your datafile is not located in the same relative path (i.e. c:\mydatafile.xls) on the execution host, then you will see errors.

Increase the error handling in your graphical virtual user to bring forth appropriate error messages if it were to encounter such items as a missing or misconfigured data file. Use your errors, not the ones brought forward by QTP, so you will know the exact conditions which caused the error text to appear.


Post Extras: Print Post   Remind Me!   Notify Moderator  
kiranbadi1991
Super Member


Reged: 12/03/06
Posts: 1937
Re: QTP Vuser not able to pickup values from datat [Re: JakeBrake]
      #457251 - 02/12/08 05:58 AM

First check whether LR9.0 is compatible with QTP 9.2 and then proceeds with other points.Sometimes back someone reported here the incompatibilty.

Post Extras: Print Post   Remind Me!   Notify Moderator  
PerfArch
Member


Reged: 07/02/04
Posts: 84
Loc: UK
Re: QTP Vuser not able to pickup values from datat [Re: James Pulley]
      #457267 - 02/12/08 06:14 AM

Step1:
QTP script(folder with all the files) and QTP tool located in Machine XYZ
Ex: c:\QTPSsamplescript1 (script location)
c:\QTPSsamplescript1\Default.xls
c:\QTPSsamplescript1\MyData.xls

Script successfully ran through QTP tool in XYZ machine.

Step2:
Controller also located in machine XYZ. I have added c:\QTPSsamplescript1 in controller and tried to run as GUI Vuser script it fails.

I have extended the log in controller but it only shows above 5 lines as mentioned in above posts.

QTP vuser script is able to import the datatables, it can get rowcount of the data tables but why it cant get only the values from the tables.
QTP vuser is pickedup my data table but it's not retreaving my values which i asked.

--------------------
Arch


Post Extras: Print Post   Remind Me!   Notify Moderator  
JakeBrake
Moderator


Reged: 12/19/00
Posts: 15290
Loc: St. Louis - Year 2025
Re: QTP Vuser not able to pickup values from datat [Re: PerfArch]
      #457277 - 02/12/08 06:28 AM

I think that you should ask the folks in the QTP forum about the values retrieval. Perhaps post over there with QTP-specific details? Although we tend to frown on cross-posts, this is a situation that may warrant such a thing. At the very least - post a summary over there and point to this topic.

Post Extras: Print Post   Remind Me!   Notify Moderator  
CuriousMind
Newbie


Reged: 12/06/12
Posts: 1
Re: QTP Vuser not able to pickup values from datat [Re: JakeBrake]
      #719950 - 12/06/12 01:18 AM

Hi PerfArch,

Could you able to resolve this problem? I am stuck at the same problem. Please suggest.


Post Extras: Print Post   Remind Me!   Notify Moderator  
ptrussell_ncModerator
Super Member


Reged: 01/17/06
Posts: 1636
Loc: Charlotte, NC
Re: QTP Vuser not able to pickup values from datat [Re: CuriousMind]
      #719956 - 12/06/12 06:45 AM

Curious,

This looks like a pretty old thread. You might want to start a topic of your own and explain in detail what is happening and what you have tried to fix it.

--------------------
Unless you are writing a compiler, strtok is NOT the answer.
See: http://www.sqaforums.com/showflat.php?Cat=0&Number=541641&Main=541641#542222

QAF is still an exercise in self-sufficiency! (Thank JB!)


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 48 anonymous users are browsing this forum.

Moderator:  AJ, James Pulley, ptrussell_nc, JimHowell1970 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 9328

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5