[rt-users] rt2.0.15 PostgreSQL to rt3.4.0 MySQL

Millard, Matt Millard.Matt at principal.com
Wed Feb 2 16:27:29 EST 2005 

Trying to go from rt2.0.15 PostgreSQL to rt3.4.0 MySQL and I'm getting some errors when I try and load the dump created by rt2-to-dumpfile with dumpfile-to-rt3.  Any ideas as to what's going on?

Original Server: rt2.0.15, Red Hat Linux 7.3, Perl 5.6.1, Postgresql 7.2.4 (Dual PII-266MHz, 190MB memory, 8000 tickets)
New Server: rt3.4.0, Red Hat Enterprise Linux, Perl 5.8.6, MySQL 4.1.9 (Dual Xeon 3.4GHz, 4GB memory)

[root at ul174 rt2-to-rt3-1.23]# ./dumpfile-to-rt-3.0 /rt
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 56.
Use of uninitialized value in concatenation (.) or string at /rt/rt3.4/etc/RT_SiteConfig.pm line 60.
Importing users
uCreating user joe.blow at principal.com
.uCreating user joe.blow at prinicpal.com
.
.
.
Importing groups
grrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrfffffqqqqqqqqqqImporting ticketsImporting links
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 34
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 254
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 385
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eeb324) tried to load a bogus ticket: 385
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9ef5e38) tried to load a bogus ticket: 386
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:57 2005] [crit]: RT::Ticket=HASH(0x9eed4a8) tried to load a bogus ticket: 386
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eeb39c) tried to load a bogus ticket: 390
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee7378) tried to load a bogus ticket: 157
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 391
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef5dd8) tried to load a bogus ticket: 392
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede7f0) tried to load a bogus ticket: 491
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed538) tried to load a bogus ticket: 684
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ef3bfc) tried to load a bogus ticket: 746
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eef6d0) tried to load a bogus ticket: 777
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 849
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 850
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9ede988) tried to load a bogus ticket: 899
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:58 2005] [crit]: RT::Ticket=HASH(0x9eed490) tried to load a bogus ticket: 926
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede9dc) tried to load a bogus ticket: 1017
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f424c0) tried to load a bogus ticket: 1149
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eeb150) tried to load a bogus ticket: 1184
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede8ec) tried to load a bogus ticket: 1320
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9edea84) tried to load a bogus ticket: 1655
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eef634) tried to load a bogus ticket: 2092
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee0954) tried to load a bogus ticket: 2245
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9eed4c0) tried to load a bogus ticket: 2343
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ede970) tried to load a bogus ticket: 2353
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee72b8) tried to load a bogus ticket: 1684
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9444) tried to load a bogus ticket: 2485
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee099c) tried to load a bogus ticket: 2485
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9ee9378) tried to load a bogus ticket: 2732
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:11:59 2005] [crit]: RT::Ticket=HASH(0x9f412c0) tried to load a bogus ticket: 2731
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede874) tried to load a bogus ticket: 2728
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)
l[Wed Feb  2 21:12:00 2005] [crit]: RT::Ticket=HASH(0x9ede97c) tried to load a bogus ticket: 2752
 (/rt/rt3.4/lib/RT/Ticket_Overlay.pm:257)

Could not create scrip: On Correspond Notify Owner With Attach with template Correspondence in queue0 -- $VAR1 = {
          'ScripCondition' => 'On Correspond',
          'ScripAction' => 'Notify Owner With Attach',
          'Queue' => '0',
          'Template' => 'Correspondence',
          'Description' => 'Imported from RT 2.0'
        };

 - may be due to a non-standard template, condition or action

Could not create scrip: On Correspond Notify Requestors, Ccs and AdminCcs With Attach with template Correspondence in queue #0
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Matt Autoreply in queue #6
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Midrange Auto Response in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Notify Owner with template Assigned in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Ticket Pickup Open Ticket with template blank in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Owner Change Open Ticket with template blank in queue #7
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template Quote  Autoreply in queue #9
 - may be due to a non-standard template, condition or action

Could not create scrip: On Create Autoreply To Requestors with template To Do  Reply in queue #10
 - may be due to a non-standard template, condition or action
Couldn't create link  from fsck.com-rt:/ticket/254 to fsck.com-rt:/ticket/270
Couldn't create link  from fsck.com-rt:/ticket/385 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/386 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/390 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/157 to fsck.com-rt:/ticket/390
Couldn't create link  from fsck.com-rt:/ticket/391 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/392 to fsck.com-rt:/ticket/57
Couldn't create link  from fsck.com-rt:/ticket/777 to fsck.com-rt:/ticket/391
Couldn't create link  from fsck.com-rt:/ticket/849 to fsck.com-rt:/ticket/392
Couldn't create link  from fsck.com-rt:/ticket/850 to fsck.com-rt:/ticket/385
Couldn't create link  from fsck.com-rt:/ticket/2485 to fsck.com-rt:/ticket/158


-----Message Disclaimer-----

This e-mail message is intended only for the use of the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential and exempt from disclosure under applicable law.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have
received this communication in error, please notify us immediately by
reply email to Connect at principal.com and delete or destroy all copies of
the original message and attachments thereto. Email sent to or from the
Principal Financial Group or any of its member companies may be retained
as required by law or regulation.

Nothing in this message is intended to constitute an Electronic signature
for purposes of the Uniform Electronic Transactions Act (UETA) or the
Electronic Signatures in Global and National Commerce Act ("E-Sign")
unless a specific statement to the contrary is included in this message.

More information about the rt-users mailing list