[rt-users] Problem upgrade from rt-2.0.9 to rt3-0.6

[Philippe Van Hecke]

I have a problem to migrate my rt-2.0.9 installation to rt3-0.6
after importing the rt2 db to rt3 db with rt2-to-rt3-v1.20 i am 
unable to create new ticket or udpate existing ticket in rt3.
befor the update rt3 work well.

I use a gentoo system with postgres postgresql-7.3.4
 Server Version: Apache/1.3.28 (Unix) (Gentoo/Linux) mod_perl/1.27
HTML-Mason 1.20

*  Apache-DBI
      Latest version installed: 0.91

*  DBI
      Latest version installed: 1.37

*  DBD-Pg
      Latest version installed: 1.22

DBIx::SearchBuilder 0.92

looking in the log when i try to create the ticket i obtain this.


Nov 17 11:32:34 philippe-2 RT: DBD::Pg::st execute failed: ERROR:  Cannot 
insert a duplicate key into unique index tickets_pkey at /usr/lib/perl5/
site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  (/usr/local/rt3//lib/
RT.pm:247)
Nov 17 11:32:34 philippe-2 RT: RT::Handle=HASH(0x8befe80) couldn't execute the 
query 'INSERT INTO Tickets (Owner, Started, Type, InitialPriority, 
LastUpdatedBy, Resolved, Starts, Subject, Status, Created, FinalPriority, 
Priority, Queue, Due, LastUpdated, Creator) VALUES 
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/lib/perl5/
site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  (/usr/local/rt3//lib/
RT.pm:247)

As rt3 working correctly befor update of db from rt2 i suspect the conversion 
tools but have no idea where to investigate to try to resolve my problem.

Any help will be welcom.

regards,

Philippe.



-- 
_____________________
Philippe Van Hecke
NETWORK ENGINEER
BELNET
Rue de la Science, 4 
B-1000 Brussels 
Belgium 
Tel: +32 (0) 27903333 
Fax: +32 (0) 27903335
______________________