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

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

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]

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

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...


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

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