Batch Assignment failing with SBL-GEN-03006: (attrapi.cpp: 953), msg1 = pLinkColInfo is NULL (Doc ID 1160140.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Assignment Manager - Version 7.8.2.14 SIA[19251] to 8.2.2.3 SIA [23021] [Release V7 to V8]
Information in this document applies to any platform.

Symptoms

 Customer created a new Assignment Object and was using Batch Assignment (AsgnBatch server component) to assign multiple records in a single batch.The assignment failed and the following errors were logged in the Batch Assignment trace file:
SBL-GEN-03006: (attrapi.cpp: 953) error code = 3006, system error = 3833, msg1 = pLinkColInfo is NULL
SBL-GEN-03006: (asgnengi.cpp: 5928) error code = 3006, system error = 0, msg1 = WFGetCount

Here is a more detailed excerpt of the error:

Object: Invoice, Invoice Number: 1-251898003, Invoice Type Code: TMPC Spares Claim [1-45Z1QR]
  ++++++++++++++++++++ BEGIN RULE EVALUATION +++++++++++++++++++++++++++
  Rule: TM Claim [1-462LKN], Sequence: 1, Rule Group: Default Rule Group, Score: 0, Minimum: 0, Type: Multiple
  Rule: TM Claim [1-462LKN], Person Candidates: From Rule, Organization Candidates: From Rule, Non-Exclusive
    -------------------- BEGIN CRITERIA EVALUATION ---------------------
    Criteria: TM Claim To Region [1-462LLG], Score: 0, Minimum: 0, Type: Object List, Include, Always Required

SELECT T0.SUB_TYPE_CD, T0.INVC_DT, T0.STATUS_CD, T0.X_DNRM_INVOICE_FORMAT, T0.X_DISPATCH_MODE, T0.X_AUTHOR_STATUS, T0.X_ALL_LOB
01:1-45Z1QR

      Column-based attribute TM Claim To Region [TM Caim To Region]: West
      > TM Claim To Region: West
      Attribute values matched
    Criteria passed with score = 0
    -------------------- END CRITERIA EVALUATION -----------------------
    -------------------- BEGIN CRITERIA EVALUATION ---------------------
    Criteria:  [1-462LKU], Score: 0, Minimum: 0, Type: Workload, Include, Always Required

   select linkcol.TBL_INST_ID, col.COL_ID,
          cond.VAL, cond.COND_OPERAND, repos_col.DATA_TYPE
     from SIEBEL.S_COLUMN repos_col,
          SIEBEL.S_ASGN_WL_OBJ_COL cond,
          SIEBEL.S_ASGN_WL_OBJ wlobj,
          SIEBEL.S_ASGN_OBJECT asgnobj,
          SIEBEL.S_ESCL_LINK_COL linkcol,
          SIEBEL.S_ESCL_LINK link,
          SIEBEL.S_ESCL_COL col,
          SIEBEL.S_ESCL_OBJECT obj
    where cond.ASGN_WL_OBJ_ID = ? and
          wlobj.ROW_ID = cond.ASGN_WL_OBJ_ID and
          asgnobj.NAME = wlobj.ASGN_OBJECT_NAME and
          asgnobj.REPOSITORY_ID = ? and
          (asgnobj.INACTIVE_FLG = 'N' or asgnobj.INACTIVE_FLG IS NULL) and
          obj.ROW_ID = asgnobj.ESCL_OBJ_ID and
          obj.REPOSITORY_ID = asgnobj.REPOSITORY_ID and
          col.REPOSITORY_ID = asgnobj.REPOSITORY_ID and
          col.NAME = cond.LINK_COL_NAME and
          link.NAME = cond.ESCL_LINK_NAME and
          link.OBJECT_ID = obj.ROW_ID and
          linkcol.COND_COL_ID = col.ROW_ID and
          linkcol.TBL_INST_ID = link.ROW_ID and
          repos_col.ROW_ID = col.COL_ID
01:1-3VUSZG
02:1-CDGI-1


(attrapi.cpp (953) err=3006 sys=3833) SBL-GEN-03006: (attrapi.cpp: 953) error code = 3006, system error = 3833, msg1 = pLinkColInfo is NULL, msg2 = (null), msg3 = (null), msg4 = (null)
(asgnengi.cpp (5928) err=3006 sys=0) SBL-GEN-03006: (asgnengi.cpp: 5928) error code = 3006, system error = 0, msg1 = WFGetCount, msg2 = (null), msg3 = (null), msg4 = (null)

 

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