Siebel Tech Blog

We got the below error message while validating a workflow in Siebel 8.1 Validation failed for the workflow process 'XYZ' for the branch 'Connector 33' The 'WF Branch Criteria Value' - field such as LO_.. or HI_.. for the respective data type is null or empty. Solution: Run the sql below with the source as workflow row id, you will see all the branch conditions in your workflow. Pick the one which has the same name as the error message, isolate the wf step (you can modify this sql to get that) and then delete and re-add the condition step. SELECT WFBRANCRIT . ROW_ID , WFBRANCRIT . NAME , WFBRANCRIT . BRANCH_ID FROM SIEBEL . S_WFR_PROC WF , SIEBEL . S_WFR_STP WFSTEP , SIEBEL . S_WFR_STP_BRNCH WFSTPBRANCH , SIEBEL . S_WFR_PROC_FLOW WFSTEPCON , SIEBEL . S_WFR_COND_CRIT WFBRANCRIT WHERE WF . ROW_ID = WFSTEP . PROCESS_ID (+) AND WFSTEP . ROW_ID = WFSTPBRANCH . STEP_ID (+) AND WFSTPBRANCH . ROW_ID = WFSTEPCON . FOR_BRNCH_ID (+) AND WFSTPBRANCH...

Not too sure if you ever faced it, but at one time I found it really difficult to build siebel searchspecs. I had to copy already built searchspecs and manipulate it to cater to my needs.. :). However recently I figured out it's not that difficult to build these specs. In general if you are not using a process property (in a workflow) or a function (like LookupValue) searchspec is pretty straight forward. The below is an example. '[Status]='"In Progress"' (In progress within double quotes and the whole statement within single quotes, the vice versa is also okay, but make sure you use one particular quotes within the statement) If you need two fields in the searchspec and it will look like below: '[Status]="In Progress" and [Type]="Administrative"' and so on and so forth. Simple right. Now comes the little difficult part, when you have a process property or a function, e.g. '[Status]="In Progress" and [Type]="...

Siebel architecture explained in layman terms: nice one .

In Siebel version 8.0 and higher, when extracting a local database with the default settings, the local database is now encrypted. This is the standard behavior and differs from the earlier versions when you needed to make changes in order to encrypt the local database. One result is that if you download the local database using Siebel Tools, you will not automatically be able to connect to it using the Siebel Mobile Web Client (MWC). This FAQ demonstrates how in Siebel 8.0 and higher you can use the Siebel Mobile Web Client (MWC) to connect to a Local Database extracted by Siebel Tools. Steps 1. Run Generate New Database (GenNewDB). 2. Run Database Extract (DBExtract). 3. Start Siebel Tools and Connect to Local using your USER_ID and PASSWORD. Due to the fact the local database does not exist on the PC, you will be prompted to download the Local Database. 4. Once the local database had downloaded, please ensure you can connect correctly using Siebel Tools. 5. Copy the fil...

Detailed information on how to extract a local DB can be found on at this nice blog . While trying to initialize the local DB I got an error msg saying 'An internal error has occurred within the authentication subsystem for the Siebel application. Please contact your system administrator for assistance.(SBL-DAT-00565)'. This was because the DLL parameter under tool.cfg Local header was wrongly set as 'SSCDW8.DLL'. Upon changing this to 'sscdw9.dll' the DB init started working perfect.