[rt-users] Failed To Record Message

[Varun]

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 .

-----Original Message-----
From: Joop van de Wege [mailto:JoopvandeWege at mococo.nl] 
Sent: Monday, July 20, 2009 3:14 PM
To: Varun
Cc: rt-users at 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