Getting logfile for browser script in siebel

How to debug browser script.. Here's one way of doing it

To get the Log file for Browser Script.
To get the log file for Browser script in local machine we need to add the
following system variables in machine.

SEBLCL_TRACEMODE - 1
SEBLCL_LOGFILESIZE - 10
SEBLCL_LOGARCHIVECOUNT - 5
SEBLCL_LOGDIR - C:\SiebelLogs
SEBLCL_TRACEUNICODE - Y
To add these variables follow the following steps:
1) Right click on My Computer icon and select properties.
2) Select the Tab Advanced
3) Click "Environment Variables"
4) In the lower portion Click on the New Button in the System variables
section and add each parameter.

How to get user list associated for a siebel View

There are some requirements where you need to know who are all the users assigned to a particular siebel View,you can get the user list by running below query on the database.


SELECT DISTINCT
usid.per_fst_name || ' ' || usid.per_last_name "Users"
FROM siebel.s_resp resp,
siebel.s_app_view vi,
siebel.s_app_view_resp inter,
siebel.s_per_resp usid
WHERE vi.row_id = inter.view_id
AND resp.row_id = inter.resp_id
AND vi.name = 'Contact List View'
AND usid.resp_id = resp.row_id

In the above query I have queried for 'Contact List View',Just replace it with your view to get list of users associated to it.
Hope this helps...

ERROR in Local DB Initialization

Issue: Local DB Initialization erroring out.

Error Message:

DBCLog DBCLogError 1 000000024d621250:0 2011-02-21 09:36:28 [Sybase][ODBC Driver][Adaptive Server Anywhere]Procedure 'exrate' not foundUpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:28 [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Procedure 'exrate' not foundUpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Unable to read row 1 from export file (cbVal (8) /SSCHAR_SIZE + 1 > bufSize (2)).UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Unable to import table "S_REPOSITORY" (UTLDataRowRead).UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Unable to process data file dicrepos.dat.UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:31 Import DML action failed.UpgradeLog UpgradeError 1 000000024d621250:0 2011-02-21 09:36:32 Error executing action ().

Analysis:

The jobs "Generate New Database" and "Database Extract" ran successfully without any issues. However when the user tried to Initialize Local using Tools it ran fine till "Initializing User Accounts" and errored out with above error.

To resolve this issue create the following entries in registry of System DSN created on Siebel Application Server and the local client.

Making a field required using script at the applet level

Making a field required using script at the applet level 


Requirement : Making 'Contact Method' field required in an applet which is not 'required' field in the buscomp

Solution: I used the below script at applet level to make the 'Contact Method' required.The code is pretty simple as shown here.

if ( MethodName == "WriteRecord" )
    {  
    if(this.BusComp().GetFieldValue("Contact Method") == "")
    {
    TheApplication().RaiseErrorText("Contact Method is a required field please enter a value");
     return( CancelOperation );
    }

Readers,please let me know the other possibilities of making field required at applet level with out using script

Oracle BI

Oracle BI Answers :

To add a filter for a column that is not included in request, press and hold down the CTRL key at the Criteria tab and click the column name in the selection pane.