Skip to main content

Unable to make changes to the Object with the newly created Workspace after the upgrade (Doc ID 2497349.1)

APPLIES TO:

 Siebel Tools - Version 18.12 and later
Information in this document applies to any platform.
SYMPTOMS

Unable to make changes to the Object with the newly created Workspace after the upgrade


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into the tools
2. Create a Workspace dev_sadmin_deu_test
3. In the Action BC > try to inactivate a MVL
4. Getting following error"The selected record has been modified by another user since it was retrieved. Please continue.(SBL-DAT-00523)"

CAUSE
In the SQL which is causing this Issue STATUS_CD is empty

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

EVIDENCE OF CAUSE
---------------
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



SOLUTION
When two languages are installed then both the Languages Seed Data needed to by installed. For ex: if ENU and DEU is installed and DEU is the base language. Both the ENU and DEU seed data has been installed as we need all the LOV's values related to both the Languges

Source:
https://support.oracle.com > Doc ID 2497349.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

Background: Based on the requirements you need to show data or reports on a popup applet. You can invoke popup applet using workflow (below business service will be used in business service step), applet server script or browser script and using vanilla method and setting field user properties. Procedure: Below is the script for calling popup applet through server 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 (CancelOperati...
Post a Comment
Read more

How to create and publish Inbound Web Service in Siebel based on Workflow

Inbound Web Services: The Inbound Web Service allows an external system to call a Siebel published Web Service. You can publish a business service or a business process as a Web Service and generate a Web Service Definition Language (WSDL) file that an external system can import. The Inbound Web Services can only be published from Siebel C using SOAP-RPC binding. Source: Oracle Docs What Is The Difference Between Web Services and APIs? An API is an interface that allows you to build on the data and functionality of another application, while a web service is a network-based resource that fulfills a specific task. Yes, there’s overlap between the two: all web services are APIs, but not all APIs are web services. Both web services and APIs are — at their core — very useful and very much used today. However, it’s the web services associated with SOAP and/or Service Oriented Architecture which are falling out of favor. Source: NordicApis Process: Prepare the workflow which will serve as Si...
Post a Comment
Read more