'Unable to use cache due to column' error on log?

[erdnase17]

I am trying to run a report using a custom stat but it always shows with no values so I looked at the log and found this message:

Code: Select all

[StatManager] Unable to use cache due to column: cnt_p_minraise_greater_than_16bb (cnt_p_minraise_greater_than_16bb)

What does this mean and how can I fix this problem?

Thanks.

[kraada]

That means that since the column is custom, everything in that report is calculated directly from the database and the cache is not used. It will take longer for the report to populate but it should work - how do you have this stat defined?

[erdnase17]

That means that since the column is custom, everything in that report is calculated directly from the database and the cache is not used. It will take longer for the report to populate but it should work - how do you have this stat defined?

Ok I think I found the source of the problem. The query

Code: Select all

select amt_p_effective_stack from tourney_hand_player_statistics
where amt_p_effective_stack > 0

returns no results. In fact this database field is -1 for all rows. Did something go wrong with the conversion when upgrading to v4.0.2.13?

This column is defined as:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_steal_opp and (tourney_hand_player_statistics.amt_p_effective_stack /  tourney_blinds.amt_bb) > 16, 1, 0])

Thanks.

[kraada]

You need to reimport your data after the update in order to get the proper values in those fields.

[erdnase17]

You need to reimport your data after the update in order to get the proper values in those fields.

Ok thanks, I am doing this for a friend and forgot about this step

One more question: after the upgrade on my own database I noticed that I lost the accumulated stats on observed hands. Aren't those saved in the DB while observing games?

Thanks.

[erdnase17]

You need to reimport your data after the update in order to get the proper values in those fields.

1. I created a new database using the 'Database Management' dialog.
2. I set this database as the default and active database
3. I clicked on Restore and selected the backup zip file that was created before upgrading to v4.0.2.13
4. This process forced me to create yet another database because I was afraid to overwrite the new one (I think the restore tries to use the original DB name)

After the restore was completed I still have the same problem.
I ended up with 2 extra databases but only the first one appears on the Database Management tool. The other one from step 4 appears only on pgAdminIII.
Am I missing any steps?


(For my own database I did the import from the PS HH files and tournament summaries so I didn't face this problem.)

[kraada]

Any imported hands will all be treated the same regardless of whether they were observed or not and they should have all updated together.

Restoring a database is not the same as reimporting. You'll need to create your new database, set it as Active and use the Get Hands From Disk button and choose the directory with your hand history files in it. This may take some time, but it is the only way to have PT4 reprocess all of the relevant hands.