SBL-EIM-00420: Subprocess failed to execute with DELETE MATCHES

(Doc ID 2330259.1)

Last updated on NOVEMBER 21, 2017

Applies to:

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

Symptoms

On : 16.16 [IP2016] version, EIM

When attempting to run task for EIM, the following error occurs.

ERROR
-----------------------
 

EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 Process [Delete S_PROD_RATE] had all rows fail
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 on EIM_FN_PRDINT1 for batch 100:
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 Nothing to do for specified IF table. (severity 2, table aborted)
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 The interface table was listed in the process for deletion however nothing was
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 specified for deletion. Use one of the DELETE EXACT, DELETE ALL or DELETE
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 MATCHES parameters to specify what should be deleted through this interface
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 table.
EIMError EIMErrorSubEvent 0 0000048e5a090f00:0 2017-11-13 22:16:58 Error SBL-EIM-00420: Sub-process "Delete S_PROD_RATE" failed to execute
GenericLog GenericError 1 0000048e5a090f00:0 2017-11-13 22:16:58 (compmain.cpp (1565) err=65956 sys=2) SBL-EIM-00420: Subprocess failed to execute.
GenericLog GenericError 1 0000048e5a090f00:0 2017-11-13 22:16:58 (smisched.cpp (923) err=65956 sys=0) SBL-EIM-00420: Subprocess failed to execute.



STEPS
-----------------------
The issue can be reproduced at will with the following ifb file:

 

[Siebel Interface Manager]
PROCESS = Remove Product Rates

[Remove Product Rates]
TYPE = SHELL
INCLUDE = Delete Product Rates

[Delete Product Rates]
TYPE = DELETE
BATCH = 100
TABLE = EIM_FN_PRDINT1
DELETE MATCHES = S_PROD_RATE, (TYPE_CD = 'Fixed')

 

 



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