S_RR_WORKFLOW Table Is Empty after Siebel Migration

(Doc ID 2410920.1)

Last updated on JUNE 19, 2018

Applies to:

Siebel Call Center - Version 18.5 and later
Information in this document applies to any platform.

Symptoms

On : 18.5 version, System Admin
Siebel 18.5 on Oracle Linux 7.4 and Oracle DB 12.1.0.2


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

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