Geek Talkin Siebel

Siebel System Requirements and Supported Platforms (v8.1,v8.0,v7.8,v7.7,v7.5,v7.0,v6.3,v6.2,v6.1,v6.0)

2009-10-20T18:37:00.000+05:30

Hi Friends,

This is one very important ready reckoner page regarding the System Requirements & Supported Platforms for all the Siebel Versions released & supported so far.

http://download.oracle.com/docs/cd/E11886_01/srsphomepage.html

This is the best source to keep in touch for any updated System requirements & platforms.
Hope this helps everyone.

Keywords:
Siebel Systems, Siebel CRM, Siebel System Requirements, Supported Platforms, Hardware, Software, 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 Decisions

Oracle UPK Installation Failed - ORA-12640: Authentication adapter initialization failed

2009-10-14T14:37:00.003+05:30

Hi Friends,

I was setting up Oracle User Productivity Kit (UPK) in Server only mode for setting up a dedicated documentation facility. This was my first hand setup experience with the UPK & so as i expected i landed up with few issues during installation.

While deploying the UPK server on a local server, at the end of the installation, i received error:
ORA-12640: Authentication adapter initialization failed

I thought, there might be some issue due to the database. Went around searched & re-tried the installation, but it again failed due to the same error.

After further research, i found that this error is more related to the Oracle Client settings in sqlnet.ora

Below is the change i did in my sqlnet.ora file after which Oracle UPK Server Mode installation completed successfully:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
Changing this one to:
SQLNET.AUTHENTICATION_SERVICES = (NONE)

Keywords: Oracle UPK, Oracle User Productivity Kit, Oracle UPK Installation, ORA-12640, etc

The DLL 'SSCEACTVIEW.DLL' could not be loaded.(SBL-DAT-00170)

2009-09-13T20:52:00.001+05:30

Hi Friends,

You might have received this long time buggy error: "The DLL 'SSCEACTVIEW.DLL' could not be loaded.(SBL-DAT-00170)" while trying to generate a EIM Report using Siebel Tools.

Issue:

This issue occurs particularly when you are connected to 'SERVER' Datasource & try to generate an EIM Report.

Solution:
There has been no Product Fixes from Oracle, but a simple workaround: Use LOCAL Database for generating EIM Report.

If you connect to your Local DBF using Siebel Tools then you will not face this error while generating EIM Report but other inital error like:

Once you clear the initial error, try again to generate the EIM Report & this time it will generate the report without any errors or prompts.

Keywords:

siebel crm,siebel, siebel systems, siebel tools, siebel dev, eim, eim report, SBL-DAT-00170

Missing PID in Adminstration-Server Management-Sessions Screen

2009-07-15T01:34:00.004+05:30

Hi Friends,

One minor bug i encountered during implementation of Siebel 8.0 is the missing PIDs for open Sessions in Administration-Server Management Screen!

If you observe carefully; the PID column would be blank for all Sessions, whereas ideally it should have the Process ID Value populated for all running Sessions.
Further investigating, it was verified that PID was not only absent from UI, but also when we try to export the same from command line srvrmgr utility, the result is same.

Presently, the only workaround to find the PID of a running Session would be to find the associated Task to that Session. This can be achieved by noting down the Session ID value showed in UI for a particular Session & then finding the same in Administration - Server Management -> Tasks Screen as Task ID. i.e.
(Sessions Screen)Session ID= Task ID (Tasks Screen)
I know, its a very mechanical workaround, but when those annoying user-related or particular session related issues get reported in Production, we badly need this PIDs to see whats happening over the server ;-)

And yes...finally this has been admitted as a bug for Siebel 8.0 Platform.

Happy CRM Hunting! :-)
Keywords:Siebel, Siebel Systems, Siebel Session, Session PID, PIDs, PID, Process ID, Administration-Server Management, etc

Add Social Bookmarking Widgets: ShareThis-AddThis [How To]

2009-07-14T14:13:00.006+05:30

Hi Friends,

One of the most important part of blogging is to reach out good audience. In earlier dotcom eras, multiple link sharing & different link exchanges were used to promote websites.

But nowadays due to the huge popularity of social networking sites, people are much more eager to carry each & everything with them as they keep moving from one place to another and
so a online bookmarking solution is the perfect tool for them.

Having considered all of this, we should quickly sit down & start using this utility for our own blog!

Two very good widget solutions exist online: Share This or Add This

Both of this websites provide professional bookmarking solutions for Blog Publishers including definitive Analytics in order to track all of your content popularity.

Lets review both of this individually:

Share This:
- Free
- Easy to use
- Instant Widget installation across different blogging sites
- Definitive Analytics for Advanced Reporting Purpose
- Registration is compulsory.

Sample Screenshot:

Add This:
- Free
- Easy to use
- Instant Widget installation across different blogging sites
- Direct code insertion also possible.
- Defintive Analytics for Advanced Reporting Purpose
- Registration is only required, if you want to subscribe for Analytics, else its plug n play ;-)

Sample Screenshot:

I am using Add This for my Blog. Its pretty much simpler & easy to use. I would definitely recommend Add This.

Keywords:social bookmarking widget, social bookmarking sharing button widget, addthis social bookmarking sharing button widget, social bookmarking widgets, widget, widgets, AddThis,ShareThis, blog widget, blog widgets, social bookmarking, social bookmarks, online bookmark, etc

Historical Audit Trail Information Missing after Siebel 8.0 Upgrade

2009-07-05T01:26:00.005+05:30

Hi Friends,

If you have just upgraded to Siebel 8.0, then be prepared to have a big shocker in waiting! All the historical audit trail information will be missing from UI due to the New Encoded Audit Trail storing mechanism introduced in Siebel 8.0

A major change in Siebel 8.0 is the query formed while retrieving the Audit Trail records:
" WHERE
((T1.BC_BASE_TBL = ?) AND
(T1.RECORD_ID = ?))"

All Historical Audit Trail records would be having BC_BASE_TBL column as null causing this issue.
If you are thinking to populate this column using EIM, then it wont work as S_AUDIT_ITEM does not have the required userkeys.

So how to go about populating BC_BASE_TBL directly? We need to query S_BUSCOMP & get the Base Table name for each record.

I have wrote a PL/SQL Block for directly updating S_AUDIT_ITEM which will populate the BC_BASE_TBL for all the historical records inorder to resolve this issue...

############################################################
/* Update Audit Trail Historical Records for UI Visibility
Author:- Shalabhsneha Katdare (SHALABHKATDARE AT GMAIL.COM)
Version 1.0
*/

DECLARE

V_COUNT NUMBER:=0;
V_COUNT1 NUMBER:=0;
V_ROW_ID VARCHAR2(30);
V_ERR_MSG VARCHAR2(200);
v_Table_Name VARCHAR2(75);
v_Buscomp_Name VARCHAR2(75);

CURSOR CUR_AUDIT_RECORDS
IS
SELECT
ROW_ID, BUSCOMP_NAME
FROM
SIEBEL.S_AUDIT_ITEM
WHERE
BC_BASE_TBL is null;

BEGIN
FOR CUR1 IN CUR_AUDIT_RECORDS LOOP
EXIT WHEN CUR_AUDIT_RECORDS%NOTFOUND;

v_row_id := cur1.row_id;
v_Buscomp_Name := cur1.BUSCOMP_NAME;
V_COUNT:=V_COUNT+1;

select table_name into v_Table_Name from s_buscomp
where name=v_Buscomp_Name
and repository_id in (select row_id from s_repository where name='Siebel Repository');

if v_Table_Name is not null then
/* Its always a best practice to update LAST_UPD_BY, LAST_UPD & MODIFICATION_NUM while doing a backend update directly on Siebel Base Table*/

UPDATE
SIEBEL.S_AUDIT_ITEM
SET
BC_BASE_TBL = v_Table_Name
,LAST_UPD_BY='0-1'
,LAST_UPD = SYSDATE
,MODIFICATION_NUM = NVL(MODIFICATION_NUM,0)+1
WHERE
ROW_ID = CUR1.ROW_ID;
END IF;

/* A COMMIT Counter in order to commit after every 1000 records*/
IF V_COUNT>=1000 THEN
COMMIT;
V_COUNT:=0;
END IF;

END LOOP;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
COMMIT;
/* Exception Handling Code if you want to add */
END;
/
##########################################################

I hope this helps to all who have recently upgraded to Siebel 8.0!
Welcome to Siebel 8.0 :)

Enjoy!
Keywords:
audit trail,audit trails,audit report,audit management,siebel crm,siebel, siebel systems,S_AUDIT_ITEM,BC_BASE_TBL,EIM,Historical Audit,etc

ESD [EMS 2012] Error: FindClass org/apache/catalina/startup/Bootstrap failed

2009-05-13T17:31:00.008+05:30

Hello Friends,

If you happen to use the new breed of Siebel Email Marketing Server (ESD/BHD/CTD) [EMS2012], then you might be greeted with below error while starting the Service for the first time in jakarta_service_date.log file under \logs:

[2009-05-11 06:22:38] [info] Procrun (2.0.3.0) started
[2009-05-11 06:22:38] [info] Running Service...
[2009-05-11 06:22:38] [info] Starting service...
[2009-05-11 06:22:38] [443 javajni.c] [error] FindClass org/apache/catalina/startup/Bootstrap failed
[2009-05-11 06:22:38] [997 prunsrv.c] [error] Failed loading main org/apache/catalina/startup/Bootstrap class d:\Program Files\esd\bin\bootstrap.jar
[2009-05-11 06:22:38] [1260 prunsrv.c] [error] ServiceStart returned 3
[2009-05-11 06:22:38] [info] Run service finished.
[2009-05-11 06:22:38] [info] Procrun finished.

This is mainly because, Apache Tomcat 6 is now distributed with the latest EMS components which needs updated JDK Version to be installed prior its installation.

You can install J2SDK 1.5 update 18 & then re-install to eliminate this error.

If you are planning to install J2SDK 1.6, then you might want to read the below page first:
https://issues.apache.org/bugzilla/show_bug.cgi?id=41538

Keywords: ESD, Email Sending Daemon, crm,siebel, siebel systems,Siebel Bounce Handler Daemon, Siebel Click Through Daemon, BHD, CTD,EMS, Email Marketing Server,etc

Siebel SRVRMGR Utility - Spool [HOWTO]

2009-04-29T18:52:00.005+05:30

Hi Friends,

If you want to take some export of Parameters or Components from SRVRMGR Utility through command prompt, then keep reading...

Below simple steps teach how to take a spool while working with SRVRMGR in Command Line Mode:

Command Line Parameters to Take Spool of Component Parameters:

cmd:>srvrmgr /g GATEWAY_ADDR /e ENTERPRISE_SERVER_NAME /s SIEBEL_APPLISRVR_LOG_NAME /u USERNAME /p PASSWORD
srvrmgr:>spool C:\Parameter_Spool.txt
srvrmgr:>list parameters for component SSEObjMgr_enu
srvrmgr:> list advanced parameters for component SSEObjMgr_enu
srvrmgr:> list hidden parameters for component SSEObjMgr_enu
srvrmgr:> spool off
srvrmgr:>exit

Once you exit the srvrmgr, you have Parameter_Spool.txt file ready with required information.
SRVRMGR spool is highly important tool, if you dont use 'Administration - Server Management' in UI for Siebel Server Administration :-)

Keywords:
siebel crm,siebel, siebel systems,srvrmgr,srvrmgr command line, command line,server admin, siebel admin,siebel srvrmgr utility

SQL Error Creating table Dummy Table to Verify Previleges / Extending the Database by Adding New Columns to the Base Table

2009-04-28T16:21:00.005+05:30

Hi Friends,

During development when you are connected to your Local Database, you might need to test out any schema changes to a Table or Column.
In order to achieve this, you will be needing to apply the logical changes from Tools to your Local Database.

While doing so, you need to give Privileged Database User & Password to make changes to your Local DB Schema.
If you use your Tools login username & password; you would be greeted with this two errors:

First Error:
SQL Error Creating table Dummy Table to Verify Privileges

Second Error:
42000 (-121): [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Permission denied: you do not have permission to use the "CREATE TABLE" statement

To avoid above errors, you need to change the Privileged User & Password being supplied before applying the change:

Siebel Application User Id User Password
Prior to Version 7.7 DBA SQL
Version 7.7 SIEBEL Local
Version 8.0 SIEBEL Local

Here, Local means to use your own Local User Password.
i.e. Say if you use dummyuser/dummypassword to login to your Local Tools, then you need to use SIEBEL/dummypassword as your Privileged User Id & Privileged User Password for making schema changes to your Local DB.

Same information is also available in the Siebel Bookshelf at:
http://download.oracle.com/docs/cd/B40099_01/80Siebel_HTML/books/DevDep/DevDep_DBExtension3.html

Keywords:
siebel crm,siebel, siebel systems,siebel tools,siebel crm tools,Local Database, DBF

No server connect string for Siebel Component SRBroker in Siebel Enterprise SBA_ES, Siebel Server DEV8~ 1-3HU6QN~Campaign Contact

2009-04-28T16:00:00.005+05:30

Hi Friends,

If you use dedicated client in your environment & try to invoke assignment manager through scripting, then you might face errors like:

"No server connect string for Siebel Component SRBroker in Siebel Enterprise SBA_ES, Siebel Server DEV8~ 1-3HU6QN~Campaign Contact"

For this to work correctly, you need to modify your Dedicated client CFG & include following in the InfraObjMgr Section:

[InfraObjMgr]

RequestServerName = dev8

TO

[InfraObjMgr]

RequestServerName = sba_as

Above changes mean that you have to use the 'Logical Siebel Server' Name for RequestServerName instead of Physical Server Name & this Server should have 'Assignment Manager Component' running on it.

After you make these changes in the CFG & restart the client, you will not face this issue again.

Keywords:
siebel crm,siebel, siebel systems,siebel dedicated client,dedicated web client,CFG,Assignment Manager, siebel admin,siebel config,siebel assignment manager

Buttons in Siebel UI are having Transparent Look & Feel

2009-04-25T17:04:00.007+05:30

Hi Friends,

Well a very annonyning problem i came across & it took me around 4 months & 4 Service Requests before Siebel accepted it as bug.

Scenario:
If you have Siebel 8 Implementation in your environment over cross platforms, then you will face this issue of Transparent Buttons across the Application.
For e.g. Application Servers are on Windows Platform
Webservers [Siebel Web Server Extention Implementation] are on UNIX or Linux Platform.

Issue:
main.css has button related file extension reference in uppercase; i.e. "GIF"
Check the screenshot:

Now, when we are having our Webservers on UNIX or Linux Platform, this upper case extensions become a big bottleneck as file systems are case sensitive.
All the image file provided by Siebel are having file extension in lower case: ie "gif" or "jpg".
Now due to this uppercase extension, the Siebel UI was failing to render the button images at all causing the transparent look & feel.

Resolution:
There are two ways to correct this:
1) Edit the Vanilla main.css under [SWSE_ROOT\public\enu\files] for all such upper case references to lower case: i.e. "GIF" to "gif"
2)Create a copy of button images with uppercase extensions using below commands:
[SWSE_ROOT\public\enu\images\]
-bash-3.00$ cp bkgrnd_minibtn.gif bkgrnd_minibtn.GIF
-bash-3.00$ cp bkgrnd_minibtn_hover.gif bkgrnd_minibtn_hover.GIF

This issue has been validated from Siebel 8.0 to 8.0.0.6. A Fix Request has been raised, so lets see when this annoying issue of transparent buttons is officially fixed ;-)

Till then happy CRM hunting. :-)

Keywords:
siebel crm, swse, siebel swse, siebel, siebel systems, webservers, web servers, linux, unix, Sun One, Oracle HTTP Server, OHS 2.0, Apache 2.0, IIS, Siebel Web Server Extensions

Enabling Dynamic Pricing/Advanced Pricing Capabilities in Siebel 8.x/7.8.x

2008-06-10T12:39:00.003+05:30

Hi All,

This article would discuss about enabling Dynamic Pricing/Advanced Pricing Capabilities in Siebel.
By default, Siebel uses Basic Pricing as its base pricing procedure followed.

In order to enable & use advanced pricing procedure, quite a few configuration changes are required as listed below:

1) First & foremost requirement is, you need to have Siebel Dynamic Pricer License.

2) You need to activate all the workflows related to your Pricing Configuration Requirement.
A complete technical reference is available in the Siebel Pricing Administration Guide
Siebel 8: http://download.oracle.com/docs/cd/B40099_02/books/PriceAdm/PriceAdmTOC.html

Siebel 7.8:
http://download.oracle.com/docs/cd/B31104_02/books/PriceAdm/PriceAdmTOC.html

3) Apart from this, you may need to activate other workflows available in the Order Management Infrastructure Guide

Siebel 8:
http://download.oracle.com/docs/cd/B40099_02/books/OrderMgtInfra/OrderMgtInfraTOC.html

Siebel 7.8:
http://download.oracle.com/docs/cd/B31104_02/books/OrderMgtInfra/OrderMgtInfraTOC.html

4) Need to modify various signals which point to Basic Pricing Procedure, to enable Dynamic Pricing.
For this, follow the detailed guidelines of Tech Note 643 or Document Id: 473914.1 on Oracle Metalink 3.

When you complete the above 4 steps, your environment would be successfully configured for Dynamic Pricing or Advanced Pricing Capabilities.

Keywords: comparison pricing,competitive pricing,dynamic price,dynamic pricing,market pricing,price waterfall,pricer,pricing management,pricing strategy,product pricing,siebel crm,value pricing

Siebel 8.0 Simplified Installation Tasks/Guide for Windows

2008-05-09T11:13:00.000+05:30

Hi Friends,

One of the most frequently asked question regarding Siebel is an shortcut summarized document for its installation, to test it out faster.
Well, on other environments, it may not be easy to write a shortcut document, but for Windows Oracle has definitely written one.

You can access this simplified installation document on Oracle Siebel SupportWeb or Metalink 3 by searching for Document ID: 475438.1 or TechNote 688

Enjoy installing Siebel!

Enabling HighInteractivity for PRM Portal (eChannel) in Siebel v7.8 & Siebel v8.0

2008-04-16T21:17:00.001+05:30

Enabling HighInteractivity for Partner Portal (PRM Portal, eChannel) is a simple job!
HighInteractivity provides the same functionality as you find in your Sales or Marketing Application with ActiveX Loaded & minimum page refreshes.
By default, Partner Portal runs in StandardInteractivity Mode.

For Siebel CRM v7.8, following are the steps:
1)Browse to your Siebel_Server_Root\bin\enu\
2)Open the scw.cfg
3)Find the section [SWE]
4)Add the following two lines:

HighInteractivity = TRUE
ShowWriteRecord = TRUE

5) Save the file & restart the server to have HighInteractivity on your PRM Portal

Similarly for Siebel CRM v8.0, following are the steps:
1)Browse to your Siebel_Server_Root\bin\enu\
2)Open the scw.cfg
3)Find the section [InfraUIFramework]
4)Add the following two lines:

HighInteractivity = TRUE
ShowWriteRecord = TRUE

5) Save the file & restart the server to have HighInteractivity on your PRM Portal

Keywords: channel portal,crm,crm portal,customer relationship management,e channel,echannel,high interactivity,on demand,partner portal,prm portal,relationship management,siebel,siebel high interactivity,siebel high interactivity framework,siebel high interactivity framework for ie,siebel portal,siebel systems

Error loading dictionary file diccache.dat.(SBL-DAT-60237)

2008-04-08T12:49:00.000+05:30

This error is caused due to problem in schema synchronization. The proposed resolution is to run the Database Utilities & perform Schema Synchronization.

After schema synchronization has been done, stop the Siebel Server Service, search & delete the file diccache.dat from the Siebel Installation directory, if present.

Now restart the Siebel Server Service for generation of fresh diccache.dat file.

Keywords: siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, SBL-DAT-60237

Oracle Apps - Java Concurrent Program

2008-03-24T21:23:00.002+05:30

Writing a Java Concurrent Program

Concurrent Processing provides an interface JavaConcurrentProgram with abstract method runProgram() which passes the concurrent processing context CpContext. The concurrent program developer will implement all of their business logic for a concurrent program in runProgram().

CpContext will have the request specific log and output file input methods. The class name with the runProgram() method will be registered as the java executable file name in the register executable form.

Follow the following generic format to write a Java Concurrent Program…

package oracle.apps.yourpackage.subpackage;

import oracle.apps.fnd.common.Context;
import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.cp.request.*;
import oracle.apps.fnd.util.*;

public class HelloWorldApp
implements JavaConcurrentProgram{

public void runProgram(CpContext ctx){

//Obtain the reference to the Output file for Concurrent Prog
OutFile out = ctx.getOutFile();

//Obtain the reference to the Log file for Concurrent Prog
LogFile log = ctx.getLogFile();

try{

 //To read parameters passed via Concurrent Program
 String myName = null;
 ParameterList lPara = ctx.getParameterList();
 while (lPara.hasMoreElements())
             {
             NameValueType aNVT = lPara.nextParameter();
             if ( aNVT.getName().equalsIgnoreCase("My Name") )
                 myName = aNVT.getValue(););
       }

 //Write your logic here

 out.writeln("This will be printed to the Output File");

 log.writeln("This will be printed to the Log File", 0);
  
//Request the completion of this Concurrent Prog
//This step will signal the end of execution of your Concurrent Prog
ctx.getReqCompletion().setCompletion(ReqCompletion.NORMAL,  "Completed.");
}
//Handle any exceptional conditions
catch(Exception e){
 StackTraceElement ste[] = e.getStackTrace();
 for(int i=0; i<ste.length; i++){
  log.writeln(ste[i].toString(), 0);
 }
}
}
}

Best Practice

As a best practice, use Oracle JDeveloper patched with the following patch number: 6012619. You can download it from Metalink. This patched release of JDeveloper includes all the FND packages and other requisite packages commonly used while writing Java Concurrent Programs. You may use Eclipse, but you will have to manually copy all the packages from Oracle Apps Server to your local machine and give its reference to the project.

Porting Third-Party Libraries

Ask the DBA to place all the requisite third-party libraries under $JAVA_TOP. To make the third-party libraries available to your JCP, follow the steps outlined below to create your Concurrent Program Executable and to create the actual Concurrent Program.

Create Concurrent Program Executable

Path: Concurrent -> Program -> Executable

Create the concurrent program executable, details of which are as follows:

Executable   : HelloWorld
Short Name   : HelloWorld
Application   : Custom Applications
Execution Method  : Java Concurrent Program
Execution File Name         : HelloWorldApp This is your main class file
Execution File Path  : oracle.apps.yourpackage.subpackage

Create the Concurrent Program

Path: Concurrent -> Program -> Define

We are having one concurrent program.

Program  : HelloWorld Java Concurrent Program
Short Name : HELLOWORLDJCP
Application : Custom Applications
Description : Hello World Program
Executable Name : HelloWorld
Executable Method : Java Concurrent Program
Options  : -classpath  /dv00/oracle/product/DEV1110/java:/dv00/oracle/apps/DEV1110/11.5/au/11.5.0/java/appsborg.zip:/dv00/oracle/product/DEV1110/java/thirdParty1.jar:/dv00/oracle/product/DEV1110/java/thirdParty2.jar

Note:- If your JCP does not make use of any Third-Party libraries, then please DO NOT put any entry in the Options.

The Options to be specified must be fully qualified. Use of environment variables will fail the execution of the Java Concurrent Program.

/dv00/oracle/product/DEV1110/java - This is the path to my $JAVA_TOP
/dv00/oracle/apps/DEV1110/11.5/au/11.5.0/java/appsborg.zip - This is the path to my $AU_TOP/java/appsborg.zip
/dv00/oracle/product/DEV1110/java/thirdParty1.jar - This is the JAR reference to my first Third Party Library dependency.
/dv00/oracle/product/DEV1110/java/thirdParty2.jar - This is the JAR reference to my second Third Party Library dependency.

The paths must be set for appropriate environment as specified above and must be separated using a colon “:” without any new-line characters.

Keywords: apps software,concurrent application,concurrent applications,concurrent tutorial,java application,java concurrent program,java concurrent programming,java example,java examples,
java programming,java sample,java sample code,java source code,java tutorial,java tutorial program,oracle resume

Enabling Auto Order Functionality in Siebel v8.0 CRM /Error Code:SBL-APS-00802

2008-03-19T20:49:00.003+05:30

Hi Friends,

If you just installed Siebel CRM v8.0 & are facing issues with AUTO ORDER Functionality while using Quotes (Error: SBL-APS-00802), then you need to do some configuration changes before proceeding.

1) Firstly check whether you have all the workflow components enabled on the server
If not, enable the workflow component group.

2)Go to Sitemap>Administration-Server Configuration>Component Definitions>
Query for the component for which you want to enable the Auto Order functionality. Say for e.g. Sales
Now, in the Component Parameters Applet, Query for: 'Order Management - Enable Asse' & set its Value to: 'True'

3)Go Siebel_Server_Installation_Root\siebsrvr\bin\enu
Open the .cfg file for the application which you just enabled the Auto Order Functionality.
Under the '[InfraObjMgr]' add following line:
'AssetBasedOrderingEnabled = TRUE'
Save the file & close.
You need to do similar changes in your Dedicated or Mobile Client cfg's to enable the functionality.

4)Now restart your Siebel Services!
Order of Siebel Service Restart:
1)Stop the Webserver Service
2)Stop the Siebel Server Service
3)Restart Gateway Server Service
4)Start Siebel Server Service
5)Start the Webserver Service

5)Now go to Sitemap>Administration - Business Process>Workflow Deployment
Select All Workflows & click ACTIVATE

6)Now log out of the application & relogin to test your AUTO ORDER Functionality! It should be working now!

Enjoy!

Keywords: autoorder,auto order,siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, SBL-APS-00802

Siebel Thin Client Connectivity Fails/SWSE Configuration/Siebel Web Server Extentions Problem

2008-03-16T14:39:00.004+05:30

Hello Friends,

I was playing around Siebel CRM 8.0 Installation (Business Applications/Enterprise Applications)!
One of the most amusing aspect of the setup is the configuration & installation of Siebel Web Server Extensions (SWSE)!

I would like to point here one very common & specific reason why thin client connectivity fails almost always while configuring the first time!
While creating the SWSE Logical Profile, we are asked to give High Interactivity User & Standard Interactivity User

As you can see, i used GUEST & GUESTCTS as the High & Standard Interactivity Users respectively!
Well logically this should be true as its mentioned in the Siebel Installation Guide!
But the biggest problem is, your Database does not have GUEST or GUESTCTS users being created by Siebel.
These users should be created when we fire the grantusr.sql file before running Database Configuration Wizard!
But since they are not mentioned in the SQL Script, they are not created.

Due to this, after SWSE Installation, when we try to access the Siebel Application, we get following error:
"The server you are trying to access is either busy or experiencing difficulties. Please close the Web browser, open a new browser window, and try logging in again.[14:58:04]"

While the SWSE Log file shows:
"ObjMgrSessionLog Error 1 0000000847670820:0 2007-12-18 12:47:44 Login failed for Login name : GUESTCTS
ProcessPluginState ProcessPluginStateError 1 0000000847670820:0 2007-12-18 12:47:44 2112: [SWSE] Open Session failed (0x75eb4d) after 1.0381 seconds.
SisnapiLayerLog Error 1 0000000947670820:0 2007-12-18 12:47:44 480: [SISNAPI] Async Thread: connection (0x1a097e8), error (1180682) while reading message"

Resolutions / Workarounds:
We have two resolutions or workarounds for this problem:

Manually create users GUEST & GUESTCTS in your database and assign them SSE_ROLE
Use SADMIN as High & Standard Interactivity User in the SWSE Logical Profile

So thats the basic reason, why generally the Thin Client Connectivity fails most of the time!
Hope, if you are installing for the first time & having this problem, then by now your thin client must be up & running! ;-)

Keywords: analytics,business objects,crm,crm software,crm solutions,customer relationship management,data warehouse,ecrm,eim,erp,j2ee,pivotal,salesnet,service oriented architecture,sibel,siebel,siebel analytics,siebel crm,siebel software,siebel support,siebel systems,siebel training,web crm,workflow

Create Hidden Command Prompt/CMD/COMMAND Process

2008-03-16T14:20:00.002+05:30

Hi friends,

Being a Java programmer, i always have a wish that while distributing my programs, instead of creating some setup, i could just distribute it in a JAR file & launch it via a batch file!
But a batch file, means a command prompt window keeps running side ways!
There began my search for a way to create a hidden command prompt process!

I came across two good solutions:

Create Hidden Process (http://www.commandline.co.uk/chp/)
NirCmd (http://www.nirsoft.net/utils/nircmd.html)

Create Hidden Process is an excellent freeware which allows you to launch almost anything from command prompt & that too completely hidden!
For example, i participate in BOINC Projects (SETI@Home & Climateprediction)
Running the BOINC GUI Module consumes lots of RAM & CPU...so i always prefer to launch it via Console!
But launching via console means, i have to keep a command prompt window open!
Using CHP, i can easily create a hidden command prompt process as follows:
###########################
bhide.bat - Example to launch boinc console using CHP (Create Hidden Process)

CHP cmd.exe /c ""d:\User Profiles\skatdare\boinc.bat""
exit
###########################

###########################
boinc.bat - Example to launch boinc console (sub-batch file call)

cd\
cd pro*
cd boinc
boinc

##############################

So download Create Hidden Process from here!

NirCmd is an advanced command line tool which allows us to do lots of things without showing any user interface.
More detailed documentation for NirCmd is available here..
Download NirCmd from here!

So enjoy Hiding command prompts :-)

Keywords: batch file,batch file command,batch files,batch files command,batch files prompt,cmd,cmd command,cmd exe,cmd32,command exe,command prompt,command prompt commands,command promt,command windows xp,dos command,dos commands,dos prompt,j5,j7,j70,msdos prompt,windows 2000,command,windows command prompt,windows prompt,windows xp prompt,z5,z7

Connecting Nokia 6600 PC Suite v1.1.0 with Bluesoleil Bluetooth Dongle

2007-06-29T12:37:00.003+05:30

Connecting my Nokia 6600 PC Suite with a Bluesoleil Dongle was a big headache!
Earlier Bluesoleil version upto v1.4 worked fine with PC Suite v1.0 for Nokia 6600...but
ever since the PC Suite v1.1 for Nokia 6600 has been released & newer versions of
Bluesoleil coming up, connecting the both is a big problem!

I somehow though managed to connect it, so here are the steps for the same..

1)First of all you need the Bluesoleil Driver (http://www.ivtcorporation.com).
Please ensure that your Dongle supports Bluesoleil drivers. Not all dongles are supporting
the same.
I used the Bluesoleil driver Version: 2.1.3.0 Release: 060429 (Check Image Below)

2)After the driver installation, install the Nokia 6600 PC Suite, version 1.1.0
Download from: http://www.nokia-asia.com/nokia/0,,59279,00.html

3)PC Suite successfully installed, now diverts us to the mRouter Connection Settings...
There are various COM port options to be selected, and after many trials i found the
correct settings. Check the attached picture to select exactly what is required in your
mRouter Connection Setting Box!

4)Restart your PC

5)Insert your Bluetooth Dongle in USB & start Bluesoleil

6)Start bluetooth on your Nokia 6600 & press F5 on Bluesoleil window. This would search
your Nokia 6600 & list it.

7)Right Click the device listed & select PAIR DEVICE. Feed in any random number, say 123 &
when prompted on your mobile feed the same so that both the devices are paired to each
other!

8)Now double click your Nokia Mobile Device, & the services supported by it would be
highlighted!

9)Double Click the COM Port icon & it would ask, do you always want the service at COM port
automatically activated for this device? Say YES!
Now, it would prompt your mobile phone, saying the PC is requesting for connection, say
YES!

10)Once this is done, wait for few minutes, the mRouter would start blinking & say
connected.

11)Open the Nokia 6600 PC Suite, & it would say new phone found! Bingo!!
Thats it, take backups, restore or sync your mobile with PC Suite!

If you face any problems in this, just ask!

Enjoy the power of Nokia 6600 V1.1.0 PC Suite & Bluesoleil Bluetooth Dongles!!

Keywords: blue tooth,bluesoleil,bluesoleil 2.3,bluesoleil bluetooth,bluetooth,bluetooth dongle,cell phone,cell phones,cellphones,cellular,cellular phones,computer,free pc suite,gsm phones,ivt,ivt bluesoleil,mobile,mobile phone,pc bluetooth,pc connection,pc mobile,pc phone,pc phones,pc suite,pc suite 6600,pc suite bluetooth,pc suite software,phones,smartphone,software suite,usb dongle,wireless

Creating SYSTEM Folders in Windows XP (con, prn, aux, etc)

2006-09-30T18:17:00.002+05:30

Just curious around the working of Windows XP.. i found one interesting stuff!
Folders with name: CON, PRN, AUX, CLOCK$, NUL, COM1, COM2, COM3, COM4, COM5, COM6, COM7, COM8, COM9, LPT1, LPT2, LPT3, LPT4, LPT5, LPT6, LPT7, LPT8, & LPT9 cant be created using Windows Explorer or Command Prompt directly!

This is prevented as XP terms these folders as SYSTEM Folder Names reserved only for the Operating System..
But our curious brains dont stop pondering over such pessy stuff!

I searched around the net & found this trick to create system folders on XP through command prompt!

Try this:
CREATION
Syntax:md \\.\\$path
Example:prompt>md \\.\\C:\con
Explanation: This would create a folder named "con" on your "C Drive"

Similarly to delete such folder:
DELETION
Syntax:rd/s \\.\\$path
Example:prompt>rd/s \\.\\C:\con
Explanation: This would remove the folder named "con"!
Note: rd(Remove Directory) command is used with "/s" switch as otherwise it would give error that "folder is not empty"!

On another hand...if you ever wondered how to create a folder with no name...then try this:
Create a New Folder from Windows Explorer
Select rename & type: "ALT+255"(Use Numpad)..thats it!
ALT+255 stands for blank character in ASCII...so it still accepts your folder name!

Keywords: computer, file folders, information systems,network,operating systems,system,system 2000,system folder,system folders,system volume information folder,systems,technology,windows system folder,windows xp folders

Free Subdomains or Redirection URL's Available!

2006-09-10T23:47:00.001+05:30

Over the internet, there has been various subdomain & redirection URL services coming up...
Just thought of compiling the list here...

http://www.freeurl.com
http://www.jwdx.com
http://www.cjb.net
http://www.dot.tk
http://www.v3.com
http://www.hotredirect.com
http://www.internetjump.com
http://www.zdos.com
http://www.webalias.com
http://www.reduce.to
http://www.warping.to
http://www.gosurfto.com
http://www.shorturl.com
http://www.has.it
http://www.1fx.net
http://www.get-2.com
http://www.myredirector.com
http://www.tr.cx
http://www.kickme.to
http://www.dk3.com
http://www.suite.net/url.htm
http://www.ontheweb.nu
http://www.globalredirect.com
http://www.linkworld.to
http://www.rename.net
http://www.webmask.com
http://www.guruguru.to
http://www.6x.to
http://www.b4.to
http://www.b6.to
http://www.h3.to
http://www.thx.to
http://www.tsx.to
http://www.tsx.org
http://www.2fbi.de
http://www.ubb.cc
http://www.IDz.net
http://zwap.to
http://www.xsub.ws
http://www.elite.to
http://www.2fbi.de
http://www.b6.to
http://www.quickurl.com
http://www.iidd.org/
http://www.ne1.net/

Few of the best ones...
http://www.dot.tk/ (Top Level Domain(TLD) Redirection)
http://www.uni.cc/ (redirection & DNS Services)
http://www.acidmist.com/
http://www.freedomain.co.nr (Best service with no ads)

If you know any more or find few deadlinks...just post in the comment & i would add to the list for the compilation!

Missing/Disappearing Battery/Power Icon/Meter in Windows XP SP2 on Acer, IBM Thinkpad, Toshiba, etc Laptops!

2006-09-02T23:19:00.003+05:30

You got a brand new laptop with Windows XP SP2 & applied those Windows Update??
A few days later you get this annoying loss of POWER METER/BATTERY ICON from the system tray!

I did a few research & four possible solutions found are listed here...

Solution 1:
1. Right-click on My Computer, Click on Manage
2. Expand 'Services & Applications'
3. Highlight 'Services'
4. Look through list of services on the right....
5. Find Universal Plug & Play Device Host
6. Right-click on it.
7. Click properties.
8. Change startup type to 'Disabled'
9. Do exactly the same with 'SSDP discovery service'

Restart & you would get your Icon BACK!

Solution 2:
1. Open Control Panel > Add/Remove Programs.
2. In the sidebar, click on Add/Remove Windows Components.
3. Scroll down to Networking Services, select it, and click the Details... button.
4. Uncheck UPnP User Interface & other UPnP Service Listed.
5. OK your way out, close Add/Remove Programs, and reboot.
All tray icons should appear normally, without the need to log off and back on.

Solution 3:
1. START, RUN, type "regedit", then enter
2. Once in the Registry Editor, navigate the left directory tree to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run
3. Then right click on the right window pane, click new, then string value.
4. Give the new string value the name "systray"
5. Your new value should now have the name "systray", the type "REG_SZ", and no/empty data.
6. Right click on your new "systray" value and click "modify".
7. Now give "systray" the value data: "C:\WINDOWS\system32\systray.exe"
8. Click ok and close the Registry Editor.
9. Restart your computer.

Solution 4:
1. Save the following "systray.zip" file & unzip it to extract "systray.reg"
Download(Save Target As): http://geektalkin.somee.com/systray.zip
2. Double click the file to add the contents to registry!
3. Then restart the PC & it would be solved...
Source: Digiportal Software

Above is also the general solution for any other System Tray Icons Failing/Disappearing from Loading...
Apart from this, no other concrete solution has been yet discovered by me...

Another part you must be worried regarding the services disable & unistallation of UPnP stuff! Well..as of now UPnP is not much used, so you can safely do the steps as i said...until microsoft provides an solution in future releases!

If you have another uncommon problem like Windows XP/2K/2K3 Server showing wrong battery time, then you need to get a hotfix from Microsoft...
Read: http://support.microsoft.com/kb/889816

Please post the solution which worked for you as an comment to this post & also stat wat exactly was your problem, so others can be benefited from it!

Sources:
Google & Annoyances.org
Notes: This article has been tested on my Acer Aspire 3002NLC Laptop & also found to be working on other company models like IBM Thinkpad, Lenovo, Toshiba, Sony Vaio, etc..

Keywords: acer laptop battery recall,asus laptop battery,battery,battery management,battery meter,battery meters,battery power meter,battery status,battery tester,battery voltage,charger battery,compaq battery,compaq laptop battery,fluke meter,hp battery,hp laptop battery,hp notebook battery,hp pavilion laptop battery,laptop,laptop accessories,laptop accessory,laptop backpacks,laptop batteries,laptop battery,laptop battery charger,laptop battery li ion,laptop battery life,laptop battery meter,laptop charger,laptop computer,laptop computer battery,laptop computers,laptop power,laptop power supply,lithium battery,lithium ion laptop battery,nec laptop battery,nicad battery,nicd battery,nimh battery,notebook battery,notebook laptop battery,panasonic laptop batteries,power battery,
power meter,presario battery,presario laptop battery,recharge battery,rechargeable batteries,rechargeable battery,replacement batteries,replacement laptop battery,samsung laptop battery,sanyo laptop battery,series laptop battery,status meter,thinkpad battery
toshiba battery,toshiba laptop batteries,toshiba laptop battery,toshiba notebook battery
universal laptop battery,windows xp power meter,xp meter

Downloading Videos from YouTube, Google, Yahoo & Many Other Sites..

2006-08-31T19:36:00.002+05:30

Ever since YouTube shot to fame...many online video sites have come up!
People love to watch Videos Online...but few of them are so nice, that a copy on your HardDisk is a Must!
To facilitate the downloads...a superb plugin has been developed by "Javi Moya" called the Video Downloader!
Its a extension based for FIREFOX Browser...If you dont have firefox, just click the Download Button on the sidebar on page!
Next Download the extension from Mozilla's Official Website: VideoDownloader Extension
Installing the extension is simple & automatically done in Firefox!

Another online utility that can be used from right here allows you to get the download URL of your fav video..
Just suffix the URL of video, e.g.: http://www.youtube.com/watch?v=4cSRpu7bI04 to link below...& paste it in your browser address bar to get the download link instantly!
http://videodownloader.net/get/?url=

E.g.http://videodownloader.net/get/?url=http://www.youtube.com/watch?v=4cSRpu7bI04

Got the video you want??? But you want to play it back on the desktop!!
Get the FREE FLV Player which enables you to play the FLV format files from Youtube & various other sites...
Download: FLV Player

You got the Video...you played it back on your computer! But you want it on your iPOD too...
Yes its possible with the Replay Converter: Replay Converter

Various Video download sites covered by this extension are:
Angry Alien, Blennus, Blip.tv, Break.com, Dailymotion, Double Agent, eVideoShare, Free Video Blog, Google Video, Grinvi, iFilm, Keiichi Anime Forever, Metacafe, MySpace, MySpace Video Code, Putfile, Totally Crap, vidiLife, vSocial, AnimeEpisodes.Net, Badjojo, Blastro, Bofunk, Bolt, Castpost, CollegeHumor, Current TV, Dachix, Danerd, DailySixer.com, DevilDucky, Double Agent, EVTV1, FindVideos, Hiphopdeal, Kontraband, Lulu TV, Midis.biz, Music.com, MusicVideoCodes.info, Newgrounds, NothingToxic, PcPlanets, Pixparty, PlsThx, Revver, Sharkle, SmitHappens, StreetFire, That Video Site, VideoCodes4U, VideoCodesWorld, VideoCodeZone, Vimeo, Yikers YouTube and ZippyVideos.

Sources:
VideoDownloader Website: VideoDownloader
Google

Keywords: capture youtube video,download a video from youtube,download a youtube video,download from youtube,download video from you tube,download video from youtube,download videos,download you tube video,download youtube video,downloading video from youtube,downloading youtube,downloading youtube video,free videos,how to download a youtube video,how to download video from youtube,,how to download youtube video,how to save a youtube video,how to save youtube video,online videos,save a youtube video,save video from youtube,save youtube,save youtube video,saving youtube video,utube,video youtube com,videos,you tube,you tube video,you tube video downloader,youtube,youtube music video,youtube video,youtube video downloader,youtube video grabber,youtube videos

INTEX / ZEBRONICS Fake RTC8139D/RTL8139D Lan Chipset Drivers

2006-04-14T11:40:00.008+05:30

Continuing my further research on the low quality LAN/NIC cards available in India...
This new INTEX / ZEBRONICS card has chipsets printed saying RTC8139D or even RTL8139D....
But both these chipsets are fake...

The driver supplied with has to installed otherwise.. even Windows XP fails to autodetect and install it as a Realtek LAN Card...

The Drivers supplied are written by Silan MicroElectronics Inc, China (www.silan.com.cn)

I have tested both the cards from INTEX & ZEBRONICS with XP & SP2 and the drivers supplied worked well..
Here are those drivers which upon installation lists the LAN/NIC Card as Realtek 8139d Card..which is totally fake...
INTEX_NIC_Fake_RTL8139d.zip
Zebronics_NIC_Fake_RTL8139d.zip

Once again.. i would recommend everyone not to fall for these cards...due to low cost...
Go for standard companies like DLINK or INTEL..
Even Original Realtek Cards are available..but proper detection has to be done in order to confirm whether its original or not...
Original Realtek/Dlink/Intel based cards get automatically installed in Windows XP without any driver disk requirement...

UPDATE (27th October, 2009):

Intex Drivers can be downloaded from (Link Updated: 23rd September 2009):
Intex Technologies

or i have uploaded the latest drivers available on website to:
8139D_RTC Based Chipset
8139D_RTL Based Chipset

UPDATE (27th October, 2009)

TechCom Drivers can be downloaded from:
TechCom India

or i have uploaded the latest drivers available on website to:
8139dII_TechCom Chipset

Keywords: 10 100,,10 100 ethernet,10 100 ethernet drivers,device drivers,ethernet card driver,ethernet card drivers,ethernet controller driver,ethernet controller drivers,ethernet driver,ethernet drivers,fast ethernet,intex driver,lan 8139,lan adapter,lan driver,lan drivers,mtd,myson,network adapter driver,network adapter drivers,network card,network card driver,network card drivers,network controller driver,network driver,network drivers,nic drivers,pci ethernet drivers,realtek drivers,realtek rtl8139 lan,rtl8139 drivers,rtl8139c drivers,rtl8139d drivers,tech com,techcom,zebronic,zebronics