Import strangeness

Hi

I’m playing with importing our current production RT1 into a RT1.3.99
setup. After modifying the import script with the appropriate
variables, and running “perl ./import-1.0-to-2.0”, it seems to be
working 100%. It creates tickets, reads the transaction history, but
when I look in the web interface, the History is empty. Any ideas?

Regards,
Dewet

Dewet Diener dewet@devco.net -o)
Systems Administrator iTouch Labs /
Self-confessed geek and Linux fanatic __v

SYN! … SYN! ACK! … ACK!
The mating call of the internet

what does the rt.log.* for the import look like (it should be in /tmp)?
Are there entries in the database for the transactions? Is this true
if you log in as root?

    -jOn Wed, Jun 13, 2001 at 04:33:22PM +0200, Dewet Diener wrote:

Hi

I’m playing with importing our current production RT1 into a RT1.3.99
setup. After modifying the import script with the appropriate
variables, and running “perl ./import-1.0-to-2.0”, it seems to be
working 100%. It creates tickets, reads the transaction history, but
when I look in the web interface, the History is empty. Any ideas?

Regards,
Dewet


Dewet Diener dewet@devco.net -o)
Systems Administrator iTouch Labs /
Self-confessed geek and Linux fanatic __v

SYN! … SYN! ACK! … ACK!
The mating call of the internet


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

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Gur SOV jnagf gb znxr guvf fvt vyyrtny.

what does the rt.log.* for the import look like (it should be in /tmp)?
Are there entries in the database for the transactions? Is this true
if you log in as root?

    -j

mysql> select count() from Transactions;
| count(
) |
| 4030 |
1 row in set (0.00 sec)

The Data field is mostly NULL, except for merges, which look like
"Ticket 272 MergedInto ticket 271".

the rt.log is about 2.5MB. Which parts are you interested in? It
starts out with “Trying to load an email address: root@localhost”, runs
through all the e-mail addresses, and then immediately bombs with:

RT::User=HASH(0x87a8e18)->HasQueueRight Couldn’t find a queue id at
/usr/local/rt2/lib/RT/User.pm line 609
RT::User::HasQueueRight(‘RT::User=HASH(0x87a8e18)’,
‘TicketObj’, ‘RT::Ticket=HASH(0x8b71a5c)’, ‘Right’, ‘ShowTicket’)
called at /usr/local/rt2/lib/RT/Ticket.pm line 2802
RT::ticket::HasRight(‘RT::Ticket=HASH(0x8b71a5c)’, ‘Principal’,
‘RT::User=HASH(0x87a8e18)’, ‘Right’, ‘ShowTicket’) called at
/usr/local/rt2/lib/RT/Ticket.pm line 2773
RT::ticket::CurrentUserHasRight(‘RT::Ticket=HASH(0x8b71a5c)’,
‘ShowTicket’) called at /usr/local/rt2/lib/RT/Ticket.pm line 2723
RT::ticket::_Value(‘RT::Ticket=HASH(0x8b71a5c)’, ‘EffectiveId’)
called at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm
line 406
DBIx::SearchBuilder::Record::AUTOLOAD(‘RT::Ticket=HASH(0x8b71a5c)’)
called at /usr/local/rt2/lib/RT/Ticket.pm line 91
RT::ticket::Load(‘RT::Ticket=HASH(0x8b71a5c)’, 152) called at
/usr/local/rt2/lib/RT/Record.pm line 96
RT::Record::Create(‘id’, 1, ‘Queue’, 2, ‘Owner’, 7, ‘Subject’,
‘xx xxxxxxxxxx -> xxxxxxx xxxxxxxxxx’, …) called at
/usr/local/rt2/lib/RT/Ticket.pm line 449
RT::ticket::Import(‘RT::Ticket=HASH(0x8b71a5c)’, ‘id’, 1, ‘Queue’,
‘SysAdmin’, ‘Status’, ‘resolved’, ‘Requestor’, …) called at
./import-1.0-to-2.0 line 421 main::MigrateTickets() called at
./import-1.0-to-2.0 line 65
1_HasRight called without an AppliesTo object
Trying to load an email address: xxxxxx.xxxxxxx@xxxxxx.xxx.xx
RT::User=HASH(0x87a8e18) passed a bogus queue or queue object. aborting
ACL checkRT::User=HASH(0x87a8e18) passed a bogus queue or queue object.
aborting ACL checkUse of uninitialized value in concatenation (.) or
string at ./import-1.0-to-2.0 line 444.
DBD::mysql::st execute failed: Column ‘KeywordSelect’ cannot be null at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 317.
RT::Handle=HASH(0x87558f4) couldn’t execute the query 'INSERT INTO
ObjectKeywords (KeywordSelect, ObjectType, Keyword, ObjectId) VALUES
(?, ?, ?, ?)'Column ‘KeywordSelect’ cannot be null

This is repeated throughout the rest of the log. I only blanked out
some specific strings using ‘x’ above.

Dewet

Dewet Diener dewet@devco.net -o)
Systems Administrator iTouch Labs /
Self-confessed geek and Linux fanatic __v

SYN! … SYN! ACK! … ACK!
The mating call of the internet