RT 3.0.11 Oracle errors with Groups and owners

My 3.0.10 RT instance works fine against Oracle, but when I upgraded a
test instance to 3.0.11, the → Configuration → Groups page shows up
blank and gives me an oracle error (see below). Also when trying to
assign an owner there are none listed other than “nobody”. I believe
something with the Groups isn’t coming up correct causing my queue
permissions to be messed up.

I have lots of errors in my log stating “ORA-00920: invalid relational
operator” or “ORA-00905: missing keyword”. I have debugged a little bit
from 3.0.10 to 3.0.11. It looks like the sql generated by clicking
“Configuration->Groups” in 3.0.10 used to be this:

SELECT main.* FROM Groups main WHERE ((main.Domain = ‘UserDefined’))
ORDER BY
main.Name ASC

In 3.0.11 the sql generated is this:

SELECT main.*
FROM ( SELECT DISTINCT main.id
FROM ( Groups main LEFT JOIN Principals as Principals_1 ON (
main.id = Principals_1.id))
WHERE ((Principals_1.Disabled = ‘0’)) AND ((main.Domain =
‘UserDefined’))
)
distinctquery, Groups main
WHERE (main.id = distinctquery.id) ORDER BY main.Name ASC

The error is in the “as Principals_1” I don’t think Oracle understands
the “as” keyword. I ran it by my DBA and she was able to run it if she
removed the as and changed the Principals_1 to Principals. Also if you
check the “Include disabled groups in listing” the groups show up and I
don’t receive an error.

Has anyone who is running Oracle seen this issue in 3.0.11? Am I
missing something in the upgrade. When I change back to 3.0.10
everything works fine.

Thanks for any information.

Greg

Here are some of the raw logs:

[Thu Jun 03 16:55:23 2004] [error] [client 10.10.50.156] FastCGI:
server “/opt/r
t3/bin/mason_handler.fcgi” stderr: DBD::Oracle::db prepare failed:
ORA-00905: mi
ssing keyword (DBD ERROR: error possibly near <> indicator at char 85
in 'SELEC
T main.
FROM ( SELECT DISTINCT main.id FROM ( Groups main LEFT JOIN
Principals
<>as Principals_1 ON ( main.id = Principals_1.id)) WHERE
((Principals_1.Disa
bled = ‘0’)) AND ((main.Domain = ‘UserDefined’)) ) distinctquery,
Groups main W
HERE (main.id = distinctquery.id) ORDER BY main.Name ASC’) [for
Statement "SELEC
T main.
FROM ( SELECT DISTINCT main.id FROM ( Groups main LEFT JOIN
Principals
as Principals_1 ON ( main.id = Principals_1.id)) WHERE
((Principals_1.Disable
d = ‘0’)) AND ((main.Domain = ‘UserDefined’)) ) distinctquery, Groups
main WHER
E (main.id = distinctquery.id) ORDER BY main.Name ASC"] at
/usr/local/lib/perl5/
site_perl/5.8.3/DBIx/SearchBuilder.pm line 129., referer:
http://test-rt.coacces
s.com/Admin/Queues/GroupRights.html?id=21
[Thu Jun 03 17:03:52 2004] [error] [client 10.10.50.156] FastCGI:
server “/opt/r
t3/bin/mason_handler.fcgi” stderr: Error:ORA-00920: invalid relational
operator
(DBD ERROR: error possibly near <> indicator at char 183 in 'SELECT
main.
FROM
( SELECT DISTINCT main.id FROM Users main, Principals Principals_1
WHERE ((Pri
ncipals_1.Disabled = ‘0’)) AND ((Principals_1.PrincipalType = ‘User’))
AND ((mai
n.Id <*>NULL ‘IS’)) AND ((lower(main.id) = principals_1.id)) )
distinctquery, U
sers main WHERE (main.id = distinctquery.id) ORDER BY main.Name ASC’),
referer:
http://test-rt.coaccess.com/Ticket/Display.html?id=4007

Benjamin Boksa b.boksa@sidebysite.de 6/3/2004 4:22:02 PM >>>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dunno if this is helpful, I wrote it some time ago:

http://www.boksa.de/tutorials/rt3_macosx.mpp

Regards,

Benne

I’m having trouble installing Request Tracker. I have LOTS of
questions so if you can help me - off list may be the way to go…

I am NOT a programmer, don’t know perl or unix - but I’m not afraid
to
learn or bang around to try to figure stuff out.

My goal is to install on to the school web server where i work -
which
is running OS X 10.3.4 Server, Apache 1.3.28, mysql 3.23.49 and php
4.3.2

Currently, I’m installing on a laptop running OS X 10.3 (client - not

Server) and everything else the same

I think I have perl 5.8.3 - how would I check to find out?

In following the documentation on the site, I got thru step 3 - all
the dependencies. I’m confused about WHERE I’m installing.
Ultimately it has to run from my web server, so it seems like it
should be going into the webserver directory, but step 1 or 2 says
NOT
to configure in the directory you want to install??? BTW, I’m not
sure I did 1 or 2 correctly either.

Step 4 says create a new unix group - I’m not sure I did this or did

it correctly.

Step 5 is where I get totally stuck - First where’s the rt directory
which one? where’s it supposed to be? None of the commands work for

me (make install, make initialize-database or make dropdb) regardless

of what directory I navigate to.

Also, since I played with all of this in Terminal (as root - of
course) I can no longer use my laptop as a testing server as the Web

sharing won’t start up and the web browser tells me that it can’t
find
“the server localhost”!!!

Thanks in advance for ANY help! I appreciate your time and energy.
Diana


The rt-users Archives

RT Developer and Administrator training is coming to LA, DC and
Frankfurt this spring and summer.
http://bestpractical.com/services/training.html

Sign up early, as class space is limited.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFAv6QiR5U9XkJXZKwRArUTAJoC5kPusNooQeTVY2ZMa8KuYjolngCffrU5
0/PDQZSnXtQQimk+vJxyUjk=
=N1gS
-----END PGP SIGNATURE-----

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Developer and Administrator training is coming to LA, DC and
Frankfurt this spring and summer.
http://bestpractical.com/services/training.html

Sign up early, as class space is limited.

CONFIDENTIALITY NOTICE: If you are not the intended recipient of this
electronic message, you are hereby notified that any disclosure, copying,
distribution, or action taken in reliance on the contents of this document
is strictly prohibited. If you received this information in error, please
notify the sender immediately and arrange for the return or destruction of
this document.
<<<>>>

My 3.0.10 RT instance works fine against Oracle, but when I upgraded a
test instance to 3.0.11, the → Configuration → Groups page shows up
blank and gives me an oracle error (see below). Also when trying to
assign an owner there are none listed other than “nobody”. I believe
something with the Groups isn’t coming up correct causing my queue
permissions to be messed up.

I have lots of errors in my log stating “ORA-00920: invalid relational
operator” or “ORA-00905: missing keyword”. I have debugged a little bit
from 3.0.10 to 3.0.11. It looks like the sql generated by clicking
“Configuration->Groups” in 3.0.10 used to be this:

Can you try the latest pre-release DBIx::SearchBuilder available on
CPAN? This is an issue we’ve found and fixed for a customer running
Oracle.

That worked great, I am no longer seeing any Oracle errors in the logs.

Thank you,

Greg

Jesse Vincent jesse@bestpractical.com 6/3/2004 6:09:57 PM >>>

My 3.0.10 RT instance works fine against Oracle, but when I upgraded
a
test instance to 3.0.11, the → Configuration → Groups page shows
up
blank and gives me an oracle error (see below). Also when trying to
assign an owner there are none listed other than “nobody”. I
believe
something with the Groups isn’t coming up correct causing my queue
permissions to be messed up.

I have lots of errors in my log stating “ORA-00920: invalid
relational
operator” or “ORA-00905: missing keyword”. I have debugged a little
bit
from 3.0.10 to 3.0.11. It looks like the sql generated by clicking
“Configuration->Groups” in 3.0.10 used to be this:

Can you try the latest pre-release DBIx::SearchBuilder available on
CPAN? This is an issue we’ve found and fixed for a customer running
Oracle.

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Developer and Administrator training is coming to LA, DC and
Frankfurt this spring and summer.
http://bestpractical.com/services/training.html

Sign up early, as class space is limited.

CONFIDENTIALITY NOTICE: If you are not the intended recipient of this
electronic message, you are hereby notified that any disclosure, copying,
distribution, or action taken in reliance on the contents of this document
is strictly prohibited. If you received this information in error, please
notify the sender immediately and arrange for the return or destruction of
this document.
<<<>>>