tag:blogger.com,1999:blog-70897414203270986002024-03-09T02:45:14.954+05:30Gateway To SiebelEverything in life is linked and so is the case in siebel...find the missing<br> pieces of the
jigsaw puzzle put
them in correct
places and visualize...<br>
and you will find the way!!Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.comBlogger44125tag:blogger.com,1999:blog-7089741420327098600.post-71204070435922681902014-12-10T17:23:00.003+05:302014-12-10T17:36:18.412+05:30The query which made me a mere spectator of Time<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7089741420327098600" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7089741420327098600" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<br />
<div class="MsoNormal">
<a href="https://www.blogger.com/blogger.g?blogID=7089741420327098600" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7089741420327098600" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a><span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">This SQL query takes it too long to bring the data<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><span style="color: red;"><br /></span></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><span style="color: red;">select * from s_evt_act where QUOTE_ID is not null <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><span style="color: red;">and TODO_CD in ('Email - Inbound','Email -
Outbound','Communication','BCP Request','PCN Request','PriceResponse')</span><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;">Generate Explain Plan using F10 in SQL Developer<o:p></o:p></span><br />
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><br /></span>
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%; mso-no-proof: yes;"><br /></span></div>
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-maY8kqH7WIg/VIg1cRddyeI/AAAAAAAAAGE/GunH4BETDyQ/s1600/explain%2BPlan%2B1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-maY8kqH7WIg/VIg1cRddyeI/AAAAAAAAAGE/GunH4BETDyQ/s1600/explain%2BPlan%2B1.png" height="217" width="640" /></a></div>
<br /></div>
<div class="MsoNormal">
<span style="font-size: 10.0pt; line-height: 115%; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; mso-no-proof: yes;"><!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_1" o:spid="_x0000_i1026" type="#_x0000_t75"
style='width:468pt;height:160.5pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\PVIDYA~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></span><span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;">We
can see that the Table Access is happening for S_EVT_ACT for query QUOTE_ID IS
NOT NULL<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;">The
Cost comes around 11200<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;">Solution:</span></b></div>
<div class="MsoNormal">
<b><span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<b><span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;">Create an Index<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;">CREATE INDEX
"SIEBEL"."S_EVT_ACT_F85_X" ON
"SIEBEL"."S_EVT_ACT"<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> (<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> "QUOTE_ID" DESC,<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> "CREATED" DESC,<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> "TODO_CD" DESC<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> )<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE
STATISTICS STORAGE<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> (<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> INITIAL 65536 NEXT 1048576 MINEXTENTS 1
MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> )<o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: #6aa84f;"> TABLESPACE "SIEBDATA" ;</span><o:p></o:p></span></i></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt;">Modify the above SQL to use the newly created INDEX as
a hint(in Blue Font)<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: red;">select</span><span style="color: orange;"> </span><span style="color: #3d85c6;">/*+ index(S_EVT_ACT
S_EVT_ACT_F85_X) */</span> <span style="color: red;">* from s_evt_act where QUOTE_ID is not null <o:p></o:p></span></span></i></div>
<div class="MsoNormal">
<i><span lang="EN-US" style="font-size: 10.0pt;"><span style="color: red;">and TODO_CD in ('Email -
Inbound','Email - Outbound','Communication','BCP Request','PCN
Request','PriceResponse')</span><o:p></o:p></span></i></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt;">Check the Explain Plan by clicking F10<o:p></o:p></span><br />
<span lang="EN-US" style="font-size: 10.0pt;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-FSPgzYRMjWY/VIg1p3MawQI/AAAAAAAAAGM/XMn7LS3NyF4/s1600/Explain%2Bplan%2B2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-FSPgzYRMjWY/VIg1p3MawQI/AAAAAAAAAGM/XMn7LS3NyF4/s1600/Explain%2Bplan%2B2.png" height="196" width="640" /></a></div>
<span lang="EN-US" style="font-size: 10.0pt;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 10.0pt; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; mso-no-proof: yes;"><!--[if gte vml 1]><v:shape
id="Picture_x0020_2" o:spid="_x0000_i1025" type="#_x0000_t75" style='width:489.75pt;
height:151.5pt;visibility:visible;mso-wrap-style:square'>
<v:imagedata src="file:///C:\Users\PVIDYA~1\AppData\Local\Temp\msohtmlclip1\01\clip_image003.png"
o:title=""/>
</v:shape><![endif]--><!--[if !vml]--><!--[endif]--></span><span lang="EN-US" style="font-size: 10.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;">You
can see that the Cost is reduced by leaps and bounds 552<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;">Performance
is improved.But you can further tune...think think think:)<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><i><b><u><span style="color: #444444;">Use
the following SQL as per need to compute statistics occasionaly</span></u></b><span style="color: red;"><o:p></o:p></span></i></span></div>
<div class="MsoNormal">
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><i><span style="color: red;">alter
index "SIEBEL"."S_EVT_ACT_F85_X" compute statistics</span></i><o:p></o:p></span><br />
<span lang="EN-US" style="font-size: 10.0pt; line-height: 115%;"><i><span style="color: red;"><br /></span></i></span>
<span lang="EN-US" style="color: #444444; font-size: 10.0pt; line-height: 115%;">Have a great day</span></div>
</div>
Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-54855193919325629292013-09-25T13:57:00.001+05:302013-09-25T13:57:16.967+05:30Open UI Benchmarks on Various Browsers and Platforms<div dir="ltr" style="text-align: left;" trbidi="on">
Here is a Benchmark Test result shared by Oracle on September 24 2013<br />
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-table-layout-alt: fixed;">
<tbody>
<tr style="height: 5.5pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<b><span style="font-size: 11.0pt;">Browser </span></b><span style="font-size: 11.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<b><span style="font-size: 11.0pt;">Time </span></b><span style="font-size: 11.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<b><span style="font-size: 11.0pt;">Hardware </span></b><span style="font-size: 11.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.2pt; mso-yfti-irow: 1;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.2pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Internet Explorer 6 (Does <b>not
</b>meet functional or performance W3C Standards) <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.2pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<b><span style="font-size: 11.0pt;">86 seconds </span></b><span style="font-size: 11.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.2pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Intel I5 1.7GHz – Windows 7 <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 18.95pt; mso-yfti-irow: 2;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 18.95pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Internet Explorer 7 <o:p></o:p></span></div>
<div class="Default">
<span style="font-size: 11.0pt;">(Does <b>not </b>meet
functional or performance W3C Standards) <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 18.95pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<b><span style="font-size: 11.0pt;">18 seconds </span></b><span style="font-size: 11.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 18.95pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Intel I5 1.7GHz – Windows 7 <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 12.2pt; mso-yfti-irow: 3;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 12.2pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Internet Explorer 8 <o:p></o:p></span></div>
<div class="Default">
<span style="font-size: 11.0pt;">(May not meet performance
Standards) <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.2pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<b><span style="font-size: 11.0pt;">3.6 seconds </span></b><span style="font-size: 11.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 12.2pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Intel I5 1.7GHz – Windows 7 <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 5.5pt; mso-yfti-irow: 4;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Android Mobile <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">2.8 seconds <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Galaxy S2 ICS <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 5.5pt; mso-yfti-irow: 5;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Safari Mobile <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">2.2 seconds <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">iPad 2 IOS <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 5.5pt; mso-yfti-irow: 6;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Chrome for Android <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">1.2 seconds <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Galaxy S4 JB 4.1 <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 5.5pt; mso-yfti-irow: 7;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Internet Explorer 9 <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">0.6 seconds <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Intel I5 1.7GHz – Windows 7 <o:p></o:p></span></div>
</td>
</tr>
<tr style="height: 5.5pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes;">
<td style="border-top: none; border: solid windowtext 1.0pt; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Internet Explorer 10 <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">0.3 seconds <o:p></o:p></span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 5.5pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.6pt;" valign="top" width="199">
<div class="Default">
<span style="font-size: 11.0pt;">Intel I5 1.7GHz – Windows 7 <o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<br />
Choose wisely live happily:)</div>
Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-1152264159707785572013-09-23T15:35:00.004+05:302013-09-23T15:35:59.893+05:30Welcome Open UI<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-msCfi6uogMI/UkASc9jX2II/AAAAAAAAAEo/EY49w7Bw0cA/s1600/Open+UI.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" closure_lm_332939="null" height="255" src="http://2.bp.blogspot.com/-msCfi6uogMI/UkASc9jX2II/AAAAAAAAAEo/EY49w7Bw0cA/s320/Open+UI.jpg" width="320" ysa="true" /></a></div>
Finally Open UI showed up on my Desktop Monitor.Eager to look out for the new features and drawbacks. </div>
Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-76118050490934511762013-02-12T13:43:00.001+05:302013-02-12T13:43:54.236+05:30Full Compile Sequence in Siebel Tools<div dir="ltr" style="text-align: left;" trbidi="on">
Today I was waiting impatiently for the full compile to finish...<br />
<br />
So I just took a note of the sequence in which compile happens<br />
<br />
this is the observation;I just noted major milestone objects and left out others ;)<br />
<br />
Compile Sequence<br />
Tables --> Applet --> Link --> Business Component --> Screen ---> Setting Up Application --> Closing SRF</div>
Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-22512855620615966742012-08-28T09:01:00.001+05:302012-08-28T09:01:06.023+05:30Verifying Classpath in Siebel<div dir="ltr" style="text-align: left;" trbidi="on">
It has been observerd that lot of time is spent in issues related to troubleshooting classpath issues.<br />
<br />
After configuring the classpath values open the Business service Simulator and use the 'EAI JMS <br />
<br />
Transport'<br />
<br />
<br />
There are a couple of handy methods in this Business Service.<br />
<br />
eg: method : CheckClasspath<br />
<br />
<br />
On running this you get an ouput telling the result.<br />
<br />
<strong><span style="font-size: x-small;"><span style="color: blue;"><span class="m"><?</span><span class="pi">xml version="1.0" encoding="UTF-8" </span><span class="m">?></span></span> </span></strong><br />
<div class="e">
<strong><span style="font-size: x-small;"><span class="b"><span style="color: red; font-family: Courier New;"> </span></span> <span style="color: blue;"><span class="m"><?</span><span class="pi">Siebel-Property-Set EscapeNames="true"</span><span class="m">?></span></span> </span></strong></div>
<div class="e">
<div style="margin-left: 1em; text-indent: -2em;">
<strong><span style="font-size: x-small;"><span class="b"><span style="color: red; font-family: Courier New;"> </span></span> <span class="m"><span style="color: blue;"><</span></span><span class="t"><span style="color: #990000;">PropertySet</span></span><span class="m"><span style="color: blue;">></span></span><span class="tx">Input property set: > Value = > Type = > SendPassword = > ConnectionPassword = > CommitTransaction = true > ReceiveUsername = > TopicUsername = > PreserveString = true > ConnectionUsername = > ConnectionFactory = > ReceivePassword = > TopicPassword = > SendUsername = java.class.path = /u01/app/siebel/jms:/u01/app/siebel/jms/Siebel.jar:/u01/app/siebel/jms/SiebelJI_enu.jar:/u01/app/siebel/jms/jndi.jar:/u01/app/siebel/jms/adminclient.jar:/u01/app/siebel/jms/bcel.jar:/u01/app/siebel/jms/dms.jar:/u01/app/siebel/jms/ejb.jar:/u01/app/siebel/jms/jms.jar:/u01/app/siebel/jms/optic.jar:/u01/app/siebel/jms/pcl.jar:/u01/app/siebel/jms/oc4jclient.jar:/u01/app/siebel/jms/javax77.jar:/u01/app/siebel/jms/ojdbc14dms.jar:/u01/app/siebel/jms/mail.jar:/u01/app/siebel/jms/jta.jar:. Found directory /u01/app/siebel/jms NOTE: A jndi.properties file is present in /u01/app/siebel/jms Found jar file /u01/app/siebel/jms/Siebel.jar with 638 entries. Found jar file /u01/app/siebel/jms/SiebelJI_enu.jar with 25 entries. Found jar file /u01/app/siebel/jms/jndi.jar with 123 entries. Found jar file /u01/app/siebel/jms/adminclient.jar with 1307 entries. Found jar file /u01/app/siebel/jms/bcel.jar with 399 entries. Found jar file /u01/app/siebel/jms/dms.jar with 192 entries. Found jar file /u01/app/siebel/jms/ejb.jar with 37 entries. Found jar file /u01/app/siebel/jms/jms.jar with 61 entries. Found jar file /u01/app/siebel/jms/optic.jar with 32 entries. Found jar file /u01/app/siebel/jms/pcl.jar with 270 entries. Found jar file /u01/app/siebel/jms/oc4jclient.jar with 850 entries. Found jar file /u01/app/siebel/jms/javax77.jar with 39 entries. Found jar file /u01/app/siebel/jms/ojdbc14dms.jar with 638 entries. Found jar file /u01/app/siebel/jms/mail.jar with 259 entries. Found jar file /u01/app/siebel/jms/jta.jar with 20 entries. Found directory /u01/app/siebel/siebsrvr/bin/. SUCCESSFUL TEST</span><span class="m"><span style="color: blue;"></</span></span><span class="t"><span style="color: #990000;">PropertySet</span></span><span class="m"><span style="color: blue;">></span></span> </span></strong></div>
</div>
</div>
Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-58373946175557292752012-07-25T12:18:00.001+05:302012-07-25T12:18:39.216+05:30Cleaning the File System in Siebel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="pb1Bullet1">
During normal operation of Siebel Business Applications software, it is
likely that orphaned files will be stored in the Siebel File System and that
orphaned records will exist in the Siebel Database. </div>
<div class="pb1Bullet1">
<br /></div>
<div class="pb1Bullet1">
Here comes in the handy SFS cleanup utility.....</div>
<div class="pb1Bullet1">
<br /></div>
<div class="pb1Bullet1">
Periodically run the SFSCLEANUP utility to remove orphaned files from the
Siebel File System. This utility is located in the bin subdirectory within the
Siebel Server root directory. </div>
<div class="pb1Bullet1">
<br /></div>
<div class="pb1Bullet1">
Run this and be a best practice compliant and responsible siebel consultant
:)</div>
<div class="pb1Bullet1">
<br /></div>
<div class="pb1Bullet1">
Cheers</div>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-9591750349713194642012-07-04T16:11:00.003+05:302012-07-04T16:11:44.479+05:30Fix C028: “Unable to Connect to the Siebel Gateway Name Server”<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
</div>
<div class="entry-content" style="text-align: left;">
<a href="" name="SYMPTOM"></a>Symptoms</div>
<div class="entry-content" style="text-align: left;">
<br /></div>
<div class="entry-content" style="text-align: left;">
The Server Configuration wizard has logged the following error message:</div>
<div class="entry-content" style="text-align: left;">
C028: Unable to Connect to the Siebel Gateway Name Server</div>
<div class="entry-content" style="text-align: left;">
<br /></div>
<div class="entry-content" style="text-align: left;">
Cause</div>
<div class="entry-content" style="text-align: left;">
Database Authentication failed.</div>
<div class="entry-content" style="text-align: left;">
Gateway authentication is a new feature in Siebel 8.1.1. If the Configuration Wizard fails due to authentication it will log the error messages, above.</div>
<div class="entry-content" style="text-align: left;">
<br /></div>
<div class="entry-content" style="text-align: left;">
Solution</div>
<div class="entry-content" style="text-align: left;">
<br /></div>
<div class="entry-content" style="text-align: left;">
Follow these steps to resolve the issue:</div>
<div class="entry-content" style="text-align: left;">
<br /></div>
<div class="entry-content" style="text-align: left;">
1. In the ‘$SIEBEL_ROOT/gtwysrvr/siebenv.sh’ environment sourcing script, check the following environment variables and set them appropriately before starting the Gateway server.</div>
<blockquote class="entry-content" style="text-align: left;">
1a. For all servers: ORACLE_HOME must be declared before any library paths are declared.<br />
Example:<br />
<blockquote>
<code>ORACLE_HOME=/export/home/ora10g/10203 ; export ORACLE_HOME</code></blockquote>
</blockquote>
<blockquote class="entry-content" style="text-align: left;">
1b. NOTE: For the following library paths, Oracle 32-bit libraries must be referenced before 64-bit libraries. An example is provided for each library path per Unix system, as follows:</blockquote>
<blockquote class="entry-content" style="text-align: left;">
For AIX: LIBPATH<br />
<blockquote>
<code>LIBPATH=${SIEBEL_ROOT}/lib:${MWHOME}/lib:${SQLANY}/lib:/usr/lib:${LIBPATH}:${ORACLE_HOME}/lib32:${ORACLE_HOME}/lib</code></blockquote>
</blockquote>
<blockquote class="entry-content" style="text-align: left;">
For HP-UX: SHLIB_PATH<br />
<blockquote>
<code>SHLIB_PATH=/usr/lib/hpux32:${SIEBEL_ROOT}/lib:${MWHOME}/lib:${SQLANY}/lib:${ORACLE_HOME}/lib32:${ORACLE_HOME}/lib</code></blockquote>
</blockquote>
<blockquote class="entry-content" style="text-align: left;">
For Linux and Solaris: LD_LIBRARY_PATH<br />
<blockquote>
<code>LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib32:<br />${ORACLE_HOME}/lib</code></blockquote>
</blockquote>
<div class="entry-content" style="text-align: left;">
2. Open the ‘gateway.cfg’ file, which is located in the ‘$SIEBEL_ROOT/gtwysrvr/bin’ directory.<br />Check the ‘ServerDataSrc’ section and confirm the parameters are correct, particularly:</div>
<blockquote class="entry-content" style="text-align: left;">
ConnectString<br />TableOwner<br />GatewayAddress<br />EntepriseServer</blockquote>
<div class="entry-content" style="text-align: left;">
3. Test Siebel database connectivity using the Oracle<span style="text-decoration: underline;"> odbcsql</span> utility for the ‘sadmin’ user. This is typically located in the ‘$IEBEL_ROOT/siebsrvr/bin’ directory.</div>
<blockquote class="entry-content" style="text-align: left;">
For example:</blockquote>
<blockquote class="entry-content" style="text-align: left;">
<blockquote>
<code>odbcsql /s sia811_DSN /u sadmin /p sadmin</code></blockquote>
</blockquote>
<blockquote class="entry-content" style="text-align: left;">
where:<br />
<blockquote>
/s = the source ODBC DSN (the Siebel ConnectString parameter) for the database connection.<br />/u = the user ID.<br />/p = the password.</blockquote>
</blockquote>
<blockquote class="entry-content" style="text-align: left;">
If connection is possible, continue with step 4.</blockquote>
<div class="entry-content" style="text-align: left;">
4. Restart the Gateway server, and then try configuring the Siebel Server.</div>
<div class="entry-content" style="text-align: left;">
<br /></div>
<div class="entry-content" style="text-align: left;">
Hope that helps !!!! have a nice day</div>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com2tag:blogger.com,1999:blog-7089741420327098600.post-38812248797915266212012-06-04T11:40:00.003+05:302012-06-04T11:40:25.635+05:30Measuring the performance of Workflows in Siebel<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="ph3Heading3" style="text-align: left;">
<a href="" name="wp141438"></a><a href="" name="wp153911"></a>You can get performance tracing of workflows by setting the event WfPerf for the component in which your workflow is running. </div>
<div class="ph3Heading3" style="text-align: left;">
<br /></div>
<div class="ph3Heading3" style="text-align: left;">
Setting the event to level 4 gives timing for the execution of the overall process. </div>
<div class="ph3Heading3" style="text-align: left;">
<br /></div>
<div class="ph3Heading3" style="text-align: left;">
Setting the event to level 5 provides timing for each step as well.</div>
<div class="pt1Text1" style="text-align: left;">
<br /></div>
<div class="pt1Text1" style="text-align: left;">
You can set this event level for any Siebel Server component that invokes a workflow process as part of Siebel eAI functionality. For example, to set this event level for the MQ Receiver using srvmgr, enter the following:</div>
<div class="pcf2CompFont2" style="text-align: left;">
<br /></div>
<div class="pcf2CompFont2" style="text-align: left;">
<em>change evtloglvl WfPerf=5 for comp MqSeriesSrvRcvr</em></div>
<div class="pt1Text1" style="text-align: left;">
<br /></div>
<div class="pt1Text1" style="text-align: left;">
These events can be useful not just for measuring workflow performance but also for measuring the performance of business services executed within these workflows.</div>
<div class="pt1Text1" style="text-align: left;">
<br /></div>
<div class="pt1Text1" style="text-align: left;">
Hope this helps!!!!!</div>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-44977562627010665192012-05-15T10:15:00.004+05:302012-05-15T10:15:30.216+05:30How to stop a Workflow Process Instance via eScript<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="pt1Text1">
<span style="font-family: Arial, Helvetica, sans-serif;">This can be achieved using the _StopInstance method of Worflow Process Manager BS</span></div>
<div class="pt1Text1">
<br /></div>
<div class="pt1Text1">
<span style="font-family: Arial, Helvetica, sans-serif;">An example usage of this technique occurs when you have an interactive workflow which needs to be cancelled but which is suspended in a Wait step. In this scenario, the Process Instance Id is already known. </span></div>
<div class="phtdHeadingToDo">
<br /></div>
<div class="phtdHeadingToDo">
<span style="font-family: Arial, Helvetica, sans-serif;">To stop a workflow process instance from script</span></div>
<div class="pt1Text1">
<br /></div>
<div class="pt1Text1">
<span style="font-family: Arial, Helvetica, sans-serif;">Invoke the _StopInstance method on the Workflow Process Manager business service, as in the following example, which uses a hard-coded Process Instance Id:</span></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<br /></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<br /></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<span style="font-family: Arial, Helvetica, sans-serif;">var bs = TheApplication().GetService("Workflow Process Manager");</span></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<a href="" name="wp1058994"></a><span style="font-family: Arial, Helvetica, sans-serif;">var ps_inputs = TheApplication().NewPropertySet();</span></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<a href="" name="wp1058995"></a><span style="font-family: Arial, Helvetica, sans-serif;">var ps_outputs = TheApplication().NewPropertySet();</span></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<a href="" name="wp1058996"></a><span style="font-family: Arial, Helvetica, sans-serif;">ps_inputs.SetProperty("ProcessInstanceId", "1-IIT");</span></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<a href="" name="wp1058997"></a><span style="font-family: Arial, Helvetica, sans-serif;">bs.InvokeMethod("_StopInstance" , ps_inputs, ps_outputs);</span></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<br /></div>
<div class="pcf2CompFont2" style="font-family: Lucida Console;">
<span style="font-family: Arial, Helvetica, sans-serif;">Comes in handy while you want to dliberately stop that annoying instance:)</span></div>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-83827646068917727212012-03-14T12:43:00.002+05:302012-03-14T13:49:57.515+05:30Playing with the SOUNDEX function<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<br /></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
Hi All</div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<br /></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
Have you ever tried the SOUNDEX function for finding phonetically similar words such as querying First Name you vaguely remeber.I read about this in Alex's <a href="http://siebel-essentials.blogspot.com/2010/02/low-cost-fuzzy-query-in-siebel-crm.html" target="_blank">Siebel Essentials</a> and after a bit of trial/POC I am writing this post.</div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
<br /></div>
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">
So I typed in this query and ....</div>
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;">
<br /></div>
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-9aDyzQPFvac/T2BB0g1An7I/AAAAAAAAACw/nX3GAqYpD-g/s1600/query.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; height: 93px; margin-bottom: 1em; margin-right: 1em; width: 509px;"><img aea="true" border="0" src="http://4.bp.blogspot.com/-9aDyzQPFvac/T2BB0g1An7I/AAAAAAAAACw/nX3GAqYpD-g/s1600/query.jpg" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
got the following results<br />
<br />
<br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-F9IB3Suly94/T2BB-0BY38I/AAAAAAAAAC4/S7JwE0TM5mk/s1600/results.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img aea="true" border="0" height="141" src="http://3.bp.blogspot.com/-F9IB3Suly94/T2BB-0BY38I/AAAAAAAAAC4/S7JwE0TM5mk/s400/results.png" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
so here we can see that the soundex value for all the results are same.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<u>The Soundex algorithm is as follows:</u><br />
<br />
<div>
</div>
<div>
</div>
<div>
1.The soundex return value will always begin with the first letter of string.'P' in our case.<br />
</div>
<div>
</div>
<div>
2.The soundex function uses only the first 5 consonants to determine the NUMERIC portion of the return value, except if the first letter of string is a vowel.<br />
</div>
<div>
</div>
<div>
3.The soundex function is not case-sensitive. What this means is that both uppercase and lowercase characters will generate the same soundex return value.</div>
<div>
</div>
<div>
</div>
<div>
<br />
<strong><u>Applies to</u></strong> :Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g</div>
<br />
Have a nice day ahead.....<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<span lang="EN"></span></div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-10281331418582327042012-02-29T16:13:00.003+05:302012-02-29T16:46:22.249+05:30Reading Input and Output of Vanilla Business Service and logging them.<div dir="ltr" style="text-align: left;" trbidi="on">
<em>Hello Everyone</em><br />
<br />
<em>Have you ever guessed what are the input and output property sets and methods called while a vanilla business is executing....</em><br />
<em><br /></em><br />
<em>well here is the step to log them in a readable and logical way...</em><br />
<em><br /></em><br />
<em>for eg lets take the BS: Search External Service</em><br />
<br />
<strong>Enter the following lines of code in the declaration section.....</strong><br />
<br />
<span style="color: #38761d;">/*----------------------------This is the Declaration Section --------------------------------------------------*/</span><br />
<span style="color: #45818e;">var</span> OutPutFileName = 'C:\\SearchExternal_Dump.txt'; <span style="color: #38761d;">//Your fav Location and name:)</span><br />
<span style="color: #0b5394;">var</span> IndentAmount = 2; <span style="color: #38761d;">// Indent child prop sets listing this many spaces // to the right for each level down for readability</span><br />
<br />
<br />
<strong>Now comes our 2 handy function</strong><br />
<br />
<em>1.LogMe ( writes down every input provided to a text file path declared in declaration)</em><br />
<em><br /></em><br />
<em>2.DumpPropSets(Dumps the property sets)</em><br />
<em><br /></em><br />
<em>Code of both these functions follows</em><br />
<br />
1.LogMe Function<br />
<br />
<span style="color: #38761d;">// Writes what is feeded.</span><br />
<br />
<span style="color: black;"><span style="color: #3d85c6;"> function</span> LogMe<span style="color: red;">(</span>LogThis</span><span style="color: red;">)</span><br />
<span style="color: red;">{</span><br />
<span style="color: black;"> <span style="color: blue;"> var</span> MyFile = Clib.fopen<span style="color: red;">(</span>OutPutFileName, 'at'<span style="color: red;">)</span>;</span><br />
<span style="color: black;"> <span style="color: blue;"> var</span> sTime = Clib.ctime<span style="color: red;">(</span><span style="color: red;">Clib</span>.time<span style="color: red;">()</span><span style="color: red;">)</span>;</span><br />
<span style="color: black;"> sTime = sTime.replace<span style="color: red;">(</span>'\n',' '<span style="color: red;">)</span>; // Remove trailing Newline.</span><br />
<span style="color: black;"> <span style="color: red;">Clib</span>.fputs<span style="color: red;">(</span>sTime <span style="color: #45818e;">+</span> ': ' + LogThis + '\n', MyFile<span style="color: red;">)</span>;</span><br />
<span style="color: black;"> <span style="color: red;">Clib</span>.fclose<span style="color: red;">(</span>MyFile<span style="color: red;">)</span>;</span><br />
<span style="color: red;">}</span><br />
<br />
<br />
2.DumpPropSet Function<br />
<br />
<span style="color: #38761d;">/*------Premjit Vidyadharan:Function to collect property sets and feed to LogMe for printing-*/</span><br />
<span style="color: #38761d;">/*--------------------Print out the contents of a property set--------------------------------*/</span><br />
<span style="color: #0b5394;">function DumpPropSet(Inputs)</span><br />
<span style="color: #0b5394;">{ </span><br />
<span style="color: #0b5394;"> PSDepth++;</span><br />
<span style="color: #0b5394;"> var InpValue;</span><br />
<span style="color: #0b5394;"> var InpType;</span><br />
<span style="color: #0b5394;"> var InpChildCount;</span><br />
<span style="color: #0b5394;"> var inprop;</span><br />
<span style="color: #0b5394;"> var inpropval;</span><br />
<span style="color: #0b5394;"> var inpropcnt;</span><br />
<span style="color: #0b5394;"> var BlankLine = ' '; </span><br />
<span style="color: #38761d;"> /*--------------------------Build a string to indent the Listing------------------*/ </span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"> var IndentSpaces = ''; </span><span style="color: #38761d;">// [Number of spaces to indent to]</span><br />
<span style="color: #0b5394;"> for (var SpaceCount = 0; SpaceCount < IndentAmount * PSDepth; SpaceCount++)</span><br />
<span style="color: #0b5394;"> {</span><br />
<span style="color: #0b5394;"> IndentSpaces = IndentSpaces + ' ';</span><br />
<span style="color: #0b5394;"> }</span><br />
<span style="color: #0b5394;"> var IndentLevel = ToString(PSDepth);</span><br />
<span style="color: #0b5394;"> if (PSDepth < 10)</span><br />
<span style="color: #0b5394;"> {</span><br />
<span style="color: #0b5394;"> IndentLevel = '0' + IndentLevel;</span><br />
<span style="color: #0b5394;"> }</span><br />
<span style="color: #0b5394;"> </span><span style="color: #38761d;">// Indent by a number of indents, then level number as nn, then two spaces</span><br />
<span style="color: #0b5394;"> var Indent = IndentSpaces + IndentLevel + ' ';</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"> LogMe(BlankLine);</span><br />
<span style="color: #0b5394;"> LogMe(BlankLine);</span><br />
<span style="color: #0b5394;"> LogMe(Indent + '---- Starting a new property set ----');</span><br />
<span style="color: #0b5394;"> LogMe(BlankLine);</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #38761d;"> // Now do main value and type</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"> InpValue = Inputs.GetValue();</span><br />
<span style="color: #0b5394;"> InpType = Inputs.GetType();</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"> InpChildCount = Inputs.GetChildCount();</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'Value is ........ : "' + InpValue + '"');</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'Type is ........ : "' + InpType + '"');</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'Child count ..... : ' + ToString(InpChildCount));</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #38761d;"> // Dump the properties of this property set</span><br />
<span style="color: #38761d;"><br /></span><br />
<span style="color: #0b5394;"> var PropCounter = 0;</span><br />
<span style="color: #0b5394;"> inprop = Inputs.GetFirstProperty();</span><br />
<span style="color: #0b5394;"> while (inprop != "")</span><br />
<span style="color: #0b5394;"> {</span><br />
<span style="color: #0b5394;"> PropCounter++;</span><br />
<span style="color: #0b5394;"> inpropval = Inputs.GetProperty(inprop);</span><br />
<br />
<span style="color: #0b5394;"> LogMe(BlankLine);</span><br />
<span style="color: #0b5394;"> var PropCountStr = ToString(PropCounter);</span><br />
<span style="color: #0b5394;"> if (PropCounter < 10)</span><br />
<span style="color: #0b5394;"> { </span><br />
<span style="color: #0b5394;"> PropCountStr = '0' + PropCountStr; </span><br />
<span style="color: #0b5394;"> }</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'Property ' + PropCountStr + ' name : "' + inprop + '"');</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'Property ' + PropCountStr + ' value : "' + inpropval + '"');</span><br />
<span style="color: #0b5394;"> inprop = Inputs.GetNextProperty();</span><br />
<span style="color: #0b5394;"> }//while (inprop != "") ends</span><br />
<span style="color: #38761d;"> /*-----------------------------------Dump the children of this PropertySet-----------------------------*/</span><br />
<span style="color: #0b5394;"> if (InpChildCount == 0)</span><br />
<span style="color: #0b5394;"> {</span><br />
<span style="color: #0b5394;"> LogMe(BlankLine);</span><br />
<span style="color: #0b5394;"> LogMe(Indent + '(No children exist below this property set.)');</span><br />
<span style="color: #0b5394;"> }</span><br />
<span style="color: #0b5394;"> else </span><br />
<span style="color: #0b5394;"> {</span><br />
<span style="color: #0b5394;"> for (var ChildNumber = 0; ChildNumber < InpChildCount; ChildNumber++)</span><br />
<span style="color: #0b5394;"> {</span><br />
<span style="color: #0b5394;"> LogMe(BlankLine);</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'Child Property Set ' + ToNumber(ChildNumber + 1) + ' of ' + ToNumber(InpChildCount) + ' follows below.');</span><br />
<span style="color: #0b5394;"> LogMe(Indent + 'This child is on level ' + ToNumber(PSDepth));</span><br />
<span style="color: #0b5394;"> </span><br />
<span style="color: #0b5394;"> // Recursive call for children, grandchildren, etc.</span><br />
<span style="color: #0b5394;"> DumpPropSet(Inputs.GetChild(ChildNumber));</span><br />
<span style="color: #0b5394;"> }</span><br />
<span style="color: #0b5394;"> }</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"> PSDepth--; </span><span style="color: #38761d;">// We are about to pop up a level</span><br />
<span style="color: #0b5394;">}</span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: black;"><strong>Now Call this functon at the evnt of your choice</strong></span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: black;"><em>eg given below</em></span><br />
<span style="color: #0b5394;"><br /></span><br />
<span style="color: #0b5394;">function Service_PreInvokeMethod (MethodName, Inputs, Outputs)</span><br />
<span style="color: #0b5394;">{</span><br />
<span style="color: #0b5394;"> LogMe('---- Method Called PreInvoke ----'+ MethodName);</span><br />
<span style="color: #0b5394;"> LogMe('---- Method Called PreInvoke-----INPUTS ----'+ MethodName);</span><br />
<span style="color: #0b5394;"> LogMe(Inputs);</span><br />
<span style="color: #0b5394;"> LogMe('---- Method Called PreInvoke----- OUTPUTS ---'+ MethodName); </span><br />
<span style="color: #0b5394;"> LogMe(Outputs);</span><br />
<span style="color: #0b5394;"> LogMe('---- PreInvoke Ends Here---------------------'+ MethodName); </span><br />
<span style="color: #0b5394;"> return (ContinueOperation);</span><br />
<span style="color: #0b5394;">}</span><br />
<br />
Below is the result which we get....A long story to read for the debuggers ot there<br />
<br />
<span style="font-family: Arial, Helvetica, sans-serif; font-size: x-small;">Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke ----GetParams<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke-----INPUTS ----GetParams<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke----- OUTPUTS ---GetParams<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- PreInvoke Ends Here---------------------GetParams<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke ----GetParams<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke INPUTS ----------------------GetParams<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke OUTPUTS ---------------------GetParams<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Invoke Ends Here----------------------------------GetParams<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke ----SetSamePage<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke-----INPUTS ----SetSamePage<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke----- OUTPUTS ---SetSamePage<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- PreInvoke Ends Here---------------------SetSamePage<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke ----SetSamePage<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke INPUTS ----------------------SetSamePage<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke OUTPUTS ---------------------SetSamePage<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Invoke Ends Here----------------------------------SetSamePage<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke ----FindOnly<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke-----INPUTS ----FindOnly<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Method Called PreInvoke----- OUTPUTS ---FindOnly<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- PreInvoke Ends Here---------------------FindOnly<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke ----FindOnly<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke INPUTS ----------------------FindOnly<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Method Called Invoke OUTPUTS ---------------------FindOnly<br />Wed Feb 22 05:12:57 2012 : PropertySet [ ]<br />Wed Feb 22 05:12:57 2012 : ---- Invoke Ends Here----------------------------------FindOnly</span><br />
<br />
<em><span style="font-family: inherit;">Be sure to remove the code when u are done with the debugging.........</span></em><br />
<em><br /><span style="font-family: inherit;"></span></em><br />
<em><span style="font-family: inherit;">Enjoy!!!!!!!!!!!!!!!!</span></em></div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-23159880413941258512012-02-22T08:52:00.001+05:302012-02-22T08:52:11.009+05:30A faster way to Open Support Web :)<div dir="ltr" style="text-align: left;" trbidi="on">
Friends<br />
<br />
This might be known to many but still I would recommend to use<br />
<br />
<a href="https://supporthtml.oracle.com/">https://supporthtml.oracle.com/</a><br />
<br />
This has got a cool loading time w.r.t the flash based one <a href="https://support.oracle.com/CSP/ui/flash.html">https://support.oracle.com/CSP/ui/flash.html</a><br />
<br />
specially if you are on Android Cupcake v 1.5....errr sorry did i mention a very outdated OS...whel i am a victim.<br />
<br />
Happy debugging!!!!!<br />
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-12147714642915752082012-02-17T11:14:00.000+05:302012-02-17T11:14:33.490+05:30Allow Object Locking for Projects in Siebel.<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
For each project you can specify whether or not developers are allowed to check out and check in individual objects within the project. To allow developers to check out and check in objects, you set the project's Allow Object Locking property to TRUE. To modify the Allow Object Locking property, you must use the SADMIN user ID to log in, and you must be logged into a server data source. You cannot set the Allow Object Locking property in your local repository. <br />
<br />
To set the Allow Object Locking property<br />
In the Object Explorer, choose Project. <br />
<br />
In the Projects window, choose the desired Project object, then right-click and choose Toggle Allow Object Locking. <br />
<br />
NOTE: You can only change the Allow Object Locking flag on the Server database using the SADMIN login ID.<br />
<br />
<em><span style="color: blue;">Important:If a project has the Allow Object Locking configuration file parameter set to TRUE, and the user is logged in to the server using the SADMIN user ID, the Toggle Allow Object Locking menu option is enabled. When the SADMIN user chooses this option for a project that is already set to allow object locking, a check is performed to determine whether any objects are locked on the server within the project. If there are objects locked within the project, the system administrator receives an error message. If the project is locked on the server by someone else, the menu option for Toggle Allow Object Locking does not appear</span></em>.<br />
<br />
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-5611601593802350382012-02-14T15:27:00.001+05:302012-02-14T15:27:06.364+05:30Setting The JVM Classpath and JVM DLL Name in Siebel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<table align="left" border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin: auto 6.75pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-table-anchor-horizontal: margin; mso-table-anchor-vertical: page; mso-table-left: left; mso-table-lspace: 9.0pt; mso-table-rspace: 9.0pt; mso-table-top: 45.05pt; mso-yfti-tbllook: 1184; width: 567px;"><tbody>
<tr style="height: 21.85pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;"><td style="background: #bfbfbf; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: windowtext 1pt solid; height: 21.85pt; mso-border-alt: solid windowtext .5pt; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 36.7pt;" width="49"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">Parameter</span></b></div>
</td><td style="background: #bfbfbf; border-bottom: windowtext 1pt solid; border-left: #d4d0c8; border-right: windowtext 1pt solid; border-top: windowtext 1pt solid; height: 21.85pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 388.7pt;" width="518"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">Value</span></b></div>
</td></tr>
<tr style="height: 134.55pt; mso-yfti-irow: 1;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #d4d0c8; height: 134.55pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 36.7pt;" width="49"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">JVM Classpath</span></div>
</td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #d4d0c8; border-right: windowtext 1pt solid; border-top: #d4d0c8; height: 134.55pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 388.7pt;" width="518"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Lucida Console"; font-size: 9pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"><SIEBSRVR_ROOT>/classes/Siebel.jar;<SIEBSRVR_ROOT>/classes/SiebelXMLP.jar;<SIEBSRVR_ROOT>/classes/wlfullclient.jar</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">where:</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<i><span style="color: black; font-family: "Courier New"; font-size: 9pt; mso-fareast-font-family: "Times New Roman";">SIEBSRVR_ROOT</span></i><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: "Courier New"; mso-fareast-font-family: "Times New Roman";"> is the actual path where the Siebel Server is installed.</span><i><span style="color: black; font-family: "Courier New"; font-size: 9pt; mso-fareast-font-family: "Times New Roman";"></span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: maroon; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">NOTE: </span></b><span style="color: maroon; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"> For UNIX, replace <SIEBSRVR_ROOT> with ${SIEBEL_HOME}.<b></b></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<i style="mso-bidi-font-style: normal;"><span style="color: #558ed5; font-family: "Cambria", "serif"; mso-ascii-theme-font: major-latin; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-theme-font: major-latin; mso-style-textfill-fill-alpha: 100.0%; mso-style-textfill-fill-color: #558ED5; mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"; mso-style-textfill-fill-themecolor: text2; mso-themecolor: text2; mso-themetint: 153;">Alternatively, you can set the CLASSPATH using the Siebel Server Manager (srvrmgr program). For information about using the srvrmgr program to set the CLASSPATH, see Troubleshooting the CLASSPATH Settings Using Siebel Server Manager. </span></i></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<br /></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: red; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">CAUTION: </span></b><span style="color: red; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"> An error might occur if the value of the CLASSPATH parameter is too long (must be less than 1024 characters). To avoid this, copy the CLASSPATH folder to the root directory, and then point CLASSPATH to this path. </span><span style="color: black; font-family: "Lucida Console"; font-size: 9pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"></span></div>
</td></tr>
<tr style="height: 134.1pt; mso-yfti-irow: 2; mso-yfti-lastrow: yes;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #d4d0c8; height: 134.1pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 36.7pt;" width="49"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">JVM DLL Name</span></div>
</td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #d4d0c8; border-right: windowtext 1pt solid; border-top: #d4d0c8; height: 134.1pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0in; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; width: 388.7pt;" width="518"><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">For AIX, Linux, and Oracle Solaris:</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"><path to libjvm.so_file></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">For HP-UX:</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"><path to libjvm.sl_file></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">For Windows:</span></b></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"><path to jvm.dll ></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">For example, </span><span style="color: black; font-family: "Courier New"; font-size: 9pt; mso-fareast-font-family: "Times New Roman";">c:\Program Files\Java\jdk1.6.0_xx\jre\client\bin\jvm.dll</span><span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<b><span style="color: maroon; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">NOTE: </span></b><span style="color: maroon; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";"> For Windows, the path to the JVM DLL file is automatically read from the Windows registry setting of the JRE installed on the Siebel Server.<b></b></span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-element-anchor-horizontal: margin; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-top: 45.05pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly;">
<span style="color: black; font-family: "Verdana", "sans-serif"; font-size: 8.5pt; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman";">For more information on setting the values of the JVM DLL Name and JVM Options parameters, see <i>Transports and Interfaces: Siebel Enterprise Application Integration</i>.<b></b></span></div>
</td></tr>
</tbody></table>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com4tag:blogger.com,1999:blog-7089741420327098600.post-77662782261550954572012-02-07T10:21:00.001+05:302012-02-07T10:21:35.994+05:30Siebel CRM version 8.2.2<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="km">
<a href="" name="REF_TEXT"></a>Siebel CRM version 8.2.2 Industry Target Guidance</h2>
<strong>Siebel CRM version 8.2.2 (SIA 8.2.2) delivers enhanced functionality in the areas of Public Sector; Loyalty for Travel, Transportation, Retail and Coalitions; and Financial Services for integration to Oracle FLEXCUBE Universal Banking.</strong><br /><br />SIA 8.2.2 is intended specifically for Public Sector; Loyalty for Travel, Transportation, Retail and Coalitions; and Financial Services for FLEXCUBE Universal Banking customers who want to integrate with Siebel. <br />Siebel CRM version 8.1.x (currently SIA 8.1.1.6) remains the primary code line for all other Siebel products. Innovations, enhancements and patches will be delivered on a priority basis to the base code line for the affected products. Customers should work with their account team to review any questions on appropriate code lines for their implementation.<br /><br /><strong>The software packages released with Siebel CRM version 8.2.2 are the following:</strong><br /><br />
<ul>
<li>Siebel Business Applications for Public Sector Media Pack for Microsoft Windows x64 (64-bit) - <a href="https://edelivery.oracle.com/" target="_blank" title="Oracle Software Delivery cloud">Oracle Software Delivery cloud</a> part number B65190-01, software translations available as B65244-01.</li>
</ul>
<ul>
<li>Siebel Business Applications for Travel, Transportation, Retail and Coalitions Media Pack for Microsoft Windows x64 (64-bit) - <a href="https://edelivery.oracle.com/" target="_blank" title="Oracle Software Delivery cloud">Oracle Software Delivery cloud</a> part number B65192-01, software translations available as B65247-01.</li>
</ul>
<ul>
<li>Siebel Business Applications for Financial Services Integration with FLEXCUBE Media Pack for Microsoft Windows x64 (64-bit) - <a href="https://edelivery.oracle.com/" target="_blank" title="Oracle Software Delivery cloud">Oracle Software Delivery cloud</a> part number B65194-01, software translations available as B65241-01.</li>
</ul>
<br />These software packages are only applicable to the specified industry groups. All other Siebel products will continue primary development on the SIA 8.1.x code line. <br /><br />The Siebel code line was split to deliver significant enhancements to specific industries without disrupting other product areas. In the near future, the Siebel code lines will be merged allowing both 8.1.x and 8.2.x customers to continue with their implementations without significant migration costs.<br /><br /><strong>Example Scenarios:</strong><br /><br />I am a Loyalty customer from Telco or Financial Services looking for the 'latest' Siebel Loyalty release, what should I do?<br /><em>You should target Siebel Loyalty version SIA 8.1.x. </em><br /><br />I am a Siebel Financial Services customer not implementing the Oracle FLEXCUBE Universal Banking integration, wanting to migrate to the latest Siebel CRM products, what should I do?<br /><em>You should target Siebel Financial Services version SIA 8.1.x. </em><br /><br />I am a Siebel 7.8x / 8.0x Public Sector customer looking for the 'latest' Siebel Public Sector release, what should I do?<br /><em>You should target Siebel Public Sector version SIA 8.2.2.</em><br /><br />All industries not specifically listed above can continue on the SIA 8.1.x code line with no need for upgrade to obtain innovations. More information is available in the 'Readme' files in the above listed SIA 8.2.2 media packages on the <a href="https://edelivery.oracle.com/" target="_blank" title="Oracle Software Delivery cloud">Oracle Software Delivery cloud</a> and from your account representative.<br /></div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com8tag:blogger.com,1999:blog-7089741420327098600.post-21591688214232242862012-01-31T10:07:00.001+05:302012-01-31T10:07:25.183+05:30SRBroker and SRProc in a gist<div dir="ltr" style="text-align: left;" trbidi="on">
<strong>Server Request Broker (SRBroker)</strong><br />
<br />
1.Used to start synchronous Siebel Server tasks<br />2.Server Request Broker & Server Manager are the only components which directly start tasks.<br />3.Introduced in in Siebel 7<br />4.Background component<br />5.Multi-threaded component<br />6.Need to set MaxTasks as per the needs.<br />
<br />
<strong>Server Request Processor (SRProc)</strong><br />
<br />
1.Used to start asynchronous Siebel Server tasks<br />2.Manages queued requests<br />3.Calls SRBroker to manage task execution<br />4.Background component<br />
<br />
This is a high level explanation which would be very helpful when you sit next time to debug logs;cheers</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-85857302887533565212012-01-11T11:14:00.000+05:302012-01-11T11:14:18.971+05:30How to enable Customize Button<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="ph1Heading1">
<a href="" name="wp1016921"></a>Enabling the Customize Button</h2>
<hr />
<div class="pt1Text1">
<a href="" name="wp1016923"></a>The user can select a configurable product and click the Customize button to customize the product. However, the Customize button is only enabled when the user's responsibilities include one of the appropriate views that allows users to customize products. The following views of the Quotes screen are examples of views that enable the customize button: </div>
<ul class="pb1Bullet1" type="square">
<li class="pb1Bullet1"><a href="" name="wp1016924"></a>Complex Product Runtime Instance View </li>
<li class="pb1Bullet1"><a href="" name="wp1016925"></a>Complex Product Runtime Instance View - Order </li>
<li class="pb1Bullet1"><a href="" name="wp1016926"></a>Complex Product Runtime Instance View - Shopping Cart </li>
</ul>
<div class="pt1Text1">
<a href="" name="wp1028903"></a>Within these views, the Customize button is enabled only when the type of the product is Customizable. </div>
<div class="phtdHeadingToDo">
<a href="" name="wp1016927"></a>To find a complete list of the views that enable the Customize button</div>
<ol class="ps1StepNum">
<li class="ps1StepNum" value="1"><a href="" name="wp1016928"></a>Open Oracle's Siebel Tools. </li>
<li class="ps1StepNum" value="2"><a href="" name="wp1016929"></a>In the Views tab, search for views that match the following: <div class="pt2Text2">
<a href="" name="wp1016930"></a>Complex Product Runtime Instance View*</div>
</li>
</ol>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-59585853096059308322012-01-09T12:20:00.000+05:302012-01-09T12:52:24.683+05:30Did you Know these personalities in Siebel:)<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="left">
<table border="1" cellpadding="5"><caption><a href="http://www.blogger.com/" name="wp1026164"></a>Demo Users for Siebel Call Center</caption><tbody>
<tr align="left" bgcolor="#f0f0f0" valign="top"><th><div class="ptbh1TableHead1">
<a href="http://www.blogger.com/" name="wp1026174"></a>Username / Password</div>
</th><th><div class="ptbh1TableHead1">
<a href="http://www.blogger.com/" name="wp1026176"></a>Name / Title</div>
</th><th><div class="ptbh1TableHead1">
<a href="http://www.blogger.com/" name="wp1026178"></a>Application</div>
</th><th><div class="ptbh1TableHead1">
<a href="http://www.blogger.com/" name="wp1026180"></a>Primary Responsibility</div>
</th><th><div class="ptbh1TableHead1">
<a href="http://www.blogger.com/" name="wp1026182"></a>Role</div>
</th></tr>
<tr align="left" valign="top"><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1026184"></a>CCHENG</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1026186"></a>Casey Cheng / Universal Agent</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1026188"></a>Siebel Call Center</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1026190"></a>Universal Agent</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1026192"></a>Cheng handles service requests of all types: emails, inbound calls, and Web collaboration session requests. In addition, he executes outbound call campaigns.</div>
</td></tr>
<tr align="left" valign="top"><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027215"></a>TARNOLD</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027217"></a>Ted Arnold / Telesales Representative</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027219"></a>Siebel Call Center</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027221"></a>Telesales Representative</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027223"></a>Arnold primarily executes inbound and outbound telemarketing and telesales calls.</div>
</td></tr>
<tr align="left" valign="top"><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027205"></a>VTAYLOR</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027207"></a>Vic Taylor / VP Call Center</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027209"></a>Siebel Call Center</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027211"></a>Call Center Manager</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027213"></a>Taylor's responsibilities for the day-to-day operations of a Call Center make him a regular user of Siebel Call Center Administration functions. He uses the Siebel Analytics function to evaluate performance and ROI and to make strategic decisions based on the analyses.</div>
</td></tr>
<tr align="left" valign="top"><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027094"></a>EMODI</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027096"></a>Emily Modi /Engagement Manager</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1038536"></a>Siebel Call Center</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027101"></a>Consulting Manager</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027103"></a>Modi is responsible for managing a consulting practice business, including opportunity management, client relationships, contracts and agreements, and financial reporting and management.</div>
</td></tr>
<tr align="left" valign="top"><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027115"></a>GABBO</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027117"></a>Glen Abboline / Information Technologist</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027119"></a>Siebel Professional Services </div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027121"></a>Consultant</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027123"></a>Abboline is responsible for day-to-day project management, including staffing requests.</div>
</td></tr>
<tr align="left" valign="top"><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027105"></a>GCLARK</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027107"></a>Gary Clark / Consultant</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027109"></a>Siebel Professional Services </div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027111"></a>Consulting Manager</div>
</td><td><div class="pt1Text1">
<a href="http://www.blogger.com/" name="wp1027113"></a>Clark is responsible for managing a consulting practice business.</div>
</td></tr>
</tbody></table>
</div>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com1tag:blogger.com,1999:blog-7089741420327098600.post-20463446580994791622012-01-05T12:12:00.002+05:302012-01-05T12:17:56.511+05:30How Siebel Workflow Interacts with Siebel Server Components..<div dir="ltr" style="text-align: left;" trbidi="on">
<h4>
<a href="http://www.blogger.com/" name="wp1068797"></a><span style="font-family: Verdana, sans-serif;">Siebel Server Components</span></h4>
<a href="http://www.blogger.com/" name="wp1068798"></a><span style="font-family: Verdana, sans-serif;">The Workflow Engine interacts with other server components through the Server Request Broker. Working as a business service, the Workflow Engine calls server components. To call a server component that is exposed as a specialized service, the Workflow Engine calls the signature for the service. For example, to send an email, the Workflow Engine calls the Communications Server as the Outbound Communications Manager business service. To assign an object to a user, it calls the Assignment Manager component as the Synchronous Assignment Manager Requests business service. </span><br />
<a href="http://www.blogger.com/" name="wp1076118"></a><span style="font-family: Verdana, sans-serif;">To call a server component that is not exposed as a specialized service, the Workflow Engine uses the predefined Server Requests Business Service. This business service sends a generic request to the Server Request Broker.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">Server Request Broker</span><br />
<a href="http://www.blogger.com/" name="wp1068806"></a><span style="font-family: Verdana, sans-serif;">The Workflow Engine sends a request to the Server Request Broker, synchronously or asynchronously, and the Server Request Broker brokers the request to the appropriate component. The following work is performed:</span><br />
<br />
<dir><dir><a href="http://www.blogger.com/" name="wp1068807"></a><span style="font-family: Verdana, sans-serif;">1.Sending asynchronous messages from an interactive server component to the Workflow Engine </span><br /><br /><span style="font-family: Verdana, sans-serif;">2.Communicating, synchronously and asynchronously, between the Workflow Engine and batch components </span><br /><br /><span style="font-family: Verdana, sans-serif;">3.Scheduling repeated server tasks that are executed periodically in the Workflow Engine </span></dir></dir><a href="http://www.blogger.com/" name="wp1073701"></a><span style="font-family: Verdana, sans-serif;">The Server Request Broker also performs load balancing. If the Server Request Broker receives a request, then it routes the request to the server component in the current server. For a workflow process, if the component is not available in the current server, then the Server Request Broker sends it to other servers on a round robin basis where the Workflow Process Manager component is activated.</span> <br />
<a href="http://www.blogger.com/" name="wp1068811"></a><span style="font-family: Verdana, sans-serif;">A workflow process also uses Server Request Broker to resume a waiting workflow process. The Server Request Broker queries a database table on a regular basis in order to identify server tasks that must be resumed.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><strong>Personalization Engine</strong></span><br />
<br />
<a href="http://www.blogger.com/" name="wp1073227"></a><span style="font-family: Verdana, sans-serif;">The Personalization engine handles run-time events, such as application events, applet events, and business component events. A workflow process handles run-time events through integration with the Personalization engine. A workflow started or resumed by a run-time event registers itself with the Personalization engine when the process is activated. If a run-time event occurs in a user session, then the Personalization engine calls Siebel Workflow in the local object manager.</span><br />
<h4>
<a href="http://www.blogger.com/" name="wp1073470"></a> </h4>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-49209261079052266762011-12-28T14:54:00.000+05:302011-12-28T14:54:17.388+05:30Components for Email Response in Siebel<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="ph1Heading1">
<a href="" name="wp1008852"></a>Siebel Email Response Server Components</h2>
<div class="pt1Text1">
<a href="" name="wp1008853"></a>Siebel Email Response uses Communications Server components to enable contact center agents to read and respond to inbound email messages. </div>
<h4 class="pd1Division1">
<a href="" name="wp1008854"></a>Key Server Components</h4>
<div class="pt1Text1">
<a href="" name="wp1008855"></a>Siebel Email Response is supported in the Siebel Server environment primarily by the following server components: </div>
<ul class="pb1Bullet1" type="square">
<li class="pb1Bullet1"><a href="" name="wp1008856"></a><b class="cBold">Communications Inbound Receiver (CommInboundRcvr).</b> This server component receives inbound work items and queues them for processing by Communications Inbound Processor. Work items may include email messages (for Siebel Email Response). <ul class="pb2Bullet2" type="square">
<li class="pb2Bullet2"><a href="" name="wp1008857"></a>For nonreal-time work items, such as email messages for most deployments of Siebel Email Response, Communications Inbound Receiver queues work items it has received for further processing by Communications Inbound Processor. </li>
<li class="pb2Bullet2"><a href="" name="wp1008858"></a>For real-time work items, such as email messages for some deployments of Siebel Email Response, Communications Inbound Receiver processes work items it has received. Communications Inbound Processor is not used. </li>
</ul>
</li>
<li class="pb1Bullet1"><a href="" name="wp1008859"></a><b class="cBold">Communications Inbound Processor (CommInboundProcessor).</b> This server component processes inbound work items that were queued by Communications Inbound Receiver. </li>
<li class="pb1Bullet1"><a href="" name="wp1008860"></a><b class="cBold">Communications Outbound Manager (CommOutboundMgr).</b> This server component sends outbound email. </li>
<li class="pb1Bullet1"><a href="" name="wp1008861"></a><b class="cBold">Siebel File System Manager.</b> This server component writes to and reads from the Siebel File System. It stores inbound messages prior to processing and stores attachments to inbound and outbound email messages. </li>
</ul>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-11913884501391573012011-12-28T14:37:00.000+05:302011-12-28T14:37:42.864+05:30An Overview about Server Clustering<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="ph1Heading1">
<a href="" name="wp1008475"></a>About Server Clustering</h2>
<div class="pt1Text1">
<a href="" name="wp1008476"></a>A server cluster is a group of two or more servers that are configured so that if one server fails, another server can take over application processing. The servers in a cluster are called nodes. Typically, these servers store data on a common disk or disk array.</div>
<div class="pt1Text1">
<a href="" name="wp1008477"></a>Clustering software monitors the active nodes in a server cluster. When a node fails, the clustering software manages the transition of the failed server's workload to the secondary node. </div>
<div class="pt1Text1">
<a href="" name="wp1008478"></a>When a clustered Siebel Server fails, all the applications and services on the server stop. Application users must reconnect and log in to the server that takes over. For example, if the Siebel Server that failed was hosting Siebel Communications Server, the communications toolbar is disabled, and users must reconnect and log in to the new server.</div>
<div class="pt1Text1">
<a href="" name="wp1018608"></a>Cluster vendors can validate their third-party server cluster products to provide server clustering for deployments of Siebel Business Applications. For validation assistance, contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle's Application Expert Services. For recommendations and help on the use of cluster products with Siebel Business Applications, customers should contact the cluster vendor of their choice.</div>
<h4 class="pd1Division1">
<a href="" name="wp1008479"></a>Active-Passive Configuration</h4>
<div class="pt1Text1">
<a href="" name="wp1008480"></a>An active-passive server cluster contains a minimum of two servers. One server actively runs applications and services. The other is idle. If the active server fails, its workload is switched to the idle server, which then takes over application processing. </div>
<div class="pt1Text1">
<a href="" name="wp1008481"></a>Because the standby server is idle, active-passive server clusters require additional hardware without providing additional active capacity. The benefit of active-passive clusters is that, after a failover, the same level of hardware resources is available for each application, thereby eliminating any performance impact on users. This benefit is particularly important for performance-critical areas such as the database. The most common use of active-passive clusters is for database servers.</div>
<h4 class="pd1Division1">
<a href="" name="wp1008482"></a>Active-Active Configuration</h4>
<div class="pt1Text1">
<a href="" name="wp1008483"></a>An active-active server cluster contains a minimum of two servers. Both actively run applications and services. Each may host different applications or may host instances of the same application. If one server fails, its processing load is transferred to the other. </div>
<div class="pt1Text1">
<a href="" name="wp1010063"></a>Active-active configuration is the most common server clustering strategy for servers other than the database server. </div>
<div class="pn1Note1">
<a href="" name="wp1010064"></a><b class="cBold">NOTE: </b> Configuring the Siebel Database (database server) and a Siebel Server to failover to each other is supported, but not recommended.</div>
<h5 class="pd2Division2">
<a href="" name="wp1008486"></a>Potential Port Conflicts</h5>
<div class="pt1Text1">
<a href="" name="wp1008487"></a>Some Siebel Server components, such as Siebel Connection Broker (SCBroker), Siebel Gateway Name Server, Synchronization Manager (Siebel Remote), and Siebel Handheld synchronization listen on a configurable static port. When these components run in an active-active cluster, you must plan your port usage so there is no port conflict after failover. </div>
<div class="pt1Text1">
<a href="" name="wp1008488"></a>For example, an active-active server cluster contains two platforms, each running a Siebel Server. If one platform fails, the other will host two Siebel Servers. Siebel Servers include several services, such as Siebel Connection Broker, that use a dedicated port. If this port number was the same on both platforms, there will be a port conflict after failover. </div>
<h5 class="pd2Division2">
<a href="" name="wp1008489"></a>Capacity Planning</h5>
<div class="pt1Text1">
<a href="" name="wp1008465"></a>Active-active clusters use all the server platforms continuously. Consequently, they take better advantage of computing resources than active-passive clusters. When doing capacity planning, make sure that clustered servers have sufficient capacity to handle a failover. Because failovers are usually infrequent and normally last only a short time, some performance degradation is often acceptable.</div>
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-64074137295856380122011-12-15T10:44:00.002+05:302011-12-15T10:44:40.073+05:30How to enable a Component Group on Siebel Server<div dir="ltr" style="text-align: left;" trbidi="on">
<br />To enable a component group on a Siebel Server<br />
Navigate to Administration-Server Configuration screen, Enterprises, and then the Component Groups view. <br />
In the Component Groups list, select the Siebel Server component group of interest. <br />
In the Component Groups Assignment list, select the Siebel Server of interest. <br />Click the Enable button. <br />
The Enabled on Server? field of the Siebel Server record becomes checked.<br />
For the change to take effect, stop and restart the Siebel Server System Service.</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-18318465943772218792011-12-13T16:11:00.001+05:302011-12-13T16:11:44.858+05:30Implementing ACRs In Siebel<div dir="ltr" style="text-align: left;" trbidi="on">
ACRs are enhanced functionalities provided as a part of patch installation.<br />
A list of various ACRs will be available in the Siebel Maintainance Release Guide which are updated and various revisions are available in support web.<br />
ACRs are usually found as a Zip file in the local installation of Tools in a folder called REPPATCH.eg:<br />
C:/Siebel/Tools/REPPATCH.<br />
These zip files usually contain archive files of seed objects like Applet,Views,Table,Webtemplate files etc.<br />
ef ACR 374 to configure IMAP protocol<br />
</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-79109822125248733032011-11-09T08:45:00.003+05:302011-11-09T08:46:30.202+05:30For a change lets know what are RSS feeds:)<div dir="ltr" style="text-align: left;" trbidi="on">What is RSS?<br />
RSS stands for "Really Simple Syndication"(Origin - RDF Site Summary). It is a way to easily distribute a list of headlines, update notices, and sometimes content to a wide number of people. It is used by computer programs that organize those headlines and notices for easy reading. <br />
Why do we need RSS?<br />
Most people are interested in many websites whose content changes on an unpredictable schedule. Examples of such websites are news sites, community and religious organization information pages, product information pages, medical websites, and weblogs. Repeatedly checking each website to see if there is any new content can be very tedious. <br />
Email notification of changes was an early solution to this problem. Unfortunately, when you receive email notifications from multiple websites they are usually disorganized and can get overwhelming, and are often mistaken for spam. <br />
RSS is a better way to be notified of new and changed content. Notifications of changes to multiple websites are handled easily, and the results are presented to you well organized and distinct from email. <br />
The Working Principle?<br />
RSS works by having the website author maintain a list of notifications on their website in a standard way. This list of notifications is called an "RSS Feed". People who are interested in finding out the latest headlines or changes can check this list. Special computer programs called "RSS aggregators" have been developed that automatically access the RSS feeds of websites you care about on your behalf and organize the results for you. (RSS feeds and aggregators are also sometimes called "RSS Channels" and "RSS Readers".) <br />
Producing an RSS feed is very simple and hundreds of thousands of websites now provide this feature, including major news organizations like the New York Times, the BBC, and Reuters, as well as many weblogs. <br />
What information does RSS provide?<br />
RSS provides very basic information to do its notification. It is made up of a list of items presented in order from newest to oldest. Each item usually consists of a simple title describing the item along with a more complete description and a link to a web page with the actual information being described. Sometimes this description is the full information you want to read (such as the content of a weblog post) and sometimes it is just a summary. <br />
<br />
Eg:Of RSS XML<br />
<br />
<?xml version="1.0" encoding="UTF-8" ?><br />
<rss version="2.0"><br />
<channel><br />
<title>RSS Title</title><br />
<description>This is an example of an RSS feed</description><br />
<link>http://www.someexamplerssdomain.com/main.html</link><br />
<lastBuildDate>Mon, 06 Sep 2010 00:01:00 +0000 </lastBuildDate><br />
<pubDate>Mon, 06 Sep 2009 16:45:00 +0000 </pubDate><br />
<ttl>1800</ttl><br />
<br />
<item><br />
<title>Example entry</title><br />
<description>Here is some text containing an interesting description.</description><br />
<link>http://www.wikipedia.org/</link><br />
<guid>unique string per item</guid><br />
<pubDate>Mon, 06 Sep 2009 16:45:00 +0000 </pubDate><br />
</item><br />
<br />
</channel><br />
</rss><br />
Atom(Feeds) is the next generation web feed mechnism or an aternative to RSS.</div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0tag:blogger.com,1999:blog-7089741420327098600.post-81915998086104358632011-11-01T16:11:00.000+05:302011-11-01T16:11:44.766+05:30Playing with ToolTip in eCalendar Applets<div dir="ltr" style="text-align: left;" trbidi="on"><h4 class="pd1Division1"><a href="" name="wp1044850"></a>Displaying Field ToolTip Text</h4><div class="pt1Text1"><a href="" name="wp1050898"></a>When you move the mouse over a display field in a calendar record.The ToolTip content is configurable through the applet user property Display Field Name.Tooltip Fields, where Display Field Name is the name of the display field. </div><div class="pt1Text1"><a href="" name="wp1051347"></a>The user property value is a list of comma delimited business component fields. The values of these business component fields display as the ToolTip in the display field. By default, the name of the business component field is used as the label in the ToolTip text. </div><div class="pt1Text1"><a href="" name="wp1052104"></a>Make the label for a ToolTip field translatable by creating a control in the applet with the name Tooltip Field Label:Field Name. The caption of the control is used as the label for the ToolTip field. For example, for the business component Quote, field Name, the ToolTip label for the field is defined as a control of name ToolTip Field Label:Quote.Name, and the caption of the control will be the label for this field.</div></div>Premjit M Vidyadharanhttp://www.blogger.com/profile/12409737925816115698noreply@blogger.com0