My Oracle Support Banner

Siebel Workspace Error SBL-DAT-00523 While Trying to Modify Objects after Upgrade (Doc ID 2497349.1)

Last updated on JUNE 07, 2021

Applies to:

Siebel Tools - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

After performing an upgrade, users are unable to make changes to the objects in the Workspace.


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

  1. Complete the Upgrade Process.
  2. Login into Siebel Tools
  3. Create a new Workspace "dev_sadmin_deu_test"
  4. In the Action Business Component (BC) try to inactivate a Multi-Value List (MVL)
  5. Following error will be displayed:  "The selected record has been modified by another user since it was retrieved. Please continue. (SBL-DAT-00523)"

 

In the Siebel.log and/or Object Manager Log file(s), the bellow SQL with an empty STATUS_CD can be seen:

UPDATE siebel.S_WORKSPACE SET
  DB_LAST_UPD = current timestamp,
  LAST_UPD = ?,
  LAST_UPD_BY = ?,
  MODIFICATION_NUM = ?,
  LATEST_VER = ?,
  OBJ_LOCKED_BY = ?,
  OBJ_LOCKED_DATE = ?,
  OBJ_LOCKED_FLG = ?
  WHERE
  ROW_ID = ? AND LATEST_VER = ? AND STATUS_CD = ? AND MODIFICATION_NUM = ?


SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 1: 2019-01-17 10:34:36.000000

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 2: 0-1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 3: 1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 4: 1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 5: 0-1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 6: 2019-01-17 10:34:36.000000

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 7: Y

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 8: 5-PFVTF1

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 9: 0

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 10:

SQLParseAndExecute Bind Vars 4 000000025c401710:0 2019-01-17 10:34:36 11: 0

SQLParseAndExecute Execute 5 000000025c401710:0 2019-01-17 10:34:36 0s

SQLParseAndExecute Execute 5 000000025c401710:0 2019-01-17 10:34:36 DML statement affected 0 rows

 

 

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
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.