Repository Search Returns Error when Searching Task Related Repository Objects SBL-DAT-00464 (Doc ID 2226983.1)

Last updated on JANUARY 25, 2017

Applies to:

Siebel Tools - Version 16.5 [IP2016] and later
Information in this document applies to any platform.

Symptoms

On : 16.5 [IP2016] version, Upgrade

Repository Search is not working on the Local and Server Database.

Login into Siebel Tools.

Use the Application Menu Tools / Repository Search.

Repository Search always errors out. Most of the time the error code is the following:

"Unable to find the parent buscomp of buscomp 'Repository Task Step IO Argument', possibly because there is no active link at this time.(SBL-DAT-00464)".

The detailed Siebel Tools siebdev.log had the following sql with error SBL-DAT-00464 in the log file.

The environment variable Siebel_Log_Events was set to 5.


ObjMgrSqlCursorLog Create 5 00000002588217dc:0 2017-01-20 12:07:43 End: construct Sql Cursor Object b551918

ObjMgrSqlLog Detail 4 00000002588217dc:0 2017-01-20 12:07:43 SELECT statement with ID: B551918
SELECT /*+ ALL_ROWS */
  T9.CONFLICT_ID,
  T9.DB_LAST_UPD_SRC,
  T9.DB_LAST_UPD,
  T9.LAST_UPD,
  T9.CREATED,
  T9.LAST_UPD_BY,
  T9.CREATED_BY,
  T9.MODIFICATION_NUM,
  T9.ROW_ID,
  T9.ARG_NAME,
  T9.BUSCOMP_NAME,
  T9.BUSCOMP_FLD_NAME,
  T9.COMMENTS,
  T2.MODULE_NAME,
  T7.BUSOBJ_NAME,
  T2.TASK_ID,
  T7.INACTIVE_FLG,
  T7.NAME,
  T9.INACTIVE_FLG,
  T9.MODULE_NAME,
  T9.NAME,
  T7.OBJ_LOCKED_LANG,
  T7.OBJ_LOCKED_FLG,
  T7.OBJ_LOCKED_BY,
  T2.BUSCOMP_NAME,
  T2.SERVICE_NAME,
  T2.METHOD_NAME,
  T9.TASK_STEP_ID,
  T2.INACTIVE_FLG,
  T2.NAME,
  T2.REPOSITORY_ID,
  T9.PREF_SEQ,
  T7.PROJECT_ID,
  T8.LOCKED_FLG,
  T8.LOCKED_BY,
  T8.LOCKED_LANG,
  T8.NAME,
  T8.UIFREEZE_FLG,
  T8.UIFREEZE_BY,
  T9.PROP_NAME,
  T9.REPOSITORY_ID,
  T3.NAME,
  T7.MODULE_NAME,
  T9.VAL,
  T9.INPUT_OUTPUT_CD,
  T6.NAME,
  T6.VAL,
  T6.LANG_ID,
  T6.TYPE,
  T6.BU_ID,
  T2.ACTION_TYPE_CD,
  T4.NAME,
  T4.VAL,
  T4.LANG_ID,
  T4.TYPE,
  T4.BU_ID,
  T2.TYPE_CD,
  T5.NAME,
  T5.VAL,
  T5.LANG_ID,
  T5.TYPE,
  T5.BU_ID,
  T9.TYPE_CD,
  T1.NAME,
  T1.VAL,
  T1.LANG_ID,
  T1.TYPE,
  T1.BU_ID,
  T7.ROW_ID,
  T7.ROW_ID,
  T7.MODIFICATION_NUM,
  T7.DB_LAST_UPD,
  T2.ROW_ID,
  T2.ROW_ID,
  T2.MODIFICATION_NUM,
  T2.DB_LAST_UPD,
  T8.ROW_ID,
  T8.ROW_ID,
  T8.MODIFICATION_NUM,
  T8.DB_LAST_UPD,
  T3.ROW_ID,
  T3.ROW_ID,
  T3.MODIFICATION_NUM,
  T3.DB_LAST_UPD,
  T6.ROW_ID,
  T6.TYPE,
  T6.LANG_ID,
  T6.NAME,
  T6.MODIFICATION_NUM,
  T6.DB_LAST_UPD,
  T4.ROW_ID,
  T4.TYPE,
  T4.LANG_ID,
  T4.NAME,
  T4.MODIFICATION_NUM,
  T4.DB_LAST_UPD,
  T5.ROW_ID,
  T5.TYPE,
  T5.LANG_ID,
  T5.NAME,
  T5.MODIFICATION_NUM,
  T5.DB_LAST_UPD,
  T1.ROW_ID,
  T1.TYPE,
  T1.LANG_ID,
  T1.NAME,
  T1.MODIFICATION_NUM,
  T1.DB_LAST_UPD,
  :1
  FROM
  SIEBEL.S_LST_OF_VAL T1,
  SIEBEL.S_TU_STEP T2,
  SIEBEL.S_REPOSITORY T3,
  SIEBEL.S_LST_OF_VAL T4,
  SIEBEL.S_LST_OF_VAL T5,
  SIEBEL.S_LST_OF_VAL T6,
  SIEBEL.S_TU_TASK T7,
  SIEBEL.S_PROJECT T8,
  SIEBEL.S_TU_STP_IO_ARG T9
  WHERE
  T2.TASK_ID = T7.ROW_ID AND
  T9.TASK_STEP_ID = T2.ROW_ID AND
  T7.PROJECT_ID = T8.ROW_ID (+) AND
  T9.REPOSITORY_ID = T3.ROW_ID (+) AND
  T9.INPUT_OUTPUT_CD = T6.NAME (+) AND T6.TYPE (+) = 'REPOSITORY_TSK_ARG_TYPE' AND T6.LANG_ID (+) = :2 AND
  T2.ACTION_TYPE_CD = T4.NAME (+) AND T4.TYPE (+) = 'WF_SIEBEL_OPER_TYPE_CD' AND T4.LANG_ID (+) = :3 AND
  T2.TYPE_CD = T5.NAME (+) AND T5.TYPE (+) = 'WF_STEP_TYPE_CD' AND T5.LANG_ID (+) = :4 AND
  T9.TYPE_CD = T1.NAME (+) AND T1.TYPE (+) = 'REPOSITORY_TSK_ARG_TYPE' AND T1.LANG_ID (+) = :5 AND
  (T9.REPOSITORY_ID = :6)
  ORDER BY
  T9.REPOSITORY_ID, T9.PREF_SEQ

ObjMgrSqlLog Detail 4 00000002588217dc:0 2017-01-20 12:07:43 Bind variable 1: ,,,DEVPXP1,00000002588217dc:0,,Repository Task Step IO Argument,


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
In Siebel Tools use Repository Search..
Do a search for a string like 'Test' and choose to only search on Task TBUI related objects.

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