RT 3.8.4 install on Oracle - "ORA-04043: object Users does not exist"

RT Users
1

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= --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',

‘’, ‘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
2

Can you try with older DBD::Oracle module? 1.22 or older?On Mon, Jun 22, 2009 at 8:23 PM, Eric Colemaneric.coleman@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= --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',

‘’, ‘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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

3

Eric Coleman wrote:

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.

ORACLE dependencies:

    DBD::Oracle...found

I wrote a post last week to rt-devel/rt-user about this. My guess is
that you’re upto date on DBD::Oracle (1.23), in that case install 1.22
and do a make dropdb followed by a make initdb. Things will go right
this time. Seems like a bug has crept into DBD::Oracle in 1.23

Regards,

Joop

4

Thank you Ruslan and Joop for your responses. I reverted from 1.23 to 1.22 and that resolved my issue. Thank you!
EricFrom: Ruslan Zakirov [mailto:ruslan.zakirov@gmail.com]
Sent: Monday, June 22, 2009 11:41 AM
To: Eric Coleman
Cc: rt-users@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?