Failed To Record Message

Hello All

I have problem with my RT we were previously running RT on oracle 9i. Now we
have shift it to oracle 10g . Now we are facing a strange problem that we
can access RT and can see our tickets but we are not been able update any
ticket or insert any comment or even insert any ticket also. When I have
looked at my logs it shows me like this

[Fri Jul 17 15:44:19 2009] [warning]: Encode::Guess failed: ; fallback to
iso-8859-1 (/opt/rt3/lib/RT/I18N.pm:414)

[Fri Jul 17 15:44:19 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:19 2009] [warning]: Encode::Guess failed: ; fallback to
iso-8859-1 (/opt/rt3/lib/RT/I18N.pm:414)

[Fri Jul 17 15:44:19 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:19 2009] [crit]: RT::Attachment->Create couldn’t, as you
didn’t specify a transaction (/opt/rt3/lib/RT/Attachment_Overlay.pm:145)

[Fri Jul 17 15:44:19 2009] [debug]: About to think about scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:165)

[Fri Jul 17 15:44:19 2009] [debug]: About to prepare scrips for transaction

(/opt/rt3/lib/RT/Transaction_Overlay.pm:169)

[Fri Jul 17 15:44:19 2009] [debug]: Found 4 scrips
(/opt/rt3/lib/RT/Scrips_Overlay.pm:363)

[Fri Jul 17 15:44:19 2009] [warning]: Transaction Created
(/opt/rt3/lib/RT/Record.pm:1464)

[Fri Jul 17 15:44:19 2009] [err]: This is
transcation:RT::Transaction=HASH(0xa4de134)
(/opt/rt3/lib/RT/Ticket_Overlay.pm:2448)

[Fri Jul 17 15:44:19 2009] [err]: RT::Ticket=HASH(0xa408638) couldn’t init a
transaction Transaction Created (/opt/rt3/lib/RT/Ticket_Overlay.pm:2451)

[Fri Jul 17 15:44:19 2009] [error]: Coulfn’t fire ‘Comment’ action: Message
could not be recorded (/opt/rt3/share/html/Ticket/Elements/PreviewScrips:90)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [crit]: RT::Attachment->Create couldn’t, as you
didn’t specify a transaction (/opt/rt3/lib/RT/Attachment_Overlay.pm:145)

[Fri Jul 17 15:44:25 2009] [debug]: About to think about scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:165)

[Fri Jul 17 15:44:25 2009] [debug]: About to prepare scrips for transaction

(/opt/rt3/lib/RT/Transaction_Overlay.pm:169)

[Fri Jul 17 15:44:25 2009] [debug]: Found 4 scrips
(/opt/rt3/lib/RT/Scrips_Overlay.pm:363)

[Fri Jul 17 15:44:25 2009] [debug]: About to commit scrips for transaction #
(/opt/rt3/lib/RT/Transaction_Overlay.pm:178)

[Fri Jul 17 15:44:25 2009] [warning]: Transaction Created
(/opt/rt3/lib/RT/Record.pm:1464)

[Fri Jul 17 15:44:25 2009] [err]: This is
transcation:RT::Transaction=HASH(0xad9da74)
(/opt/rt3/lib/RT/Ticket_Overlay.pm:2448)

[Fri Jul 17 15:44:25 2009] [err]: RT::Ticket=HASH(0xad74d48) couldn’t init a
transaction Transaction Created (/opt/rt3/lib/RT/Ticket_Overlay.pm:2451)

Can any one help me to solve this issue. I have debugged for 2 days and
still I haven’t found any solution to it.

Thanks & Regards

Varun Vyas

Software Engineer - Automation

Elitecore

Varun wrote:

Hello All

I have problem with my RT we were previously running RT on oracle 9i.
Now we have shift it to oracle 10g . Now we are facing a strange problem
that we can access RT and can see our tickets but we are not been able
update any ticket or insert any comment or even insert any ticket also.
When I have looked at my logs it shows me like this

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [crit]: RT::Attachment->Create couldn’t, as
you didn’t specify a transaction (/opt/rt3/lib/RT/Attachment_Overlay.pm:145)

[Fri Jul 17 15:44:25 2009] [debug]: About to think about scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:165)

[Fri Jul 17 15:44:25 2009] [debug]: About to prepare scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:169)

[Fri Jul 17 15:44:25 2009] [debug]: Found 4 scrips
(/opt/rt3/lib/RT/Scrips_Overlay.pm:363)

[Fri Jul 17 15:44:25 2009] [debug]: About to commit scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:178)

[Fri Jul 17 15:44:25 2009] [warning]: Transaction Created
(/opt/rt3/lib/RT/Record.pm:1464)

[Fri Jul 17 15:44:25 2009] [err]: This is
transcation:RT::Transaction=HASH(0xad9da74)
(/opt/rt3/lib/RT/Ticket_Overlay.pm:2448)

[Fri Jul 17 15:44:25 2009] [err]: RT::Ticket=HASH(0xad74d48) couldn’t
init a transaction Transaction Created
(/opt/rt3/lib/RT/Ticket_Overlay.pm:2451)

Since you’re using separate servers for web and database you can run
wireshark to sniff the sql that is created and what the error is that
Oracle returns. That error should show up in the logs but it looks like
it didn’t in the logs that you posted. Is there nothing in
rt.log/apache_error.log/syslog??
If not go the sniffing route and you should be able to find the error
returned.

Regards,

Joop

Apache error log says fail to execute query

[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x9acfd4c)
couldn’t execute the query ‘INSERT INTO Transactions (OldValue,
NewReference, OldReference, NewValue, Creator, ObjectId, Type, Field,
ReferenceType, Created, id, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)’ at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x9acfd4c)’,
‘INSERT INTO Transactions (OldValue, NewReference, OldReferenc…’, ‘undef’,
‘undef’, ‘undef’, ‘undef’, 12, 123572, ‘Create’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tDBIx::SearchBuilder::Handle::Insert(‘RT::Handle=HASH(0x9acfd4c)’,
‘Transactions’, ‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’,
‘OldReference’, ‘undef’, ‘NewValue’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Oracle.pm
line 105, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tDBIx::SearchBuilder::Handle::Oracle::Insert(‘RT::Handle=HASH(0x9acfd4c)’,
‘Transactions’, ‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’,
‘OldReference’, ‘undef’, ‘NewValue’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tDBIx::SearchBuilder::Record::Create(‘RT::Transaction=HASH(0x9ec3638)’,
‘OldValue’, ‘undef’, ‘NewReference’, ‘undef’, ‘OldReference’, ‘undef’,
‘NewValue’, ‘undef’, …) called at /opt/rt3/lib/RT/Record.pm line 303,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tRT::Record::Create(‘RT::Transaction=HASH(0x9ec3638)’, ‘OldValue’, ‘undef’,
‘NewReference’, ‘undef’, ‘OldReference’, ‘undef’, ‘NewValue’, ‘undef’, …)
called at /opt/rt3/lib/RT/Transaction_Overlay.pm line 153, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tRT::Transaction::Create(‘RT::Transaction=HASH(0x9ec3638)’, ‘ObjectId’,
123572, ‘ObjectType’, ‘RT::Ticket’, ‘TimeTaken’, ‘’, ‘Type’, ‘Create’, …)
called at /opt/rt3/lib/RT/Record.pm line 1444, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tRT::Record::_NewTransaction(‘RT::Ticket=HASH(0x9f8cbe4)’, ‘Type’,
‘Create’, ‘TimeTaken’, ‘’, ‘MIMEObj’, ‘MIME::Entity=HASH(0x9f910f8)’) called
at /opt/rt3/lib/RT/Ticket_Overlay.pm line 744, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tRT::ticket::Create(‘RT::Ticket=HASH(0x9f8cbe4)’, ‘DependsOn’,
‘ARRAY(0x9025f08)’, ‘TimeEstimated’, ‘’, ‘RefersTo’, ‘ARRAY(0x9025f68)’,
‘ReferredToBy’, ‘ARRAY(0x9025f80)’, …) called at
/opt/rt3/lib/RT/Interface/Web.pm line 446, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Commands::CreateTicket(‘Attachments’, ‘undef’,
‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’,
‘Object-RT::Ticket–CustomField-1-Value’, …) called at
/opt/rt3/share/html/Ticket/Display.html line 104, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Commands::ANON(‘TimeEstimated’, ‘’, ‘Status’, ‘new’,
‘new-DependsOn’, ‘’, ‘Object-RT::Ticket–CustomField-1-Value’, ‘’,
‘Requestors’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x9f8c
1e8)’, ‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’,
‘Object-RT::Ticket–CustomField-1-Value’, ‘’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1284,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Request::comp(‘undef’, ‘undef’, ‘TimeEstimated’, ‘’,
‘Status’, ‘new’, ‘new-DependsOn’, ‘’,
‘Object-RT::Ticket–CustomField-1-Value’, …) called at
/opt/rt3/share/html/Ticket/Create.html line 301, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Commands::ANON(‘TimeEstimated’, ‘’, ‘Status’, ‘new’,
‘new-DependsOn’, ‘’, ‘Object-RT::Ticket–CustomField-1-Value’, ‘’,
‘Requestors’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x9e70
cb8)’, ‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’,
‘Object-RT::Ticket–CustomField-1-Value’, ‘’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1284,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘TimeEstimated’, ‘’,
‘Status’, ‘new’, ‘new-DependsOn’, ‘’, …) called at
/opt/rt3/share/html/autohandler line 292, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Commands::ANON(‘TimeEstimated’, ‘’, ‘Status’, ‘new’,
‘new-DependsOn’, ‘’, ‘Object-RT::Ticket–CustomField-1-Value’, ‘’,
‘Object-RT::Ticket–CustomField-2-Values’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x9eb1
e18)’, ‘TimeEstimated’, ‘’, ‘Status’, ‘new’, ‘new-DependsOn’, ‘’,
‘Object-RT::Ticket–CustomField-1-Value’, ‘’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Request::comp(‘undef’, ‘undef’, ‘undef’, ‘TimeEstimated’, ‘’,
‘Status’, ‘new’, ‘new-DependsOn’, ‘’, …) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Request::exec(‘HTML::Mason::Request::CGI=HASH(0x9e476cc)’)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/CGIHandler.pm line
190, referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/CGIHandler.pm line 190,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Request::CGI::exec(‘HTML::Mason::Request::CGI=HASH(0x9e476cc)
’) called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Interp.pm line
342, referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::Interp::exec(‘undef’, ‘undef’, ‘TimeEstimated’, ‘’, ‘Status’,
‘new’, ‘new-DependsOn’, ‘’, ‘Object-RT::Ticket–CustomField-1-Value’, …)
called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/CGIHandler.pm line
121, referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/CGIHandler.pm line 121,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::_handler(‘HTML::Mason::CGIHandler=HASH(0x9acb508)
’, ‘HASH(0x9b733d8)’) called at
/usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/CGIHandler.pm line 73,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tHTML::Mason::CGIHandler::handle_cgi_object(‘HTML::Mason::CGIHandler=HASH(0
x9acb508)’, ‘CGI::Fast=HASH(0x9ddbfe4)’) called at
/opt/rt3/bin/mason_handler.fcgi line 76, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: \teval {…} called at
/opt/rt3/bin/mason_handler.fcgi line 76, referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009] [crit]:
RT::Attachment->Create couldn’t, as you didn’t specify a transaction
(/opt/rt3/lib/RT/Attachment_Overlay.pm:145), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[debug]: About to think about scrips for transaction #
(/opt/rt3/lib/RT/Transaction_Overlay.pm:165), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[debug]: About to prepare scrips for transaction #
(/opt/rt3/lib/RT/Transaction_Overlay.pm:169), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[debug]: Found 6 scrips (/opt/rt3/lib/RT/Scrips_Overlay.pm:363), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[debug]: About to commit scrips for transaction #
(/opt/rt3/lib/RT/Transaction_Overlay.pm:178), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[warning]: Transaction Created (/opt/rt3/lib/RT/Record.pm:1464), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[error]: Ticket couldn’t be created: , referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Could not make that principal a
Requestor for this ticket (/opt/rt3/lib/RT/Ticket_Overlay.pm:760), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in
concatenation (.) or string at /opt/rt3/share/html/Elements/Error line 68,
line 130., referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: [Mon Jul 20 14:42:03 2009]
[error]: WebRT: Ticket could not be created due to an internal error ()
(/opt/rt3/share/html/Elements/Error:76), referer:
http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in
string eq at /opt/rt3/share/html/Elements/Error line 78, line 130.,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Elements/Error line 52, line 130.,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
?INSERT INTO
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in
string eq at /opt/rt3/share/html/Ticket/Create.html line 299, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 91, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 101, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 185, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 191, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 197, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 220, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 221, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 222, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 223, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 224, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.html
[Mon Jul 20 20:22:46 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value in join
or string at /opt/rt3/share/html/Ticket/Create.html line 225, line
130., referer: http://rtbeta.elitecore.co.in/Ticket/Create.htmlFrom: Joop van de Wege [mailto:JoopvandeWege@mococo.nl]
Sent: Friday, July 17, 2009 10:42 PM
To: Varun
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Failed To Record Message

Varun wrote:

Hello All

I have problem with my RT we were previously running RT on oracle 9i.
Now we have shift it to oracle 10g . Now we are facing a strange problem
that we can access RT and can see our tickets but we are not been able
update any ticket or insert any comment or even insert any ticket also.
When I have looked at my logs it shows me like this

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: utf8
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [debug]: Guessed encoding: ascii
(/opt/rt3/lib/RT/I18N.pm:399)

[Fri Jul 17 15:44:25 2009] [crit]: RT::Attachment->Create couldn’t, as
you didn’t specify a transaction
(/opt/rt3/lib/RT/Attachment_Overlay.pm:145)

[Fri Jul 17 15:44:25 2009] [debug]: About to think about scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:165)

[Fri Jul 17 15:44:25 2009] [debug]: About to prepare scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:169)

[Fri Jul 17 15:44:25 2009] [debug]: Found 4 scrips
(/opt/rt3/lib/RT/Scrips_Overlay.pm:363)

[Fri Jul 17 15:44:25 2009] [debug]: About to commit scrips for
transaction # (/opt/rt3/lib/RT/Transaction_Overlay.pm:178)

[Fri Jul 17 15:44:25 2009] [warning]: Transaction Created
(/opt/rt3/lib/RT/Record.pm:1464)

[Fri Jul 17 15:44:25 2009] [err]: This is
transcation:RT::Transaction=HASH(0xad9da74)
(/opt/rt3/lib/RT/Ticket_Overlay.pm:2448)

[Fri Jul 17 15:44:25 2009] [err]: RT::Ticket=HASH(0xad74d48) couldn’t
init a transaction Transaction Created
(/opt/rt3/lib/RT/Ticket_Overlay.pm:2451)

Since you’re using separate servers for web and database you can run
wireshark to sniff the sql that is created and what the error is that
Oracle returns. That error should show up in the logs but it looks like
it didn’t in the logs that you posted. Is there nothing in
rt.log/apache_error.log/syslog??
If not go the sniffing route and you should be able to find the error
returned.

Regards,

Joop

Varun wrote:

Apache error log says fail to execute query

[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x9acfd4c)
couldn’t execute the query ‘INSERT INTO Transactions (OldValue,
NewReference, OldReference, NewValue, Creator, ObjectId, Type, Field,
ReferenceType, Created, id, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)’ at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x9acfd4c)’,
‘INSERT INTO Transactions (OldValue, NewReference, OldReferenc…’, ‘undef’,
‘undef’, ‘undef’, ‘undef’, 12, 123572, ‘Create’, …) called at

Whats missing is the ORA- error that should be there too. Oracle is
refusing the insert but it normally reports why. Could be a unique key
violation or invalid data etc.

Regards,

Joop

Well I am also trying to find it out but not been able to find exact cause.
I have checked database when I m firing same query in database then it is
inserting data but when I m firing query from application. I m getting this
error and I am not a database guy so not been able to track is there any
data corruption or key violations etc .From: Joop van de Wege [mailto:JoopvandeWege@mococo.nl]
Sent: Monday, July 20, 2009 3:14 PM
To: Varun
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Failed To Record Message

Varun wrote:

Apache error log says fail to execute query

[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x9acfd4c)
couldn’t execute the query ‘INSERT INTO Transactions (OldValue,
NewReference, OldReference, NewValue, Creator, ObjectId, Type, Field,
ReferenceType, Created, id, Data, ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?)’ at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
522,
referer: http://rtbeta.elitecore.co.in/Ticket/Create.html?Queue=483
[Mon Jul 20 20:12:03 2009] [error] [client 192.168.7.79] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
\tDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x9acfd4c)’,
‘INSERT INTO Transactions (OldValue, NewReference, OldReferenc…’,
‘undef’,
‘undef’, ‘undef’, ‘undef’, 12, 123572, ‘Create’, …) called at

Whats missing is the ORA- error that should be there too. Oracle is
refusing the insert but it normally reports why. Could be a unique key
violation or invalid data etc.

Regards,

Joop