[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