Sunday, 19 June 2011

Error: SBL-DAT-00472 and SBL-DAT-00227: Cannot log into Sample DB in a new language other than ENU

Recently doing a POC for a French speaking client, so I install the Sample database in both English and French language. The sample database is working fine in English version. But when I log into French version, I was getting below message:






This is because the Sample Database contains only ENU repository data and seed data. You cannot launch the Mobile Web Client with the Sample Database in the non-ENU language.

In order to import Non-ENU Repository and Seed Data into the Siebel Sample Database, you need to run the samp.bat located in SIEBEL_CLIENT_ROOT\sample\UTF8, where SIEBEL_CLIENT_ROOT is the directory where you installed the Siebel client and the Sample Database.

Before running the samp.bat, make sure the SQL Anywhere database engine is running. Just start Sample Database in English, it will keep running even after you log out the application. But keeping the database engine running is needed.

The syntax for using the samp.bat batch file is as follows:
samp SIEBEL_CLIENT_ROOT ODBC_DATA_SOURCE LANGUAGE

Example in my case is:
samp "C:\Siebel\8.1\Client_1" "SEAW Samp Db default instance" FRA

After running this batch, I can launch the French version Sample database now.

More information please refer to bookshelf:

or the document in support.oracle.com

Web hosting

Saturday, 18 June 2011

Communities: Siebel Forums

This blog will maintain a list with the forums in which the Siebel guys will be talking. I will update the list from time to time. If you have something new, please share that with me.

The first ones are for sure from Oracle:
http://forums.oracle.com/forums/category.jspa?categoryID=151 (external)
http://myforums.oracle.com/jive3/category.jspa?categoryID=367 (internal)
http://forum.oracle.com.cn/forumdisplay.php?fid=532 (Chinese)

The ITToolbox is also very popular, and pretty much the longest Siebel forum in the world:
http://siebel.ittoolbox.com/groups/

Some other forums but not much traffic:
http://forum.siebelunleashed.com/
http://www.siebelbook.com/discussions
http://www.siebelguide.com/forum/
http://www.siebeloracle.com/forum/
http://www.orafaq.com/forum/f/27/0/
http://www.exforsys.com/forum/siebel/

Some Chinese Siebel forums, but you need to know Chinese to participate:
http://www.itpub.net/forum-83-1.html
http://forum.chinaoug.org/forumdisplay.php?fid=532
http://www.itjaj.com/forum-15-1.html
http://www.erp100.com/forum.php?mod=forumdisplay&fid=704&page=1

If you are looking for job, you can check with below forums:
http://www.indeed.com/forum/job/Siebel-Developer.html
Web hosting

Database Extract: Extract a local database without encryption

Starting Siebel 8, it is by default that local database is encrypted. This creates a lot of headache. If you do not require a encrypted local database, it is a good idea to extract a local database without encryption.

When you extract the local database, specify below parameters:

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)

In some scenarios, you may need to have local database without encryption as a workaround. An example is mentioned in support.oracle.com, Parallel Siebel development for Siebel 8.1 using Terminal Server -one tools / multiple local encrypted databases [ID 1074091.1]
Web hosting