Rajesh Shah

EIM Table IF_ROW_BATCH_NUM - SQL Server

noreply@blogger.com (Rajesh Shah) — Tue, 26 Jul 2011 12:57:00 +0000

When loading the EIM tables in Siebel use the logic below to populate the IF_ROW_BATCH_NUM attribute

SQL Server

CASE
WHEN ROW_NUMBER() OVER (ORDER BY ROW_ID)%5000 >= 0 AND
             ROW_NUMBER() OVER (ORDER BY ROW_ID)%5000 <= 5000
THEN
            CEILING(ROW_NUMBER() OVER (ORDER BY ROW_ID)/5000+10000)
ELSE
            ROW_NUMBER() OVER (ORDER BY ROW_ID)

Oracle
Replace the CASE statement above to DECODE

Siebel Local DB

noreply@blogger.com (Rajesh Shah) — Thu, 10 Feb 2011 13:22:00 +0000

Siebel Local DB ::
If you forget the username and password to access the Local DB here is the solution

Siebel Version 6.x
User Name : SQL
Password : DBA

Siebel Version > 7.x
User Name : SQL
Password : Enterprise Server Name in Uppercase

SQL Server: Update Records

noreply@blogger.com (Rajesh Shah) — Thu, 09 Sep 2010 18:40:00 +0000

DECLARE @B_RID NVARCHAR(15);
DECLARE @B_LOC NVARCHAR(50);
DECLARE @B_NAME NVARCHAR(100);
DECLARE @AM_LOC NVARCHAR(50);
DECLARE @AM_NAME NVARCHAR(100);
DECLARE C1 CURSOR FOR
SELECT BASE.ROW_ID, BASE.LOC, BASE.NAME, AUTO.ACCOUNT_ID, AUTO.ACCOUNT_NAME FROM S_ORG_EXT BASE, UCM_ACCT_POST_AUTO_MATCH AUTO
WHERE BASE.LOC = AUTO.ACCOUNT_ID AND BASE.LOC IN (
SELECT DISTINCT ORG_ACCNT_LOC FROM EIM_FN_CIF_SYST WHERE IF_ROW_STAT = 'PARTIALLY_IMPORTED')
ORDER BY BASE.LOC;
OPEN C1;
FETCH NEXT FROM C1 INTO @B_RID, @B_LOC, @B_NAME, @AM_LOC, @AM_NAME
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE S_ORG_EXT SET NAME = @AM_NAME WHERE ROW_ID = @B_RID
FETCH NEXT FROM C1 INTO @B_RID, @B_LOC, @B_NAME, @AM_LOC, @AM_NAME
END
CLOSE C1
DEALLOCATE C1

Arithmetic overflow error converting expression to data type int

noreply@blogger.com (Rajesh Shah) — Wed, 10 Feb 2010 02:54:00 +0000

The "Arithmetic overflow error converting expression to data type int." error occurs when the computing field's result is bigger than the size of the data type defined.

The error can also occur using COUNT(*). Try using the COUNT_BIG(*)

Generate Address Name for EIM

noreply@blogger.com (Rajesh Shah) — Wed, 02 Dec 2009 00:28:00 +0000

Many times we have to replicate the ADDR_NAME configuration/calculation for Initial load.

Below is the query to generate the exact string as it gets generated from UI. This is written in SQL Server and the inbuilt functions can be changed to replicate the same in Oracle

ADDR NAME
------------------------
SELECT
LEFT
(ADDR,
CASE
WHEN (100-CASE
WHEN STATE IS NULL
THEN 0
ELSE LEN(STATE)
END
-
CASE
WHEN CITY IS NULL
THEN 0
ELSE LEN(CITY)
END
- 4) < (LEN(ADDR))
THEN 100-CASE
WHEN STATE IS NULL
THEN 0
ELSE LEN(STATE)
END
-
CASE
WHEN CITY IS NULL
THEN 0
ELSE LEN(CITY)
END - 4
ELSE LEN(ADDR)
END)
+
CASE WHEN ADDR_LINE_2 IS NOT NULL THEN ', ' ELSE '' END
+
ISNULL(ADDR_LINE_2,'')
+
CASE
WHEN ADDR IS NOT NULL AND CITY IS NOT NULL OR STATE IS NOT NULL
THEN ', '
ELSE ''
END
+
CITY
+
CASE WHEN (STATE IS NOT NULL AND ADDR IS NOT NULL OR CITY IS NOT NULL)
THEN (CASE WHEN CITY IS NOT NULL THEN ', ' ELSE '' END)
ELSE ''
END
+
STATE
FROM dbo.S_ADDR_PER

For Oracle Replace
+ with (Double Pipe)
ISNULL with NVL
LEN with LENGTH
LEFT with SUBSTR
CASE WHEN THEN ELSE END with DECODE

Java: Passing arrays to a stored procedure with PLSQL Table Type

noreply@blogger.com (Rajesh Shah) — Sun, 25 May 2008 18:05:00 +0000

Not all PL/SQL arrays can be direcly accessed using JDBC. Procedures or Functions that take arrays and are declared inside packages instead of with “CREATE TYPE” can not be called using JDBC. This is a limitation of Oracle.
Approach to solve this issue:
1. Write an additonal wrapper procedure that converts an array created with CREATE TYPE into the format required by your procedure
If you can not change the procedure itself or it is already used by a large base of existing code you may have to go with option 2 of writing an additional wrapper procedure that takes parameters usable by JDBC:

Original Code:
Create or Replace Package tms_user_autocode IS
Type DeriveValuesREC IS RECORD (
DefLevelId number(10),
ColumnName VARCHAR2(30),
ValueText tms_dict_contents.term%TYPE,
ClassificationCode VARCHAR2(1));

Type DeriveValuesTAB is TABLE of DeriveValuesREC INDEX BY BINARY_INTEGER;

FUNCTION ClassifyTerm(
pDefDictionaryId IN NUMBER
pDefDomainId IN NUMBER
pTerm IN VARCHAR2
pSourceTermId IN NUMBER
pOccurrenceId IN NUMBER
pSourceTermAltKey IN VARCHAR2
pNoOmissionFlag IN VARCHAR2
pDefIntegrationKey IN VARCHAR2
pDefInstanceName IN VARCHAR2
pXArea IN NUMBER
pExtValue1 IN VARCHAR2
pExtValue2 IN VARCHAR2
pExtValue3 IN VARCHAR2
pExtValue4 IN VARCHAR2
pExtValue5 IN VARCHAR2
pExtValue6 IN VARCHAR2
pExtValue7 IN VARCHAR2
pExtValue8 IN VARCHAR2
pOmissionStatus IN OUT VARCHAR2
pOmissionOwner IN OUT VARCHAR2
pActionText IN OUT VARCHAR2
pVTAid OUT NUMBER
pSearchID OUT NUMBER
pDeriveValues IN OUT tms_user_autocode.DeriveValesTAB) RETURN PLS_INTEGER

END tms_user_autocode;
Wrapper Procedure:

CREATE OR REPLACE
PROCEDURE CTRM_tms_user_autocode
(jDefDictionaryId IN NUMBER,
jDefDomainId IN NUMBER,
jTerm IN VARCHAR2,
jSourceTermId IN NUMBER,
jOccurrenceId IN NUMBER,
jSourceTermAltKey IN VARCHAR2,
jNoOmissionFlag IN VARCHAR2,
jDefIntegrationKey IN VARCHAR2,
jDefInstanceName IN VARCHAR2,
jXArea IN NUMBER,
jExtValue1 IN VARCHAR2,
jExtValue2 IN VARCHAR2,
jExtValue3 IN VARCHAR2,
jExtValue4 IN VARCHAR2,
jExtValue5 IN VARCHAR2,
jExtValue6 IN VARCHAR2,
jExtValue7 IN VARCHAR2,
jExtValue8 IN VARCHAR2,
jOmissionStatus IN OUT VARCHAR2,
jOmissionOwner IN OUT VARCHAR2,
jActionText IN OUT VARCHAR2,
jSearchID OUT NUMBER,
jVTAid OUT NUMBER,
jDeriveValues IN OUT CTRM_DeriveValuesTAB
returnValue OUT Number) AS

l_array tms_user_autocode.DeriveValuesTAB;
l_record tms_user_autocode.DeriveValuesREC;

BEGIN
– Load our JDBC table into the PL/SQL one…
l_array.delete;
FOR i IN jDeriveValues.FIRST
.. jDeriveValues.LAST LOOP
l_record := NULL;

l_record.DefLevelId := jDeriveValues(i).DefLevelId;
l_record.ColumnName := jDeriveValues(i).ColumnName;
l_record.ValueText := jDeriveValues(i).ValueText;
l_record.ClassificationCode := jDeriveValues(i).ClassificationCode;
l_array(i) := l_record;

END LOOP;
returnValue := tms.TMS_user_AUTOCODE.ClassifyTerm(
jDefDictionaryId
, jDefDomainId
, jTerm
, jSourceTermId
, jOccurrenceId
, jSourceTermAltKey
, jNoOmissionFlag
, jDefIntegrationKey
, jDefInstanceName
, jXArea
, jExtValue1
, jExtValue2
, jExtValue3
, jExtValue4
, jExtValue5
, jExtValue6
, jExtValue7
, jExtValue8
, jOmissionStatus
, jOmissionOwner
, jActionText
, jSearchId
, jVTAid
,l_array
);

FOR i IN l_array.FIRST .. l_array.LAST LOOP
jDeriveValues(i).DefLevelId := l_array(i).DefLevelId;
jDeriveValues(i).ColumnName := l_array(i).ColumnName;
jDeriveValues(i).ValueText := l_array(i).ValueText;
jDeriveValues(i).ClassificationCode := l_array(i).ClassificationCode;

END LOOP;
–
END;

Java program :

import java.sql.*;

import oracle.jdbc.OracleTypes;
import oracle.sql.ARRAY;
import oracle.sql.ArrayDescriptor;
import oracle.sql.STRUCT;
import oracle.sql.StructDescriptor;

public class Test {
public static void main(String[] args) throws SQLException {
CallableStatement proc = null;
try {
Connection conn=null;
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
//Establish a connection
conn = DriverManager.getConnection
(”jdbc:oracle:oci8:@123.WORLD”,
“scott”, “tiger);
System.out.println(”connection success0″);

int DictId = 8;
int DomainId = 1;
String Term = “BLOOD”;
int SourceId=0;
String pOccurrenceId=”0″;
String pSourceTermAltKey =”";
String pDefIntegrationKey=”CTRM”;
String pDefInstanceName=”OCP451.TEST.COM”;
int pXArea=1;
String Flag=”N”;
String pExtValue1=”";
String pExtValue2=”";
String pExtValue3=”";
String pExtValue4=”";
String pExtValue5=”";
String pExtValue6=”";
String pExtValue7=”";
String pExtValue8=”";
String ActionText=”";
int returnValue=0;
int sid=0;
String oStat=”";
String oOwner=”";
//String xsystem=”";
int vtaid=0;

// create the ARRAY by calling the constructor

System.out.println(”connection success1.1″);
//First, declare the Object arrays that will store the data.
Object [] p1recobj = {new Integer(811),”TERM”,”",”"};
Object [] p2recobj = {new Integer(811),”DICT_CONTENT_CODE”,”",”"};
Object [] p3recobj = {new Integer(812),”TERM”,”",”"};
Object [] p4recobj = {new Integer(812),”DICT_CONTENT_CODE”,”",”"};
System.out.println(”connection success1.2″);
//Declare the Object Arrays to hold the STRUCTS.
Object [] p1arrobj;
//Object [] p2arrobj;
System.out.println(”connection success1.3″);
// Declare two descriptors, one for the ARRAY TYPE
// and one for the OBJECT TYPE.
StructDescriptor desc1 = StructDescriptor.createDescriptor(”CTRM_DERIVEVALUESREC”, conn);
ArrayDescriptor desc2 = ArrayDescriptor.createDescriptor(”CTRM_DERIVEVALUESTAB”, conn);
System.out.println(”connection success1.4″);
// Create the STRUCT objects to associate the host objects
// with the database records.
STRUCT p1struct = new STRUCT(desc1,conn,p1recobj);
STRUCT p2struct = new STRUCT(desc1,conn,p2recobj);
STRUCT p3struct = new STRUCT(desc1,conn,p3recobj);
STRUCT p4struct = new STRUCT(desc1,conn,p4recobj);
System.out.println(”connection success1.5″);
// Initialize the Input array object - to an array of STRUCT Objects.
p1arrobj = new Object []{p1struct,p2struct,p3struct,p4struct};
System.out.println(”connection success1.6″);
// Set up the ARRAY object.
ARRAY p1arr = new ARRAY(desc2,conn,p1arrobj);
// ARRAY p2arr;
System.out.println(”connection success1.7″);
proc = conn.prepareCall(”{ call CTRM_tms_user_autocode(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}”);
System.out.println(”connection success1.8″);
proc.setInt(1, DictId);
proc.setInt(2, DomainId);
proc.setString(3, Term);
proc.setInt(4, SourceId);
proc.setString(5, pOccurrenceId);
proc.setString(6, pSourceTermAltKey);
proc.setString(7, Flag);
proc.setString(8, pDefIntegrationKey);
proc.setString(9, pDefInstanceName);
proc.setInt(10, pXArea);
proc.setString(11, pExtValue1);
proc.setString(12, pExtValue2);
proc.setString(13, pExtValue3);
proc.setString(14, pExtValue4);
proc.setString(15, pExtValue5);
proc.setString(16, pExtValue6);
proc.setString(17, pExtValue7);
proc.setString(18, pExtValue8);
proc.setString(19, oStat);
proc.setString(20, oOwner);
proc.setString(21, ActionText);
proc.setInt(22,sid);
proc.setInt(23, vtaid);
proc.setArray(24,p1arr);
proc.setInt(25,returnValue);
//Registering OUT parameter
proc.registerOutParameter (19, Types.VARCHAR);
proc.registerOutParameter (20, Types.VARCHAR);
proc.registerOutParameter (21, Types.VARCHAR);
proc.registerOutParameter (22, Types.INTEGER);
proc.registerOutParameter (23, Types.INTEGER);
proc.registerOutParameter(24,OracleTypes.ARRAY,”CTRM_DERIVEVALUESTAB”);
proc.registerOutParameter (25, Types.INTEGER);
System.out.println(”connection success1.9″);
proc.execute();
System.out.println(”connection success2″);
// Associate the returned arrays with the ARRAY objects.
oStat=proc.getString(19);
oOwner=proc.getString(20);
ActionText=proc.getString(21);
sid = proc.getInt(22);
vtaid = proc.getInt(23);
p1arr = (ARRAY) proc.getArray(24);
returnValue=proc.getInt(25);
System.out.println(”connection success2.1″);
//Get the data back into the data arrays.
p1arrobj = (Object [])p1arr.getArray();
System.out.println(”connection success2.2″);
// Get the data records from each array element (which is of type STRUCT).
p1recobj = ((STRUCT)p1arrobj[0]).getAttributes();
p2recobj = ((STRUCT)p1arrobj[1]).getAttributes();
p3recobj = ((STRUCT)p1arrobj[2]).getAttributes();
p4recobj = ((STRUCT)p1arrobj[3]).getAttributes();
System.out.println(”connection success2.3″);
//Show the results:
System.out.println(”returnValue “+returnValue);
System.out.println(”ActionText “+ActionText);
System.out.println(”OmissStat “+oStat);
System.out.println(”OmissOwner “+oOwner);
System.out.println(”SearchID “+sid);
System.out.println(”VTAID “+vtaid);
System.out.println(”First Object is now “+p1recobj[0]+” and “+p1recobj[1]+” and “+p1recobj[2]+” and “+p1recobj[3]);
System.out.println(” “+p2recobj[0]+” and “+p2recobj[1]+” and “+p2recobj[2]+” and “+p2recobj[3]);
System.out.println(”Second Object is now “+p3recobj[0]+” and “+p3recobj[1]+” and “+p3recobj[2]+” and “+p3recobj[3]);
System.out.println(” “+p4recobj[0]+” and “+p4recobj[1]+” and “+p4recobj[2]+” and “+p4recobj[3]);

conn.commit();

} catch (Exception e) {

System.out.println(”e>”+e);

} finally {
if (proc != null)
proc.close();
}
}
}

2008 June Visa Bulletin Update

noreply@blogger.com (Rajesh Shah) — Sat, 10 May 2008 12:01:00 +0000

EB1 China, India, Mexico, Philippines, ROW-C
EB2 India- 01 APR 04, China, Mexico, Philippines, ROW-C
EB3
China- 01 MAR 06,
India- 01 NOV 01

Siebel Repository Tables Query

noreply@blogger.com (Rajesh Shah) — Tue, 06 May 2008 19:26:00 +0000

To get the column information based on View and Applet from the Repository

SELECT A.NAME, C.APPLET_NAME, E.FIELD_NAME, G.COL_NAME, H.NAME
FROM
S_VIEW A, S_VIEW_WEB_TMPL B, S_VIEW_WTMPL_IT C,
S_APPLET D, S_CONTROL E,
S_BUSCOMP F, S_FIELD G,
S_TABLE H, S_COLUMN I
WHERE
A.ROW_ID = B.VIEW_ID
AND B.ROW_ID = C.VIEW_WEB_TMPL_ID
AND A.ROW_ID = ''
AND A.REPOSITORY_ID = ''
AND D.NAME = C.APPLET_NAME
AND D.REPOSITORY_ID = ''
AND D.NAME = ''
AND D.ROW_ID = E.APPLET_ID
AND E.FIELD_NAME IS NOT NULL
AND F.NAME = D.BUSCOMP_NAME
AND F.REPOSITORY_ID = ''
AND G.BUSCOMP_ID =F.ROW_ID
AND G.JOIN_NAME IS NULL
AND E.FIELD_NAME = G.NAME
AND F.TABLE_NAME =H.NAME
AND H.REPOSITORY_ID = ''
AND I.TBL_ID =H.ROW_ID
AND I.NAME =G.COL_NAME

Automated Script/Batch File: To Stop Server, Compile SRF, Generate Scripts, Start Server

noreply@blogger.com (Rajesh Shah) — Wed, 30 Apr 2008 18:17:00 +0000

The batch file will perform the following Siebel Administrative Tasks:

Backup the SRF from servers
Perform Full Compile
Stop Siebel Services
Copy Compiled SRF
Start Siebel Services
Run the Genbscript Utility
Copy Genbfolder
Restart Web Server

Batch File:

@echo off
REM ——————————————————————————————————————————————————————————————————
REM Batch compiles Siebel SRF and places on the server
REM ——————————————————————————————————————————————————————————————————

REM —- Step1 : Create Backup —-
SET MONTH=%DATE:~4,2%
SET DAY=%DATE:~7,2%
SET YEAR=%DATE:~10,4%
SET HOUR=%TIME:~0,2%
SET MINUTE=%TIME:~3,2%
SET SECOND=%TIME:~6,4%

copy “\\siebel\siebsrvr\OBJECTS\ENU\siebel_sia.srf” “\\siebel\siebsrvr\OBJECTS\ENU\back\siebel_sia_%YEAR%_%MONTH%_%DAY%_%HOUR%_%MINUTE%.srf” /y
E: <>
cd \\siebel\siebsrvr\OBJECTS\ENU\

REM —- Step2 : Stop Siebel Service —-
net stop <> -- Sample : “siebsrvr_DEVENT_DEVSRVR1″

REM —- Step3 : Stop Siebel Service on second server —-
SC \\<> STOP <> -- Sample : “siebsrvr_DEVENT_DEVSRVR2″

REM —- Step4 : Complie it in local directory —-
\\siebel\Tools\BIN\siebdev.exe /C “\\siebel\Tools\BIN\ENU\tools.cfg” /d ServerDataSrc /u sadmin /p sadmin /bc “Siebel Repository” siebel_sia_new.srf

ping -n 3600 localhost > nul

REM —- Step5 : Copy to siebsrvr folder on both server —-

copy \\siebel\Tools\OBJECTS\ENU\siebel_sia_new.srf \\siebel\siebsrvr\OBJECTS\ENU\siebel_sia.srf /y

ping -n 120 localhost > nul

REM —- Step6 : Run Genb script———–
E: <>
cd \\siebel\siebsrvr\bin
genbscript “\\siebel\siebsrvr\bin\enu\Test.cfg” \\enu

REM —- Step7 : Start Siebel Service —-
net start “siebsrvr_DEVENT_DEVSRVR1″

REM —- Step8 : Start Siebel Service on Second Server —-
SC \\<> START “siebsrvr_DEVENT_DEVSRVR2″

REM —- Step9 : Stop Web Server —-
net stop “W3SVC”

ping -n 180 localhost > nul

REM —- Step10 : start Web Server —-
net start “W3SVC”

—————End of Batch Script—————————————–

Bhaskar Konda's Photography

noreply@blogger.com (Rajesh Shah) — Wed, 30 Apr 2008 01:53:00 +0000

Bhaskar is one of my friend who is very good and awesome at photography. Explore his photographs in the link below:

http://www.bigbphotography.com/

2008 May Visa Bulletin Update

noreply@blogger.com (Rajesh Shah) — Fri, 18 Apr 2008 18:29:00 +0000

EB1 China, India, Mexico, Philippines, ROW-C
EB2 China- 01 JAN 04, India- 01 JAN 04, Mexico, Philippines, ROW-C
EB3
China- 22 MAR 03,
India- 01 NOV 01,
Mexico- 01 JUL 02,
Philippines- 01 MAR 06,
ROW- 01 MAR 06

2008 April Visa Bulletin Update

noreply@blogger.com (Rajesh Shah) — Thu, 13 Mar 2008 23:16:00 +0000

EB1 China, India, Mexico, Philippines-C
EB2 China- 01 DEC 03, India- 01 DEC 03, Mexico, Philippines-C
EB3 China- 08 FEB 03, India- 01 OCT 01, Mexico, Philippines-C

Popup Applets

noreply@blogger.com (Rajesh Shah) — Sat, 16 Feb 2008 22:58:00 +0000

Every implementation we aim to rollout a ‘vanilla’ solution. Everyone also understands the ongoing benefits of not over-customizing. We also understand that there are still situations that justify slight tweaks to the Siebel application…

In Siebel 7x it’s possible to launch a pop-up applet from a normal applet by using the ShowPopup method. You can also find the information in Bookshelf -> Configuring Siebel eBusiness Applications -> Configuring Special Purpose Applets -> Configuring Pop-Up Applets Launched from Applets.

In a jist

Add a control to your applet
Set the control Method Invoked to ShowPopup
Set the control User Property Popup to the name of your popup applet
The popup applet specified in the user property must use a class derived from CSSSWEFramePopup.
To see all possible classes select ‘Class’ in Tools Object Explorer and query for ‘Super Class’ = CSSSWEFramePopup: the standard class for a popup list applet is CSSSWEFrameListPopup. If you’re creating a new applet for your popup and you don’t expect edits in the popup, it’s simplest to configure your layout in ‘Base’ mode.

The popup applet can be based on any business component in currently active business object, and will appear in context. So you could launch a popup from the Contacts applet, for instance, and list all Items. Alternatively, you can base your popup on a VBC and display any random list of choices you desire. Because it’s all in context, capturing the user action and invoking a change on the launching business component is trivial.

Useful SQL's -- Siebel

noreply@blogger.com (Rajesh Shah) — Thu, 14 Feb 2008 15:46:00 +0000

Query to identify all Custom Column Extensions

SELECT TABLE_NAME, COLUMN_NAME
FROM ALL_TAB_COLUMNS
WHERE
OWNER='SIEBEL' AND
TABLE_NAME LIKE 'S\_%' ESCAPE '\' AND
COLUMN_NAME LIKE 'X\_%' ESCAPE '\';

Query to identify all Custom Indices

SELECT INDEX_NAME, COLUMN_NAME, TABLE_NAME
FROM ALL_IND_COLUMNS
WHERE
TABLE_NAME LIKE 'S\_%' ESCAPE '\' AND
COLUMN_NAME LIKE 'X\_%' ESCAPE '\' AND
TABLE_OWNER = 'SIEBEL';

Query to identify all Custom Tables

SELECT TABLE_NAME
FROM ALL_TABLES
WHERE
OWNER='SIEBEL' AND
TABLE_NAME LIKE 'CX\_%' ESCAPE '\';

EIM Performance Tuning for Dummies

noreply@blogger.com (Rajesh Shah) — Thu, 14 Feb 2008 04:01:00 +0000

A quick look at the various strategies available for tuning EIM on Oracle.

EIM is the mechanism used to load large data volumes into a Siebel database.

EIM can also be used for ongoing data loads where data is processed (typically from an external system) to create, update, merge or delete records.

Data quality

EIM can load data fast. However, if the data is missing key fields from the source system, the entire data load will have to be repeated. Exhaustive, thorough checking, testing and validation of all data will have significant benefits. EIM performance degrades in direct proportion to the number of rejected records.

Consider using a staging table with multiple check constraints to validate the data and enforce integrity as much as possible.

Testing

Test, test, check and double check the load procedure. Check that data is actually visible in the Siebel application. Failure to populate a single primary column may mean data will not be visible to the end user.

Profiling

Analyse the SQL statements issued by EIM Process and the performance profile. The IFB parameter SQLPROFILE may be specified to generate a detailed breakdown of each EIM step together with the most resource intensive SQL statements.

Gathering statspack snapshots at the start/end of EIM processing may be used to report on general Oracle performance metrics.

Disable Transaction Logging

Siebel supports mobile web clients (remote users who work in a discinnected mode and synchronise with the Siebel server). For large scale data loads,the Siebel System Preference 'Docking: Transaction Logging' should be set to 'FALSE'. When the data load is complete, mobile web clients should be extracted.

Tune the IFB

ONLY BASE COLUMNS
The parameters 'ONLY BASE TABLES and, in particular, 'ONLY BASE COLUMNS' limit the amount of processing done by EIM. In addition, the resulting IFB documents the data mappings.

DEFAULT/FIXED COLUMNS
The EIM parameter 'DEFAULT COLUMN' and 'FIXED COLUMN' are relatively inefficient. EIM generates an UPFDATE statement for each such column for each batch processed. It is preferable to populate constant values prior to the EIM load either using SQL*Loader or updating the data.

Index hints
Two IFB parameters USE ESSENTIAL INDEX HINTS (default=TRUE) and USE INDEX HINTS (default=FALSE) should usually both be set to TRUE on Oracle. The parameters issue additional index hints to choose the appropriate indexes.

Direct path inserts
EIM also supports direct path inserts. The IFB parameter 'ORACLE INSERT APPEND MODE = TRUE' should be specified. This will add the /*+ APPEND */ hint to all insert statements.

Direct path load locks the target table. However, this isn't an issue here as the insert operation is the last part of EIM processing and is followed by a commit.

Tune the batch size
EIM processes data in batches. The size of each batch is determined by the IF_ROW_BATCH_NUM column in the EIM interface table. It is worth experimenting with batch size between 2,500 and 25,000 to determine the optimal value. There isn't a massive difference and 5,000 or 10,000 is normally a decent choice (and helps makes the sums easier).

Index monitoring
Maintaining all those indexes is expensive. Oracle provides a feature to monitor index usage. This technique can be used to enable index monitoring, execute an EIM data load. Any non-unique indexes that were not used during EIM processing may be dropped.

The necessary DDL to re-create the indexes should be captured. This allows the indexes to be reinstated when data loading is complete. Parallel index creation may be used to create the indexes quickly. The Siebel DDLSYNC utility will also recreate any missing indexes but is sequential (and relatively slow).

Tune Oracle
Siebel is an OLTP application with users connecting using a web browser. EIM is a batch application. Consequently, there is scope to reconfigure the SGA. The size of the shared pool may be reduced and the memory allocated to the buffer cache.

Pre-allocate tablespace
For large data loads, it is recommended to pre-allocate the necessary tablespace. Dynamic extent allocation is expensive and should be avoided.

Redo logs(Undo Tablespaces)
EIM generates large volumes of redo information. In addition to the actual insert's of new records into the target tables, EIM performs updates on the EIM interface tables to set and modify status values. In addition, some primary columns will also result in update statements.

Parallelism
The final step of EIM tuning should be to run multiple EIM processes in parallel. EIM is database intensive and consumes relatively few resources on the Siebel application server. With modern disk storage technologies, the limiting factor for EIM throughput should be the CPU resources on the database server.

Linux Online

noreply@blogger.com (Rajesh Shah) — Thu, 14 Feb 2008 03:56:00 +0000

Linux for newbies. There are tutorials and online terminals such telnet, ssh or java telnet client. Using one of these clients you can login to remote virtual machine by root user and start practicing your sessions from the tutorials.

The site is http://linuxzoo.net
Need to Register and Login to account

The join the queue and switch on the system.

Once you get the run or completed prompt,
Go to connect and copy the url/ip to your telnet client.

Terminal Service: Has Exceeded Maximum Number of Allowed Connections

noreply@blogger.com (Rajesh Shah) — Wed, 13 Feb 2008 15:14:00 +0000

If you encounter the following error
"The terminal server has exceeded the maximum number of allowed connections”
you generally call the System Administrator to terminate some invalid session and try again.

There is a WORK AROUND. Try this

Invoke the Run command and execute the following script

mstsc /v:000.000.000.000 /console

Replace 000.000.000.000 with your Server’s IP or Server Name.

Sanity Check: Can Mahalo Compete With Google, Digg, and Wikipedia

noreply@blogger.com (Rajesh Shah) — Wed, 13 Feb 2008 14:51:00 +0000

They proclaim that it is the world's first human-powered search engine that creates organized, comprehensive, and spam free search results for the most popular search terms

http://WWW.MAHALO.COM

2008 MARCH Visa Bulletin Update

noreply@blogger.com (Rajesh Shah) — Tue, 12 Feb 2008 17:02:00 +0000

EB1 China, India, Mexico, Philippines-C
EB2 China- 01 DEC 03, India-U, Mexico, Philippines-C
EB3 China- 01 DEC 02, India- 01 AUG 01, Mexico- 01 MAY 01, Philippines- 01 JAN 05

The cut-off date movement for March in several Employment categories has been greater than those experienced in recent months. Advancement of the cut-off dates at this time should prevent a situation later in the fiscal year where there are large amounts of numbers available but not enough time to use them. If the expected increase in CIS number use materializes, future cut-off date movements could slow or stop.

Siebel High Interactivity Framework

noreply@blogger.com (Rajesh Shah) — Wed, 06 Feb 2008 17:06:00 +0000

Have you ever wondered where are all the records???

When clicking on Pick/MVG/Shuttle Applet in Siebel Web Client, the applet which pops up does not seem to show any records.

The IE instance which runs the Siebel Application crashes when you invoke the Pick/MVG/Shuttle Applet

The pop up window is hidden and small

If any of the above happens then there is a damaged High Interactivity Object. Try deleting all the Siebel High Interactivity object and launch the application again. The object will be recreated and the pop ups should work properly. Alternatively check if the Pop Up Blocker is disabled.

TO DELETE THE HIGH INTERACTIVITY OBJECTS:

Internet Explorer –> Tools Menu –> Internet Options
Go To General Tab
In the section "Temporary Internet Files" click on the Setting Button
There will another PopUp
Click on the "View Object" Button
Delete all the Siebel High Interactivity Object.

Or

Navigate to "\\WINDOWS\Downloaded Program Files"
Delete all the Siebel High Interactivity Object.

Yael Naim

noreply@blogger.com (Rajesh Shah) — Wed, 30 Jan 2008 01:24:00 +0000

New Soul

Awesome Version of Brit's Toxic by Yael Naim

New soul Live Yael Naim with AWESOME Lucie Star

Siebel LOVs Performance

noreply@blogger.com (Rajesh Shah) — Wed, 23 Jan 2008 21:56:00 +0000

Whenever one needs to access lists of values data in the configuration, note the of the business components defined on the S_LST_OF_VAL table, Picklist Generic is cached while List Of Values is not. The impact of this is that repeated queries to Picklist Generic will be served from the memory of the Object Manager, whereas queries to List Of Values will always hit the database. So for improved performance be sure to use Picklist Generic in your configuration, not List Of Values.

Caching behaviour is controlled by the business component property Cache Data: when this property is set to true then the database is only read once for a given query. You can see in Object Explorer that Picklist Generic has Cache Data set to true, while it’s false for List Of Values. This configuration allows the List Of Values BC to be used for managing LOVs, where it’s critical to always have the current database values, while Picklist Generic can be used where performance is more important.

Oracle Forums

noreply@blogger.com (Rajesh Shah) — Thu, 17 Jan 2008 13:53:00 +0000

http://forums.oracle.com/forums/category.jspa?categoryID=151

Siebel and Internet Explorer 7

noreply@blogger.com (Rajesh Shah) — Thu, 17 Jan 2008 13:37:00 +0000

Siebel started supporting its application using IE7 for the High Interactivity Web client for all versions higher than 7.5.

The summary of the Siebel versions (and QuickFixes) required to support IE7 is:

8.0.0.1 with QF0103
7.8.2.5 with QF0547
7.7.2.8 with QF0814
7.5.3.17

Oracle Wiki

noreply@blogger.com (Rajesh Shah) — Thu, 17 Jan 2008 13:35:00 +0000

Official Oracle Public WIKI is out

The Wiki is based on WetPaint and the article editor is pretty intuitive and easy to use.

http://wiki.oracle.com/