Rt2-to-rt3-v1.13 import problem

Hi,

i’m using rt2.0.9 and want to upgrade RT to rt3.0.3.

Old system:
SuSE 7.2
Apache 1.3.19
Perl 5.6.1
modperl1
Mysql 3.23.37

New system:
SuSE 8.2
Apache 1.3.27
Perl 5.8.0
modperl1
Mysql 4.0.13

I have installed rt3.0.3 and Mysql 4 on the new system an it looks fine.
Export the old rt2.0.9 database with rt2-to-rt3-v1.13/rt2-to-dumpfile
runs without errors.
Importing the rt database on the new system show the following errors
on 60 of my 6500 tickets.

.t-51
.t-52
[Mon Jun 30 13:13:59 2003] [crit]: Failed to create user : Must specify
’Name’ attribute (/opt/rt3/lib/RT/User_Overlay.pm:595)
[Mon Jun 30 13:13:59 2003] [error]: Could not load create a user with
the email address ‘’ to add as a watcher for ticket 52
(/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)
.t-53
[Mon Jun 30 13:14:05 2003] [crit]: Failed to create user : Must specify
’Name’ attribute (/opt/rt3/lib/RT/User_Overlay.pm:595)
[Mon Jun 30 13:14:05 2003] [error]: Could not load create a user with
the email address ‘’ to add as a watcher for ticket 53
(/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)
.t-54
.t-54

.t-999
Importing links
llllllllllllllllllllllllllllllllCould not create scrip: On Transaction
Notify Owner with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Notify Owner with template
Transaktionsmeldung in queue0 – $VAR1 = {
‘ScripCondition’ => ‘On Create’,
‘ScripAction’ => ‘Notify Owner’,
‘Queue’ => ‘0’,
‘Template’ => ‘Transaktionsmeldung’,
‘Description’ => ‘Imported from RT 2.0’
};

Could not create scrip: On Create Notify Requestors, Ccs and AdminCcs
with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Autoreply To Requestors with
templateEingangsbestaetigung in queue0

The script runs up to this point and exit.
Was the import sussessfull?
I can login on webui and also read and change tickets with errormessages
on import. But i have a bad feeling with this import.

Can i do something to repair that?

Thanks
Torsten

Torsten Olschewski wrote:

[Mon Jun 30 13:13:59 2003] [crit]: Failed to create user : Must specify
‘Name’ attribute (/opt/rt3/lib/RT/User_Overlay.pm:595)
[Mon Jun 30 13:13:59 2003] [error]: Could not load create a user with
the email address ‘’ to add as a watcher for ticket 52
(/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)
.t-53
[Mon Jun 30 13:14:05 2003] [crit]: Failed to create user : Must specify
‘Name’ attribute (/opt/rt3/lib/RT/User_Overlay.pm:595)
[Mon Jun 30 13:14:05 2003] [error]: Could not load create a user with
the email address ‘’ to add as a watcher for ticket 53
(/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)

Two ticket watchers cannot be created. Check those tickets and
make sure this is not going to cause you problems. It probably
won’t; have a look at the dumpfile and the original RT2 tickets
if you’re concerned.

Could not create scrip: On Transaction
Notify Owner with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Notify Requestors, Ccs and AdminCcs
with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Autoreply To Requestors with
templateEingangsbestaetigung in queue0

Custom templates are not imported. You should recreate them
after checking that all the objects and methods therein are
still valid, and then configure the above scrips for that
queue.

Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

Phil Homewood schrieb:

Hallo,

.t-53
[Mon Jun 30 13:14:05 2003] [crit]: Failed to create user : Must specify
‘Name’ attribute (/opt/rt3/lib/RT/User_Overlay.pm:595)
[Mon Jun 30 13:14:05 2003] [error]: Could not load create a user with
the email address ‘’ to add as a watcher for ticket 53
(/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)

Two ticket watchers cannot be created. Check those tickets and
make sure this is not going to cause you problems. It probably
won’t; have a look at the dumpfile and the original RT2 tickets
if you’re concerned.

for testing i have replaced the
“‘Email’ => undef,” with “‘Email’ => ‘myemail@host.com’”
in every ticket with these error.

Could not create scrip: On Transaction
Notify Owner with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Notify Requestors, Ccs and AdminCcs
with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Autoreply To Requestors with
templateEingangsbestaetigung in queue0

Custom templates are not imported. You should recreate them
after checking that all the objects and methods therein are
still valid, and then configure the above scrips for that
queue.

Here I have deleted the Scrip section in the metadata file.
‘Scrip’ => [
{
‘Template’ => ‘Transaktionsmeldung’,
‘Action’ => ‘NotifyOwner’,
‘Condition’ => ‘OnTransaction’
},
{
‘Template’ => ‘Correspondence’,
‘Action’ => ‘NotifyRequestors’,
‘Condition’ => ‘OnCorrespond’
},
{
‘Template’ => ‘Transaktionsmeldung’,
‘Action’ => ‘NotifyAllWatchers’,
‘Condition’ => ‘OnCreate’
},
{
‘Template’ =>
‘Eingangsbestaetigung’,
‘Action’ => ‘AutoreplyToRequestors’,
‘Condition’ => ‘OnCreate’
}
],

Do I need this section absolutely? In my new RT3 I have the standard
templates which i can change by hand. Thanks so far.

One error ist still there after the userimport:

Importing groups
gggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
[Wed Jul 2 08:14:56 2003] [crit]: 1 /opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Jul 2 08:14:56 2003] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
rrrrrrqqqqqqqqqqqqqqqqqqqqq
Importing tickets…t-1000
.

Groups table in rt2 looks different to rt3 table. So I can’t compare the
fields. How can I check this?

Thanks in advance
Torsten

Phil Homewood schrieb:

Hello,

.t-53
[Mon Jun 30 13:14:05 2003] [crit]: Failed to create user : Must
specify ‘Name’ attribute (/opt/rt3/lib/RT/User_Overlay.pm:595)
[Mon Jun 30 13:14:05 2003] [error]: Could not load create a user
with the email address ‘’ to add as a watcher for ticket 53
(/opt/rt3/lib/RT/Ticket_Overlay.pm:1420)

Two ticket watchers cannot be created. Check those tickets and
make sure this is not going to cause you problems. It probably
won’t; have a look at the dumpfile and the original RT2 tickets
if you’re concerned.

for testing i have replaced the
“‘Email’ => undef,” with “‘Email’ => ‘myemail@host.com’”
in every ticket with these error.

Could not create scrip: On Transaction Notify Owner with
templateTransaktionsmeldung in queue0
Could not create scrip: On Create Notify Requestors, Ccs and
AdminCcs with templateTransaktionsmeldung in queue0
Could not create scrip: On Create Autoreply To Requestors with
templateEingangsbestaetigung in queue0

Custom templates are not imported. You should recreate them
after checking that all the objects and methods therein are
still valid, and then configure the above scrips for that
queue.

I have deleted the Scrip section in the metadata file.
Do I need this section absolutely? In my new RT3 I have the standard
templates which i can change by hand. Thanks so far.

One error is still there after the userimport:

Importing groups
gggggggggggggrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr
[Wed Jul 2 08:14:56 2003] [crit]: 1 /opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Jul 2 08:14:56 2003] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
rrrrrrqqqqqqqqqqqqqqqqqqqqq
Importing tickets…t-1000
.

Groups table in rt2 looks different to rt3 table. So I can’t compare the
fields. How can I check this?

Thanks in advance
Torsten

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm