1. Siebel Remote – Component Group needs to be enabled on the server.
This can be done by connecitng to server manager (srvrmgr) and executing
srvrmgr>list compgrp
If Siebel Remote is not enabled, need to execute the command
srvrmgr> enable component group Remote for server <servername>
Resatart Siebel server & verify Siebel Remote compgrp available on list compgrps command
2. Database Extract component (DbXtract) needs to be enabled on server
srvrmgr> list comp DbXtract
3. Generate New Database – Job needs to be executed
Administration – Server Management > Jobs > New job
> For Component/Job field select Generate New Database
> For Requested Server field give <siebsrvr_hostname>
In Job parameters applet Create New Value
> Name column as SQL Any where database and value as sse_utf8.dbf
Submit the job and ensure it was successful
4. Registering an employee as Siebel mobile webclient user
Administration – Siebel Remote > Mobile Clients
In Mobile Clients Applet
> Mobile Client column <username needs DbXtract>
> App Server Name as <server_name>
> UserID as user_available_as_employee
5. Executing DbXtract for the mobile user
Administration – Server Management > Jobs > New job
> For Component/Job field select Database Extract
> For Requested Server field give <siebsrvr_hostname>
In Job parameters applet Create New Value
> Name column as Client Name and value as <username needs DbXtract>
> Name column as Move Siebel Remote Cliet and value as True (For first time extract)
> In Routing Model select value MOBILE CLIENT – EXTRACT ONLY
Submit the job and ensure it was successful
Errors
Issue 1: After submitting Database Extract, the job was in Queued state for long time
issue can be identified as Siebel Remote compgrp / DbXtract comp was not enabled.
Issue 2: SBL-DBX-00038: No local database template found.
issue can be identified as not generated Database template
Issue 3: SBL-SMI-00077: Component error, see the trace file for more information
and in DbXtract_xxxxx.log contains
GenericLog GenericError 1 000000084b553068:0 2010-01-20 10:00:37 (smisched.cpp (894) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information
issue identified as not availability of Siebel mobile client users.
This can be confirmed by executing the command
select * from SIEBEL.S_NODE where NODE_TYPE_CD = ‘REMOTE’ and NAME=’SADMIN’ and EFF_END_DT is NULL;
which returns no rows (or) username for whom extract needs to be executed will not be in output
