RT on Oracle - ORA-04043 object Attachments does not exist

RT Users
1

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.

2

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

3

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.From: “Joop van de Wege” JoopvandeWege@mococo.nl
To: “Nick Yonko” nyonko@advnettech.net
Cc: rt-users@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

4

Nick Yonko wrote:

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.
Can you turn on sql logging within RT?
This might give you a clue as to what exact statement is causing the
ora-04043 error

Regards,

Joop

5

Do you know how I would do that?From: “Joop van de Wege” JoopvandeWege@mococo.nl
To: “Nick Yonko” nyonko@advnettech.net
Cc: rt-users@bestpractical.com
Sent: Wednesday, June 3, 2009 12:30:51 AM GMT -08:00 US/Canada Pacific
Subject: Re: [rt-users] RT on Oracle - ORA-04043 object Attachments does not exist

Nick Yonko wrote:

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.
Can you turn on sql logging within RT?
This might give you a clue as to what exact statement is causing the
ora-04043 error

Regards,

Joop