Error In Submission When Searching on the Proposal (Charter) Page in Instantis EnterpriseTrack (Doc ID 1566006.1)

Last updated on MARCH 02, 2017

Applies to:

Instantis EnterpriseTrack - Version 4.3 and later
Instantis EnterpriseTrack Cloud Service - Version 4.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to do a search on the Proposal (Charter) Listing Page, the following error occurs.

ERROR
-----------------------
[engine-id = F_K9M79MHK9QP5J, engine-name = /charters/charterlisting/funnelgridpageserver, time = 2013-07-01 15:25:35.568 PDT] Executing count() on the query '/charters/queryengine/getFunnelsByFilter' failed. The error was: An error occured when executing the query. The error returned by the database was: ORA-29902: error in executing ODCIIndexStart() routine ORA-20000: Oracle Text error: DRG-51030: wildcard query expansion resulted in too many terms The SQL executed by the query was: SELECT COUNT (*) AS a_0 FROM F_K9M79QXCXVT7X x_funnelmaster, F_K9M79QW74KXXJ x_FunnelMaster_Ext, F_K9M79QWM5GMJX x_charterstaticmaster_ext WHERE ((/* ##5 */ (x_funnelmaster.C_1 != chr(0)) AND (x_funnelmaster.C_1 IN (SELECT 'dummy_funnel_id' FROM DUAL UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_1, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_5, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_33, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_31, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_30, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_34, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_26, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_29, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_25, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_32, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_27, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QXCXVT7X WHERE contains(C_28, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QLNSTQ3J WHERE contains(C_5, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QLNSTQ3J WHERE contains(C_8, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QLNSTQ3J WHERE contains(A_14, '(%\*% AND %\*%)', 0) > 0 UNION SELECT C_1 AS ti_col1_ FROM F_K9M79QLNSTQ3J WHERE contains(C_10, '(%\*% AND %\*%)', 0) > 0 UNION SELECT funnel_id FROM (SELECT C_1 AS funnel_id, C_6 AS doc FROM F_K9M79QLNSTQ3J ) , (SELECT /*+ INDEX(ulf T_I_CONTEXT_DATA) */ score(1) AS score, substr(ulf.fileid, 1, 20) AS fileid FROM T_UPLOADED_FILES ulf, T_FORM_CONFIGURATION fc WHERE (ulf.formId = fc.formid) AND (ulf.itype = 'VisitorFiles') AND (fc.username = 'instantis/bbcn') AND (contains (ulf.data, '(%\*% AND %\*%)', 1) > 0)) WHERE (fileid = doc)))) AND ((/* ##5 */ (x_funnelmaster.C_1 != chr(0)) AND (x_funnelmaster.C_1 IN (SELECT DISTINCT a_.C_3 FROM F_K9M79PRX6RX2L a_ WHERE (a_.C_1 = 'C') AND (a_.C_2 IN ('bank')) AND ( (0 = 1) OR (1 = 1) OR (a_.C_5 = 'ALL') OR ( (a_.C_5 = 'M') AND ( (a_.C_6 IN ('U.instantis_sa_uid')) OR (a_.C_7 IN ('U.instantis_sa_uid')) OR (a_.C_8 IN ('U.instantis_sa_uid')) OR (a_.C_9 IN ('U.instantis_sa_uid')) OR (a_.C_10 IN ('U.instantis_sa_uid')) ) ) )))) AND ((1 = 1) AND ((1 = 1) AND ((/* ##9 */ (LOWER(x_funnelmaster.C_38) = 'bank')) AND ((x_funnelmaster.C_1 = x_charterstaticmaster_ext.C_1) AND (x_funnelmaster.C_1 = x_FunnelMaster_Ext.C_1)))))))

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms