Open UI 2016 Batch Job Using Custom Datasource Does Not Fetch Data from External Source

(Doc ID 2321328.1)

Last updated on OCTOBER 30, 2017

Applies to:

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

Symptoms

On : 16.13 [IP2016] version, System Admin

ACTUAL BEHAVIOR

Siebel Open UI 2016 batch job using a custom WfProcBatchMgr component with custom datasource is not working.

User recently upgraded from Siebel 8.2.2.2 to Siebel Open UI 2016 and noticed that after the upgrade, a particular batch job that utilizes a custom datasource to an external connection no longer works.

There are no specific errors in the Enterprise logs, just that the database connection is made but no data is fetched from the external datasource.

 

Error
-----------------------
SMTWfProcBatchMgr_0037_38797314.log 16.13.0.0 [23057] ENU

ObjMgrBusServiceLog InvokeMethod 4 0000c51659cb5225:0 2017-10-04 12:09:53 Begin: Business Service 'Workflow Process Manager' invoke method: 'BusSvcMgrInit' at 12f8b710
EngInv EngInv 3 0000c51659cb5225:0 2017-10-04 12:09:53 Workflow engine requested to perform method 'BusSvcMgrInit'.
EngInv Arg 4 0000c51659cb5225:0 2017-10-04 12:09:53 Input: @0*0*0*0*0*0*
ObjMgrSqlObjLog Create 5 0000c51659cb5225:0 2017-10-04 12:09:53 Begin: construct SqlObject 'SSAId' at 12f8bb00


ObjMgrSqlObjLog WriteRecord 5 0000c51659cb5225:0 2017-10-04 12:09:53 Begin: WriteRecord for SqlObj 'SSAId' at 12f8bb00
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 INSERT/UPDATE statement with ID: Unknown

UPDATE SIEBEL.S_SSA_ID SET
  DB_LAST_UPD_SRC = :1,
  DB_LAST_UPD = current_date,
  LAST_UPD = :2,
  LAST_UPD_BY = :3,
  MODIFICATION_NUM = :4,
  NEXT_SUFFIX = :5
  WHERE
  ROW_ID = :6 AND MODIFICATION_NUM = :7

ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 1: Object Manager - Default
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 2: 10/04/2017 19:09:53
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 3: 1-D0UV9
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 4: 883233
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 5: AAJ6ND
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 6: 0-11
ObjMgrSqlLog Detail 4 0000c51659cb5225:0 2017-10-04 12:09:53 Bind variable 7: 883232

ObjMgrSqlCursorLog Trace 5 0000c51659cb5225:0 2017-10-04 12:09:53 SQL Cursor with ID 12F8C688 Buscomp: SSAId, Forward Only: 0, Fetch Rows: 1, Fetch All Time: 0.000 seconds.


GenericLog GenericWarn 2 0000c51659cb5225:0 2017-10-04 12:09:53 (scirkey.cpp (132) err=1311788 sys=0) SBL-SVR-01068: This component is not enabled for "Key Based Routing"
GenericLog GenericWarn 2 0000c51659cb5225:0 2017-10-04 12:09:53 (scirkey.cpp (1047) err=1311788 sys=0) SBL-SVR-01068: This component is not enabled for "Key Based Routing"
EngInv Arg 4 0000c51659cb5225:0 2017-10-04 12:09:53 Output: @0*0*0*0*0*0*
ObjMgrBusServiceLog InvokeMethod 4 0000c51659cb5225:0 2017-10-04 12:09:53 Business Service 'Workflow Process Manager' invoke method 'BusSvcMgrInit' Execute Time: 0.020 seconds.
ObjMgrBusServiceLog InvokeMethod 4 0000c51659cb5225:0 2017-10-04 12:09:53 End: Business Service 'Workflow Process Manager' invoke method: 'BusSvcMgrInit' at 12f8b710




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