WACS Throws SQL Error On CM Query Zones (Doc ID 2704067.1)

Last updated on AUGUST 19, 2024

Applies to:

Goal

WACS has a SQL Error on CM Query Zones

Steps:

1. Duplicate the Base Zone 'F1-BNALGS' to 'CM-BNALGS'

2. Modify the DESCRIPTION as '*** Algorithm Search TEST ***' for 'CM-BNALGS'

3. Navigate to Entity Search Multi Query Zone as 'F1-BNDLENTQ' where DESCRIPTION in 'Entity Search' and Query Zone 1 in 'F1-BNALGS'

4. Add the CM version as #31: Query Zone 31 where OVERRIDE PARAMETER VALUE in 'CM-BNALGS'

5. Navigate to Bundle Export and open a 'Pending' record

6. At Entity Search > SEARCH BY > select the CM as '*** Algorithm Search TEST ***'

output:

<Error>

<USER> - c1073d8acdc9c5ed 2020-06-11 14:20:21.554 [242] ERROR com.splwg.base.support.sql.PreparedStatementImpl Error executing list for rawSQL:
null
with 'FixedCHAR' parameter named 'LANGUAGE' to : 'ENG' to indices:
with 'FixedCHAR' parameter named 'H1' to : '333046758256' to indices:
with 'FixedCHAR' parameter named 'F1' to : 'cm%%' to indices:
[correlationId=a6495f98-8405-44a4-9014-7d17f16fc4d8]
DBALINT - c1073d8acdc9c5ed 2020-06-11 14:20:21.552 [242] ERROR com.splwg.base.support.sql.PreparedStatementImpl Error parsing custom sql
SELECT 'REM' AS ACTION, 'ALGORITHM' AS MO_NAME, 'F1_REMOVE_LBL' as BUTTON_LBL,A.ALG_CD, :H1 as BNDL_ID FROM CI_ALG_L A WHERE UPPER(A.ALG_CD) LIKE UPPER (:F1) AND A.LANGUAGE_CD = :LANGUAGE AND EXISTS (SELECT * FROM F1_BNDL_ENTITY B WHERE B.BNDL_ID = :H1 AND B.MAINT_OBJ_CD='ALGORITHM' AND TRIM(A.ALG_CD) = TRIM(B.PK_VALUE1) ) UNION SELECT 'ADD' AS ACTION, 'ALGORITHM' AS MO_NAME,'ADD_LBL' as BUTTON_LBL,A.ALG_CD, :H1 as BNDL_ID FROM CI_ALG_L A WHERE UPPER(A.ALG_CD) LIKE UPPER (:F1) AND A.LANGUAGE_CD = :LANGUAGE AND NOT EXISTS (SELECT * FROM F1_BNDL_ENTITY B WHERE B.BNDL_ID = :H1 AND B.MAINT_OBJ_CD='ALGORITHM' AND TRIM(A.ALG_CD) = TRIM(B.PK_VALUE1) ) /* SQL for Zone 'CM-BNALGS' */ /* com.splwg.base.web.dataExplorer.common.DataExplorerSQLExecuter */
^
[correlationId=d5c40246-3c4c-4f23-a10f-86f8505bbd1b]

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.