Cannot export DB into HHs

Any support related posts should go here.

Cannot export DB into HHs

Postby Chaser8 » Mon May 19, 2008 9:41 pm

I keep getting this error message when I try to export my entire 5 million hands database into hand histories.

Database Error:

Error opening cursor.

7- SQLSTATE = S1000
Out of memory while reading tuples.;
Error while executing the query

I have 15 gigs of space left in my computer. I'm running winxp with 2 gigs memory. What is going wrong here and how do I fix it?

The reason I'm exporting everything into hand histories is because I want to convert my db into PT3 but I can't convert it directly because of the limited space in my hard drive. I want to export all my hands into HH files, delete (and backup) my current PT2 db, which will free up 50gigs, then import all my HH files into PT3. Am I doing this right?

Thanks
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Cannot export DB into HHs

Postby Chaser8 » Mon May 19, 2008 9:44 pm

Oh, and after this error occurs, I can't load up my db when I open 'Ring game player statistics.' Everything is empty. However, everything comes back to normal when I restart PT2
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Cannot export DB into HHs

Postby ptrack pat » Mon May 19, 2008 10:28 pm

You are going to have to do the export in batches. Use the date filters (between dates) on the export window to export certain periods of hands, say 6 months worth at a time.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Cannot export DB into HHs

Postby Chaser8 » Mon May 19, 2008 10:39 pm

Thanks Pat.

When I specify the "Between Dates," will the exporter export hands including the dates?

For example, if I specify to export from Jan 1st 2007 to Dec 31st 2007, will it export all the hands of both Jan 1st 2007 AND Dec 31 2007?
Chaser8
 
Posts: 96
Joined: Thu Jan 24, 2008 8:03 pm

Re: Cannot export DB into HHs

Postby ptrack pat » Tue May 20, 2008 11:06 am

Yes, it will export all hands between those dates inclusive of the start/end dates.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 0 guests