[rt-users] RT 3.8.4 install on Oracle - "ORA-04043: object Users does not exist"
Eric Coleman
eric.coleman at re-questinc.com
Mon Jun 22 12:23:24 EDT 2009
I'm having difficulties installing RT version 3.8.4 utilizing an Oracle
backend and would appreciate assistance/guidance through this issue.
When the RT build process (make initialize-database) reaches the create
schema step I'm receiving an Oracle 4043 error when the Users tables is
populated. The schema objects (tables, indexes and sequences) are being
generated successfully so I'm confident that DBI is making the connection to
the Oracle DB. I've verified that the Users table exists and via the
rt_user user as well as via the system (via alter session similar to the
build process) account, both of which are able to successfully access this
table.
I've also tried using the following command with the same results:
TWO_TASK=TIME perl sbin/rt-setup-database --dba=system
--dba-password=<password> --action coredata
Versions:
RT Version - 3.8.4
Perl Version - v5.8.5 built for i386-linux-thread-multi
Oracle - 10.2.0.4 - Enterprise Edition
OS - Linux app02.server.com 2.6.9-67.0.0.0.1.ELsmp #1 SMP Sun Nov 18
00:23:42 EST 2007 i686 i686 i386 GNU/Linux
Exact Error:
# TWO_TASK=TIME perl sbin/rt-setup-database --dba=rt_user
--dba-password=xxxxxxx --action coredata
Working with:
Type: Oracle
Host: db01.server.com
Name: TIME
User: RT_USER
DBA: rt_user
Now inserting RT core system objects
[Fri Jun 19 17:59:49 2009] [warning]: DBD::Oracle::st execute failed:
ORA-04043: object Users does not exist (DBD ERROR: Can't match some
parameters to LOB fields in the table, check type and name) [for Statement
"INSERT INTO Users (Comments, RealName, Creator, Password, LastUpdatedBy,
Created, id, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)" with
ParamValues: :p1='Do not delete or modify this user. It is integral to RTs
internal database structures', :p2='The RT System itself', :p3='1',
:p4='*NO-PASSWORD*', :p5='1', :p6='2009-06-19 17:59:49', :p7='7',
:p8='RT_System', :p9='2009-06-19 17:59:49'] at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm:509)
[Fri Jun 19 17:59:49 2009] [warning]: RT::Handle=HASH(0xb059c78) couldn't
execute the query 'INSERT INTO Users (Comments, RealName, Creator, Password,
LastUpdatedBy, Created, id, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?)' at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
522
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb059c78)',
'INSERT INTO Users (Comments, RealName, Creator, Password, Las...',
'HASH(0xb16772c)', 'The RT System itself', 1, '*NO-PASSWORD*', 1,
'2009-06-19 17:59:49', 7, ...) called at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 357
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb059c78)',
'Users', 'Comments', 'HASH(0xb16772c)', 'RealName', 'The RT System itself',
'Creator', 1, 'Password', ...) called at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line 105
DBIx::SearchBuilder::Handle::Oracle::Insert('RT::Handle=HASH(0xb059c78)',
'Users', 'Comments', 'HASH(0xb16772c)', 'RealName', 'The RT System itself',
'Creator', 1, 'Password', ...) called at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 1293
DBIx::SearchBuilder::Record::Create('RT::User=HASH(0xb138bb8)',
'Comments', 'Do not delete or modify this user. It is integral to RTs
inte...', 'RealName', 'The RT System itself', 'Creator', 1, 'Password',
'*NO-PASSWORD*', ...) called at
/stage/resource_tracker/rt-3.8.4/sbin/../lib/RT/Record.pm line 289
RT::Record::Create('RT::User=HASH(0xb138bb8)', 'id', 7, 'Comments',
'Do not delete or modify this user. It is integral to RTs inte...',
'Password', '*NO-PASSWORD*', 'LastUpdatedBy', 1, ...) called at
/stage/resource_tracker/rt-3.8.4/sbin/../lib/RT/User_Overlay.pm line 388
RT::User::_BootstrapCreate('RT::User=HASH(0xb138bb8)', 'Name',
'RT_System', 'RealName', 'The RT System itself', 'Comments', 'Do not delete
or modify this user. It is integral to RTs inte...', 'Creator', 1, ...)
called at /stage/resource_tracker/rt-3.8.4/sbin/../lib/RT/Handle.pm line 593
RT::Handle::InsertInitialData('RT::Handle=HASH(0xb059c78)') called
at sbin/rt-setup-database line 230
main::action_coredata('action', 'coredata', 'dba-password',
'<password>', 'dba', 'rt_user') called at sbin/rt-setup-database line 166
(/usr/lib/perl5/5.8.5/Carp.pm:204)
Couldn't finish 'coredata' step.
ERROR: Could not create user
Exact with DBI_TRACE=1 set:
<- STORE('ShowErrorStatement', 1)= 1 at Oracle.pm line 70
<- install_driver= DBI::dr=HASH(0x972fa14)
connect using
'(DESCRIPTION=(ADDRESS=(HOST=db01.re-questinc.com)(PROTOCOL=tcp)(PORT=1521))
(CONNECT_DATA=(SID=T
IME)))' <- connect('host=db01.re-questinc.com;sid=TIME;port=1521',
'RT_USER', ...)= DBI::db=HASH(0xbaabb50)
at DBI.pm line 653
<- STORE('PrintError', 1)= 1 at DBI.pm line 705
<- STORE('AutoCommit', 1)= 1 at DBI.pm line 705
<- STORE('Username', 'RT_USER')= 1 at DBI.pm line 708
<> FETCH('Username')= 'RT_USER' ('Username' from cache) at DBI.pm line
708
<- connected('dbi:Oracle:host=db01.re-questinc.com;sid=TIME;port=1521',
'RT_USER', ...)= undef at DBI.pm l
ine 714
<- connect= DBI::db=HASH(0xbaabb50)
<- STORE('dbi_connect_closure', CODE(0xbaa9c9c))= 1 at DBI.pm line 723
<- STORE('FetchHashKeyName', 'NAME_lc')= 1 at Handle.pm line 110
<- STORE('LongTruncOk', 1)= 1 at Oracle.pm line 48
<- STORE('LongReadLen', 8000)= 1 at Oracle.pm line 49
<- prepare('ALTER SESSION set NLS_DATE_FORMAT = 'YYYY-MM-DD
HH24:MI:SS'')= DBI::st=HASH(0x972f6b4) at Hand
le.pm line 469
<- execute= '0E0' at Handle.pm line 509
<- DESTROY(DBI::st=HASH(baabc88))= undef at Oracle.pm line 51
<- STORE('LongReadLen', 10000000)= 1 at Handle.pm line 122
<- prepare('SELECT * FROM Users WHERE lower(Name) = ?')=
DBI::st=HASH(0xac8bd98) at Handle.pm line 469
<- execute('rt_system')= '0E0' at Handle.pm line 509
<- fetchrow_hashref= undef at Record.pm line 1213
<- err= undef at Record.pm line 1215
<- DESTROY(DBI::st=HASH(972f738))= undef at Record.pm line 1126
<- ping= 1 at Handle.pm line 827
<- ping= 1 at Handle.pm line 827
<- begin_work= 1 at Handle.pm line 724
<- prepare('SELECT Principals_seq.nextval FROM DUAL')=
DBI::st=HASH(0xbafc500) at Handle.pm line 469
<- execute= '0E0' at Handle.pm line 509
<- fetchrow_array= ( "4" ) [1 items] row1 at Oracle.pm line 94
<- prepare('INSERT INTO Principals (Disabled, PrincipalType, id,
ObjectId) VALUES (?, ?, ?, ?)')= DBI::st=
HASH(0xbb0012c) at Handle.pm line 469
<- execute('0', 'User', ...)= 1 at Handle.pm line 509
<- DESTROY(DBI::st=HASH(bb0009c))= undef at Oracle.pm line 107
<- DESTROY(DBI::st=HASH(bbb700c))= undef at Record.pm line 1293
<- prepare('SELECT * FROM Principals WHERE id = ?')=
DBI::st=HASH(0xbbb6f34) at Handle.pm line 469
<- execute('4')= '0E0' at Handle.pm line 509
<- fetchrow_hashref= HASH(0xbbaa88c)4keys row1 at Record.pm line 1213
<- DESTROY(DBI::st=HASH(bbb7024))= undef at Record.pm line 1126
<- prepare('UPDATE Principals SET ObjectId=? WHERE id=? ')=
DBI::st=HASH(0xbbb7108) at Handle.pm line 469
<- execute('4', '4')= 1 at Handle.pm line 509
<- DESTROY(DBI::st=HASH(bbb7198))= undef at Cachable.pm line 139
<- prepare('INSERT INTO Users (Comments, RealName, Creator, Password,
LastUpdatedBy, Created, id, Name, La
stUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)')= DBI::st=HASH(0xbbb7228) at
Handle.pm line 469
<- bind_param(1, undef, ...)= 1 at Handle.pm line 495
!! ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR:
Can't match some parameters to LOB fi
elds in the table, check type and name)' (err#1)
<- execute('Do not delete or modify this user. It is integral to RT's
internal database structures', 'The
RT System itself', ...)= undef at Handle.pm line 509
ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR:
Can't match some parameters to LOB fi
elds in the table, check type and name)' (err#0)
<- errstr= 'ORA-04043: object Users does not exist (DBD ERROR: Can't
match some parameters to LOB fields i
n the table, check type and name)' at Handle.pm line 525
ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR:
Can't match some parameters to LOB fi
elds in the table, check type and name)' (err#1)
<- DESTROY(DBI::st=HASH(bbaaac0))= undef at Handle.pm line 357
ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR:
Can't match some parameters to LOB fi
elds in the table, check type and name)' (err#0)
<- ping= 1 at Handle.pm line 827
ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR:
Can't match some parameters to LOB fi
elds in the table, check type and name)' (err#0)
<- ping= 1 at Handle.pm line 827
!! ERROR: '4043' CLEARED by call to rollback method
<- rollback= 1 at Handle.pm line 769
Display for the gmake testdeps step:
# gmake testdeps
/usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-Oracle
--with-fastcgi
perl:
>=5.8.3(5.8.5)...found
users:
rt group (apache)...found
bin owner (root)...found
libs owner (root)...found
libs group (bin)...found
web owner (apache)...found
web group (apache)...found
CLI dependencies:
Term::ReadKey...found
Getopt::Long >= 2.24...found
HTTP::Request::Common...found
Term::ReadLine...found
Text::ParseWords...found
LWP...found
CORE dependencies:
Class::ReturnValue >= 0.40...found
Text::Quoted >= 2.02...found
CSS::Squish >= 0.06...found
Encode >= 2.13...found
Module::Versions::Report >= 1.05...found
MIME::Entity >= 5.425...found
DBI >= 1.37...found
Locale::Maketext::Lexicon >= 0.32...found
Devel::StackTrace >= 1.19...found
Digest::base...found
Time::ParseDate...found
File::Temp >= 0.18...found
Locale::Maketext >= 1.06...found
Tree::Simple >= 1.04...found
Text::Template >= 1.44...found
Scalar::Util...found
HTML::Scrubber >= 0.08...found
File::Spec >= 0.8...found
Calendar::Simple...found
DBIx::SearchBuilder >= 1.54...found
Sys::Syslog >= 0.16...found
Mail::Mailer >= 1.57...found
File::ShareDir...found
Regexp::Common...found
Digest::MD5 >= 2.27...found
HTML::Entities...found
Cache::Simple::TimedExpiry...found
File::Glob...found
Locale::Maketext::Fuzzy...found
Time::HiRes...found
Text::Wrapper...found
Log::Dispatch >= 2.0...found
UNIVERSAL::require...found
Email::Address...found
DASHBOARDS dependencies:
HTML::RewriteAttributes >= 0.02...found
MIME::Types...found
FASTCGI dependencies:
CGI::Fast...found
CGI >= 3.38...found
FCGI...found
GPG dependencies:
PerlIO::eol...found
GnuPG::Interface...found
ICAL dependencies:
Data::ICal...found
MAILGATE dependencies:
Pod::Usage...found
HTML::TreeBuilder...found
Getopt::Long...found
HTML::FormatText...found
LWP::UserAgent...found
MASON dependencies:
Storable >= 2.08...found
CSS::Squish >= 0.06...found
Apache::Session >= 1.53...found
Errno...found
Devel::StackTrace >= 1.19...found
CGI::Cookie >= 1.20...found
Text::WikiFormat >= 0.76...found
XML::RSS >= 1.05...found
HTML::Mason >= 1.36...found
Digest::MD5 >= 2.27...found
ORACLE dependencies:
DBD::Oracle...found
SMTP dependencies:
Net::SMTP...found
STANDALONE dependencies:
Net::Server::PreFork...found
Net::Server...found
HTTP::Server::Simple >= 0.34...found
HTTP::Server::Simple::Mason >= 0.09...found
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090622/ac6e8c7b/attachment.htm>
More information about the rt-users
mailing list