Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle Error  RSS feed

Ram Sudheer Mandava
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!