Hi All,
We're having few IPM Applications and search screens and using the search screen we're pulling data from Content Server. Full Text Search is enabled in our server.
In our IPM search screen we're having few fields with Operator Text as Contains. Like report id contains, Report Name Contains etc. Whenever we're putting a 2 digit number (eg. there is a report whose id- 0069, and we put 69 in the id field and click on search ) in any of the field whose Operator Text is Contains, We're getting DRG-51030, DRG-50857, ORA-20000 and other ORA errors.
But, if we put 3 digits in the field (i.e- 069), no error is occurring and documents are returned properly. This is happening in our UAT environment.
In Dev if we put 1 digit in any of the field whose Operator Text is Contains the same error appears. But not if we put 2/3 digit.
In production irrespective of the digits this is working fine.
Note: For all Admin/Non Admin users this is happening. We have only Groups and roles, no Account/ACL is configured.
I've attached the screenshots and error logs, please let me know if any other information required.
IPM Version- 11.1.9
WCC version- 12.2.1
In Oracle support i found few documents but none of them are similar to this issue.
systemdatabase/6 05.21 09:56:17.349 IdcServer-30439 <sdata name="dID"/><sdata name="sddDocName"/><score />
systemdatabase/6 05.21 09:56:17.349 IdcServer-30439 </hitlist></ctx_result_set_descriptor>],[result (output)],[metaResult (output)],[baseResult (output)],[count (output)],[qvSnippetStartTag:<span class="largeTableEntry"><span class="highlightField">],[qvSnippetEndTag:</span></span>],[qvSnippetTranslation:true],[qvSnippetSeparator:<b>...</b>],[procFlags:0],[trace (output)])
>systemdatabase/6 05.21 09:56:17.594 IdcServer-30439 !csMonitorReadActions,109398
>systemdatabase/7 05.21 09:56:17.596 IdcServer-30439 (start) SELECT 1 FROM DUAL
>systemdatabase/6 05.21 09:56:17.600 IdcServer-30439 5.28 ms. SELECT 1 FROM DUAL[Executed. Returned row(s): true]
>systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 !csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 ORA-20000: Oracle Text error:
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 DRG-51030: wildcard query expansion resulted in too many terms
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 ORA-06512: at "CTXSYS.DRUE"\, line 171
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 869
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 ORA-06512: at "UAT25_OCS.CONTENT_SEARCH"\, line 125
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 ORA-06512: at "UAT25_OCS.CONTENT_SEARCH"\, line 320
systemdatabase/6 05.21 09:56:17.603 IdcServer-30439 ORA-06512: at line 1
>systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 run: 11 ms. total 25 ms. [ORA-20000: Oracle Text error:
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 DRG-50857: oracle error in ctx_query.result_set
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ORA-20000: Oracle Text error:
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 DRG-51030: wildcard query expansion resulted in too many terms
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ORA-06512: at "CTXSYS.DRUE", line 171
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ORA-06512: at "CTXSYS.CTX_QUERY", line 869
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ORA-06512: at "UAT25_OCS.CONTENT_SEARCH", line 125
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ORA-06512: at "UAT25_OCS.CONTENT_SEARCH", line 320
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ORA-06512: at line 1
systemdatabase/6 05.21 09:56:17.605 IdcServer-30439 ]
>searchquery/6 05.21 09:56:17.610 IdcServer-30439 !csMonitorActiveDbConnections,0
>searchquery/6 05.21 09:56:17.611 IdcServer-30439 Connection is removed from active connections with key of '35'.
>searchquery/6 05.21 09:56:17.614 IdcServer-30439 release pool connection
>systemdatabase/6 05.21 09:56:17.617 IdcServer-30439 Removing query: CotsSearchQuery
>systemdatabase/6 05.21 09:56:17.618 IdcServer-30439 Closing statement.
>systemdatabase/6 05.21 09:56:17.623 IdcServer-30439 !csMonitorActiveDbConnections,0
Thanks,
Pritam Biswas