Sunpoker (IPoker) fails to import

[rdrunner]

I tried the the latest Version ((1.19.23A Beta) but still have no success in importing the histories of normal SNG games...


Is this currently a known issue?

Thanks

Edit it looks like SQL errors are fiering:

Thats from the SQLErrors File... Got toms od those errors in there...

The Error: String was not recognized as a valid DateTime.

Occurred when running GetDataTable with this query: select * from tourneydata td join tourneyplayerdata tpd on td.tourneynumber = tpd.tourneynumber and td.site_id = tpd.site_id where td.tourneynumber = '316547054' and td.site_id = 4

Edit2: I am from Germany, regional settings are en-us

[fozzy71]

What site?

Can you please answer these questions. http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=174

Please www.7zip.org the hands and email them to me at fozzy@holdemmanager.net, with a link to this thread.

[rdrunner]

Please note that skipping questions will only delay us in fixing the problem, as we'll have to re-ask the questions you didn't answer and wait for your response.

1) What version of Holdem Manager are you using?

Currently the latest build - 1.09.23a Beta
Problem also surfaces with the 1.09.19 Build any any in between

2) a. What poker site are you playing on and does the problem occur on more than one site?

Sunpoker - IPoker Network

3) Often times, it is one setting or one box that has not been selected that causes the problem. Please see our detailed FAQs on configuring Holdem Manager to work with select poker sites to make sure that your HUD is set up properly for your selected poker site.

Yes... Import was working before.

4) Check to see if the hand histories are showing up in the correct folder.

Import fails with import error - Hands are found but SQL Error is thrown --


4) If the hand histories are not showing up in the folder, then go back to the FAQ, as they should show you how to check the settings in the lobby to configure the poker site to save the Hand History and make sure its sending the Hand Histories to the correct location. Contact your poker site if your unsure to find out where you can set the location of the hand histories to save to.

see 3

5) So by now you should have confirmed in answering each question that you have setup the folders correctly and the hands are appearing in the correct folder.


No... See 3. -> Import error


5a) If the hand histories show up in the auto import folders, but they're not importing into the database, please create a new database and try importing some hands to test if it's a corrupt database.

Didnt help


6) Have you tried the Table Finder and did it work?

N/A -> SNG Hand histories

7) If you open the hand history files, are they written in English? Note that they should be.

Yes

8) Make sure UAC is disabled and unselect it and restart if it is.

Holdem is running as Admin / No UAC

9) Please attach your holdemmanager.config file from C:\Program Files\RVG Software\Holdem Manager\Config folder.



--------------------------

Edit:

--------------------------

I did a Vacum + reindex + Analyze of my postgress DB , and that seemed to fix the Problem

[fozzy71]

........
I did a Vacum + reindex + Analyze of my postgress DB , and that seemed to fix the Problem

That really shouldn't fix an import issue, typically. Please make sure you try the newest 1.09 Beta 24 version if you have any issues.

As far as DB and HD maintenance, and performance, I usually suggest this:



I would suggest you do the majority of the things in this thread: http://www.holdemmanager.net/forum/showthread.php?t=11194

Some of the most important things, imo:

- Turning off logging and deleting existing logs
- Vacuum/Full/Analyze, then Reindex
- SQL Tuning Wizard
- Defrag last and make sure you stop the postgresql service before you defrag. I personally use Defraggler.
- Do a Cold Boot (Shut Down > Start) before you use HM again

[rdrunner]

That really shouldn't fix an import issue, typically. Please make sure you try the newest 1.09 Beta 24 version if you have any issues.

As far as DB and HD maintenance, and performance, I usually suggest this:

Thats the last error i got from the SQL log...

The Error: ERROR: XX001: could not read block 1856 of relation base/16403/16626: read only 0 of 8192 bytes

Occurred when running ExecuteNonQuery with this query: EXECUTE CSUpdate_month(26339,0,4,-1000,0,-0.5,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0); EXECUTE CSPositionActionUpdate_month(26339,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,1,0,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 );

XX001 is Data corrupted, so i thought a full maintenance couldnt hurt. After the maintanence I was able to import the files that caused errors.