Siebel Tools >  LOCAL_XE Database Is Not Opening Using Siebel Tools

LOCAL_XE Database Is Not Opening Using Siebel Tools

APPLIES TO:
Siebel CRM - Version 16.0 [IP2016] and later

SOLUTION
An1:With 16.5 there is a new defect 24735751 - LOCALDBSETUP.EXE EXCLUDES TABLE RECORDS REQUIRED FOR SIEBEL LOGIN TO LOCAL_XE. This was introduced with the fix that was made for 22219728 - ORACLE XE LOCAL DB EXTRACTS ALL DATA AND ERRORS WHEN DB EXCEEDS 11GB.

In 16.5, the data_2.inp file has the following where clause on all tables:

where ROW_ID like '0%

This causes the data in the following tables not to be included which are needed to login to Siebel:

S_USER
S_CONTACT
S_PARTY
S_POSTN
S_APP_KEY
S_SSA_ID
S_EMP_PER

The workarounds to this are as follows:

WORKAROUND 1:
===============
1. capture the data_2.inp file form LocalDbTemplate
2. edit data_2.inp to remove the where clause for the following tables:

S_USER
S_CONTACT
S_PARTY
S_POSTN
S_APP_KEY
S_SSA_ID
S_EMP_PER

3. after LocalDbSetup.exe is launched, paste this edited data_2.inp file into LocalDbTemplate folder, replacing the original one

WORKAROUND 2:
===============
1. download the file ‘login.inp’ attached to the SR
2. copy it to the LocalDbTemplate folder
3. open a DOS window
4. navigate to SIEBEL_TOOLS_HOME\bin
5. run the following:

dataexp /u /p /c <Server_ODBC> /d SIEBEL /i SIEBEL_TOOLS_HOME\BIN\LocalDbTemplate\login.inp /f SIEBEL_TOOLS_HOME\Tools\BIN\LocalDbTemplate\login.dat /w y /l SIEBEL_TOOLS_HOME\BIN\LocalDbTemplate\login.log

6. run the following:

dataimp /u SIEBEL /p SIEBEL /c LOCAL_XE /d SIEBEL /f SIEBEL_TOOLS_HOME\BIN\LocalDbTemplate\login.dat /w n /e y /t y /h Log /x t /l SIEBEL_TOOLS_HOME\BIN\LocalDbTemplate\login_imp.log

Note: Respond Y to the prompt about whether you want to truncate these tables before import

7. Test login to local OracleXE

WORKAROUND 3:
===============
1. uninstall Tools
2. uninstall Oracle XE
3. install Tools, and do not check "Install Local Database"
4. run Generate New Database
5. run Database Extract
6 initialize the Tools client in legacy fashion

An2:After applying 16.6 in which fixed 24735751 and 23550615, the local database was not detected and customer was prompted to pull a new local database. To resolve this, the customer found the remote user needed to have the Siebel Administrator position. Documentation defect 25113856 SIEBEL ADMINISTRATOR POSITION REQUIRED FOR ORACLE XE, NOT JUST RESPONSIBILITY has been logged to address this.