My Oracle Support Banner

Two Entries Of 'S_EVT_ACT' In 'S_RR_TABLE' With Same Repository Id (Doc ID 2478567.1)

Last updated on JANUARY 25, 2020

Applies to:

Siebel High Tech and Manufacturing - Version 18.8 and later
Information in this document applies to any platform.

Symptoms


Two entries of 'S_EVT_ACT' in 'S_RR_TABLE' with same repository id after Siebel upgrade to v 18.8.
The issue can be reproduced at will with the following steps:
1. upgrade to Siebel 18.8
2. run the following SQL
SELECT ROW_ID, CREATED, NAME, REPOSITORY_ID, VERSION_NUM, DB_LAST_UPD_SRC, WS_ID FROM SIEBEL.S_RR_TABLE WHERE NAME = 'S_EVT_ACT';


ROW_ID                               CREATED           NAME    REPOSITORY_ID           VERSION_NUM        DB_LAST_UPD_SRC         WS_ID
1-N6N2-4EMZQ             07-SEP-18         S_EVT_ACT       1-N6N2-1                                      0                      repimexp                     1-N6N2-4
1-11P783FA                     07-NOV-18         S_EVT_ACT      1-N6N2-1                                      3     Object Manager - Default             1-N6N2-4

We are getting the same two entry of S_EVT_ACT table with the same Repository Id and WS_Id.
Here the repository id ‘1-N6N2-1 ‘ is for the ‘Siebel Repository’ and WS_Id ‘1-N6N2-4’ is the ‘MAIN’ workspace.

 

Changes

Upgrade from older release

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


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