intradoc.data.DataException: !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error: search/7 04.17 07:11:45.146 IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set search/7 04.17 07:11:45.146 IdcServer-3513 ORA-20000: Oracle Text error: search/7 04.17 07:11:45.146 IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000 search/7 04.17 07:11:45.146 IdcServer-3513 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at line 1 search/7 04.17 07:11:45.146 IdcServer-3513 search/7 04.17 07:11:45.146 IdcServer-3513

Oracle Community | 2983392 | 11 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Search results are getting displayed in Web UI but not from DIS

    Oracle Community | 11 months ago | 2983392
    intradoc.data.DataException: !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error: search/7 04.17 07:11:45.146 IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set search/7 04.17 07:11:45.146 IdcServer-3513 ORA-20000: Oracle Text error: search/7 04.17 07:11:45.146 IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000 search/7 04.17 07:11:45.146 IdcServer-3513 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at line 1 search/7 04.17 07:11:45.146 IdcServer-3513 search/7 04.17 07:11:45.146 IdcServer-3513
  2. 0

    WebCenter Content Server startup error csServiceDataException,DBSEARCH_UPDATE_ZONE_FIELDS

    Oracle Community | 1 year ago | 1799267
    intradoc.data.DataException: !csJdbcGenericError services/3 11.09 11:30:55.739 [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'
  3. 0

    Error while upload content in UCM: after site studio integration with UCM

    Oracle Community | 3 years ago | 1010126
    java.sql.SQLException: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE<br> intradoc.common.ServiceException: !csServiceDataException,CHECKIN_NEW_SUB,Imeta!$ *ScriptStack CHECKIN_NEW_SUB 3:doScriptableAction,dDocName=abc0013:doSubService,dDocName=abc001CHECKIN_NEW_SUB,dDocName=abc0012:Imeta,dID=10810,dDocName=ABC001
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Migration Import Issue

    Oracle Community | 3 years ago | user277913 - oracle
    intradoc.common.ServiceException: !csServiceDataException,INSERT_NEW,validateStandard!$
  6. 0

    Site Studio 11g--unable to get search results

    Oracle Community | 6 years ago | oim11guser
    intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT Revisions.dDocName\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtensi on\, dInDate\, dOutDate\, dPublishType\, dRendition1\, dRendition2\, dFileSize AS VaultFileSize\, DocMeta.* FROM Revisio ns\, DocMeta\, Documents WHERE Revisions.dID=DocMeta.dID And Revisions.dID=Documents.dID And dIsPrimary=1 AND dReleaseSt ate IN ('Y'\, 'U'\, 'I') AND (((((( CONTAINS(xWebsites\, 'S1')> 0 )) AND ( xWebsiteObjectType LIKE 'Element Definitio n' ))))) ORDER BY Revisions.dDocName ASC!$ORA-00904: "CONTAINS": invalid identifier

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. intradoc.data.DataException

      !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error: search/7 04.17 07:11:45.146 IdcServer-3513 DRG-50857: oracle error in ctx_query.result_set search/7 04.17 07:11:45.146 IdcServer-3513 ORA-20000: Oracle Text error: search/7 04.17 07:11:45.146 IdcServer-3513 DRG-13607: end_hit_num is not specified or out of valid range 1..16000 search/7 04.17 07:11:45.146 IdcServer-3513 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "CTXSYS.DRUE"\, line 160 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 800 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 125 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at "DMS07_OCS_2.CONTENT_SEARCH"\, line 320 search/7 04.17 07:11:45.146 IdcServer-3513 ORA-06512: at line 1 search/7 04.17 07:11:45.146 IdcServer-3513 search/7 04.17 07:11:45.146 IdcServer-3513

      at intradoc.jdbc.JdbcWorkspace.handleSQLException()
    2. intradoc.jdbc
      JdbcWorkspace.handleSQLException
      1. intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2680)
      1 frame