Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 4

Hi,

Welcome to Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 4 of the series

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

In this part we will install and configure the Siebel Database server Software.

To Install a Siebel Development Server we will go through the following steps

  1. Install the Prerequisite Software – this was completed in part 2 (here)
  2. Install and Configure the Siebel Enterprise Server – this was completed in part 3 (here)
  3. Install and Configure the Siebel Database Server (this step)
  4. Install and Configure the Siebel Server
  5. Install and Configure the Siebel Web Server
  6. Patching and Postinstallation Tasks
  7. Installing Siebel Charts
  8. Enabling OpenUI

To Install the Siebel Database server we will go through the following steps:

  1. Create tablespaces, datafiles, roles and users on the Database
  2. Run Siebel Database Server Configuration
Continue reading “Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 4”

Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 3

Hi,

Welcome to Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 3 of the series

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

In this part we will install and configure the Siebel Gateway and the Siebel Enterprise server Software.

To Install a Siebel Development Server we will go through the following steps

  1. Install the Prerequisite Software – this was completed in part 2 (here)
  2. Install and Configure the Siebel Enterprise Server (this step)
  3. Install and Configure the Siebel Database Server
  4. Install and Configure the Siebel Server
  5. Install and Configure the Siebel Web Server
  6. Patching and Postinstallation Tasks
  7. Installing Siebel Charts
  8. Enabling OpenUI

Run this entire installation as the siebel service user, which must have full local administrator rights.

My installation media is the SIA 8.2.2.4 base. Start with the Siebel Enterprise Server Software (aka SES).

Continue reading “Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 3”

Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 2

Hi,

Welcome to Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 2 of the series

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

In this part we will configure prerequisite software to support the siebel installation. We will install more software as we go along, where appropriate. But there is a lot of prerequisite software to install.

Siebel 8 is still a 32 bit application, running on a x64 os+machine, that means 32 bit versions of all basic software needs to be installed. Oh Oracle/Siebel get that fixed! Give us a native x64 build – thanks! (note to self and others – write to supportweb and ask for this!).

To Install a Siebel Development Server we will go through the following steps

  1. Install the Prerequsite Software (this step)
  2. Install and Configure the Siebel Enterprise Server
  3. Install and Configure the Siebel Database Server
  4. Install and Configure the Siebel Server
  5. Install and Configure the Siebel Web Server
  6. Patching and Postinstallation Tasks
  7. Installing Siebel Charts
  8. Enabling OpenUI

Here’s the initial list of things you will install and configure in this part:

  • install jre x64
  • install jre x32
  • install oracle client x64 version
  • install oracle client x32 version
  • Install and configure Microsoft Office 2007 x32 version
  • Create the Siebel File Share

Notice that I Install the x32 versions last, to keep my path env. variable in order like this:

Continue reading “Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 2”

Installing Oracle BI Publisher 11g1 On Windows 2008R2 Server Part 1

Hi,

Welcome to Installing Oracle BI Publisher 11g1 On Windows 2008R2 Server Part 1 of the series

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

In this part we will install the Siebel Application server. This server will house a complete Siebel development server. Production servers should generally not be deployed on a single instance as we do here, but the installation of the development server demonstrates that it is possible, this walk-through will focus only on the development server installation.

Before we begin prepare the Siebel Development Server by doing the following steps:

  • install win 2008r2 operating system
  • join domain
  • update operating system with latest patches
  • install your favorite tools (mine are notepad++, procmon from sysinternals and winrar)

To Install a Siebel Development Server we will go through the following steps

  1. Installing Oracle Business Intelligence Applications – Reports – BiP 11g – Part 1
  2. Configuring Oracle Business Intelligence Applications – Reports – BiP 11g – Part 2
  3. Configuring BiP 11g in Siebel

I’m still doing the writeup of many of the steps, as I bring them online I’ll update the links accordingly.

Read the Next part in the series “Configure the Oracle Database” 

Enjoy!

/Henrik

Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 1

Hi,

Welcome to Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 1 of the series

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

In this part we will install the Siebel Application server. This server will house a complete Siebel development server. Production servers should generally not be deployed on a single instance as we do here, but the installation of the development server demonstrates that it is possible, this walk-through will focus only on the development server installation.

Before we begin prepare the Siebel Development Server by doing the following steps:

  • install win 2008r2 operating system
  • join domain
  • update operating system with latest patches
  • install your favorite tools (mine are notepad++, procmon from sysinternals and winrar)

To Install a Siebel Development Server we will go through the following steps

  1. Install the Prerequsite Software
  2. Install and Configure the Siebel Enterprise Server
  3. Install and Configure the Siebel Database Server
  4. Install and Configure the Siebel Server
  5. Install and Configure the Siebel Web Server
  6. Patching and Postinstallation Tasks
  7. Installing Siebel Charts
  8. Enabling OpenUI

I’m still doing the writeup of many of the steps, as I bring them online I’ll update the links accordingly.

Read the Next part in the series “Install the Prerequsite Software” 

Enjoy!

/Henrik

Siebel ST Scripting Engine – and ECMAScript Compliance

Hi,

Do you ever write eScript in Siebel ???

With never versions of Siebel (7.8+) Siebel introduced the ST Scripting engine. It contains a lot of changes, and Siebel may have jumped the gun a little by actually supporting ECMAScript revision 4, before the standard was finalized, but the information about the compliance is not to be found anywhere in the documentation, or supportweb….

I recently had the chance to discuss the subject with a very knowledgeable Support Engineer, that i have had the pleasure of working with on many occasions. Here´s his reply to my question:

Q) “Which version of ECMA-262 is Siebel eScript based on?”   

A) “Siebel eScript in Siebel 8.x is based on ECMA-262 version 4. This version actually never made it past the proposal status, as mentioned on Wikipedia:
http://en.wikipedia.org/wiki/Ecmascript#ECMAScript.2C_4th_Edition

This fourth edition proposal contained new language features like static typing, which were adopted by Siebel eScript, to make scripts faster and also more robust against the typical programming errors associated with dynamic typing.

While the ECMA-262 version 4 proposal has vanished, eScript continues to provide these new features.

Siebel eScript does adhere to ECMA-262 as much as possible, but subtle differences may always occur, and this is more likely for ECMAScript features that are not documented in Siebel Bookshelf.”

Here is a link to the standards definition (note that this may or may not be the features supported by the Siebel implementation of ECMAScript 4…).

Enjoy!

/Henrik

Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch

Hi,

This is going to be a looong series of posts. I needed to install a new development environment, and I wanted to test the new Siebel 8.2.2.4 SIA with all the verticals available.

Installing Siebel is no small task, and this guide is not meant to be a full replacement for reading up on the procedure on supportweb (My Oracle Support) MOS, including installation guide in bookshelf, release notes, post installation information, bugs and what-have-you-not, I’ll do my best to link to the different documents that may be relevant along the way.

The Installation will Guide you through:

It will not:

  • Teach you to install windows 2008R2

I’ll assume the following, that you in advance prepare and install two Windows 2008R2 servers in a domain. I use Hyper-V services, its fast and effortless to get started on the deployment for a new development environment.

Lets Get Started, We will do the Oracle database first!

Read About the Installation of the Oracle Database here: Installing Oracle 11r2 on Windows 2008R2 Server Part 1

I´ll finish the writeup for all the bits and pieces over the next few weeks, and publish them as i get the time. Let me know if you have any comments!

Enjoy!

/Henrik

Using Subversion with Siebel Tools

I’ve for as long as i can remember been using SourceSafe integration for all my siebel projects. Thats all good and fine, but it is aging, and for other projects I’m now using subversion. So when i installed a complete siebel 8.2.2.4, i decided to move the source control integration from SourceSafe to SVN.

First off, Siebel is not really heping you here, the default source control file installed with 8.2.2.4 looks like the source control file back in Siebel 6.

Researching a little on the net, provided lots of discussions if siebel can integrate with SVN, and the answer to that question is yes – it can. But if you come from a development background that is non siebel, then I might as well call it as it is, the source integration will only cover objects modified directly in tools, and it is solely a change log, allowing you to backtrack changes in time to a specific object. Its not a build repository, or even a complete picture of the changes that may be within one version of Siebel (ie. non-metadata changes are not included).

The batch file srcctrl.bat needs a lot of modification to work, luckily there was this one guy Michael Williams, who posted a good looking svn enabled srcctrl.bat file.

Use the file below as your starting point.

@echo off 
SETLOCAL
set SOFTWARE=svn
set CHECKIN=%SOFTWARE% commit
set CHECKOUT=%SOFTWARE% checkout
set ADD=%SOFTWARE% add
rem ==================================================================
rem =============== User defined parameters ==========================
rem ==================================================================  
rem IF SVN IS NOT IN THE DEFAULT PATH ADD IT HERE set PATH=[Path_to_svn];%PATH%
set SVN_URL=https://[svnserver]/svn/[repository]
set SVN_REPOS=[trunk]
set SRC_USR=[youruser]
set SRC_PSWD=[yourpassword]
set LOGFILE=[path_to_siebel_root]\SVN\[repository]\svn_integration.log
set WORKING_DIR=[path_to_siebel_root]\SVN\[repository]
rem LOGFILE SHOULD NOT HAVE SPACES IN ITS PATH 
rem AND WATCH OUT FOR TRAILING SPACES ON THE SET COMMANDS! 
rem ================================================================== 
rem ==================================================================     
set OPTIONS=--username %SRC_USR% --password %SRC_PSWD%
set COMMENT=-F
set FILE=
echo ===========================START============================ >> %LOGFILE%   
echo %DATE% %TIME% >> %LOGFILE%   
echo ARGS: >> %LOGFILE%   
echo %* >> %LOGFILE%
echo ============================================================ >> %LOGFILE%   
echo PARSING.. >> %LOGFILE%   
set ACTION=%1
shift 
set DIR=%1
shift
set COMMENT=%COMMENT% %1
set COMMENT_FILE=%1
shift
set FILE=%1
SET DIR_NO_QUOTE=###%DIR%###
SET DIR_NO_QUOTE=%DIR_NO_QUOTE:"###=%
SET DIR_NO_QUOTE=%DIR_NO_QUOTE:###"=%
SET DIR_NO_QUOTE=%DIR_NO_QUOTE:###=%
if errorlevel 100 goto END   

echo ACTION: %ACTION% >> %LOGFILE%   
echo DIR: %DIR% >> %LOGFILE%   
echo COMMENT_FILE: %COMMENT_FILE% >> %LOGFILE%   
echo FILE: %FILE% >> %LOGFILE%   
echo DIR_NO_QUOTE: %DIR_NO_QUOTE% >> %LOGFILE%   
echo ============================================================ >> %LOGFILE%   

if %ACTION%==checkout goto CHECK_OUT 
if %ACTION%==checkin goto CHECK_IN   

:CHECK_OUT 
echo =========================CHECKOUT=========================== >> %LOGFILE%   
echo Check out file: %FILE% from Source Control System >> %LOGFILE%   
echo Change local directory to %DIR% >> %LOGFILE% 
chdir %DIR% >> %LOGFILE% 2>&1   
echo Start checking out %FILE% from Source Control System >> %LOGFILE% 
echo %CHECKOUT% %SVN_URL%/%SVN_REPOS% %OPTIONS% "%WORKING_DIR%\%SVN_REPOS%" >> %LOGFILE% 
%CHECKOUT% %SVN_URL%/%SVN_REPOS% %OPTIONS% "%WORKING_DIR%\%SVN_REPOS%" >> %LOGFILE% 2>&1   
echo ======================CHECKOUT DONE========================= >> %LOGFILE%   
goto END   

:CHECK_IN 
echo =========================CHECKIN============================ >> %LOGFILE%   
echo Check in file: %FILE% into Source Control System >> %LOGFILE%   
echo Change local directory to %WORKING_DIR%\%SVN_REPOS% >> %LOGFILE% 
chdir %WORKING_DIR%\%SVN_REPOS% >> %LOGFILE% 2>&1   
if exist %FILE% goto FILE_EXIST >> %LOGFILE% 2>&1   
echo Copying %FILE% to local Working Copy Folder: %WORKING_DIR%\%SVN_REPOS% >> %LOGFILE% 
copy "%DIR_NO_QUOTE%%FILE%" "%WORKING_DIR%\%SVN_REPOS%\%FILE%" >> %LOGFILE% 2>&1   
echo Add %FILE% in case it doesn't exist in Source Control System >> %LOGFILE% 
echo %ADD% %WORKING_DIR%\%SVN_REPOS%\%FILE% %OPTIONS% >> %LOGFILE% 
%ADD% %WORKING_DIR%\%SVN_REPOS%\%FILE% %OPTIONS% >> %LOGFILE% 2>&1
goto COMMIT   

:FILE_EXIST   
echo Copying %FILE% to local Working Copy Folder: %WORKING_DIR%\%SVN_REPOS% >> %LOGFILE% 
echo copy "%DIR_NO_QUOTE%%FILE%" "%WORKING_DIR%\%SVN_REPOS%\%FILE%" >> %LOGFILE% 
copy "%DIR_NO_QUOTE%%FILE%" "%WORKING_DIR%\%SVN_REPOS%\%FILE%" >> %LOGFILE% 2>&1
:COMMIT 
echo Check in %WORKING_DIR%\%SVN_REPOS%\%FILE% into Source Control System >> %LOGFILE% 
echo %CHECKIN% %WORKING_DIR%\%SVN_REPOS%\%FILE% %COMMENT% %OPTIONS% >> %LOGFILE% 
echo ***** COMMENT_FILE ***** >> %LOGFILE% 
type %COMMENT_FILE% >> %LOGFILE% 2>&1 
echo . >> %LOGFILE% 
echo ************************ >> %LOGFILE% 
%CHECKIN% %WORKING_DIR%\%SVN_REPOS%\%FILE% %COMMENT% %OPTIONS% >> %LOGFILE% 2>&1
echo =======================CHECKIN DONE========================= >> %LOGFILE%   
goto END   
:END 
echo %DATE% %TIME% >> %LOGFILE%   
echo ============================END============================= >> %LOGFILE%
ENDLOCAL

Replace the elements in [square brackets] in above file, and you are ready to go.

I Use Subversion 1.7.x, SVNServer (std Edition) and Siebel Tools 8.2.2.4

Note: Rename the source control batch file (eg. to svn_srcctrl.bat) as siebel will overwrite the srcctrl.bat file on patches and updates 🙁

Enjoy!

/Henrik

Siebel Error Codes

Siebel use two kinds of error codes the XXX-XXX-nnnnn (eg. SBL-DAT-00402) type, and the internal ones in the e object thrown in code. I Can’t find a list of these internal error codes, and the SBL-XYZ-123435 codes, are not readily available in code unless you string parse, ofcourse… So I need the mapping to the error objects errCode.

I need to remember these things so for my own reference I added this post, I will update it as more errorcodes are determined by me.

SBL-DAT-00225, e.errCode = 27546 (Value does not exist in bounded picklist) – thanks Tuba !

SBL-DAT-00381, e.errCode = 27714 (Duplicate Record Exists, User Key Violation)

SBL-DAT-00382, e.errCode = 27715 (Duplicate Record Exists, Unique Index Violation)

SBL-DAT-00402, e.errCode = 27735 (This operation is not available for read only field)

SBL-DAT-00523, e.errCode = 27864 (The selected record has been modified by another user since it was retrieved), Race Condition on BC.WriteRecord()

SBL-???-?????, e.errCode = 28378 (Raise Error text), the raised text is in e.errText

SBL-EXL-00147, e.errCode = 27515 (BC.SetFieldValue() targets a field which is not active)

SBL-EXL-00119, e.errCode = 28461 (BC.GetFieldValue()), the Field is not activated, do not exist in BC

SBL-EXL-00109, e.errCode = 28511 (PropertySet Data is Binary), On PropertySet.GetProperty()

If you have more information, leave a comment!

/Henrik Ohm Eriksen