[rt-users] RT 3.8.4 install on Oracle - "ORA-04043: object Users does not exist"
Eric Coleman
eric.coleman at re-questinc.com
Tue Jun 23 00:09:05 EDT 2009
Thank you Ruslan and Joop for your responses. I reverted from 1.23 to 1.22 and that resolved my issue. Thank you!
Eric
-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com]
Sent: Monday, June 22, 2009 11:41 AM
To: Eric Coleman
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT 3.8.4 install on Oracle - "ORA-04043: object Users does not exist"
Can you try with older DBD::Oracle module? 1.22 or older?
On Mon, Jun 22, 2009 at 8:23 PM, Eric
Coleman<eric.coleman at re-questinc.com> wrote:
> 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
>
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
--
Best regards, Ruslan.
More information about the rt-users
mailing list