Import Issues

[ZakWray]

Hello, when i click import all hands to start the HUD the app itself freezes after the import starts (directory of hand histories is correct), i can't close it without pressing ctrl alt delete and forcing shut down. I tried to rebuild cache and full vacuum but get the following errors (please see attached screenshots) so I don't know what I can do next.

My database is a few years old and has many hands - would creating a new database work? At the moment I can't play without the HUD crashing, Zak

[ZakWray]

Just to also add: i created a new database and the app does not crash now after clicking "get hands while playing" and "stop getting hands" and the HUD works, but if i revert back to my default database the problem still exists.

[Flag_Hippo]

There is a PostgreSQL restriction on the number of columns in a table so you will need to restrict the number of custom columns which are cached to 1600 before attempting the cache rebuild again. Each custom column has a "Cache" checkbox - you can turn this off to prevent a column from being cached, and you will need to reduce the number of cached columns to less than 1600. The custom cache in PT4 is separate from the built in cache - you don't get the full 1600 columns as we need identifiers but you get something like 1585. You can alter what is and isn't cached in the custom cache by going to Configure -> Statistics and in the Players section you can untick "cache" for custom columns you don't want cached. So you can pick the 1580-odd columns you do want cached. The rest can be used in the HUD (or reports) they'll just take longer to return data as it needs to be calculated on the fly.

[ZakWray]

So I need to work my way through the custom built stats and untick cache for each of them, then try to rebuild cache again?

[Flag_Hippo]

Yes that would be the first thing to do. The easiest to check how many columns you are currently using is to use PGAdmin III, browse to your database's tables and look at the cache_custom_cache (or tourney_custom_cache) table in the Schemas -> Public section.

[ZakWray]

sorry i don't know what PGAdmin III is

[ZakWray]

Is there another solution because I'm going to struggle doing that on my own

[Flag_Hippo]

Click your Windows Start button then type the following:

pgadmin

and click on it when it appears. Double click on "PostgreSQL x.y" (where x.y is your PostgreSQL version) and if your prompted for a password the default is "dbpass" (without the quotes). Next double click on "Databases -> YOUR_DATABASE_NAME -> Schemas -> Public -> Tables -> cash_custom_cache (and/or tourney custom cache for tournaments) and the number in brackets is the number of custom columns which should look like this.

[ZakWray]

Okay this is what it says: see attached, so there are 855 columns?

[Flag_Hippo]

Yes however in some cases that number doesn't correlate directly to the number of cached columns which depends on the custom content you are using - you can see more about this in this thread and this thread.