Siebel Web Tools Displays Blank Page after login due to Performance Issue (Doc ID 2714758.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Siebel CRM - Version 20.3 to 20.6 [Release V17]
Information in this document applies to any platform.

Symptoms

When trying to access Siebel web tools, it displays blank page after click on login. The below query is executed many times and Initial Fetch Time for SQL takes time of around 240 secs for each execution and hangs at last step

SELECT /*+ parallel(auto) */

T8.CONFLICT_ID,

T8.LAST_UPD,

T8.CREATED,

T8.LAST_UPD_BY,

T8.CREATED_BY,

T8.MODIFICATION_NUM,

T8.WS_SRC_ID,

T1.APP_CD,

T8.ASSOC_APPLET_NAME,

T8.AUTO_QUERYMODE,

T8.BGND_BMAP_NAME,

T8.BGND_BMAP_STYLE,

T8.BROWSER_CLASS,

T8.BUSCOMP_NAME,

T8.CLASS_NAME,

T8.COMMENTS,

T8.DFLT_APPLET_METHOD,

T8.DFLT_DBLCLK_METHOD,

T8.DISA_DATALOSS_FLG,

T8.HTML_NUM_ROWS,

T8.HTML_POPUP_DM,

T8.HEIGHT,

T8.HELP_ID,

T8.UPG_ICL_PATH_CD,

T8.INACTIVE_FLG,

T8.INS_APPLET_NAME,

T8.INSERT_POSITION,

T1.LANG_CD,

T5.NAME,

T8.MAIL_ADD_FLD_NAME,

T8.MAIL_TEMPLATE,

T8.MODULE_NAME,

T8.NAME,

T8.NODELETE,

T8.NOINSERT,

T8.NOMERGE,

T8.NOUPDATE,

T8.OBJ_LOCKED_LANG,

T8.OBJ_LOCKED_FLG,

T8.OBJ_LOCKED_BY,

T6.LOGIN,

T8.OBJ_LOCKED_DATE,

T8.POPUP_DIMENSION,

T8.PROJECT_ID,

T7.LOCKED_FLG,

T7.LOCKED_BY,

T7.NAME,

T7.UIFREEZE_FLG,

T7.UIFREEZE_BY,

T8.REPOSITORY_ID,

T8.SCRIPTED_FLG,

T8.SRCHSPEC,

T8.TASK_NAME,

T8.TEXT_STYLE_NAME,

T2.STRING_VALUE,

T4.STRING_VALUE,

T1.TITLE,

T8.TITLE_REF,

T8.TYPE,

T8.UPGD_ANCESTOR,

T8.UPG_BEHAVIOR,

T8.WIDTH,

T8.ROW_ID,

T8.WS_ID,

T8.WS_OBJ_VER,

T8.WS_DELETE_FLG,

T3.WS_SRC_ID,

T3.PAR_ROW_ID,

T3.ROW_ID,

T3.WS_ID,

T3.WS_OBJ_VER,

T3.WS_DELETE_FLG,

FROM

(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPLET_INTL WHERE ((WS_ID = :2))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPLET_INTL WHERE ((WS_ID = :3))) 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 = :4) T1,

(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_SYM_STR_INTL WHERE ((WS_ID = :5))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_SYM_STR_INTL WHERE ((WS_ID = :6))) 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 = :7) T2,

(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPLET_RX WHERE ((WS_ID = :8))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPLET_RX WHERE ((WS_ID = :9))) 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 = :10) T3,

(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_SYM_STR_INTL WHERE ((WS_ID = :11))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_SYM_STR_INTL WHERE ((WS_ID = :12))) 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 = :13) T4,

(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_LIST WHERE ((WS_ID = :14))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_LIST WHERE ((WS_ID = :15))) 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 = :16) T5,

SIEBEL.S_USER T6,

SIEBEL.S_PROJECT T7,

(SELECT TBL1.* FROM (SELECT * FROM SIEBEL.S_APPLET WHERE ((WS_ID = :17))) TBL1 LEFT OUTER JOIN (SELECT * FROM SIEBEL.S_APPLET WHERE ((WS_ID = :18))) 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 = :19) T8

WHERE

T8.WS_SRC_ID = T1.APPLET_ID (+) AND T1.APP_CD (+) = :20 AND T1.INACTIVE_FLG (+) = 'N' AND T1.LANG_CD (+) = :21 AND

T8.OBJ_LOCKED_BY = T6.PAR_ROW_ID (+) AND

T8.PROJECT_ID = T7.ROW_ID (+) AND

T8.WS_SRC_ID = T5.APPLET_ID (+) AND

T8.REPOSITORY_ID = T2.REPOSITORY_ID (+) AND T8.TITLE_REF = T2.SYM_STR_KEY (+) AND T2.APP_CD (+) = 'STD' AND T2.INACTIVE_FLG (+) = 'N' AND T2.LANG_CD (+) = :22 AND

T8.REPOSITORY_ID = T4.REPOSITORY_ID (+) AND T8.TITLE_REF = T4.SYM_STR_KEY (+) AND T4.APP_CD (+) = :23 AND T4.INACTIVE_FLG (+) = 'N' AND T4.LANG_CD (+) = :24 AND

T8.WS_SRC_ID = T3.PAR_ROW_ID (+)

ORDER BY

T8.NAME