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 file ${Tools}\local\dicdata.dat to ${Client}\local\dicdata.dat
Without this step, you cannot connect to the local database from the Siebel
Mobile Web Client.
6. Locate and copy the following parameters' lines exactly as they are
from [Local] section of Tools CFG (used to Initialize database) to
Siebel Mobile Web Client's CFG file:
DSDockEncryptDB = ...
DSHashUserPwd = ...
DSHashAlgorithm = ...
7. In the Mobile Web Client CFG file [Local] section, edit the
ConnectString parameter to point to where the local database is located.
8. Copy the file ${Tools}\bin\mwc_storage.cfg to
${Client}\bin\mwc_storage.cfg
9. Change the ODBC DataSource for the Client by performing the
following steps:-
a. Navigate to Control Panel > Administrative Tools > Data
Source (ODBC)
b. Select the System DSN tab
c. In the list, find the DSN Source called “SSD Local DB default
instance”. Double-click on it or click once and then click the Configure
button.
d. Click the Database tab
e. Copy the Server Name (such as:
C__SIA_TOOLS_Local_sse_data_dbf). Click Cancel to close this window and
return to the list of System Data Sources.
f. Locate the System Data Source for the client called “SEAW Local DB
default instance”. Double-click on it or click once and then click the
Configure button.
g. Click the Database tab
h. Paste the data just copied into the Server Name. Click OK to
save the changes.
NOTE: It is possible to extract a local database without encryption but you
need to specify the parameters below:-
Encrypt client Db password = False
Client Database encryption method = none
If you create a non-encrypted local database, you will still need to copy
the file ‘mwc_storage.cfg’ file from the ${Tools}\bin directory to the
${Client}\bin directory and update the local ODBC section in the client CFG
file (assumes extraction took place using Tools)
SBL-SEC-10018, SBL-DAT-00522, SBL-SEC-10001 and SBL-DAT-00565,
SBL-DAT-00522, Incorrect, "missing encryption key"