Hey everyone,
We are having an odd issue with a CF5 ent server losing a connection with an
oracle 8i database server on a particular query. It drops out about 40% of
the time. We are using oracle's intermedia text to index some db records
and executing the query below to search the records and rank them. The
query takes a couple of seconds to execute. While this happens, the rest of
the applications on the server work happily, it seems to be isolated to this
query. Query is below (one that worked), error message immediately below.
Any help/ideas appreciated. C
------------------Error--------------------------
Error Diagnostic Information
Oracle Error Code = 3113
ORA-03113: end-of-file on communication channel
----------QUERY-----------
get_search_innovations (Records=73, Time=2203ms)
SQL =
select a.page_id,
a.link_name,
a.page_title,
i.grant_keywords,
score(1) score_keyword,
i.innovation_title,
i.innovation_short_title,
i.funding_round,
i.funded_body,
ceil(decode(sign(round(((score(1)*10 ) + score(2)*5 + score(3)*5 +
score(4) ) / 5)) - 100, 1, 100,
round(((score(1)*10 ) + score(2)*5 + score(3)*5 + score(4) )
/ 5) ) /10)
relevance
FROM ps_pages a,
ps_licensed_modules b,
iv_innovations i
WHERE a.SITE_ID = :1
and b.module_id = a.module_id
and b.site_id = a.site_id
and a.activated_yn = 'Y'
and i.page_id = a.page_id
and ( contains(i.grant_keywords,'?!{seeding}',1) > 0
or contains(i.innovation_title,'?!{seeding}',2) > 0
or contains(i.innovation_short_title,'?!{seeding}',3) > 0
or contains(a.htmlcontent,'?!{seeding}',4) > 0 )
order by relevance desc, score_keyword desc, a.page_title
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
