File does not exist of may be in use by another process(SBL-DAT-00142)

File does not exist of may be in use by another process(SBL-DAT-00142)

This error occur when the SRF file is used by some another process.
When you come across this error please make sure that
 1. services like siebel service is not accessing the SRF
 2. All DB,Siebel Process are down.
 3. Some windows machine (Windows 7)  may prevent file access. So your tools must have permission to access files. For that right click on tools give run as administrator. Then your tools can access the SRF file

Setting tab order in Siebel

You can decide the tab order of each control in a form applet.
 To do so query the applet -> controls and you can find a property called "HTML Sequence". Give the sequence as you required.

Applet Minimizing & Maximizing.

We can minimize and maximize applet in a view. To do this go to its view.
view web template item. Select your applet. go to display size option. select maximized or minimized.
If you select maximized option, when view loads the applet will be in maximized state, you can minimize it.
If you select minimized, when you loads a view that applet will be in minimized state.
There is another option always maximized, if you select that option, you cannot minimize your applet.
(Method minimize applet will not works there)

Unlock siebel repository object using SQL

APPLET

UPDATE  siebel.s_applet appl SET appl.obj_locked_flg = 'N', appl.obj_locked_date = NULL, appl.obj_locked_by = null, appl.obj_locked_lang = null WHERE appl.row_id = 'replace_your_object_ID';

COMMIT;


BUSCOMP

UPDATE siebel.s_buscomp bc SET bc.obj_locked_flg = 'N', bc.obj_locked_date = NULL, bc.obj_locked_by = null, bc.obj_locked_lang = null  WHERE bc.row_id = 'replace_your_object_ID' ;

COMMIT;

VIEW

UPDATE siebel.s_view bc SET bc.obj_locked_flg = 'N', bc.obj_locked_date = NULL, bc.obj_locked_by = null, bc.obj_locked_lang = null WHERE bc.row_id = 'replace_your_object_ID';

commit;


PROJECT

UPDATE siebel.s_project  AS proj SET proj.locked_flg = 'N', proj.locked_date = NULL WHERE proj.name = 'your project_name';

COMMIT


BUSSERVICE

UPDATE siebel.s_service serv SET serv.obj_locked_flg = 'N', serv.obj_locked_date = NULL, serv.obj_locked_by = null, serv.obj_locked_lang = null WHERE serv.row_id = 'replace_your_object_ID';

COMMIT;


TABLE

UPDATE siebel.s_table tab SET tab.obj_locked_flg = 'N', tab.obj_locked_date = null, tab.obj_locked_by = null, tab.obj_locked_lang = null WHERE tab.name = 'your Table NAME' and tab.row_id = 'replace_your_object_ID';

COMMIT;

APPLICATION

UPDATE SIEBEL.S_APPLICATION app
  SET
    app.OBJ_LOCKED_FLG = 'N',
    app.OBJ_LOCKED_DATE = NULL,
    app.OBJ_LOCKED_BY = NULL,
    app.OBJ_LOCKED_LANG = NULL
  WHERE
    app.ROW_ID ='replace_your_object_ID';

COMMIT;

How to test inbound webservice with attachment in siebel

Before making IC make sure that the BC class should be "CSSBCFile"
Then In XML request please make sure that the values are

                         FileAutoUpdFlg = Y
                         FileDeferFlg = R
                         QuoteFileDockReqFlg = N
                        QuoteFileDockStatFlg = E

then specify your file name & encoded format.

to get 64bit decoded value of a file, please use this site.

How to Run and Test a workflow using siebel application?

We can test a workflow using Siebel tool & Application. Most of you are familiar with testing Workflow with tool's simulation. But we can test workflow using siebel application. To do that goto Administration - Business Service -> Simulator.
Give Service Name as "Workflow Process Manager" and Method name "RunProcess". Give required Input argument and click "Run" and find output in output argument section.

How to setup Profile attribute in Workflow?

There is a Business service Called  "SIS OM PMT Service" & Its Method named as
"Set Profile Attribute"
Input Arguments are
Profile Attribute Name
Profile Attribute Value