[rt-users] RT 3.0.11 Oracle errors with Groups and owners

Thu Jun 3 19:06:36 EDT 2004

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 at 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

Am 03.06.2004 um 03:00 schrieb Diana Clarke:

> 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
>
> _______________________________________________
> 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.
-----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.
<<<<GWAVAsig>>>>