WorkFlow Policy Problems (Doc ID 1597130.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.0.0.13 [20448] and later
Information in this document applies to any platform.

Symptoms

I create a new workflow policy object based in a new table named CX_IB_REG_ACT which is a custom table.
I create a custom Workflow Monitor Agent component WorkMonSV.
When I start the Work Monitor Agent task, i.e., WorkMonSV task, it fails with the error SBL-ESC-00053: Error loading rule definitions:

2021 2013-09-13 16:41:07 2013-09-13 16:41:49 -0500 000007a3 001 ffff 0001 09 WorkMonSV 11534339 2740 8032 D:\sba80\siebsrvr\log\WorkMonSV_0011_11534339.log 8.0.0.13 [20448] ESN


SQLSlowQuery Statement 4 0000000452330ab4:0 2013-09-13 16:41:26

  select link.ROW_ID, link.SRC_TBL_ID, link.SRC_COL_ID,
  link.TAR_TBL_INST_ID, link.TAR_COL_ID, link.PRIMARY_FLG,
  link.NAME, link.ADDTL_JOIN_SPEC
  from SIEBEL.S_ESCL_LINK link,
  SIEBEL.S_ESCL_OBJECT obj
  where obj.NAME = ? and
  obj.REPOSITORY_ID = ? and
  (obj.INACTIVE_FLG = 'N' or obj.INACTIVE_FLG IS NULL) and
  link.OBJECT_ID = obj.ROW_ID and
  (link.INACTIVE_FLG = 'N' or link.INACTIVE_FLG IS NULL)

SQLSlowQuery Bind Variables 4 0000000452330ab4:0 2013-09-13 16:41:26 01:IBP Reg Action IVR
02:1-1-1

ProcReq GenericFatal 0 0000000452330ab4:0 2013-09-13 16:41:26 IBP Reg Action IVR in Load

GenericLog GenericError 1 0000000452330ab4:0 2013-09-13 16:41:26 Message: ESCL-07,
 Additional Message: IBP Reg Action IVR


ProcReq GenericFatal 0 0000000452330ab4:0 2013-09-13 16:41:26 Object Info in LoadRules

GenericLog GenericError 1 0000000452330ab4:0 2013-09-13 16:41:26 Message: GEN-11,
 Additional Message: Object Info


ProcReq GenericFatal 0 0000000452330ab4:0 2013-09-13 16:41:26 Error in LoadRules

GenericLog GenericError 1 0000000452330ab4:0 2013-09-13 16:41:26 Message: ESCL-16,
 Additional Message: Error


ProcReq GenericFatal 0 0000000452330ab4:0 2013-09-13 16:41:26 Creacion de Actividad Siebel IVR in LoadRules

GenericLog GenericError 1 0000000452330ab4:0 2013-09-13 16:41:26 Message: ESCL-27,
 Additional Message: Creacion de Actividad Siebel IVR in LoadRules


SQLSummary Stmt 4 0000000452330ab4:0 2013-09-13 16:41:26

  select rle.NAME, rle.OBJECT_NAME, rle.ROW_ID,
  rle.RULE_DURATION, rle.QUALIFY_COUNT, rle.SUB_TYPE_CD, rle.ASGN_OBJECT_NAME,
  rle.ACTIVATE_DT, rle.EXPIRE_DT, {fn ifnull (rle.BATCH_FLG, 'N')}
  from SIEBEL.S_ESCL_RULE rle,
  SIEBEL.S_ESCL_GROUP grp
  where grp.NAME = ? and
  rle.GROUP_ID = grp.ROW_ID

SQLSummary BindVar 4 0000000452330ab4:0 2013-09-13 16:41:26 01:IBPRegActSiebelIVR


GenericLog GenericError 1 0000000452330ab4:0 2013-09-13 16:41:26 (smishell.cpp (342) err=458805 sys=0) SBL-ESC-00053: Error al cargar definiciones de regla

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