My Oracle Support Banner

S_RR_WORKFLOW Tables Are Empty after Siebel Migration: Workflows are Deleted After IRR (SBL-EAI-04319) (Doc ID 2410920.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel Call Center - Version 18.5 to 19.1 [Release V17]
Information in this document applies to any platform.

Symptoms


After Siebel Migration from the Development to Test environment, the S_RR_WORKFLOW table is empty.

There are workflow errors in the associated logs.

EAI log file captured the following error messages:
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (wservice.cpp (140)) SBL-EAI-04307: No ports were initialized for Web Service named 'SiebelSearchPlusWebService' having namespace value 'http://abc.com/CustomUI'.
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (factory.cpp (246)) SBL-EAI-04319: Active Workflow Process named 'SM Service Request with DataMap' cannot be found in runtime database 'ServerDataSrc'.
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (factory.cpp (246)) SBL-EAI-04319: Active Workflow Process named 'SM Service Request SRM' cannot be found in runtime database 'ServerDataSrc'.
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (factory.cpp (246)) SBL-EAI-04319: Active Workflow Process named 'SM Service Request' cannot be found in runtime database 'ServerDataSrc'.

Based on these errors, user executed a select count in Siebel Runtime Repository tables (S_RR*) and an important table (S_RR_WORKFLOW) is empty in test environment.
However, in the development environment, this table has 2498 rows.

Siebel Migration finished without problems.


ERROR
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (factory.cpp (246)) SBL-EAI-04319: Active Workflow Process named 'SM Service Request with DataMap' cannot be found in runtime database 'ServerDataSrc'.
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (factory.cpp (246)) SBL-EAI-04319: Active Workflow Process named 'SM Service Request SRM' cannot be found in runtime database 'ServerDataSrc'.
ObjMgrLog Error 1 000000145b191825:0 2018-06-07 18:04:34 (factory.cpp (246)) SBL-EAI-04319: Active Workflow Process named 'SM Service Request' cannot be found in runtime database 'ServerDataSrc'.



STEPS
1. Execute Siebel Application Migration from DEV to TEST.
2. Check record count for S_RR_WORKFLOW.

Result: The S_RR_WORKFLOW table is empty in the migrated Test Environment.


Changes

 Migration was executed from Dev to Test.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.