Dynamic Pricing - Siebel 8.1.1.x and above

Hi Friends,

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 (Complete Manual Instructions), but now that is no longer the case from Siebel 8.1.1.x and above versions :-)

Dynamic Pricing can now be enabled at a click of a button from:
Sitemap -> Administration - Pricing -> Pricelists -> Menu -> Enable Dynamic Pricing

Hope this tip helps!
Enjoy!

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

IE8 - SBL-UIF-00296: You already have a web browser accessing the current web session.

Hi Friends,

With Siebel CRM recently releasing IE8 compatibility, one common issue faced on day one is
"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"

No matter what you do, you are not able to open multiple Siebel instances in IE8!
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.

The correct way to resolve this is to start a new IE8 Siebel Session using
a) File -> New Session or  [From IE8 UI]
b) iexplore.exe -nomerge   [Command line -nomerge option]

This way we explicitly instruct IE8 not to replicate session allowing us to open multiple Siebel instances.
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.


Hope this tip helps :-)

Keywords:
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, etc

Siebel Bookshelf (v8.1,v8.0,v7.8,v7.7,v7.5,v7.0,v6.3,v6.2,v6.1,v6.0)

Hi Friends,

One common requirements we have in our day to day Siebel Activities is the Siebel Bookshelf. Its the ultimate knowledge power house regarding Siebel.

Below are the links you need for different Siebel Versions:

Siebel 8.1.x http://download.oracle.com/docs/cd/E14004_01/homepage.htm

Siebel 8.0.x http://download.oracle.com/docs/cd/B40099_02/homepage.htm

Siebel 7.8.x http://download.oracle.com/docs/cd/B31104_02/homepage.htm

Siebel 7.7.x http://download.oracle.com/docs/cd/E05553_01/homepage.htm

Siebel 7.5.x http://download.oracle.com/docs/cd/E05554_01/homepage.htm

Siebel 7.x http://download.oracle.com/docs/cd/E05555_01/homepage.htm

Siebel 7.x Mid-market Edition: http://download.oracle.com/docs/cd/E05565_01/homepage.htm

Siebel 6.x http://download.oracle.com/docs/cd/E05556_01/homepage.htm

Siebel Online Help Files and Help Development Kits

Enjoy!

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

SBL-GEN-03001: Error allocating (null)

Hi Friends,

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

Logs files were showing up following dump:
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

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

Due to this, Siebel Assignment Manager component was not getting started & constantly crashing. If you start, it will again stop & crash after few minutes.

This behaviour is particularly related to Physical Memory availability to the Assignment Manager component.
You can setup following log level for your Assignment Manager component to have a quick informative trace regarding the issue:

   1. Object Assignment = 4
   2. Rules Evaluation = 5
   3. Loading = 4
   4. Assignment Manager Generic = 4
   5. SQL Tracing = 2
   6. SQL Parse and Execute = 4
   7. Task Configuration = 4
   8. Component Tracing = 3

In our environment, this issue came up suddenly so it definitely wasnt an Siebel Product issue but something to do with our environment changes.
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.

The only way to resolve this was to follows below steps:
1) Stop Assignment Manager & Batch Assignment components.
2) Delete rulecache.dat file under $SIEBEL_ROOT/siebsrvr/bin
3) Delete or expire all unwanted Assignment rules
4) Start Assignment Manager & Batch Assignment components
5) Allow the new rulecache.dat file to be generated.
6) Now check log to see if Assignment Manager component is still shutting down.

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.

You may also notice 0KB crash_xx.txt files under $SIEBEL_ROOT/siebsrvr/bin until you resolve this issue.
Enjoy!

Keywords:
siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, assignment manager, crash.txt, FDRs, etc

Ektron eWebEditPro5: Run time Error '0'

Hi Friends,

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!

After you apply the fix pack for Siebel Web Server Extension (SWSE), it upgrades the existing eWebEditPro editor from v4 to v5.

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 eWebEditProLibCtl5 saying, "Run time error '0'"

 In order to resolve this, you will need to edit the webeditorctrl.htm file under /$SIEBEL_SWSE_ROOT/public/enu/webeditor/

Find out the below code:



and replace it with below code:



After you do this, make sure you do a CLEAR CACHE in your browser else it will still show Javascript errors like:

This happens as the old webeditorctrl.htm file is used from browser cache for loading eWebEditPro Editor.
So ensure you do a clear cache without fail!

Hope this helps resolve patching issue.

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

8.0.0.8/8.0.0.9 Fix Pack Installer Hangs

Hi Friends,

On Linux/Unix Platforms, if you try to start 8.0.0.8 or 8.0.0.9 Fix Pack Installer in console mode (./setuplinux -console), you might see that the installer hangs after you proceed the instance to be patched step!

Further investigation led me to find out that the Fix Pack installer tries to install mandatory Oracle Configuration Manager (OCM) before the actual Siebel Patch Installation begins... As the OCM installation is launched in a separate typical Oracle 11g Database Installer type setup, it fails to launch in console mode due to which the entire setup lies in a hung state :(

The only current workaround is to start the start Fix Pack installer in UI mode so that the mandatory OCM installation completes successfully and you are allowed to proceed ahead for Siebel Patch Installation!

Read about another 8.0.0.8/8.0.0.9 Fix Pack Setup issue you might come across:
http://geektalkin.blogspot.com/2010/04/setupproductinstall-utility-err-unable.html

Keywords:
siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems,8.0.0.8, 8.0.0.9, Fix Pack, Siebel Patch, OCM, Oracle Configuration Manager, etc.

Installshield Installer JRE issue

Hi Friends,

Java based installshield installer comes with its own bundled JRE. If this bundled JRE gets corrupted, then you will be in a great pain to start the installer as it will report errors like:

This application requires a Java Run Time Environment (JRE)
         to run. Searching for one on your computer was not successful.
          Please use the command line switch -is:javahome to specify
          a valid JRE.  For more help use the option -is:help.

Even though you try to specify a valid JAVA HOME using -is:javahome option, still the installer will fail to start & keep giving me the same error, the reason being installshield needs a very specific JRE & it wont accept any JRE passed as an -is:javahome option!

Such particular issue is encountered with Siebel Uninstallers on Linux/Unix platform.
Siebel product uninstallers exist in /$SIEBEL_ROOT/_uninst/uninstall.ksh

You need to start the uninstaller by passing the product name as an option:
E.g. If we need to uninstall Siebel Web Server Extensions (SWSE), then we would invoke the uninstaller as:
./uninstall.ksh eappweb

Now, if you receive the JRE issue, then there is pre-extracted Installshield JRE which is corrupted.
Such JRE exists in the Product directory which you are trying to uninstall:
e.g. /$SIEBEL_ROOT/_uninst/eappweb/_jvm

In order to fix this issue, the only option you have is to restore the _jvm directory from backup or copy the contents of _jvm from a different machine having similar Siebel Setup & overwrite the contents in the corrupted JRE directory.

While i was researching on this issue, i came across solution for IBM Product Installshield Installers, was to setup the below Environment variable to successfully bypass this error:
set JAVA_COMPILER=NONE
or
export JAVA_COMPILER=NONE

Hope this info helps if you come across installshield issues.

Keywords:
siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, Installshield, JAVA, JRE, JVM, Uninstaller, JAVA_COMPILER, etc.

Setup.product.install, Utility, err, unable to launch (SBL-STJ-00152)

Hi Friends,

As Siebel 8.0 is evolving, we have new annoying bugs to face!
From Siebel 8.0.0.8 Fix Pack onwards, you might face an error like:

(Mar 29, 2010 5:57:33 AM), Setup.product.install, Utility, err, unable to launch: "\\server1\d$\Siebel_Install_Image\8.0.0.9\Windows\Server\Siebel_Enterprise_Server/Disk1/install/setup.exe -waitforcompletion -nowait ORACLE_HOME="d:\sba80/gtwysrvr" -defaultHomeName -responseFile \\server1\d$\Siebel_Install_Image\8.0.0.9\Windows\Server\Siebel_Enterprise_Server/Disk1/stage/response/NTOCMCD.rsp" error code: "-1"(SBL-STJ-00152)
(Mar 29, 2010 5:58:41 AM), Setup.product.install, InstalledProductsPanel, err, Not able to stop the server. Please stop the server
manually and run patch installation again.(SBL-STJ-00101)

If you note, i was trying to apply 8.0.0.9 Fix Pack from a network shared location. Like always,  i expected this to work perfectly fine as with earlier Patch Installs, but this time it errored out!

Well, further investigation led me to find out that, the Fix Pack installer tries to install mandatory Oracle Configuration Manager (OCM) before the actual Siebel Patch Installation begins...
The OCM installation is launched in a separate typical Oracle 11g Database Installer type setup, which fails to launch when we have invoked the parent Siebel Patch setup from a network shared location!

In order to workaround this issue, you need to copy the extracted Patch Installer, like for Siebel Enterprise Server to a local machine drive where you are trying to apply the patch.

As of now, this is no mechanism to bypass OCM installation, though OCM has nothing to do with Siebel Patching Process as such.

If you do not want OCM, post-installation, re-run Oracle Installer & deinstall the OCM. Oracle has acknowledged that OCM installation should be optional, so lets see when they add the optional functionality in the installer.

Till then breathe a sigh & proceed with the Patch Installation :-)

Keywords:
siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, SBL-STJ-00152, SBL-STJ-00101, 8.0.0.8 Fix Pack, 8.0.0.9 Fix Pack, Oracle Configuration Manager, OCM, etc.

SBL-DAT-60171: End of the log stream is reached

Hi Friends,

This is an amusing bug [SBL-DAT-60171: End of the log stream is reached] in Siebel 8.0 which is dumped in your log files while accessing Audit Trail fields.
Its related to database as its dumped via sqllog.cpp (671) file.

This error comes when GetAuditTrail method is called via script.
So far this issue exists in Siebel 8.0 till 8.1.1. There is no uncertain application behaviour noticed due to this error, but just a dump in the log.

Its already logged as a bug, but so far no fixes have been released for the same.
If this error is in your logs & do not create any related problem, then you can safely ignore this error.

Enjoy!

Keywords:siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, SBL-DAT-60171, Audit Trail, Logs, etc

SBL-EIM-00205: NULL target table for relation

Hi Friends,

You can encounter SBL-EIM-00205: NULL target table for relation error while running an EIM Job in Siebel 8.0!
This issue is peculiar to Siebel 8.0 & above as this is caused to erroneous EIM Mapping when you have enabled Case Insensitivity (CIAI) on one of your base table columns.

When you enable CIAI (Case Insensitivity Accent Insensitivity) on one of your base table columns which has indexes on it, it will create another column corresponding to it & create CIAI indexes on the same to achieve the functionality.

For e.g. If you have created a new column on S_ORG_EXT say Column X_A having indexes on it & then you enable CIAI on it, it will create a another column called X_A_CI & create CIAI index on top of it. So internally whenever in application you query on column A, it will be driven by the CIAI Column created & the index associated to it.

This is good to achieve Case Insensitive & Accent Insentive stuff on a column, but when you move forward & run the EIM Column Mapping Wizard as its a new column, it will create mappings for both, i.e. Column X_A & Column X_A_CI in the EIM Mapping!

This mapping of X_A_CI column creates an issue with EIM which causes it to fail with SBL-EIM-00205 error!
In order to resolve this, you will need to manually delete the X_A_CI column mapped into the EIM Table  [EIM_ACCOUNT (For S_ORG_EXT)].

Delete this mapping & apply EIM table changes on the table & then do a DDLSYNC on the server. Delete eimcolrelcache.dat & diccache.dat before restarting the server.
Once the server is up, try running your EIM Job, it should no longer fail with SBL-EIM-00205 error. Also this has been acknowledged as a bug, so lets wait for Siebel to fix it. Until then this is the only workaround available.

Enjoy!

References:
How to DDLSync?
How to run CIAI wizard?
How to run EIM Column Mapping Wizard?


Keywords:
siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, EIM, EIM Mapping, Extend Base Table, Enterprise Integration Manager, CIAI, Case Insensitive, Accent Insensitive, SBL-EIM-00205, etc

How to run EIM Mapping Wizard?

Hi Friends,

Its a common activity where in you extend a base table for your customization requirements & then also need the same column available for data loading using Siebel EIM (Enterprise Integration Manger).

Here, i will walk you through simple steps to run EIM Mapping Wizard. For our example i have extended a column in S_ORG_EXT & want to map the same in EIM_ACCOUNT.

Steps:
1) Lock EIM_ACCOUNT & S_ORG_EXT Projects in your Siebel Tools
2) Go to S_ORG_EXT Table from object explorer in Tools & right click the same to select EIM Table Mapping:

3) Now, Interface Table Mapping Wizard opens up which shows all the EIM tables to which S_ORG_EXT has been associated. Since we want to map our new column in EIM_ACCOUNT, select EIM_ACCOUNT from the list & then click Next:

4) Moving ahead, click finish to let the Mapping Wizard actually map the columns in EIM_ACCOUNT Table:

 

  

  

5) As you saw above the EIM Table mapping has completed successfully. Now in order to reflect the same physically in your database, either go to EIM_ACCOUNT in Tools & use the "Apply" feature or do a DDLSYNC.

This completes the EIM Mapping. Its short & simple!

References:

How to run DDLSYNC? 

Keywords:

siebel crm,siebel customer relationship management,siebel solutions,siebel support,siebel supportweb,siebel systems, EIM, EIM Mapping, Extend Base Table, Enterprise Integration Manager, etc

Genbscript Error: Couldn't enumerate buscomps (initial)

Hi Friends,

This is one of the rare errors which you might get while generating browser script after compiling an full SRF.
Couldn't enumerate buscomps (initial)

This error happens basically when you have a EBC in your SRF while the CFG you are pointing to generate the Browser Script does not have the External Datasource information captured.

Quite puzzled as you must be having the External Datasource configured at Siebel Enterprise Profile Configuration, then why this issue?
Well, if you carefully observe the genbscript command (genbscript "%SIEBEL_ROOT%\siebsrvr\bin\enu\siebel.cfg" "%SIEBEL_ROOT%\siebsrvr\webmaster\enu" enu), we refer to a local CFG, while since we are configuring all the Enterprise Setting through Admin-Siebel Configuration, the changes are directly reflected in our siebns.dat via Gateway & not the local application CFG.

Thus to overcome this issue & generate all the browser scripts successfully, simply add a dummy holder in CFG for the External Datasource:

Steps:
Open your local application CFG (e.g. siebel.cfg (%SIEBEL_ROOT%\siebsrvr\bin\enu)
Add Under
[DataSources]
EDSNAME=EDSNAME    (Here EDSNAME is the actual External Datasource Name configured in Enterprise Profile Configuration)

Add after [ServerDataSrc] block completes:
[EDSNAME]

Thats it! Save the CFG & you are all set for a successful genbscript!

Keywords:
siebel crm,siebel, siebel systems, genbscript, siebns.dat, External Data Source, EBC, External Buscomp, siebel tools, siebel dev, SRF, siebel repository, etc

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)

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

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

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

Siebel SRVRMGR Utility - Spool [HOWTO]

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

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

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