Welcome, Guest. Please login or register.
Login with username, password and session length

 
Advanced search

18539 Posts in 4847 Topics- by 32743 Members - Latest Member: watty
 

AdvancedQTP forums have been nominated as a finalist in ATI’s 2nd annual automation honors awards!

We’d like to thank you for your continued support and participation, and urge you to hurry and vote.

Make you voice count! 

Del.icio.us Digg FURL FaceBook Stumble Upon Reddit SlashDot

you are here: AdvancedQTP Forums » AdvancedQTP Forums » General QTP Q&A »  (Moderators: Paul Grossman, Stefan Thelenius, Asiq Ahamed)Not enough storage is available to complete this operationcorp-lt Theme designed by padexx
« previous next »
Pages: [1]   Go Down
Print
0 Members and 1 Guest are viewing this topic.
Author Topic: Not enough storage is available to complete this operation    (Read 213 times)
p_noblebose
User
*
Offline Offline

Posts: 10
« on: February 23, 2010, 06:53:44 AM »
Not enough storage is available to complete this operation Array = rs1.getrows

I am executing a query which will fetch around 10 million records.

i am getting this error when i am executing the below code:

 rsArray = rs1.GetRows()

Please let me know how to resolve this

Regards,
Noble2all
Logged
Oren Dvir
Full User
***
Offline Offline

Posts: 182
« Reply #1 on: February 23, 2010, 06:57:10 AM »
What do u want to do with all these rows?
Logged
Tarun Lalwani
Advanced User
*****
Offline Offline

Posts: 894



WWW
« Reply #2 on: February 23, 2010, 07:13:15 AM »
You cannot get so many rows at once, You should proceed with few rows at a time. May be 10k at a time
Logged
Tarun Lalwani,
QuickTest Professional Unplugged - My new Book on QTP...
p_noblebose
User
*
Offline Offline

Posts: 10
« Reply #3 on: February 23, 2010, 07:33:50 AM »
I would be validating the data againts different tables data...

some thing like table A data is loaded to table B based on some tranformation and business rules, I would be validating the same using QTP..

Please let me know how to do that....
Logged
Oren Dvir
Full User
***
Offline Offline

Posts: 182
« Reply #4 on: February 23, 2010, 07:37:57 AM »
Decrease your query to get less rows each time, so you can compare each time a little amount of rows
Logged
Tarun Lalwani
Advanced User
*****
Offline Offline

Posts: 894



WWW
« Reply #5 on: February 23, 2010, 09:46:09 AM »
Look at the parameters for the function

http://www.w3schools.com/ado/met_rs_getrows.asp
Logged
Tarun Lalwani,
QuickTest Professional Unplugged - My new Book on QTP...
Asiq Ahamed
Moderator
Advanced User
*****
Offline Offline

Posts: 503
« Reply #6 on: February 23, 2010, 10:31:31 PM »
Hi,
   Can you use the below commands in your ADODB connection?

page size = 100
timeout = 30
size limit=5000

I have never used these commands in my connection. Could you try it once, please?

Let me know your results Smiley
Logged
Pages: [1]   Go Up
Print
« previous next »
Jump to: