Skip to main content

Unable To Change Objects In Siebel Tools Using Workspace_SBL-DAT-00523 (Doc ID 2345990.1)

Not able to modify any object in any worksapre, siebel is returning error

APPLIES TO:

 Siebel Tools - Version 17.3 [IP2017] and later
Information in this document applies to any platform.
SYMPTOMS
On : 17.3 [IP2017] version, Configuration - Dev Env

When attempting to make any change to objects in siebel tools using workspace,
the following error occurs.

ERROR
-----------------------
SBL-DAT-00523: The selected record has been modified by another user since it was retrieved. Please continue.


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

1. login siebel tools,
2. open workspace
3. locate object (business component, applet, etc)
4. change any object property

CAUSE

 UPDATE SIEBEL.S_WORKSPACE SET
  DB_LAST_UPD_SRC = :1,
  DB_LAST_UPD = current_date,
  LAST_UPD = :2,
  LAST_UPD_BY = :3,
  MODIFICATION_NUM = :4,
  LATEST_VER = :5,
  OBJ_LOCKED_BY = :6,
  OBJ_LOCKED_DATE = :7,
  OBJ_LOCKED_FLG = :8,
  STATUS_CD = :9
  WHERE
  ROW_ID = :10 AND LATEST_VER = :11 AND STATUS_CD = :12 AND MODIFICATION_NUM = :13

SQLParseAndExecute Bind Vars 4 000000025a4c0f28:0 2018-01-03 13:15:28 12:
SQLParseAndExecute Bind Vars 4 000000025a4c0f28:0 2018-01-03 13:15:28 13: 0

In this case, in the criteria, its searching on STATUS_CD with an empty string.


SOLUTION
There are many reasons on why the error "SBL-DAT-00523" is occurred but in this case issue is solved after changing the multi_lingual_flg value for LOVs to N, including the following:

VER_DEPLOYMENT_STATUS
WORKSPACE_CONTEXT_INFO
WS_MERGE_STATUS

Source:
https://support.oracle.com/ > Doc ID 2345990.1
Labels:

Comments

Post a Comment

Popular posts from this blog

How to set Profile Attribute in Siebel Workflow

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set  SessionAccessService in Business Service Name. Set  SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.
Post a Comment
Read more

How to call Popup Applet through Server Script in Siebel

Below is the script for calling popup applet through script: if (MethodName == "MethodName") { var oServiceAF = TheApplication().GetService("SLM Save List Service"); var inputPropAF = TheApplication().NewPropertySet(); var outputPropAF = TheApplication().NewPropertySet(); inputPropAF.SetProperty("Applet Name","ABC Popup Applet"); inputPropAF.SetProperty("Applet Mode","6"); inputPropAF.SetProperty("Applet Height", "700"); inputPropAF.SetProperty("Applet Width", "700"); oServiceAF.InvokeMethod("LoadPopupApplet", inputPropAF, outputPropAF) return (CancelOperation); } Applet Modes:  1=Base, 2=New, 3=Edit, 5=Query, 6=EditList
Post a Comment
Read more

How to query or find record in Siebel Business Component

You can perform query operation on Business Component through Workflow, eScript with the help of Siebel Operation, Inbound E-mail Database Operations (method: FindRecord) or EAI Siebel Adapter (method: Query but you need to create Integration Objects). This Business Component can be Virtual Business Component (VBC), External Business Component (EBC) or generic Business Component (BC).  See also: Difference Between Business Components and How to Create BC in Siebel through Object Wizard through Workflow with the help of Siebel Operation Create a workflow and provide the Business Object, business component should be in this BO for which you want to perform the query operation. From the Palettes window drag drop the Siebel Operation into workflow designer plane. Select the Siebel Operation box and open the properties window, provide the Business Component name from the drop down list and set Query in Operation field. You can set the search specification by two means either provide the fie
Post a Comment
Read more