[rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

[Nick Yonko]

That was my initial thought, but when I log into the database using the rt user with sqlplus, as the account that runs the apache daemon no less, I can issue a 'desc attachments' command and a 'desc "Attachments"' command and both return the table structure.

----- Original Message -----
From: "Joop van de Wege" <JoopvandeWege at mococo.nl>
To: "Nick Yonko" <nyonko at advnettech.net>
Cc: rt-users at bestpractical.com
Sent: Tuesday, June 2, 2009 11:14:19 PM GMT -08:00 US/Canada Pacific
Subject: Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

Nick Yonko wrote:
> I am getting an error when rt-mailgate sends an email to RT saying that the Attachments object does not exist.  The email is received and the details of it are written to the database, however the body of the email is missing.  Has anyone dealt with this?  I am on Oracle 10.2.0, running RT on openSuSE 11.1 using the full administrator install of the Oracle client.
Can you login into the database using sqlplus with user rt_user/... and 
do a:
desc attachments

This should output the table structure of the Attachments table.
Looks like you're missing one table.
What could be the case, no pun indented, is that somehow the table was 
created using quotes which means Oracle is then case sensitive.

Regards,

Joop