Error encountered while trying to retrieve graph definition.

Any support related posts should go here.

Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Sat Sep 25, 2010 12:17 pm

I've installed PT2 on my new comp, but graphing is not working. I get the following: "Error encountered while trying to retrieve graph definition. Unable to continue."

I've found a single thread on the entire internets which talks about this issue, but unfortunately for me it's a Postgres DB, not an Access one. The error occurs for every single graph in the tabs.

I tested an access database and graphs work on it. I also tested another Pgsql DB that has observed hands and i get the same error above.
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby WhiteRider » Sat Sep 25, 2010 3:51 pm

What version of PostgreSQL do you have?
Is everything else working OK?

Try using the PostgreSQL Database Functions in the Utilities menu. I don't currenly have PT2 set up with PostgreSQL but the housekeeping functions may help.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Sat Sep 25, 2010 10:37 pm

> Try using the PostgreSQL Database Functions in the Utilities menu. I don't currenly have PT2 set up with PostgreSQL but the housekeeping functions may help.


I tried a Vacuum Full/Analyze and the problem remains.


> What version of PostgreSQL do you have?


8.4


> Is everything else working OK?


Usually yes, altho today i've come across another problem, importing hands late in the Pokerstars 100k VIP Monthly tourney. I think it might be unrelated, my very rough guess is perhaps the blind level name 'XXVIII' exceeds the maximum size PT expects?:


*********************************
PT Version: 2.17.04m
Error Date: 09/25/2010 16:04
Database Error: 7
Error Text: SQLSTATE = 22001
ERROR: value too long for type character varying(5);
Error while executing the query

No changes made to database.

INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 128, 13682, 13682, {ts '2010-09-25 19:04:13'}, 17, 'XXVIII', 0, 14000.0000, 129680, {ts '2010-09-25 16:04:58'}, '305278298 620', '(did not show hand)', 129680, 0, 8, 0, '50170060110' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 128, 13682, 13682, {ts '2010-09-25 19:04:13'}, 17, 'XXVIII', 0, 14000.0000, 129680, {ts '2010-09-25 16:04:58'}, '305278298 620', '(did not show hand)', 129680, 0, 8, 0, '50170060110' )
*********************************
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby WhiteRider » Sun Sep 26, 2010 4:21 am

ptrack pat wrote:PT2 does not support 8.4, use 8.2

http://wwwmaster.postgresql.org/downloa ... 2.13-1.zip
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Sun Sep 26, 2010 11:37 am

WhiteRider wrote:
ptrack pat wrote:PT2 does not support 8.4, use 8.2

http://wwwmaster.postgresql.org/downloa ... 2.13-1.zip


Not one of those mirror links works (yes, i tried every last one).

Edit 1: I've found some mirrors with v8.2.16 and v8.2.17. Should i use one of those?

Edit 2: NM, with some digging i found it at ftp://ftp-archives.postgresql.org/pub/b ... 2.13-1.zip

Edit 3: I'm assuming there's a reason you linked that very specific version and not 8.2.16 etc.?
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby kraada » Sun Sep 26, 2010 12:02 pm

8.2.17 should work fine; Pat's post is apparently a bit out of date.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Tue Sep 28, 2010 9:28 pm

kraada wrote:8.2.17 should work fine; Pat's post is apparently a bit out of date.

How would i go about doing that, given that i've been playing and importing hands using version 8.4 for the last 5 months? I'm guessing it's not a simple "uninstall 8.4, install 8.2, profit". It almost seems like it'd be easier to uninstall and reinstall PT2 at the same time...

Well, assuming i keep PT2 as is, anything unnecessary, wrong, and/or correct in the following list?:

1) purge all ring sessions, tourney hands, tourney summaries from the last 5 months
2) stop the psql service
3) uninstall psql 8.4, delete all psql database files
4) install psql 8.2
5) import 5 month old psql database backup
6) import all hand histories and tourney summaries for the last 5 months
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby WhiteRider » Wed Sep 29, 2010 5:44 am

If the 5 month old backup file is from 8.2 before you updated to 8.4 (which is what it sounds like) then your procedure should be fine. Make sure you have all of the hand history files before you delete anything.
If you're going to uninstall 8.4 and delete it then you don't need to do 1) as you're going to delete the database so purging it first will make no difference (but will take some time).
You can install 8.2 alongside 8.4 but on a different port (e.g. 5433 instead of 5432) - you can even run both at the same time, but I guess you'll only be using one, so it would be more efficient to not have 8.4 started.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Error encountered while trying to retrieve graph definition.

Postby sdlsdlsd » Wed Sep 29, 2010 1:24 pm

WhiteRider wrote:If you're going to uninstall 8.4 and delete it then you don't need to do 1) as you're going to delete the database so purging it first will make no difference (but will take some time).

But won't the hands still be recorded in the hhdb.mdb file, and hence won't be able to be imported?
sdlsdlsd
 
Posts: 63
Joined: Tue May 06, 2008 12:14 pm

Re: Error encountered while trying to retrieve graph definition.

Postby WhiteRider » Wed Sep 29, 2010 2:36 pm

If you're using PostgreSQL I don't think there will be a hhdb.mdb file - that is an Access database file.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to PTH Support

Who is online

Users browsing this forum: No registered users and 4 guests

cron
highfalutin