[rt-users] rt2-to-rt3 postgres issue

Law Mitchell lawmit at gmail.com
Tue Jun 28 15:44:56 EDT 2005


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 at 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 at zoolo$ 

help much appreciated,
mitchell



More information about the rt-users mailing list