tag:blogger.com,1999:blog-202706532024-03-13T16:06:53.365+05:30Geek Talkin SiebelSiebel CRM, OBIEE, BI/XML Publisher, OEM & Technology!Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.comBlogger72125tag:blogger.com,1999:blog-20270653.post-58599703424350311242011-02-24T15:57:00.000+05:302011-02-24T15:57:35.689+05:30Load: Class VncViewer.class not foundHi Friends,<br />
<br />
The other day I started to play around Oracle's new Virtualization product Oracle VM 2.2. Its pretty neat product with quick installation & no much hiccups.<br />
<br />
The interesting part starts once you have Oracle VM Manager, the web-based tool to manage & deploy Guest VMs on the Oracle VM Server.<br />
<br />
Since the entire offering is based out of Xen's Hypervisor & linux based, the remote console facility is leveraged using VNC.<br />
<br />
If you already have deployed a new Guest VM using Oracle VM Manager and try to view its console, you will get an error as in the Java Applet Execution window. <br />
<br />
<span style="font-family: helvetica;"><strong><i>Load: Class VncViewer.class not found</i></strong></span><br />
<br />
The simple reason being is the VncViewer.jar is missing due to which it fails to invoke VNC Viewer within the browser.<span style="font-family: helvetica;"><strong><i> </i></strong></span><br />
<br />
To install follow below quick steps:<br />
<br />
1) Get TightVNC RPM:<br />
<i>bash$ wget http://oss.oracle.com/oraclevm/manager/RPMS/tightvnc-java-1.3.9-3.noarch.rpm</i><br />
2) Install the new downloaded RPM<br />
<i>bash$ rpm -ivh tightvnc-java-1.3.9-3.noarch.rpm</i><br />
<br />
Once done verify if the VncViewer.jar file is created successfully under<br />
<i>/opt/oc4j/j2ee/home/applications/OVS/webapp1/Class</i><br />
<br />
Thats it!<br />
Restart your browser and login into Oracle VM Manager again to browse to the console successfully :-)<br />
<br />
Keywords:<br />
Oracle VM Server, Oracle VM Manager, Xen, Virtualization, Vmware, etc.<br />
<span style="font-family: helvetica;"><strong><i> </i> </strong></span>Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-25199035591813206442011-01-13T16:02:00.000+05:302011-01-13T16:02:51.399+05:30How to edit /etc/sudoers?Hi Friends,<br />
<br />
Well you must have come across various situations when you need to quickly edit the /etc/sudoers file for making changes.<br />
<br />
Though it is not straight forward to open in an vi editor & edit it, below are time saving commands for Linux & Unix to quickly edit the same:<br />
<br />
<b>Linux:</b><br />
<i>bash-3.00$ sudo visudo</i><br />
<br />
<b>Unix:</b><br />
<i>bash-3.00$ /usr/local/bin/sudo /usr/local/sbin/visudo</i><br />
<br />
VISUDO opens the /etc/sudoers file in a temporary editable mode, which can be changed and saved to reflect changes immediately.<br />
<br />
Hope this tip helps :-)<br />
<br />
Keywords:<br />
Linux, Unix, Red Hat, Solaris, /etc/sudoers, vi, visduo, sudo, edit, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-80092869160363417452010-12-23T12:20:00.000+05:302011-02-16T14:07:35.045+05:30Dynamic Pricing - Siebel 8.1.1.x and aboveHi Friends,<br />
<br />
Well, up to Siebel 8.0.0.x versions, we had to manually configure dozens of things to ensure that we successfully enable Dynamic Pricing (<a href="http://geektalkin.blogspot.com/2008/06/enabling-dynamic-pricing-advanced.html" linkindex="31">Complete Manual Instructions</a>), but now that is no longer the case from Siebel 8.1.1.x and above versions :-)<br />
<br />
Dynamic Pricing can now be enabled at a click of a button from:<br />
<b>Sitemap -> Administration - Pricing -> Pricelists -> Menu -> Enable Dynamic Pricing</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/_xIG1J-w3dWc/TRLwcdMUbEI/AAAAAAAADVw/LTzOGmBHMYc/s1600/dynamic_pricing.png" imageanchor="1" linkindex="32" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://1.bp.blogspot.com/_xIG1J-w3dWc/TRLwcdMUbEI/AAAAAAAADVw/LTzOGmBHMYc/s320/dynamic_pricing.png" width="214" /></a></div><br />
<br />
<br />
<br />
Hope this tip helps!<br />
Enjoy!<br />
<br />
Keywords:<br />
comparison pricing,competitive pricing,dynamic price,dynamic pricing,market pricing,price waterfall,pricer,pricing management,pricing strategy,product pricing,siebel crm,value pricingShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-19639330790103261232010-11-23T16:42:00.000+05:302011-02-16T14:07:35.047+05:30IE8 - SBL-UIF-00296: You already have a web browser accessing the current web session.Hi Friends,<br />
<br />
With Siebel CRM recently releasing IE8 compatibility, one common issue faced on day one is<br />
<i>"SBL-UIF-00296: You already have a web browser accessing the current web session. Multiple browsers are not allowed to share the same web session"</i><br />
<br />
No matter what you do, you are not able to open multiple Siebel instances in IE8!<br />
Well, those who are new to IE8, there seems to be a session replication builtin which causes to replicate the session in the multiple instances you open causing Siebel to give the error.<br />
<br />
The correct way to resolve this is to start a new IE8 Siebel Session using<br />
a) File -> New Session or [From IE8 UI]<br />
b) iexplore.exe -nomerge [Command line -nomerge option]<br />
<br />
This way we explicitly instruct IE8 not to replicate session allowing us to open multiple Siebel instances.<br />
<i>Please remember that never open multiple Siebel instances in different IE Tabs! It is not supported and can cause a big issue with your data. </i><br />
<i><br />
</i><br />
Hope this tip helps :-)<br />
<br />
Keywords:<br />
IE8, 8.0.0.8, 8.1.1.3, Siebel CRM, siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel support web,siebel systems, Internet Explorer, Session Replication, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com6tag:blogger.com,1999:blog-20270653.post-1428333519835895102010-11-02T10:00:00.002+05:302010-11-08T15:41:23.574+05:30Joomla LDAP SetupHi Friends,<br />
<br />
Few days back i was playing with an internal setup of WAMP Server having Apache 2.2.11, PHP 5.3.0 & MySQL 5.1.36 deployed with Joomla 1.5.21 CMS. <br />
<br />
Joomla provides a native LDAP Authentication plugin which can be enabled to connect to your LDAP directory for authentication. It can be found under your Joomla Admin Panel -> Extensions -> Plugin Manager -> Authentication - LDAP <br />
<br />
In our environment we have Red Hat Directory Server providing us the directory services. <br />
It supports bind & search kind of authentication over LDAP, so below are the settings needed to be done on the joomla authentication plugin <br />
<br />
<b>Host</b>: ldaphost.domain.com <br />
<b>Port</b>: 389 <i>[Default, change it if you run on other port number]</i> <br />
<b>Authorisation Method</b>: Bind & Search <br />
<b>Base DN</b>: dc=value,dc=value <i>[e.g. dc=domainname,dc=com]</i> <br />
<span class="editlinktip"><b>Search String</b>: uid=[search] <i>[Note, here <b>uid</b> is the attribute which stores user id. So in your environment you have userid as the attribute, then the correct value is <b>userid=[search]</b> ]</i></span> <br />
<b>User's DN</b>: <i>[This should be blank & only used if you are using Authorisation Method as bind directly as a user. ]</i> <br />
<b>Connect Username</b>: uid=directoryadminusername,ou=directoryadminusergroup,dc=value,dc=value <br />
<i>[Notes:</i> <br />
<i><b>uid</b> - Is the attribute which stores user id. If you have userid as the attribute, the it should be userid=</i> <br />
<i>directoryadminusername - This should be your LDAP Directories Admin user's id</i> <br />
<i>directoryadminusergroup - This should be your LDAP Directory Admin user's group name</i> <br />
<i>dc=value,dc=value - This should be similar to your Base DN ]</i> <br />
<b>Connect Passwod</b>: Specify the directory admin user password here <br />
<b>Map Full name</b>: fullnameattribute <i>[Specify the attribute within LDAP Directory which stores the full name]</i> <br />
<b>Map Email</b>: emailattribute <i>[Specify the attribute within LDAP Directory which stores the email address]</i> <br />
<b>Map Userid</b>: useridattribute <i>[Specify the attribute within LDAP Directory which stores the userid]</i> <br />
<i></i> <br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/_xIG1J-w3dWc/TMgt8rdwaAI/AAAAAAAADVQ/TvAFT0zGpL4/s1600/ldap.png" imageanchor="1" linkindex="17" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="120" nx="true" src="http://1.bp.blogspot.com/_xIG1J-w3dWc/TMgt8rdwaAI/AAAAAAAADVQ/TvAFT0zGpL4/s320/ldap.png" width="320" /></a></div><br />
<br />
Note, once you enable the LDAP Authentication, any new user logging in will have an automatic user record creation within Joomla. So in essence, you should take off the "Register" link on the login form!<br />
<br />
If you face issues while setting this up, then please ask in the comments section :-)<br />
Enjoy!<br />
<br />
Keywords:<br />
Joomla 1.5.21, PHP, MySQL, WAMP, Apache, CMS, LDAP, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com1tag:blogger.com,1999:blog-20270653.post-32743927990471086662010-10-29T10:05:00.004+05:302010-11-08T15:41:41.512+05:30Joomla PHP/MySQL Performance TuningHi Friends,<br />
<br />
Few days back i was playing with an internal setup of WAMP Server having Apache 2.2.11, PHP 5.3.0 & MySQL 5.1.36 deployed with Joomla 1.5.21 CMS. <br />
<br />
For a 500 user base below are Apache & MySQL Parameters for optimal Joomla Performance on a Windows Deployment: <br />
<br />
<b>Apache</b> <b>mpm_winnt_module</b> <br />
<i># WinNT MPM</i> <br />
<i># ThreadsPerChild: constant number of worker threads in the server process</i><br />
<i># MaxRequestsPerChild: maximum number of requests a server process serves</i><br />
<i><ifmodule mpm_winnt_module=""></ifmodule></i><br />
<i>ThreadLimit 1000</i><br />
<i>ThreadsPerChild 500</i><br />
<i>MaxRequestsPerChild 0</i><br />
<i>KeepAlive On</i><br />
<i>KeepAliveTimeout 60</i><br />
<i>MaxKeepAliveRequests 100</i><br />
<i>MaxMemFree 100</i><br />
<i></i><br />
<br />
<b>MySQL my.ini</b><br />
<i>key_buffer = 150M</i><br />
<i>max_allowed_packet = 1M</i><br />
<i>table_cache = 1000</i><br />
<i>sort_buffer_size = 1M</i><br />
<i>net_buffer_length = 8K</i><br />
<i>read_buffer_size = 1M</i><br />
<i>read_rnd_buffer_size = 768K</i><br />
<i>myisam_sort_buffer_size = 64M</i><br />
<i>basedir=D:/wamp/bin/mysql/mysql5.1.36</i><br />
<i>log-error=D:/wamp/logs/mysql.log</i><br />
<i>datadir=D:/wamp/bin/mysql/mysql5.1.36/data</i><br />
<i>query_cache_limit=1M</i><br />
<i>query_cache_size=32M</i><br />
<i>query_cache_type=1</i><br />
<i>tmp_table_size=32M</i><br />
<i>key_buffer_size=64M</i><br />
<br />
These changes are tested & found be working at acceptable levels in my environment. Please consider your deployment sizing & other aspects before adopting above settings.<br />
<br />
Keywords:<br />
Apache, WAMP, PHP, MySQL, Performance, Tuning, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-267231491116758642010-10-28T10:00:00.004+05:302010-11-08T15:42:01.983+05:30Joomla PHP Fatal error: Out of memoryHi Friends,<br />
<br />
Few days back i was playing with an internal setup of WAMP Server having Apache 2.2.11, PHP 5.3.0 & MySQL 5.1.36 deployed with Joomla 1.5.21 CMS.<br />
<br />
The first & foremost problem i faced on daily basis was a Apache Crash due to PHP Fatal error: Out of Memory!<br />
<br />
Googling around pointed me to increase the memory allocated to PHP in php.ini by changing the parameter <br />
<i>; Maximum amount of memory a script may consume (128MB)</i><br />
<i>; </i><a href="http://php.net/memory-limit" linkindex="18"><i>http://php.net/memory-limit</i></a><br />
<i>memory_limit 128M</i> <br />
<br />
By default, PHP 5.3.0 has 128MB memory allocated. The error logs though pointed to a out of memory crash, it actually didnt have a memory availability issue.<br />
<br />
I changed this to 256MB, 512MB & even 1024MB but all the time it crashed :-(<br />
The official parameter description suggested that, if you set this up to -1, there wont be an upper limit capped for PHP.<br />
<br />
My next setup test was to change it to -1<br />
<i>; Maximum amount of memory a script may consume (128MB)</i><br />
<i></i><br />
<i>; <a href="http://php.net/memory-limit" linkindex="19">http://php.net/memory-limit</a></i><br />
<i>memory_limit -1</i><br />
<br />
Well, i wasnt surprised as it still crashed!! <br />
After much digging, i felt that Apache itself wasnt able to handle its memory well on Windows. Many articles i came across also suggested the same.<br />
<br />
So in the quest of stablizing Apache on Windows, i started investigating this issue purely from Apache point of view.<br />
An quick overview of <b>mpm_winnt_module</b> parameters on Apache.org suggested that i needed to have a couple of must needed configurations :-)<br />
<ol><li><b>ThreadLimit</b> which has a default value of 2500 if not specified, was brought down to 1000</li>
<li><b>ThreadsPerChild</b> which has a default value of 64 needs to be increased as i had atleast a 500 concurrent user base, so this was changed to 500. Remember, ThreadLimit & ThreadsPerChild go in tandem. You cannot lower ThreadLimit value when compared to ThreadsPerChild.</li>
<li><b>MaxRequestsPerChild</b> which has a default value of 0, need not be changed as in Windows, we have one parent process managing the other child process which caters to multiple threads. No separate child process forking as possible on Linux/Unix deployments.</li>
<li><b>KeepAlive</b> should be turned ON. It is very necessary to avoid unnecessary new connections from the same client within a span of 1 minute. The timeout should be turned on with atleast 1 minute.</li>
<li><b>KeepAliveTimeout</b> which has a default value of 15secs needs to be changed to 60secs i.e. 1minute</li>
<li><b>MaxMemFree</b> is a directive available in Apache 2.2.x which allows us to specify upto how much free memory will be held by the Apache process without calling the free() function. When not specified this is considered as unlimited, which is generally not good for Apache deployed on Windows Platform as memory leaks are evident. I changed this parameter to 100 in order to force Apache release free memory frequently & avoid leaks. Remember this settings has direct impact to your webserver performance, but if you are seeing too many frequent crashes, this will definitely stabilize the system.</li>
</ol>Thats it!<br />
Putting above settings in place along with php memory limit to -1, i was successful in stabilizing the PHP Fatal error + Apache crashes.<br />
<br />
Please note that extensive testing was done to arrive at this settings, hence be sure of your implementation requirements & sizing before adopting ;-)<br />
<br />
Keywords,<br />
Apache, WAMP, PHP, MySQL, mpm_winnt_module, Joomla, performance tuning, etc.Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-56280766052063143932010-10-27T16:43:00.002+05:302010-11-08T15:42:17.892+05:30WAMP child process exited with status 3221225477Hi Friends,<br />
<br />
Few days back i was playing with an internal setup of WAMP Server having Apache 2.2.11, PHP 5.3.0 & MySQL 5.1.36 deployed with Joomla 1.5.21 CMS.<br />
<br />
The setup was on a Windows 64-bit AMD x86 environment, but i frequently had my Apache go down due to following error: <b>"Parent: child process exited with status 3221225477"</b><br />
<br />
A quick google & it pointed me that it should be related the associated MySQL dll. After going through various articles & bug reports, it made sense to try out one solution!<br />
<br />
The solution was to copy <b>libmySQL.dll</b> available under <i>mysql5.1.36\bin</i> to my <i>WINDOWS\system32</i> folder and then do a complete machine restart.<br />
<br />
I did this & believe me there has been no single Apache shutdown reported due to this error :-)<br />
Hope this helps all WAMP or XMPP deployers.<br />
<br />
Keywords:<br />
Apache, WAMP, XMPP, PHP, MySQL, Crash, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com1tag:blogger.com,1999:blog-20270653.post-62816064016594350602010-09-30T19:18:00.004+05:302010-10-02T00:12:49.130+05:30Configure DSL-2640T with Tata Broadband [Wired ADSL]Hi Friends,<br />
<br />
Its been a while since i have posted a new article!<br />
Last week my friend got with him his old Dlink DSL-2640T ADSL 2+ Router from home town.<br />
<br />
Now, my current setup with Tata Broadband (Wired ADSL) was with Broadcom ADSL Router tied to a Linksys Wireless Router WRT54GH (a pretty basic & decent wireless router).<br />
<br />
We need WiFi badly as we house some 5 laptops (personal [Acer Aspire 3002 NLC, Toshibha A105-S4014] + office [All Dell M65 Precision]), plus latest smartphones like HTC HD, iPhone 3G & Nokia E63 all hungry to be connected over WiFi with social networking ;-)<br />
<br />
DSL-2640T seems to be that one device which would have helped me eliminate my Broadcom + Linksys setup including some power conservation ;-)<br />
<br />
But hold on!<br />
Though it seemed to be a pretty straight forward setup...i.e. Remove my ADSL Line from Broadcom and plugin to DSL-2640T and switch it on, configure the PPPOE Settings...but it didn't turned out to be a dream run :-(<br />
<br />
Two days down the line, i was still trying to play and configure it. Fed up i even started a discussion in <a href="http://www.indiabroadband.net/tata-indicom-broadband/32146-tata-broadband-dsl-2640t-router-problem.html" linkindex="26">India Broadband Forum</a> to check out if these guys had any specific inputs!<br />
<br />
From what i got from them was an vital tip! Run the router in a Bridge Mode and create a PPPoE Dialer in Windows to see if you can connect! This step is essential as it certifies that all your router settings are intact and working fine.<br />
<br />
I tried this and soon it was clearer to me that somewhere my router settings were incorrect as i was not able to login from the Dialer created within windows in bridge mode :-(<br />
<br />
After much dilemma, the setting to be corrected was ADSL Modulation Type! By default it comes with ADSL 2+, but somehow that was not working for Tata.<br />
<br />
So lets sit down and configure this router!<br />
STEPS<br />
1) Remove the ADSL Phone Line input and plug it in to your DSL-2640T's ADSL Port<br />
2) Start the router and wait for 2mins to boot up.<br />
3) Use a Straight through or Cross over cable and plug its one end into 1st LAN Port of router and the other end to your machine.<br />
4) Open a browser and type in the browser: 192.168.1.1<br />
5) On the Username/Password prompt use: User-> admin Password-> admin<br />
6) Now lets configure the settings specific to Tata Broadband as below:<br />
<br />
For Tata Broadband (Wired ADSL), following are the final set of settings working for me:<br />
WAN ATM VC SETTINGS [Found Under Home->WAN] <br />
<b>VPI</b>=0 , <br />
<b>VCI</b>=32<br />
<b>WAN Settings</b>: PPPoE/PPPoA<br />
<b>Username</b>: Your Tata Broadband UserName e.g. dummy@vsnl.net<br />
<b>Password</b>: Your Tata Account Password<br />
<b>Authentication Type</b>: Auto<br />
<b>Connection Type</b>: PPPoE LLC<br />
<br />
Rest settings for WAN, leave it as default<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/_xIG1J-w3dWc/TKSPTwI3RiI/AAAAAAAADUo/qRvcS_csOEI/s1600/dsl-2640t-1.png" imageanchor="1" linkindex="27" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="241" src="http://1.bp.blogspot.com/_xIG1J-w3dWc/TKSPTwI3RiI/AAAAAAAADUo/qRvcS_csOEI/s320/dsl-2640t-1.png" width="320" /></a></div><br />
<br />
ADSL [Found Under Advanced->ADSL] <br />
<b>Modulation Type</b> = ADSL (ITU G.992.2) [Upload Speeds limited to 128kbps]<br />
<br />
<em>UPDATE 1st October 2010:</em><br />
<em>ADSL (ITU G.992.2) was not giving me the optimum upload speed as the Tata Supplied router easily gave me arould 300kbps of upload speed which is part of my Flash 384 Plan.</em><br />
<br />
<em>Played further around and found the below modulation to give the best optimum download and upload speed:</em><br />
<em><strong>Modulation Type</strong> = ADSL2 (Multimode) [Upload Speeds upto 300kbps and above]</em><br />
<em>When you set this modulation up, it gets connected over modulation: ADSL_G.dmt.bis</em><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/_xIG1J-w3dWc/TKSPi9Isr8I/AAAAAAAADUs/6u6T0_S5D5g/s1600/dsl-2640t-2.png" imageanchor="1" linkindex="28" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="222" src="http://4.bp.blogspot.com/_xIG1J-w3dWc/TKSPi9Isr8I/AAAAAAAADUs/6u6T0_S5D5g/s320/dsl-2640t-2.png" width="320" /></a></div><br />
7) Eureka! You are done with the router configuration. Now go to Tools Tabs-> System -> Hit Save and Reboot Button<br />
8) Upon reboot, your ADSL LED on the router should be stable and ON<br />
Status LED keeps blinking all the while which is normal.<br />
9) Below are few post setup screenshots for your reference to show successful connected status:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/_xIG1J-w3dWc/TKSRMKW7qEI/AAAAAAAADUw/5Fy-NuFSsHM/s1600/dsl-2640t-3.png" imageanchor="1" linkindex="29" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="261" src="http://4.bp.blogspot.com/_xIG1J-w3dWc/TKSRMKW7qEI/AAAAAAAADUw/5Fy-NuFSsHM/s320/dsl-2640t-3.png" width="320" /></a></div><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/_xIG1J-w3dWc/TKSRYnM6OXI/AAAAAAAADU0/UADybJhZv64/s1600/dsl-2640t-4.png" imageanchor="1" linkindex="30" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="http://2.bp.blogspot.com/_xIG1J-w3dWc/TKSRYnM6OXI/AAAAAAAADU0/UADybJhZv64/s320/dsl-2640t-4.png" width="320" /></a></div><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/_xIG1J-w3dWc/TKSRmWAXQgI/AAAAAAAADU4/IzCyCWgha6M/s1600/dsl-2640t-5.png" imageanchor="1" linkindex="31" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="235" src="http://2.bp.blogspot.com/_xIG1J-w3dWc/TKSRmWAXQgI/AAAAAAAADU4/IzCyCWgha6M/s320/dsl-2640t-5.png" width="320" /></a></div><br />
If you are looking for Firmware Upgrades to your Dlink DSL-2640T, then below FTP Link points to European Firmwares released:<br />
<br />
<a href="ftp://203.126.164.142/DSL-2640T/">ftp://203.126.164.142/DSL-2640T/</a><br />
<br />
Looking at the various folders, <a href="ftp://203.126.164.142/DSL-2640T/20091107">ftp://203.126.164.142/DSL-2640T/20091107</a> points to the last stable released firmware for DSL-2640T Europe i.e. back in 2009<br />
For MEA Firmwares:<br />
<a href="ftp://ftp.dlink-me.com/DLink_ME/ADSL/DSL-2640T/Firmwares/">ftp://ftp.dlink-me.com/DLink_ME/ADSL/DSL-2640T/Firmwares/</a> [Very Slow]<br />
<br />
<br />
Be very sure before flashing your firmware. Unless you dont face any issues, please do not flash it.<br />
<br />
Hope this helps all Tata Broadband Users! :-)<br />
<br />
Keywords:<br />
DSL-2640T Router, ADSL, PPPoE, Tata Broadband, Firmware, WRT54GH, Dlink, Linksys, Cisco, Nokia E63, HTC HD, Acer, Dell, Toshibha, iPhone, Apple, etc.Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com2tag:blogger.com,1999:blog-20270653.post-10692021054452817812010-07-26T18:18:00.004+05:302010-07-26T18:31:28.423+05:30Shell Script to monitor Virtual Bytes for Sawserver & NQSServerHi Friends,<br />
<br />
I was troubleshooting gradual increase in physical memory consumption for Sawserver & NQSServer in our environment.<br />
<br />
One requirement was to observe the gradual increase my logging the virtual bytes using a shell script every 5 minutes.<br />
<br />
The command was simple: <b>ps -ef -o vsz,pcpu,args | grep sawserver64</b><br />
<br />
To automate it, i wrote a small shell script which will write the output of above command every 5minutes, until I kill the script execution:<br />
<script class="brush: bash" type="syntaxhighlighter">
<![CDATA[
#!/bin/sh
#Shell Script to output Virtual Bytes for SAWSERVER64 & NQSSERVER Process every 5minutes
#Author: Shalabhsneha Katdare (shalabhkatdare AT GMAIL.com)
#Version: 1.0
#Filename: VirtualByteTrace.sh
i=1
while [ "$i" -ne 0 ]
do
echo "#############################################" >> VirtualByteOutput.txt
date >> VirtualByteOutput.txt
ps -ef -o vsz,pcpu,args | grep sawserver64 >> VirtualByteOutput.txt
ps -ef -o vsz,pcpu,args | grep nqsserver >> VirtualByteOutput.txt
sleep 300
done ]]>
</script><br />
<br />
If you go over the logic, i have wrote a never ending while loop which writes timestamp, virtual byte information for sawserver & nqsserver and included a sleep command to pause the execution for 5mins.<br />
<br />
Customizable Sections:<br />
1) You can add more processes to be monitored for Virtual Bytes.<br />
2) Sleep time can be increase on decreased. It accepts input in seconds, i.e. 300=5mins<br />
<br />
How to Invoke:<br />
1)Make sure that the script has executable rights or <b>do chmod 777 VirtualByteTrace.sh</b><br />
2)Invoke the script in background mode: <b>bash-$./VirtualByteTrace.sh &</b><br />
<br />
Output:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/_xIG1J-w3dWc/TE2FCFGFl7I/AAAAAAAADKc/60qt-Ullb2w/s1600/VirtualByteOutput.png" imageanchor="1" linkindex="17" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/_xIG1J-w3dWc/TE2FCFGFl7I/AAAAAAAADKc/60qt-Ullb2w/s320/VirtualByteOutput.png" /></a></div><br />
Tested successfully on Sun Solaris 10 platform.<br />
Hope this helps you for any other process as well :-)<br />
<br />
Keywords:<br />
OBIEE, Sawserver, Sawserver64, NQSServer, Shell Script, Unix, Solaris, OBIEE 10.1.3.4.1, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-60163814899694717892010-07-20T12:01:00.001+05:302010-07-20T12:06:58.624+05:30Rupee Symbol Font DownloadHi Friends,<br />
<br />
We have the Rupee Symbol font 2.0 out by <a href="http://www.foradian.com/" linkindex="6">Foradian Technologies</a>!<br />
Download & start using immediately so that its adopted by everyone faster :-)<br />
<br />
Blog Post: <a href="http://blog.foradian.com/rupee-font-version-20" linkindex="7">http://blog.foradian.com/rupee-font-version-20</a><br />
Download Font: <a href="http://posterous.com/getfile/files.posterous.com/foradian/3UAMU7WINSptf5AKZPu2v0PFx9AuWoAuUvDiKk2dvBK5nGectr2029CQ7EdP/Rupee_Foradian.ttf" linkindex="8">Rupee Font.ttf</a><br />
<br />
The first font was created by Souymadip. Checkout his creation at: <a href="http://www.cuttingthechai.com/2010/07/download-the-new-rupee-symbol-font-and-a-new-symbol-for-the-paise/" linkindex="9">Rupee Font</a><br />
Download Font by Souymadip: <a href="http://www.box.net/shared/jtjcv6pixm" linkindex="10">Rupee.ttf</a><br />
<br />
Presently it is not incorporated in Unicode, so it will not be visible without the font.<br />
Adopt & spread the word :-)<br />
<br />
Keywords:<br />
Rupee Symbol, Rupee Font Download, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-15963908756895144832010-07-09T21:03:00.000+05:302010-07-09T21:03:34.579+05:30Spool Date & Timestamp using PL/SQLHi Friends,<br />
<br />
The other day i was trying to write an automated alert script to monitor the asynchronous requests in Siebel Server or in other words trying to monitor the S_SRM_REQUEST table for any failed async requests.<br />
<br />
Well in order to achieve the same, i create a quick PL/SQL Script which spooled the necessary information i required as no out of box solution existed from Siebel.<br />
But wait a minute, the timestamp was not getting captured in the spooled out :-(<br />
It was only spooling the date instead of the entire date & time!<br />
<br />
For e.g. if run the below SQL, it will only spool the date<br />
<br />
<script type="syntaxhighlighter" class="brush: sql"><![CDATA[
set pages 999 line 350 feedback off
SET SERVEROUTPUT ON
SPOOL D:\S_SRM_REQ_RPT.txt
column c1 heading "DATE" Format DATE
select sysdate from dual;
SPOOL OFF;
EXIT;
]]></script><br />
<br />
Output was like below :-(:<br />
<b>SYSDATE<br />
--------- <br />
07-JUL-10</b><br />
<br />
Quick research on Google & it pointed me that we need to alter our session to set the NLS_DATE_FORMAT before the spool will actually capture the Date & Time...<br />
So based on this recommendation, i revised my PL/SQL Block to:<br />
<br />
<script type="syntaxhighlighter" class="brush: sql"><![CDATA[
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
set pages 999 line 350 feedback off
SET SERVEROUTPUT ON
SPOOL D:\S_SRM_REQ_RPT.txt
column c1 heading "DATE" Format DATE
select sysdate from dual;
SPOOL OFF;
EXIT;
]]></script><br />
<br />
The end result is, <br />
<b>SYSDATE<br />
-------------------- <br />
07-JUL-2010 08:14:19</b><br />
<br />
Yipee! :-D<br />
I posted here, as i thought its a very useful info for everyone :-)<br />
Happy Weekend!<br />
<br />
Keywords:<br />
Programming, Siebel Async Request, S_SRM_REQUEST, PL/SQL, NLS_DATE_FORMAT, SPOOL, Oracle, etc.Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com1tag:blogger.com,1999:blog-20270653.post-89410088710527446392010-07-02T10:30:00.001+05:302010-07-02T13:20:38.714+05:30oracle.sysman.emSDK.emd.fetchlet.FetchletExceptionHi Friends, <br />
<br />
While experimenting with Oracle Enterprise Manager Grid Control alongside SOA Management Pack Plus, i was getting following Metric collection errors for BPEL Process Manager Partner Link Metrics.<br />
<br />
<b>Issue:</b><br />
The error description was:<br />
"oracle.sysman.emSDK.emd.fetchlet.FetchletException: java.rmi.UnmarshalException: Error deserializing return-value: java.io.InvalidClassException: javax.xml.namespace.QName; local class incompatible: stream classdesc serialVersionUID = -916876369326528164, local class serialVersionUID = -9120448754896609940"<br />
<br />
<b>Reason:</b><br />
Well, if you carefully observe the error description tries to say, <i>"local class incompatible"</i>!<br />
This generally means a JDK Version conflict. If you research further, you will easily see that this happens due to a JDK Version conflict between your Grid Control Agent & the BPEL Process JDK.<br />
<br />
You can verify the JDK Version using: <b>"java -version"</b><br />
<br />
<b>Solution:</b> <br />
The only solution to this issue is to upgrade your BPEL Process Target JDK version. You cannot downgrade your Agent's JDK Version.<br />
Please be careful while upgrading your BPEL Process Target JDK as it might destabilize your system.<br />
<br />
Please ensure that the new JDK is compatible with your BPEL Process version and you know correct steps to upgrade the same.<br />
After you upgrade the JDK, restart the Grid Control Agent and force an Metric Collection upload as follows:<br />
<br />
<b>prompt:/>emctl stop agent - Windows<br />
bash-$ ./emctl stop agent - Unix/Linux<br />
<br />
prompt:/>emctl start agent - Windows<br />
bash-$ ./emctl start agent - Unix/Linux<br />
<br />
prompt:/>emctl upload agent - Windows<br />
bash-$ ./emctl upload agent - Unix/Linux</b><br />
<br />
Keywords:<br />
OEM, OMS, Enterprise Manager, Grid Control, Grid Control Agent, OMS Agent, OBIEE Management Pack, Siebel Management Pack, SOA Management Pack, AGENT_TZ_MISMATCH, Timezone, 10.2.0.5, PSU 3, JDK Mismatch, BPEL Process, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-5920736034619226172010-07-01T15:43:00.002+05:302010-07-01T15:50:13.094+05:30Oracle Enterprise Manager - AGENT_TZ_MISMATCHHi Friends,<br />
<br />
Last entire week i was busy playing with Oracle Enterprise Manager Grid Control alongside Siebel, OBIEE & SOA Management Packs.<br />
<br />
Believe me, its not a piece of cake!<br />
Though PSU 3 on top of 10.2.0.5 provides great stability, still few nagging issues around Metric collections for different target types & other areas keep affecting us.<br />
<br />
One of the most annoying issue that took me long time to figure out was my Grid Control Agent, simply failing to startup :-(<br />
<br />
It was working perfectly fine earlier, but didn't know when it stopped working :-(<br />
After much due diligence in the logs, the <b>emagent.nohup</b> had following dumps:<br />
<b>Issue:</b><br />
<i>----- Wed Jun 23 11:32:51 2010::Agent Launched with PID 3852 at time Wed Jun 23 11:32:51 2010 -----<br />
(pid=3852): starting emagent version 10.2.0.5.0<br />
(pid=3852): emagent started successfully<br />
OMS decided to shutdown the agent because of the following reason sent from OMS: AGENT_TZ_MISMATCH(pid=3852): emagent now exiting abnormally - initialization failure. Consult '.trc' and '.log' files.<br />
----- Wed Jun 23 11:34:39 2010::Pid 3852 not found. reaped=3852, processStatus=14080 -----<br />
----- Wed Jun 23 11:34:40 2010::Checking status of EMAgent : 3852 -----<br />
----- Wed Jun 23 11:34:40 2010::EMAgent exited at Wed Jun 23 11:34:40 2010 with return value 55. -----<br />
----- Wed Jun 23 11:34:40 2010::EMAgent has exited due to initialization failure. -----<br />
----- Wed Jun 23 11:34:40 2010::Stopping other components. -----<br />
----- Wed Jun 23 11:34:40 2010::Commiting Process death. -----<br />
----- Wed Jun 23 11:34:40 2010::Exiting watchdog loop</i><br />
<br />
I was scratching my head, what does AGENT_TZ_MISMATCH means?? Googled it around no luck! I was shocked & surprised that there was no results in Google!<br />
<br />
<b>Reason:</b><br />
Felt like i have hit some kind of jackpot ;-)<br />
After much research, i came to know that such kind of issue might happen when your Agent's host has its Time Zone changed.<br />
<br />
Now, first of all, i didnt accept it! What does Agent's Timezone has to do with its startup? It should automatically accept the new time...<br />
<br />
But then, it was clear that Agent did startup correctly, but when it use to communicate with my OMS Server where the Agent's Timezone is recorded, the changed TimeZone hits a mismatch here!!!<br />
<br />
<b>Solution:</b><br />
Well, in order to resolve this, the solution is simple!<br />
From a command prompt or terminal go to %Agent_Home%/bin directory.<br />
Execute below command:<br />
<br />
<b>prompt:/>emctl resetTZ agent</b> - Windows <br />
<b>bash-$./emctl resetTZ agent</b> - Unix/Linux<br />
<br />
This will update your Agent's emd.properties with the changed TimeZone. But wait this does not complete the changes. You will need to execute a procedure on your Enterprise Manager Repository Database to reflect the changes in the timezone of the Agent.<br />
<br />
So connect to your OMS Repository Database (generally 'emrep') using the repository owner (generally 'sysman')<br />
<br />
SQL>exec mgmt_target.set_agent_tzrgn(<agent_name>, <new_tz_rgn>);<br />
<br />
Well, the exact statement for this procedure is automatically generated at the end of <i>'emctl resetTZ agent'</i> command :-)<br />
<br />
Well, this completes your Agent's TimeZone change. Now to try to start the agent using below command:<br />
<br />
<b>prompt:/>emctl start agent</b> - Windows<br />
<b>bash-$./emctl start agent</b> - Unix/Linux<br />
<br />
I am sure it will startup correctly! ;-)<br />
<br />
Keywords:<br />
OEM, OMS, Enterprise Manager, Grid Control, Grid Control Agent, OMS Agent, OBIEE Management Pack, Siebel Management Pack, SOA Management Pack, AGENT_TZ_MISMATCH, Timezone, 10.2.0.5, PSU 3, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com5tag:blogger.com,1999:blog-20270653.post-2072049856896637632010-06-15T10:30:00.001+05:302010-06-15T11:59:04.174+05:30Extract %time% in Batch ProgrammingHi Friends,<br />
<br />
Date & Time are two very sensitive information which we need to extract frequently which doing any batch scripting for administrative purpose.<br />
<br />
While, i already covered a article regarding how to correctly extract %date%, lets focus on how to extract %time% ;-)<br />
<br />
Well, for the record, %time% variable holds information uniformly across all Windows Version. Which is good as we can easily extract our information as per needs.<br />
<br />
But wait, there is a catch! No matter what you do & instruct your regional settings to include a leading "0" (zero) before the hour, silly DOS will always fail to do so for time prior to 10:00 am!<br />
<br />
So lets evaluate how to extract %time%:<br />
A simple way is like below:<br />
<b>@set time_temp=%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%<br />
@echo %time_temp%</b><br />
<br />
This will work correctly only for time after 10:00 am as before 10:00 am, the %time% variable has value somewhat as:<br />
<i>C:\>echo %time%<br />
C:\>7:06:03.64</i><br />
<br />
As you can see, DOS fails to append a leading zero for your hour :-(<br />
This makes my first approach fail instantly!<br />
<br />
So how to go around & fix this problem?<br />
<script type="syntaxhighlighter" class="brush: vb"><![CDATA[
@set hh=%time:~0,2%
@if "%time:~0,1%"==" " set hh=0%hh:~1,1%
@set time_temp=%hh%%TIME:~3,2%%TIME:~6,2%
]]></script><br />
<br />
As you can see, we simply but a check that if the extracted hour information is having the leading zero available or not...<br />
If not, we are forcing one in the variable :-)<br />
<br />
This should resolve your %time% extracting woes in batch programming!<br />
If you have similar issues for extracting %date%, checkout <a href="http://geektalkin.blogspot.com/2010/06/extract-date-in-batch-programming.html">how to extract %date%</a>!<br />
<br />
Keywords:<br />
how to extract %time%, extract %time%, batch file commands, batch file command, bat files, bat file, batch files, batch script, batch scripting, batch program, windows scripting, windows scripts, DOS, %time%, Leading Zero, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com1tag:blogger.com,1999:blog-20270653.post-45472207891779196612010-06-14T10:00:00.004+05:302010-06-15T12:00:11.301+05:30Extract %date% in Batch ProgrammingHi Friends,<br />
<br />
One very annoying problems is extracting date & time using batch programming.<br />
The reason is simple!<br />
Try <b>c:\>echo %date%</b> on Windows 2003 Server v/s Windows 2000 Server<br />
<i>Windows 2000 Server Output: Sun 06/13/2010</i><br />
<i>Windows 2003 Server Output: 06/13/2010</i><br />
<br />
You will see that both the output are different & that is a cause of big headache. When i write any administrative scripts for taking log backups with appropriate date, it is very important for me that such platform differences should not make my batch scripts to fail on either of the platform.<br />
<br />
Thus, this let me out find a generic solution which will always extract correct date for me no matter its Windows 2000 Server or Window 2003 Server as the underlying platform!<br />
<br />
My earlier way to extract date was like this:<br />
<b>@set date_temp=%date:~4,2%%date:~7,2%%date:~10,4%</b><br />
This use to give me output as<br />
<br />
<i>Windows 2000 Server Output: 06132010</i><br />
<i>Windows 2003 Server Output: 3/01</i><br />
<br />
As you can clearly see that my approach fails on Windows 2003 Server platform. I have the option to modify & setup my date extraction as per Windows 2003 Server platform, but that would make it fail on Windows 2000 Server :-(<br />
So how to find that all in one code?<br />
<br />
Well, its simple! Just have a glance at the below code:<br />
<script type="syntaxhighlighter" class="brush: vb"><![CDATA[
for /f "skip=1 tokens=2-4 delims=(-)" %%a in ('echo.^|date') do (
set A=%%a&set B=%%b&set C=%%c)
set t=2&if "%date%z" LSS "A" set t=1
for /f "skip=1 tokens=2-4 delims=(-)" %%a in ('echo.^|date') do (
for /f "tokens=%t%-4 delims=.-/ " %%d in ('date/t') do (
set dd=%%d&set mm=%%e&set yy=%%f))
@set date2=%dd%_%mm%_%yy%
]]></script><br />
<br />
Above code will always return you the correct date regardless of the underlying platform. It works correctly because its logic is based on the delimiter "-"<br />
I was relieved that, atleast the delimiter is common across all the Windows Versions :-)<br />
<br />
I hope this helps you in your batch or DOS programming :-D<br />
If you have similar issues for extracting %time%, checkout <a href="http://geektalkin.blogspot.com/2010/06/extract-time-in-batch-programming.html">how to extract %time%</a>!<br />
<br />
Keywords:<br />
how to extract %date%, extract %date%, batch script, batch scripting, batch program, windows scripting, windows scripts, DOS, Windows 2000 Server, Windows 2003 Server, %date%, echo, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-90929422904899682382010-06-10T00:23:00.000+05:302011-02-16T14:09:49.657+05:30oracle.apps.xdo.security.ValidateExceptionHi Friends,<br />
<br />
As promised in my first brush with <a href="http://geektalkin.blogspot.com/2010/06/bi-publisher-comphaoscryptocipherexcept.html">BI Publisher post</a>, the next error i faced was <i>oracle.apps.xdo.security.ValidateException</i><br />
<br />
Well, this was because the BI Publisher's security model was set to "BI Server" as BI Publisher was installed as part of OBIEE 10.1.3.4.1<br />
<br />
Now, it is obvious that the RPD "Administrator" user password is changed from the default password "Administrator" & also the RPD must be missing the BI Publisher Security Groups with "Administrator" user added to XMLP_ADMIN group.<br />
<br />
So before we proceed & understand the different Security Models & ways to counter the BI Publisher Authentication woes, it is must to setup a Super User in BI Publisher.<br />
<br />
Super User is a fundamental used in BI Publisher which allows to have a one super admin regardless of whatever security model you configure. Due to this feature BI Publisher allows you to login & configure the BI Publisher system through one common super admin user.<br />
<br />
In order to achieve this, you will first need to change the <i>xmlp-server-config.xml</i> file available under /xmlp/XMLP/Admin/Configuration/ folder:<br />
Change the following line:<br />
<b><property name="SECURITY_MODEL" value="BI Server"/></b><br />
TO<br />
<b><property name="SECURITY_MODEL" value="XDO"/></b><br />
<br />
Setting the Security Model to <b>XDO</b> means, you are configuring the BI Publisher to use its builtin BI Publisher security model.<br />
<br />
After you make this change, stop & restart your J2EE Application server.<br />
Now try to access your BI Publisher using URL: http://host:port/xmlpserver/ & login using following details<br />
User: Administrator<br />
Password: Administrator<br />
<br />
You should be inside BI Publisher now :-)!<br />
Click the Admin Tab & under the "Security Center" section, click: <b>Security Configuration </b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/_xIG1J-w3dWc/TA_iycCvLYI/AAAAAAAADIs/VcfM8qJusgI/s1600/BI_PUB1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" qu="true" src="http://2.bp.blogspot.com/_xIG1J-w3dWc/TA_iycCvLYI/AAAAAAAADIs/VcfM8qJusgI/s320/BI_PUB1.png" /></a></div><br />
Inside "Local Superuser" section:<br />
a) Enable the checkbox for "Enable Local Superuser<br />
b) Choose a suitable "Superuser name"<br />
c) Choose a suitable "Password"<br />
d) Click the "Apply" button on the top right-hand corner.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://3.bp.blogspot.com/_xIG1J-w3dWc/TA_i9cWsBVI/AAAAAAAADI0/4M6wueCa8GI/s1600/BI_PUB2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" qu="true" src="http://3.bp.blogspot.com/_xIG1J-w3dWc/TA_i9cWsBVI/AAAAAAAADI0/4M6wueCa8GI/s320/BI_PUB2.png" /></a></div><br />
e) Restart your J2EE App Server & try logging in using your Super user<br />
If you can successfully login into the BI Publisher system, it makes way for you to start fidling with the other available Security Models for BI Publisher.<br />
<br />
I will cover the other Security Models in upcoming posts.<br />
Stay tuned!<br />
<br />
Keywords:<br />
BI Publisher, Tomcat, Apache, ResourceNotFoundException, OBIEE, 10.1.3.4.1, XML Publisher, Security Model, XDO, BI Server, SIEBEL etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-67187270952130806362010-06-08T13:12:00.004+05:302011-02-16T14:09:49.658+05:30RESTful Webservices Support for SiebelHi Friends,<br />
<br />
If you have heard about the REST (Representational State Transfer) Architecture, then you must have also heard about RESTful Webservices which formed on the principles of REST Architecture and gives us a more enhanced form of the Webservices in terms of scalability, interfacing with the systems & easy independent deployment of components.<br />
<br />
Good news is Siebel 8.1.1 supports such RESTful Webservices!<br />
It is available in Siebel <i> 8.1.1.1 QF0135 & distributed generally as ACR 599</i><br />
<br />
There are chances that this fix will be back ported for Siebel 8.0 Release as well :-)<br />
<br />
If you need general guidelines regarding REST Architecture or RESTful Webservices, then below links are good starting points:<br />
a) <a href="http://en.wikipedia.org/wiki/Representational_State_Transfer" linkindex="17">REST Architecture</a><br />
b) <a href="http://java.sun.com/developer/technicalArticles/WebServices/restful/" linkindex="18">RESTful Webservices</a><br />
c) <a href="http://rest.elkstein.org/" linkindex="19">REST Tutorials</a> <br />
<br />
Keywords:<br />
RESTful Webservices, REST Architecture, Siebel 8.1.1, Siebel 8.0, siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems,Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-14986440351294131342010-06-07T11:00:00.016+05:302010-06-07T14:22:32.349+05:30oracle.apps.xdo.servlet.resources.ResourceNotFoundExceptionHi Friends,<br />
<br />
As promised in my first brush with <a href="http://geektalkin.blogspot.com/2010/06/bi-publisher-comphaoscryptocipherexcept.html" linkindex="14">BI Publisher post</a>, the next error i faced was<br />
<i>oracle.apps.xdo.servlet.resources.ResourceNotFoundException "${oracle.home}/xdo/repository"</i><br />
<br />
Well, i simply dont understand why does such nagging errors always come up.<br />
<br />
<b>Why does it happen?</b> <br />
The BI Publisher always need its Repository location to be defined in <b>xmlp-server-config_orig.xml</b><br />
Now had the BI Publisher being deployed on OC4J or OAS (Oracle Application Server), then the default path would have worked as a charm (${oracle.home}/xdo/repository)<br />
But since we are deploying our BI Publisher in custom J2EE server, we will need to configure this path before we can actually use it.<br />
<br />
<b>Solution?</b><br />
Its simple to rectify this. If you are using BI Publisher as part of integrated OBIEE Setup, you need to find the repository path.<br />
Generally, the repository has folder structure as:<br />
%OBIEE_INSTALL_ROOT%<br />
-------xmlp<br />
-----------XMLP<br />
--------Admin<br />
--------DemoFiles<br />
--------Reports<br />
--------Tools<br />
<br />
So your BI Publisher Repository path is: %OBIEE_INSTALL_ROOT%/xmlp/XMLP<br />
<br />
Now you need to make these changes in the <b>xmlp-server-config.xml</b> file. This file is generally available in your WEB-INF folder where you have deployed the BI Publisher WAR in the J2EE Server.<br />
E.g. for Tomcat: /tomcat-root/webapps/xmlpserver/WEB-INF/<br />
<br />
Edit this file & change <br />
<b><file path="${oracle.home}/xdo/repository"></file></b><br />
to<br />
<b><file path="$OBIEE_INSTALL_ROOT/xmlp/XMLP"></file></b><br />
<br />
Now restart Apache Tomcat Server & you should be all set for a successful login into BI Publisher.<br />
<br />
<br />
Keywords:<br />
BI Publisher, Tomcat, Apache, ResourceNotFoundException, OBIEE, 10.1.3.4.1, XML Publisher etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com3tag:blogger.com,1999:blog-20270653.post-49798753825750337662010-06-04T17:21:00.005+05:302010-06-10T00:26:23.151+05:30BI Publisher: com/phaos/crypto/CipherExceptionHi Friends,<br />
<br />
My first brush with BI Publisher... As always being the case, no Enterprise standard software easily setups as said in its documentation! Thats why the need to expert Consultants to deploy & maintain the same ;-)<br />
<br />
Following was the brief error after i tried logging in from my BI Publisher login screen:<br />
<br />
<i>The server encountered an internal error () that prevented it from fulfilling this request.<br />
<br />
exception<br />
<br />
org.apache.jasper.JasperException: com/phaos/crypto/CipherException<br />
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:476)<br />
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)<br />
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)<br />
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)<br />
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />
oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)<br />
<br />
root cause<br />
<br />
javax.servlet.ServletException: com/phaos/crypto/CipherException<br />
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)<br />
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)<br />
org.apache.jsp.login_jsp._jspService(login_jsp.java:499)<br />
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br />
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)<br />
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)<br />
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)<br />
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />
oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)<br />
<br />
root cause<br />
<br />
java.lang.NoClassDefFoundError: com/phaos/crypto/CipherException<br />
oracle.apps.xdo.servlet.security.SecurityHandler.getHandler(SecurityHandler.java:66)<br />
org.apache.jsp.login_jsp._jspService(login_jsp.java:190)<br />
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br />
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)<br />
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)<br />
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)<br />
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />
oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)<br />
<br />
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs</i>. <br />
<br />
Ahh....i was like what the heck!<br />
<br />
Before i proceed again, i would like to quickly give you my BI Publisher Setup Info:<br />
J2EE Server: Apache Tomcat 5.5.27<br />
BI Publisher: 10.1.3.4.1<br />
Standalone/Integrated: This was installed as part of OBIEE 10.1.3.4.1 Setup & not deployed as standalone.<br />
<br />
Now, above error clearly points to some issue with the Authentication stuff we just passed in the login screen of BI Publisher. It is actually missing few important jars & libraries which are causing the issue.<br />
<br />
<b>Why did this happen?</b><br />
Well, as you all know, OBIEE Installation in Basic form comes with OC4J while Advanced format requires Oracle Application Server. If you dont want either of this, you need to setup your own J2EE Server & deploy these applications from the given WAR files.<br />
<br />
Now, the packaging of WAR files in case of BI Publisher has been different for OC4J & any generic J2EE server. You are bound to deploy the normal OC4J WAR file on Tomcat & then face this error.<br />
The OC4J specific WAR files has few libraries missing as these are already available with base OC4J setup.<br />
<br />
<b>Solution?</b><br />
Now, if you want to recover from this problem, you will first need to undeploy the earlier WAR file deployed on Tomcat.<br />
Once you undeploy, restart your Tomcat and then deploy the WAR (xmlpserver.war) from "generic" folder.<br />
Exact Location for the "generic" folder:<br />
%OBIEE_SETUP_ROOT%/Platform/Solaris/Server_Ancillary/Oracle_Business_Intelligence_Publisher/generic<br />
Platform stands for Solaris/Linux/Windows etc<br />
Deploy the <b>xmlpserver.war</b> from this generic folder on your Tomcat.<br />
<br />
Restart Tomcat & they open your BI Publisher:<br />
http://host:port/xmlpserver/<br />
<br />
Try logging in using your RPD Administrator user & password since BI Publisher coming with OBIEE uses OBIEE Security Model & not that of standalone BI Publisher.<br />
<br />
If you face any of below errors post attempting to login in BI Publisher then stay tuned!! I will be documenting the solutions soon :-)<br />
<br />
<span class="x2t"></span><br />
<pre><span class="x2t"><i><a href="http://geektalkin.blogspot.com/2010/06/oracleappsxdoservletresourcesresourceno.html" linkindex="16">oracle.apps.xdo.servlet.resources.ResourceNotFoundException</a><span style="font-size: 9pt;"> </span></i><b><span style="font-size: 9pt;"> </span></b></span></pre><pre><span class="x2t"><b><span style="font-size: 9pt;">OR</span></b><i><span style="font-size: 9pt;">
</span></i></span></pre><pre><span class="x2t"><i><span style="font-size: 9pt;"><a href="http://geektalkin.blogspot.com/2010/06/oracleappsxdosecurityvalidateexception.html">oracle.apps.xdo.security.ValidateException</a></span></i></span></pre><br />
Till then happy debugging...<br />
<br />
Keywords:<br />
<br />
BI Publisher, OBIEE, xmlpserver.war, RPD, CipherException, 10.1.3.4.1, XML Publisher, Tomcat etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com1tag:blogger.com,1999:blog-20270653.post-41183917981224436462010-05-26T16:46:00.001+05:302011-02-16T14:07:35.049+05:30Siebel Bookshelf (v8.1,v8.0,v7.8,v7.7,v7.5,v7.0,v6.3,v6.2,v6.1,v6.0)Hi Friends,<br />
<br />
One common requirements we have in our day to day Siebel Activities is the Siebel Bookshelf. Its the ultimate knowledge power house regarding Siebel.<br />
<br />
Below are the links you need for different Siebel Versions:<br />
<br />
Siebel 8.1.x <a href="http://download.oracle.com/docs/cd/E14004_01/homepage.htm" linkindex="26">http://download.oracle.com/docs/cd/E14004_01/homepage.htm</a><br />
<br />
Siebel 8.0.x <a href="http://download.oracle.com/docs/cd/B40099_02/homepage.htm" linkindex="27">http://download.oracle.com/docs/cd/B40099_02/homepage.htm</a><br />
<br />
Siebel 7.8.x <a href="http://download.oracle.com/docs/cd/B31104_02/homepage.htm" linkindex="28">http://download.oracle.com/docs/cd/B31104_02/homepage.htm</a><br />
<br />
Siebel 7.7.x <a href="http://download.oracle.com/docs/cd/E05553_01/homepage.htm" linkindex="29">http://download.oracle.com/docs/cd/E05553_01/homepage.htm</a><br />
<br />
Siebel 7.5.x <a href="http://download.oracle.com/docs/cd/E05554_01/homepage.htm" linkindex="30">http://download.oracle.com/docs/cd/E05554_01/homepage.htm</a><br />
<br />
Siebel 7.x <a href="http://download.oracle.com/docs/cd/E05555_01/homepage.htm" linkindex="31">http://download.oracle.com/docs/cd/E05555_01/homepage.htm</a><br />
<br />
Siebel 7.x Mid-market Edition: <a href="http://download.oracle.com/docs/cd/E05565_01/homepage.htm" linkindex="32">http://download.oracle.com/docs/cd/E05565_01/homepage.htm</a><br />
<br />
Siebel 6.x <a href="http://download.oracle.com/docs/cd/E05556_01/homepage.htm" linkindex="33">http://download.oracle.com/docs/cd/E05556_01/homepage.htm</a><br />
<br />
<h3 class="pd" style="font-weight: normal;"><span style="font-size: small;"><a href="http://download.oracle.com/docs/cd/E12300_01/onlinehelp.html" linkindex="34">Siebel Online Help Files and Help Development Kits</a> </span></h3><h3 class="pd" style="font-weight: normal;"><span style="font-size: small;"><a href="http://download.oracle.com/docs/cd/E12300_01/onlinehelp.html" linkindex="35"></a></span></h3><br />
Enjoy!<br />
<br />
Keywords:<br />
Siebel Systems, Siebel CRM, Siebel System Requirements, Supported Platforms, Hardware, <span class="IL_AD" id="IL_AD1">Software</span>, Siebel SBA, Siebel SIA, Horizontal, Vertical, eAutomotive, OBIEE, Siebel Analytics, Siebel eBusiness and Industry Applications,MidMarket Edition, Universal Application Network (UAN), Siebel Retail Finance, Oracle Self-Service E-Billing, Oracle® Real-Time DecisionsShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com2tag:blogger.com,1999:blog-20270653.post-24110407718360784492010-05-22T12:26:00.000+05:302010-05-22T12:26:06.060+05:30Reset runtime Apache access.log & error.logHi Friends,<br />
<br />
Today morning i got a page from our data center that one of the Production Apache based Webserver diskspace was almost full & most of the space was consumed by access.log & error.log!<br />
<br />
Well, i knew this would happen some day since it has been a year we put these machines in Production, moreover we havent setup the log rotation for access.log & error.log.<br />
<br />
Now, i had two tasks at my hand...<br />
1) Take a quick backup of both the log files. <br />
2) Reset/Clear the logs to size zero without bouncing the Apache Webserver services, i.e. at Runtime.<br />
<br />
Solution:<br />
1) Took a zipped backup on another disk in the same machine:<br />
<strong>bash$ zip /d01/Apache_BK/access_log_20052010.zip access.log</strong><br />
<strong>bash$ zip /d01/Apache_BK/error_log_20052010.zip error.log</strong><br />
<br />
2) Reset/Clear the logs to size zero using /dev/null:<br />
<strong>bash$ cp /dev/null access.log</strong><br />
<strong>bash$ cp /dev/null error.log</strong><br />
<br />
OR<br />
<br />
<strong>bash$ cat /dev/null > access.log</strong><br />
<strong>bash$ cat /dev/null > error.log</strong><br />
<br />
Well, using /dev/null is very effective on Linux & Unix platforms, but if you are wondering if we have something similar to that in Windows, then the answer is yes!<br />
<br />
<strong>C:\>type NUL > access.log</strong><br />
<strong>C:\>type NUL > error.log</strong><br />
<br />
Just hope that Windows havent locked the log file with an exclusive handle ;-)<br />
If you have a lock on the file & need to reset the log file without restarting the Apache services, then your only option is to install Unlocker (<a href="http://ccollomb.free.fr/unlocker/">http://ccollomb.free.fr/unlocker/</a>)<br />
<br />
Hope this tip helps as no one wants to bounce a Production system just for taking a log backup & resetting its size to zero :-D<br />
<br />
Enjoy!<br />
<br />
Keywords:<br />
Oracle HTTP Server, Apache, OHS, /dev/null, NUL, access.log, error.log, zip, backup, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com1tag:blogger.com,1999:blog-20270653.post-15822994736938343392010-04-16T15:11:00.003+05:302011-02-16T14:09:15.546+05:30SBL-GEN-03001: Error allocating (null)Hi Friends,<br />
<br />
Yesterday i came across this rare Siebel Assignment Manager error: SBL-GEN-03001: Error allocating (null) OR SBL-GEN-03001: Error allocating DynArrCreate Organization Skill Items Arr <br />
<br />
Logs files were showing up following dump:<br />
<i>GenericLog GenericError 1 000000024bc70cd4:0 2010-04-15 09:39:12 (asgnrule.cpp (8327) err=3001 sys=2640) SBL-GEN-03001: Error allocating DynArrCreate Organization Skill Items Arr<br />
<br />
GenericLog GenericError 1 000000024bc70cd4:0 2010-04-15 09:39:12 (asgnrule.cpp (929) err=3001 sys=0) SBL-GEN-03001: Error allocating DynArrCreate Organization Skill Items Arr</i><br />
<br />
Due to this, Siebel Assignment Manager component was not getting started & constantly crashing. If you start, it will again stop & crash after few minutes.<br />
<br />
This behaviour is particularly related to Physical Memory availability to the Assignment Manager component.<br />
You can setup following log level for your Assignment Manager component to have a quick informative trace regarding the issue:<br />
<br />
1. Object Assignment = 4<br />
2. Rules Evaluation = 5<br />
3. Loading = 4<br />
4. Assignment Manager Generic = 4<br />
5. SQL Tracing = 2<br />
6. SQL Parse and Execute = 4<br />
7. Task Configuration = 4<br />
8. Component Tracing = 3<br />
<br />
In our environment, this issue came up suddenly so it definitely wasnt an Siebel Product issue but something to do with our environment changes.<br />
Further tracing of the logs lead to us that the amount of rules loading was causing the Assignment manager cache to go out of bounds of the total available physical memory on Siebel Application Server.<br />
<br />
The only way to resolve this was to follows below steps:<br />
1) Stop Assignment Manager & Batch Assignment components.<br />
2) Delete rulecache.dat file under $SIEBEL_ROOT/siebsrvr/bin <br />
3) Delete or expire all unwanted Assignment rules<br />
4) Start Assignment Manager & Batch Assignment components<br />
5) Allow the new rulecache.dat file to be generated.<br />
6) Now check log to see if Assignment Manager component is still shutting down.<br />
<br />
90% of cases, this should resolve the issue. But if you still face the same problem, you need to start investigating from your trace log. Particularly the last queries fired just before you find SBL-GEN-03001 errors being dumped in the log file.<br />
<br />
You may also notice 0KB crash_xx.txt files under $SIEBEL_ROOT/siebsrvr/bin until you resolve this issue.<br />
Enjoy!<br />
<br />
Keywords:<br />
siebel crm,siebel <span class="IL_AD" id="IL_AD4">customer relationship management</span>,siebel solutions,siebel support,siebel supportweb,siebel systems, assignment manager, crash.txt, FDRs, etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-69844445360536320182010-04-14T17:13:00.001+05:302010-04-14T17:16:43.086+05:30SEVERE: EM is not configured for this databaseHi Friends,<br />
<br />
I was doing this Oracle 10gR1 database upgrade to Oracle 10gR2 using DBUA (Database Upgrade Assistant) when my upgrade failed due to this error:<br />
<i><br />
</i><br />
<i>[Thread-54] [10:25:54:325] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@6014f7<br />
[Thread-54] [10:25:54:325] [SummarizableStep.setUpgradeStatus:620] **++Set Upgrade status to:=1<br />
oracle.sysman.assistants.util.step.StepExecutionException: Enterprise manager configuration failed due to the following error -<br />
EM is not configured for this database. No EM-specific actions can be performed.<br />
Refer to the log file at C:\OracleHomes\db10gr2\cfgtoollogs\dbua\emrep\upgrade1\emConfig.log for more details.<br />
You can retry configuring this database with Enterprise Manager later by manually running C:\OracleHomes\db10gr2\bin\emca script.<br />
at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:141)<br />
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)<br />
at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)<br />
at oracle.sysman.assistants.dbma.backend.EMConfigStep.executeStepImpl(EMConfigStep.java:101)<br />
at oracle.sysman.assistants.dbma.backend.SummarizableStep.executeImpl(SummarizableStep.java:174)<br />
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)<br />
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)<br />
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2468)<br />
at java.lang.Thread.run(Thread.java:534)<br />
[Thread-54] [1:7:4:273] [EMConfigStep.handleNonIgnorableError:197] EMConfig Error:=Error ignored: Could not complete the Enterprise Manager configuration.<br />
Enterprise manager configuration failed due to the following error -<br />
EM is not configured for this database. No EM-specific actions can be performed.<br />
Refer to the log file at C:\OracleHomes\db10gr2\cfgtoollogs\dbua\emrep\upgrade1\emConfig.log for more details.<br />
You can retry configuring this database with Enterprise Manager later by manually running C:\OracleHomes\db10gr2\bin\emca script.<br />
<br />
[Thread-54] [1:7:4:273] [EMConfigStep.executeStepImpl:161] EM Configuration Step Complete..<br />
[Thread-54] [1:7:4:273] [SummarizableStep.executeImpl:175] execute impl:Enterprise Manager Configuration = DONE Sucessfully<br />
[Thread-54] [1:7:4:273] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@6014f7</i><br />
<br />
At first, i thought its over! My database is gone...but a few research down the line gave me a breather :)<br />
I was upgrading my Oracle Enterprise Manager (OEM) Grid Control Database from 10.1.2.0 to 10.2.1.0. A Grid Control Database installation does not have a separate DBConsole installed as the Database is also managed by the OEM itself.<br />
<br />
So in my particular case, i could simply press OK & then move ahead. The upgrade was almost complete & nothing else was required.<br />
<br />
I just reconfigured the LSNRCTL & NET SERVICE NAME using Net Configuration Tool & rebooted my server & my new database was up & running.<br />
<br />
However, if you are not upgrading a GC Repository Database, but an actual standalone database, this error should not be ignored as your DB Console would not be upgraded due to it.<br />
You must followup with Oracle & find out why the upgrade for DBConsole failed.<br />
<br />
Hope this info helps!<br />
<br />
Keywords:<br />
Oracle Database, Oracle 10GR1, Oracle 10GR2, Oracle Enterprise Manager, OEM, Grid Control, GC Repository Upgrade, Database Upgrade, DB Console, LISTENER.ORA, TNSNAMES.ORA, SQLNET.ORA, Listener Control, TNS Listener, DBUA, EMCA etcShalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com0tag:blogger.com,1999:blog-20270653.post-17158952353115607532010-04-12T12:26:00.002+05:302011-02-16T14:08:39.086+05:30Ektron eWebEditPro5: Run time Error '0'Hi Friends,<br />
<br />
If you recently moved to any Siebel Maintenance fix packs 8.0.0.6 and above then you might face an annoying issue with Siebel HTML Editor a.k.a Ektron eWebEditPro Editor!<br />
<br />
After you apply the fix pack for Siebel Web Server Extension (SWSE), it upgrades the existing eWebEditPro editor from v4 to v5.<br />
<br />
After this upgrade a necessary configuration change is not mentioned in the Maintenance Configuration Section, due to which you will notice that any template tried to be opened in the new HTML Editor results into a blank load & if you right click in the editor it results into a error popup window titled <i>eWebEditProLibCtl5</i> saying, "<i>Run time error '0'</i>"<br />
<br />
<div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/_xIG1J-w3dWc/S8H0BJsZUpI/AAAAAAAADD0/SK9mJqzf28U/s1600/Ektron_Issue.png" imageanchor="1" linkindex="15" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/_xIG1J-w3dWc/S8H0BJsZUpI/AAAAAAAADD0/SK9mJqzf28U/s320/Ektron_Issue.png" /></a></div><br />
In order to resolve this, you will need to edit the <b>webeditorctrl.htm</b> file under /$SIEBEL_SWSE_ROOT/public/enu/webeditor/<br />
<br />
Find out the below code:<br />
<br />
<script type="syntaxhighlighter" class="brush: html"><![CDATA[
<input name="MyContent" type="hidden" />
<script id="EditorScript" language="JavaScript1.2">
<!--
var bIsControlInstalled = false;
try
{
var xObj = new ActiveXObject(cPROGID);
if (xObj)
bIsControlInstalled = true;
xObj = null;
}
catch (e) {};
if (!bIsControlInstalled)
{
]]></script><br />
<br />
and replace it with below code:<br />
<br />
<script type="syntaxhighlighter" class="brush: html"><![CDATA[
<input type="hidden" name="MyContent" value="">
<script id="EditorScript" language="JavaScript1.2">
<!--
var versionInstalled = ActiveXVersionInstalled(cPROGID) + "";
var isInstalled = false;
if (versionInstalled.length > 0)
{
if (ActiveXElement_compareVersion(cVERSION,versionInstalled) >= 0)
{
isInstalled = true;
}
}
if (!isInstalled)
{
]]></script><br />
<br />
After you do this, make sure you do a <b>CLEAR CACHE</b> in your browser else it will still show Javascript errors like:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><br />
<a href="http://3.bp.blogspot.com/_xIG1J-w3dWc/S8H2m3m4G7I/AAAAAAAADD8/_lQPuSYGcf8/s1600/Ektron_Issue3.png" imageanchor="1" linkindex="300" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/_xIG1J-w3dWc/S8H2m3m4G7I/AAAAAAAADD8/_lQPuSYGcf8/s320/Ektron_Issue3.png" /></a></div>This happens as the old webeditorctrl.htm file is used from browser cache for loading eWebEditPro Editor.<br />
So ensure you do a clear cache without fail!<br />
<br />
Hope this helps resolve patching issue.<br />
<br />
Keywords:<br />
siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, SWSE, eWebEditPro, Ektron, HTML Editor, Marketing, WYSIWYG HTML Editor, WYSIWYG, etc.Shalabhsneha Katdarehttp://www.blogger.com/profile/07550007279075319292noreply@blogger.com2