Data conversion error?

Hello everybody

We have been using RT2 for 3 years now and it has worked very well. I am
now trying to upgrade to RT3.4.2 and receive the following error.

The upgrade process has gone fairly smoothly until now, with the upgrade
from RT 2.0.13 to RT 3.2.3 and then to RT 3.4.2 going sweetly. After the
upgrade I can create tickets in a new database properly, but as soon as
I import my historical data using the rt2-to-rt3-1.23 routines I am
unable to create tickets (this is probably a permission error - and I
will probably get to the bottom of it quite soon) BTW I did the dumpfile
routine from 2.0.13 to 3.2.3 and then went through the upgrade ro 3.4.2
following the directions.

However when I try to comment on one of the historical tickets I get the
following error…

error: Can’t call method “Scrips” on an undefined value at
/usr/local/rt3/share/html/Ticket/Elements/PreviewScrips line 95.

context: …
91: my @non_recipients = $TicketObj->SquelchMailTo;
92: </%init>
93:

<&|/l&>This message will be sent to…</&>


94: <&|/l&>(Check boxes to disable notifications to the listed
recipients)</&>


95: % foreach my $scrip (@{$Object->Scrips->Prepared}) {
96: % next unless
$scrip->ActionObj->Action->isa(‘RT::Action::SendEmail’);
97: <%$scrip->Description%>

98: <&|/l, $scrip->ConditionObj->Name, $scrip->ActionObj->Name,
$scrip->TemplateObj->Name&>[_1] [_2] with template [_3]</&>
99:

code stack: /usr/local/rt3/share/html/Ticket/Elements/PreviewScrips:95
/usr/local/rt3/share/html/Ticket/Update.html:135
/usr/local/rt3/share/html/autohandler:215

raw error

Does this mean anything to you?

My config is as follows:

Perl v5.8.7 under linux Apache v1.27; Apache::Connection v1.00;
Apache::Constants v1.09; Apache::DBI v0.94; Apache::Server v1.01;
Apache::Session v1.6; Apache::Session::Generate::MD5 v2.1;
Apache::Session::lock::Null v1.01; Apache::Session::Postgres v1.01;
Apache::Session::Serialize::Base64 v1.00; Apache::Session::Store::DBI
v1.02; Apache::Session::Store::Postgres v1.03; Apache::Status v2.03;
Apache::Table v0.01; AutoLoader v5.60; B v1.09; base v2.07;
Benchmark v1.07; bytes v1.02; Cache::Simple::TimedExpiry v0.23; Carp
v1.04; CGI v3.10; CGI::Cookie v1.25; CGI::Util v1.5;
Class::Container v0.12; Class::Data::Inheritable v0.02;
Class::ReturnValue v0.53; constant v1.05; Cwd v3.05; Data::Dumper
v2.121_04; DBD::Pg v1.43; DBI v1.48; DBIx::SearchBuilder v1.27;
DBIx::SearchBuilder::Unique v0.01; Devel::StackTrace v1.11;
Devel::StackTraceFrame v0.6; Digest::base v1.00; Digest::MD5 v2.33;
DynaLoader v1.05; Encode v2.10; Encode::Alias v2.03; Encode::Config
v2.00; Encode::Encoding v2.02; Errno v1.0901; Exception::Class v1.21;
Exception::Class::Base v1.2; Exporter v5.58; Exporter::Heavy v5.58;
Fcntl v1.05; fields v2.03; File::Basename v2.73; File::Glob v1.04;
File::Path v1.07; File::Spec v3.05; File::Spec::Unix v1.5; File::Temp
v0.16; FileHandle v2.01; HTML::Entities v1.29; HTML::Mason v1.28;
HTML::Mason::ApacheHandler v1.69; HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1; HTML::Mason::Exception::Compilation
v1.1; HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1; HTML::Mason::Exception::Decline
v1.1; HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1; HTML::Mason::Exception::System
v1.1; HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1; HTML::Mason::Exceptions
v1.43; HTML::Parser v3.45; HTML::Scrubber v0.08; I18N::LangTags
v0.35; I18N::LangTags::Detect v1.03; integer v1.00; IO v1.21;
IO::File v1.11; IO::Handle v1.24; IO::InnerFile v2.110; IO::Lines
v2.110; IO::Scalar v2.110; IO::ScalarArray v2.110; IO::Seekable
v1.09; IO::Wrap v2.110; IO::WrapTie v2.110; IPC::Open2 v1.01;
IPC::Open3 v1.0106; lib v0.5565; List::Util v1.14; locale v1.00;
Locale::Maketext v1.09; Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.49; Locale::Maketext::Lexicon::Gettext
v0.14; Log::Dispatch v2.10; Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26; Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18; Mail::Address v1.67; Mail::Field v1.67;
Mail::Field::AddrList v1.67; Mail::Header v1.67; Mail::Internet v1.67;
MIME::Base64 v3.05; MIME::Body v5.417; MIME::Decoder v5.417;
MIME::Entity v5.417; MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417; MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417; MIME::Head v5.417; MIME::Parser v5.417;
MIME::QuotedPrint v3.03; MIME::Tools v5.417; MIME::Words v5.417;
mod_perl v1.29; Module::Versions::Report v1.02; overload v1.03;
Params::Validate v0.78; POSIX v1.08; re v0.04; Regexp::Common v2.120;
Regexp::Common::delimited v2.104; RT v3.4.2; RT::Interface::Email
v1.02; Scalar::Util v1.14; SelectSaver v1.01; Socket v1.77; Storable
v2.13; strict v1.03; Symbol v1.06; Sys::Hostname v1.11; Sys::Syslog
v0.06; Text::Autoformat v1.13; Text::Quoted v1.8; Text::Reform v1.11;
Text::Tabs v98.112801; Text::Template v1.44; Text::Wrapper v1.000;
Time::HiRes v1.66; Time::JulianDay v2003.1125; Time::Local v1.11;
Time::ParseDate v2003.1126; Time::Timezone v2003.0211; URI v1.35;
URI::Escape v3.28; URI::URL v5.03; URI::WithBase v2.19; utf8 v1.05;
vars v1.01; Want v0.09; warnings v1.03; warnings::register v1.00;
XSLoader v0.02;

RT Variables
RT::AmbiguousDayInPast 1
RT::BasePath /usr/local/rt3
RT::BinPath /usr/local/rt3/bin
RT::CORE_CONFIG_FILE /usr/local/rt3/etc/RT_Config.pm
RT::CommentAddress rt@ServiceDesk.PICSolutions.com
RT::CorrespondAddress rt@ServiceDesk.PICSolutions.com
RT::DatabaseHost localhost
RT::DatabaseName rt3
RT::DatabasePassword Password not printed
RT::DatabaseRTHost localhost
RT::DatabaseType Pg
RT::DatabaseUser rt_user
RT::DateDayBeforeMonth 1
RT::DefaultSearchResultFormat ‘id/TITLE:#’, ‘Subject/TITLE:Subject’
, Status, QueueName, OwnerName, Priority, ‘NEWLINE’, ‘’,
Requestors’, ‘CreatedRelative’,
ToldRelative’,
LastUpdatedRelative’, ‘TimeLeft

RT::EmailOutputEncoding utf-8
RT::EtcPath /usr/local/rt3/etc
RT::FriendlyFromLineFormat “%s via RT” <%s>
RT::FriendlyToLineFormat “%s of ServiceDesk.PICSolutions.com Ticket
#%s”:;
RT::LocalEtcPath /usr/local/rt3/local/etc
RT::LocalLexiconPath /usr/local/rt3/local/po
RT::LocalPath /usr/local/rt3/local
RT::LogDir /opt/rt3/var/log
RT::LogToFileNamed rt.log
RT::LogToScreen error
RT::LogToSyslog debug
RT::LogoURL /NoAuth/images/bplogo.gif
RT::LoopsToRTOwner 1
RT::MailCommand sendmail
RT::MasonComponentRoot /usr/local/rt3/share/html
RT::MasonDataDir /usr/local/rt3/var/mason_data
RT::MasonLocalComponentRoot /usr/local/rt3/local/html
RT::MasonSessionDir /usr/local/rt3/var/session_data
RT::MaxAttachmentSize 10000000
RT::MaxInlineBody 13456
RT::MessageBoxWidth 72
RT::MessageBoxWrap HARD
RT::MinimumPasswordLength 5
RT::MyRequestsLength 10
RT::MyTicketsLength 10
RT::Organization ServiceDesk.PICSolutions.com
RT::OwnerEmail root
RT::RTAddressRegexp ^rt@ServiceDesk.PICSolutions.com$
RT::RecordOutgoingEmail 1
RT::RedistributeAutoGeneratedMessages 1
RT::SITE_CONFIG_FILE /usr/local/rt3/etc/RT_SiteConfig.pm
RT::SendmailArguments -oi
RT::SendmailPath /usr/sbin/sendmail
RT::Timezone ZA/Johannesburg
RT::UseFriendlyFromLine 1
RT::VERSION 3.4.2
RT::VarPath /usr/local/rt3/var
RT::WebBaseURL http://RT::rt.picsolutions.com:80
RT::WebFlushDbCacheEveryRequest 1
RT::WebImagesURL /NoAuth/images/
RT::WebURL http://RT::rt.picsolutions.com:80/
RT::rtname ServiceDesk.PICSolutions.com

Perl configuration
Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
Platform:
osname=linux, osvers=2.4.20-8, archname=i686-linux
uname=‘linux loki.picsolutions.com 2.4.20-8 #1 thu mar 13 17:54:28
est 2003 i686 i686 i386 gnulinux ‘
config_args=’‘
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc=‘cc’, ccflags =’-fno-strict-aliasing -pipe -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm’,
optimize=’-O2’,
cppflags=’-fno-strict-aliasing -pipe -I/usr/local/include
-I/usr/include/gdbm’
ccversion=’’, gccversion=‘3.2.2 20030222 (Red Hat Linux 3.2.2-5)’,
gccosandvers=’‘
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype=‘long’, ivsize=4, nvtype=‘double’, nvsize=8, Off_t=‘off_t’,
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld=‘cc’, ldflags =’ -L/usr/local/lib’
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
libc=/lib/libc-2.3.2.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=‘2.3.2’
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=’-Wl,-E
-Wl,-rpath,/usr/local/lib/perl5/5.8.7/i686-linux/CORE’
cccdlflags=’-fpic’, lddlflags=’-shared -L/usr/local/lib’

Regards,
Craig Elston
Systems Specialist

PIC Solutions
P.O. Box 2455, Cape Town 8000, South Africa

Tel: +27 (0)21 680-6008
Fax: +27 (0)21 680-6003
Email: CElston@PICSolutions.com
Web: www.PICSolutions.com