Skip to main content

Posts

Showing posts from March, 2023

How to display URL in a modal popup window? Doc ID 1360705.1

APPLIES TO: Siebel Tools - Version 8.1.1.1 SIA [21211] and later Information in this document applies to any platform. GOAL How to display external web page in a modal popup window using symbolic URL? SOLUTION 1. Create calculated field in Account buscomp: name = TestSymbolicURL calculated value = TestSymbolicURL 2. Create new form applet using the new object wizard with following properties: name = Account Symbolic URL Popup Applet buscomp = Account web template = Analytics Applet type = base Select TestSymbolicURL field in the wizard to be included in the applet. Deselect all button controls in the wizard. The wizard will create control in the applet Set the following control properties: name = Test field = TestSymbolicURL field retrieval type = Symbolic URL HTML display mode = EncodeData HTML type = Text field type = BC Field Edit the class property of the created applet and set it to: class = CSSSWEFramePopup 3. Create new button control on SIS Account Entry Applet with following p...

When selecting record from Pick Applet Siebel is returing error SBL-DAT-00249

Description: Configured the Pick Applet for selecting the records from Contact. But when selecting the record Siebel is returning below error: SBL-DAT-00249: An error has occurred getting the pick list business component %1 for field %2 in business component %3. SBL-DAT-00249: An error has occurred getting the pick list business component Contacts NBR for field Full Name in business component Asset Contacts. Solution: Open the Object Manager logs and search the error. From the error scroll up. In my case below is logs part. ObjMgrBusCompLog    Warning    2    00000004637f1bdc:0    2022-11-24 23:27:03    (sqlbcdef.cpp (2799)) SBL-DAT-00466: Multi value link definition 'Organization' does not exist for business component definition 'Contacts NBR'. ObjMgrBusCompLog    Error    1    00000004637f1bdc:0    2022-11-24 23:27:03    (buscomp.cpp (12...

How to delete Siebel Workflow Instance monitor logs SQL Developer

Workflow instance monitor have three separate tables. One for logging workflow run (workflow instance), second for its steps execution to log (workflow steps) and third for logging the values of each process property value against each step of workflow (workflow process properties). If you increase the Workflow Monitoring level over the time tables space and DB load will be increase and sometimes instance monitor will be stopped working (Check Siebel Workflow Instance Monitor not working to fix this issue) . Its a good practice to delete the old workflow instance monitor records. Below are the queries for deleting the data. Its better to delete only old data and Year is perfect condition. Workflow Instance select count(*) from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' --delete from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' Workflow Instance Steps select count(*) from S_WFA_INSTP_LOG where EXTRACT(YEAR FROM TO_DATE(created))=...