File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Error" Watch "Oracle Error" New topic
Author

Oracle Error

Ram Sudheer Mandava
Greenhorn

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: message.error.search.database.operation
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(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1741)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:83)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
at com.artesia.server.search.entity.SearchResultEntityStorageManager.createSearchResult(SearchResultEntityStorageManager.java:435)
... 85 more
Carol Enderlin
drifter
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: http://aspose.com/file-tools
 
subject: Oracle Error