Rt2-to-rt3 postgres issue

used rt-2.0-to-dumpfile on data from a rt2.0.15 system. then after a
fresh install of rt3.4.2, i get the error below when i try to use
dumpfile-to-rt-3.0 to import the dump of the 2.0.15 system.
anyone know how to handle the error below?..
Importing groups
gggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting
tickets…t-1
[Tue Jun 28 18:48:10 2005] [crit]: Couldn’t create a ticket: Internal
Error: Couldn’t execute the query ‘INSERT INTO Tickets (Status, Queue,
Started, Type, Starts, id, LastUpdated, Subject, Creator, Owner,
LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)‘ERROR: duplicate key violates unique
constraint “tickets_pkey”
(/opt/rt3/lib/RT/Ticket_Overlay.pm:590)
Couldn’t create ticket HASH(0x986c434) $VAR1 = {
‘Status’ => ‘resolved’,
‘Queue’ => ‘kerberos-test’,
‘Started’ => ‘2002-04-17 19:18:21+00’,
‘Starts’ => ‘1970-01-01 00:00:00+00’,
’_RecordTransaction’ => ‘0’,
‘id’ => 1,
‘LastUpdated’ => ‘2003-02-06 00:01:26+00’,
‘Requestor’ => [
‘xxx@yyy.net’
],
‘Subject’ => ‘test from home’,
‘Creator’ => ‘1896’,
‘Owner’ => ‘1896’,
‘EffectiveId’ => ‘1’,
‘LastUpdatedBy’ => ‘2512’,
‘Resolved’ => ‘2002-04-17 19:18:39+00’,
‘Created’ => ‘2002-04-17 19:16:21+00’,
‘Due’ => ‘2002-04-19 19:16:21+00’
};
Couldn’t create trans 1
$VAR1 = {
‘Type’ => ‘Create’,
‘Ticket’ => ‘1’,
‘Created’ => ‘2002-04-17 19:16:22+00’,
‘id’ => 1,
‘Creator’ => ‘1896’,
‘ActivateScrips’ => ‘0’
};
rt_mig@zoolo$

help much appreciated,
mitchell

Law Mitchell wrote:

used rt-2.0-to-dumpfile on data from a rt2.0.15 system. then after a
fresh install of rt3.4.2, i get the error below when i try to use
dumpfile-to-rt-3.0 to import the dump of the 2.0.15 system.
anyone know how to handle the error below?..
Importing groups
gggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqImporting
tickets…t-1
[Tue Jun 28 18:48:10 2005] [crit]: Couldn’t create a ticket: Internal
Error: Couldn’t execute the query 'INSERT INTO Tickets (Status, Queue,
Started, Type, Starts, id, LastUpdated, Subject, Creator, Owner,
LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'ERROR: duplicate key violates unique
constraint “tickets_pkey”

Do the following, then re-import:

sbin/rt-setup-database --action drop

sbin/rt-setup-database --action init

It sounds like you already have tickets in the database.

(/opt/rt3/lib/RT/Ticket_Overlay.pm:590)
Couldn’t create ticket HASH(0x986c434) $VAR1 = {
‘Status’ => ‘resolved’,
‘Queue’ => ‘kerberos-test’,
‘Started’ => ‘2002-04-17 19:18:21+00’,
‘Starts’ => ‘1970-01-01 00:00:00+00’,
‘_RecordTransaction’ => ‘0’,
‘id’ => 1,
‘LastUpdated’ => ‘2003-02-06 00:01:26+00’,
‘Requestor’ => [
‘xxx@yyy.net’
],
‘Subject’ => ‘test from home’,
‘Creator’ => ‘1896’,
‘Owner’ => ‘1896’,
‘EffectiveId’ => ‘1’,
‘LastUpdatedBy’ => ‘2512’,
‘Resolved’ => ‘2002-04-17 19:18:39+00’,
‘Created’ => ‘2002-04-17 19:16:21+00’,
‘Due’ => ‘2002-04-19 19:16:21+00’
};
Couldn’t create trans 1
$VAR1 = {
‘Type’ => ‘Create’,
‘Ticket’ => ‘1’,
‘Created’ => ‘2002-04-17 19:16:22+00’,
‘id’ => 1,
‘Creator’ => ‘1896’,
‘ActivateScrips’ => ‘0’
};
rt_mig@zoolo$

help much appreciated,
mitchell


The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati