This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Oracle Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Error" Watch "Oracle Error" New topic

Oracle Error

Ram Sudheer Mandava

Joined: Aug 04, 2010
Posts: 22
Dear All,
I am getting following error while I try to connect to the Oracle database through my web application

Exception Debug:
failed sql: insert into view_elements (view_id, element_type, element_id, position, session_id)
select 2605459, 'UOI', uoi_id, rownum, 1107006 from ( select ui.uoi_id from ( select distinct t0.uoi_id, t0.import_dt b0 from uois t0, ( select uoi_id, s from ( select uoi_id, score(0) s from uois_fulltext_metadata where contains (all_metadata_index, ?, 0) > 0)) t1, wml_images_skus_vw t2, wml_images_skus_vw t3, security_policy_permissions t4, security_policy_uois t5, user_group_users t6 where (t0.IS_LATEST_VERSION = ? and (t0.CONTENT_STATE != ? or t0.CONTENT_STATE is null) and (t2.PRODCAT != ? or t2.PRODCAT is null) and t3.BRAND = ? and (t4.user_group_id = t6.user_group_id AND t6.user_id = '381' and t4.asset_view_perm = 'Y' )) and t1.uoi_id = t0.uoi_id and t2.uoi_id = t0.uoi_id and t3.uoi_id = t0.uoi_id and t5.sec_policy_id = t4.sec_policy_id and t5.uoi_id = t0.uoi_id ) ui order by ui.b0 desc) where rownum <= 2000

Exception Message Id:
Exception Message: Database error processing search.
Exception Data: none
Exception Failed IDs: none
Exception Stack Trace:
com.artesia.common.exception.BaseTeamsException: Database error processing search.
Caused by: java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.oci8.OCIDBAccess.check_error(
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(
at oracle.jdbc.driver.OracleStatement.executeNonQuery(
at oracle.jdbc.driver.OracleStatement.doExecuteOther(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(
... 85 more
Carol Enderlin
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
Have you tried googling your error? There are a bunch of matches.

What value are you setting for your contains ?

contains (all_metadata_index, ?, 0)
I agree. Here's the link:
subject: Oracle Error
It's not a secret anymore!