Cannot Install Siebel Tools or Siebel Client : “Class Not Registered”

Issue

When you click on “Install.exe” for a Siebel Mobile Web Client or Siebel Tools installation, after selecting the desired language, you get the following error message in a popup window:

“An error occured while launching the setup” – “Class not registered”

Cause

The fact that the installer fails at the very beginning after clicking on “Install.exe” indicates this could be an external issue related to the InstallShield software used by Siebel to install the Siebel application.

Further investigation revealed that the “Engine” folder was missing under “C:\Program Files\Common Files\InstallShield”. This engine folder is required by InstallShield.

As per InstallShield web site: “Sometimes in an attempt to fix installation-related errors, you may have to update the engine that runs the installation itself”

Solution

1. Launch Windows Explorer by pressing Windows Key + E on your keyboard or select Start > Run and type explorer.
2. Browse to C:\Program Files \Common Files\InstallShield\engine. (This folder was missing)
3. Right-click the highlighted engine directory and select Delete.
4. Install the latest version of the iKernel engine.

1. Download iKernel engine update and save it to your Desktop. (http://support.installshield.com/kb/files/Q108312/ikernelupdate.exe)
2. Double-click on ikernelupdate.exe to install.

After re installing the kernel try to install to0ls/client again this time you will be able to do so.

‘Changed’ works in Siebel

I was given a system when I newly joined in the team. The system allotted to me was used by someone earlier. The problem is, while doing configuration, if I query for ‘Changed’ records in any object, it displays almost all the records in the applet. Since I have been overloaded with task as soon as I joined, I could not able to spend time in finding what went wrong. So during configuration I used to query for Specific record by typing few letters with a * before and after the keyword instead of changed. Later, when the work was balanced, we spend sometimes in finding a solution. When you query for changed, it displays some records which are changed/modified after a specified date. By changing the date to yesterday, it will display the records which are changed a day before. So, in my case, the date entered is roughly 2 years behind the current date. Obviously, when I query for changed records, it displays records which are changed in last two years. Now question is where to change the date? Records are marked as changed in the Object List Editor when they occur after the date defined under the General Tab of the development in Tools Options dialog box.

To set Changed date preferences
1. Choose Viewà Options.
2. Click the general tab.
3. Under changed date, use the date and time field to set your preferences.
4. Click Ok.

Now you query for changed, you will find only records which are edited after the date specified by you in the date and time of general tab.

Joker Display Name

In a form applet, how will you scroll (dynamically moving) the display name of all the fields from left to right with different font size and color? The scenario may look fanatical but the outcome would be wonderful and offer you a different perspective to approach the Siebel configuration.

 

Let us take the “SIS Account Entry Applet” and try to implement the same on it. Go to the Applet –> Controls, where you can find all the fields used in the applet. Now, follow the below mentioned steps.

1. In controls, point the “Account Name” field.
2. In the ‘Caption – String Override’, instead of giving ‘Account Name’ provide the following



3. Repeat the step 1 & 2 for all the fields in the applet by changing the
   display name, font, color etc.,

    

4. Compile the applet, now you can see all the fields in the applet are moving
   here and there with the font color you mentioned.

 

Numbering for duplicate record

DATA:

We have the following data

john | apple
john | melon
john | grape
jane | orange
jane | apple
mike | mango

Requirement:
We need to create a VIEW that has 2 new columns, c and d where c is the sequence number for every changes in column b and d is the sequence number for every changes in column a

a      | b          | c      | d
john | apple   | 001  | 001
john | melon  | 002  | 001
john | grape  | 003  | 001
jane | orange| 001  | 002
jane | apple  | 002   | 002
mike | mango| 001  | 003

Solution:

SELECT   name a,
           fruit b,
           TO_CHAR(ROW_NUMBER() OVER (PARTITION BY name ORDER BY rn), '009') c,
           TO_CHAR(DENSE_RANK() OVER (ORDER BY name), '009') d
    FROM   (  SELECT   ROWNUM rn, name, fruit FROM yourtable)
ORDER BY   rn

Query Record for last week in oracle

below query will tell the date between which you want to extract record.

select (next_day(TRUNC(sysdate),’Mon’)-14), (next_day(TRUNC(sysdate),’SUN’)-7) from dual

so your query will be:

Column_Name between (next_day(TRUNC(sysdate),’Mon’)-14) and (next_day(TRUNC(sysdate),’SUN’)-7)

Note: you can adjust your week by changing the value in day (Mon,Sat………)