[rt-users] Failed To Record Message

[Joop van de Wege]

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