Applet Web Layout Editor (Preview) In WebTools Hangs When Opening
(Doc ID 2528423.1)
Last updated on NOVEMBER 13, 2019
Applies to:
Siebel Tools - Version 18.12 and laterInformation in this document applies to any platform.
Symptoms
(1) Login to Web Tools.
(2) Create/open any workspace.
(3) Go to [Applet] and select 'SIS Account Entry Applet'.
(4) Go to [Applet]->[Applet Web Template]->
(5) Click the pencil icon and try to open Applet Web Layout Editor.
The application hangs here and you can't do anything. The OM log shows that it is actually a performance issue and the following SQL was extremely slow:
SELECT
T6.CONFLICT_ID,
T6.LAST_UPD,
T6.CREATED,
T6.LAST_UPD_BY,
T6.CREATED_BY,
T6.MODIFICATION_NUM,
T6.WS_SRC_ID,
T3.GROUP_NAME,
T3.HTML_ATTR,
T3.SEQUENCE,
T3.TMPL_ITMHOLDERNAME,
T3.WEB_TMPL_NAME,
T1.APP_CD,
T6.COLUMN_SPAN,
T1.COLUMN_SPAN,
T6.COMMENTS,
T6.CTRL_NAME,
T6.EXPR,
T4.MODULE_NAME,
T2.APPLET_ID,
T4.NAME,
T6.GRID_PROPERTY,
T4.UPG_ICL_PATH_CD,
T6.INACTIVE_FLG,
T6.ITEM_NUM,
T1.ITEM_NUM,
T1.LANG_CD,
T6.MARKUP_LANG_CD,
T6.MODE_CD,
T6.MODULE_NAME,
T6.NAME,
T6.NAMESPACE,
T1.NAMESPACE,
T4.OBJ_LOCKED_LANG,
T4.OBJ_LOCKED_FLG,
T4.OBJ_LOCKED_BY,
T6.APPL_WEB_TMPL_ID,
T2.INACTIVE_FLG,
T2.NAME,
T4.PROJECT_ID,
T5.LOCKED_FLG,
T5.LOCKED_BY,
T5.NAME,
T5.UIFREEZE_FLG,
T5.UIFREEZE_BY,
T6.REPOSITORY_ID,
T6.ROW_SPAN,
T1.ROW_SPAN,
T6.REPOS_TYPE,
T4.UPG_BEHAVIOR,
T3.EXPR,
T6.EXTENSION_FLG,
T6.ROW_ID,
T6.WS_ID,
T6.WS_OBJ_VER,
T6.WS_DELETE_FLG,
T3.WS_SRC_ID,
T3.MODIFICATION_NUM,
T3.CREATED_BY,
T3.LAST_UPD_BY,
T3.CREATED,
T3.LAST_UPD,
T3.CONFLICT_ID,
T3.PAR_ROW_ID,
T3.REPOSITORY_ID,
T3.ROW_ID,
T3.WS_ID,
T3.WS_OBJ_VER,
T3.WS_DELETE_FLG,
T3.PAR_ROW_ID,
:1
FROM
(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APLT_WTI_INTL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APLT_WTI_INTL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T1,
(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPL_WEB_TMPL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPL_WEB_TMPL WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T2,
(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPL_WT_IT_RX WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPL_WT_IT_RX WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T3,
(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPLET WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPLET WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T4,
SIEBEL.S_PROJECT T5,
(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPL_WTMPL_IT WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPL_WTMPL_IT WHERE ((WS_ID = '1@1' AND WS_OBJ_VER<=3) OR (WS_ID = '1-2I4AR'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND TBL1.WS_OBJ_VER < TBL2.WS_OBJ_VER) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T6
WHERE
T2.APPLET_ID = T4.WS_SRC_ID AND
T6.WS_SRC_ID = T1.APPL_WTMPL_IT_ID (+) AND T1.APP_CD (+) = :2 AND T1.INACTIVE_FLG (+) = 'N' AND T1.LANG_CD (+) = :3 AND
T6.APPL_WEB_TMPL_ID = T2.WS_SRC_ID AND
T4.PROJECT_ID = T5.ROW_ID (+) AND
T6.WS_SRC_ID = T3.PAR_ROW_ID (+) AND
(T6.EXTENSION_FLG = 'N' OR T6.EXTENSION_FLG IS NULL) AND
(T6.APPL_WEB_TMPL_ID = :4)
ORDER BY
T6.APPL_WEB_TMPL_ID, T6.NAME
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |