SBL-DBX-00083: Unable to start due to incorrect system preference setting

When I tried extracting the Local DB I was getting the error below:

SBL-DBX-00083: Unable to start due to incorrect system preference setting

Researching the same I found the below Administration - Application > System Preference "Docking:Transaction Logging" is set to false in "System Preference" value.  By resetting it back to "TRUE" I was able to continue to extract the local DB

How to find a string inside another string in BIP?

Use contains function inside the conditional region statement in BIP as below

How to change Local DB Password?

1. Browse to the below folder in Windows Explorer


SiebelInstallationFolder\Client\bin


2. Click on "dbisqlc.exe"

3. In "Login" tab Enter the "User ID" as "DBA" and "Password" as the Siebel server's Enterprise name


4. In "Database" tab select the local db in which you wish to change the password for the user and click OK


5. In "Interactive SQL" window, enter the following command and Execute 


grant connect to identified by

Using Variable in Conditional Region

Use the syntax below to use the variable in Conditional Regional (If Statement in BI Publisher Report)

VB Macro to split single column into multiple row delimited by Alt + Enter

Sub tst()    
    Dim X As Variant
    Dim iIndex As Integer


    iIndex = 1
    For i = 1 To WorksheetFunction.CountA(Worksheets("Sheet2").Range("B:B")) + 1
        If Range("B" & i).Value = "" Then Exit For
        X = Split(Range("B" & i).Value, Chr(10))
        Range("D" & iIndex).Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X)
        'For j = iIndex To iIndex + UBound(X)        
            '    Range("C" & j).Value = Range("A" & i).Value       
        ' Next
        iIndex = iIndex + UBound(X) + 1
    Next
End Sub

VB Macro to split data in single cell into multiple rows.  Assumptions 1: Data in the row is split by "Alt + Enter", Assumption 2: Data to be split is available in column B

IsPrimaryMVG field is not exported in Query / Query Page

Rather we can expose the field "SSA Primary Field" that will help to find which is the "Primary" record in MVG