HelloSiebelWorld

Salesforce.com – Object Dependency List for Data Migration

2012-02-17T06:32:00.001-08:00

Hopefully this will people who needs to check dependency every time before data migration. I have created two version one is pictorial and second on is tabular. If any correction is needed please reply back as comment to this post.

Object	Dependent on
Business Hours
Profile
Roles
Call Center
Data Category
Users	Profile, Roles, CallCenter
Solutions	User, Solution Category
Articles	User, Data Catergory
Queues	Users
Accounts	Users
Account Team	account
Account Partner Team	account
Contacts	account, user
Contact Role (Account)	Account, Contact
Products	User
Assets	Account, Contact, Product, User
Service Contract	Account, Contact, User/Queues,
Service Contract Line Item	Asset, User, Product, Service Contract
Entitlement	Account, Business Hours, Asset, Service Contract, Contract Line
Entitlment Contact	Entitlment, Contact
Cases	Account, Contact, User/Queues, Business Hours, Entitlement, Product, Asset
Case Comments	Cases
Related Cases	Cases
Contact Role (Cases)	Contact
Case Team	Cases, User/Contact
Case Articles	Cases, Article
Case Solution	Cases, Solution
Case Milestone	Case
Campaigns	User, Campaign
Leads	Campaign, User/Queue, Account
Campaign Members	Campaign, Contact, User, Lead
Opportunities	Account, Contact, User, Campaing, Quote
Opportunity Line Items	Opportunity, Products, Pricebook
Campaign Influece	Campaign, Opportunity
Opportunity Product	Opportunity, Products, Pricebook
Opportunity Contact Role	Opportunity, Contact
Similar Opportunity	Opportunity
Opportunity Partner	Opportinuty, Account
Opportunity Competitor	Opportunity
Quote	Account, Contact, User, Opportunity
Quote Line Item	Quote, Product, User, Pricebook
Contracts	Account, Contact, User
Contract Role	Contract, Contact
Contract Approved Item	Contract, User
Custom Objects	Depends on implementation
Activities	Child of almost all customer and/or standard objects
Notes and Attachment	Child of almost all customer and/or standard objects

Salesforce – Critical Update in my DE Org.

2012-02-13T08:48:00.001-08:00

critical updates details for reference. May or may not be applicable for everyone.

Salesforce – System Overview–first snapshot

2012-02-13T08:44:00.001-08:00

Good for Salesforce Administrator to see in single view

Salesforce.com–Data migration tools selection flow

2012-02-07T06:12:00.001-08:00

EXCEL – 2D to flat

2011-11-08T21:44:00.001-08:00

Input Data:-

Product VS Score	Resolution	Sound
HD TV	2	3
LCD TV	3	2

Expected output:-

Product	Category	Score
HD TV	Resolution	2
HD TV	Sound	3
LCD TV	Resolution	3
LCD TV	Sound	2

Create Excel macro and type below code. This will generate the expected output in Sheet2.

Sub Generate_Click()

    Dim oSht1, iSht1 As Worksheet
    Dim iRowNumber As Integer
    Dim iColNumber As Integer
    Dim iEndRowNumber As Integer
    Dim iEndColNumber As Integer
    Dim iOutputRowNumber As Double
    Dim i, j As Integer
    Set oSht1 = Sheet2
    Set iSht1 = Sheet1
    iRowNumber = 2
    iColNumber = 2
    iEndRowNumber = 3
    iEndColNumber = 3
    iOutputRowNumber = 2
    oSht1.Cells(1, 1).Value = "Product"
    oSht1.Cells(1, 2).Value = "Category"
    oSht1.Cells(1, 3).Value = "Score"
    For i = iColNumber To iEndColNumber
        For j = iRowNumber To iEndRowNumber
            oSht1.Cells(iOutputRowNumber, 1).Value = iSht1.Cells(j, 1).Value
            oSht1.Cells(iOutputRowNumber, 2).Value = iSht1.Cells(1, i).Value
            oSht1.Cells(iOutputRowNumber, 3).Value = iSht1.Cells(j, i).Value
             iOutputRowNumber = iOutputRowNumber + 1
        Next j
    Next i

End Sub

Salesforce :- “INVALID_SESSION_ID: Invalid Session ID found in SessionHeader”

2011-11-07T22:48:00.001-08:00

We have other system integrated with Salesforce using integration users. Recently we across error message after deploying new integration process in production instance. After looking deep into new deployed code, we found that we are using logoff in newly deployed integration.

Adding log off shouldn’t cause problem but if you go thru below then you will understand it is true.

Organization wide we have one single IP exposed to outside world.
Salesforce ties up the session to user id and ip address from where it is initiated. Salesforce has setting to tie up session id to source IP address. Setup > Security Control > Session Setting. We have this setting false, still salesforce ties up session to IP as organization wide we have single IP exposed.
Web application side, we were logging only once and all other instances were reusing the same session id or instance.
We did not faced this issue in TEST environment as there wasn’t enough load happening
Were able to figure out the issues using below pictorial method.

Application Instance consist of following

Apps I

Login
Process

Apps 2 –

Login
Process
Log off

We resolved this issue by removing logoff from newly deployed integration. Another approach was to use separate integration user which is not realistic as we will be needing to maintain multiple user and their user id, password and security token.

Siebel - Terminating/blocking user from Siebel application without changing LOGIN ID

2011-09-05T00:06:00.001-07:00

We change Login ID most of time when we need to block or terminate user from Siebel application. Whereas we can achieve this by configurations as well. In Vanilla Siebel we have field called as "Employment Status", by leveraging this field and using small configuration we can have more granular reason of blocking or termination of account.

To achieve this I have exposed this field on "Employee List More Info View" view as below.

Secondly I have added this field into "Login User" business component along with Search specification as [Employment Status]='Active' . Details are as below

With Employement Status as "Active", I was able to access Siebel properly whereas when change was made to other than "Active" got error message as below.

Note:- Please make sure that SADMIN, other proxy account and integration accounts are set to “Active” before rolling out new change.

Salesforce – Apex DataLoader and Automated migration interface

2011-09-02T05:12:00.001-07:00

Scenario :- We wanted to build the automated Employee interface which will create/update/terminate User inside Salesforce when changes are done in Organizational HRMS.

To build we have following options -

Use Apex Dataloader
Build Standalong Java apps and use Salesforce Webservices
Use of other tools like Apatar, OnDemandInformation etc.

Based on License/development cost and scalability we decided to use Apex Dataloader. If you wanted to use Apex data loader then either you can use the lastRun date to find out which records to interface or stamp status back to source data (Database table). If you decide to stamp status back to source data then dataloader does not provide the functionality to do that (atleast I am not aware :-) ). To achieve we wrote small java program which will use success file and error files generated by loader and will update the source database table.

Here is high level flow.

Flow:-
First run the data loader using configuration
once completed call java program with appropriate connection parameter and log file location. Java program will update the source records as success if found in success file and error if found in error file.

Enjoy :)

How to bypass Signal on Order Object while doing Quote to Order conversion using AutoOrderSalesQuote signal with Dynamic Pricing in Place

2011-08-28T23:06:00.001-07:00

We have dynamic pricing enabled in our environment with additional custom discounting defined for Quote and we convert Quote to Order just for integration purpose. When we convert quote to order - we are seeing following error message in log file all time. Sometime this stops whole execution.

Log file Error:-
Error invoking service "Context Service" method 'GetRowSetData'
Field: 'Additional Discount Flag' does not exists in definition for business component 'Order Entry – Orders'

GUI Error:-

Note:- Additional Discount Flag is custom field added for one of additional discounting.

Upon analysis we found that CalculatePriceAll signal is invoked and this error occurred.

There are following option to bypass CalculatePriceAll function on Order Entry - Orders which we use as placeholder for integration so no changes are required/expected on Order object.

Option I - AutoOrderSalesQuote uses "QuoteToSalesOrder" as a data map. Navigate to Administration -Application > Data Map Administration and select QuoteToSalesOrder. In Data map component select header and select "Skip Order Management Signals" on Destination Business component in Advance option.

For us this option I was configured whereas it did not worked as we had customization in Dynamic Pricing.

Option II - Add appropriate condition to skip the signal. Navigate to Administration - Order Management > Signal > Query "CalculatePriceAll" and click on "Lock" > drill down on Workspace

Option III - Modify "PSP Driver Workflow Process" workflow process with following details.
Screen shot before configuration

Configuration
1. Add "Mode" as process property in WF Property
2. I designed more add conditional step with default pointing to "End Step" and conditional branch to "". Condition to use "Mode" = "Quote"

We chose option III as first two options were not working due to customization in pricing and we did use Order object as placeholder for integration.

: : : E n j o y : : : :- )

View Siebel Repository details in Siebel Client Application

2011-08-22T00:50:00.001-07:00

IF you not aware, Siebel Tools works on Siebel's BO, BC, Screen, View concept. E.g. To find where Business component definitions are stored, select a Business component object in Tools and select Help > About View from Tools menu.

Upon selection it will popup the details wherein you will find Business object, business component, views etc as below.

If this information is available in Siebel Tools then we should be able to use this information and display within Siebel Client application. This was needed as we have Business Intelligence team who is somewhat familiar with Siebel Tools details. By making this information available in Siebel Client we are making team's job simpler.

To show one example, I have configured Application object for Siebel Client. To achieve this, I created two applets one for Application and second for screen tabs, added this applets to View,View to newly created Screen and Screen to one of Siebel Sales Enterprise (Application object). Finally add newly created view to user's responsibility. Final outcome will be similar to below screen shot.

Note:- If you use views found using Help > About view, it will not appear in Siebel Client. I tried the same and felt it is internally managed or due to repository views, secondly applet are having special class so web layout does not show anything inside Siebel Tools.

I have attached project export for reference, you job is only adding screens to existing application and view to user’s responsibility. Similarly you can built/expose all Tools objects inside Siebel Client. Only one thing to care – create applets as read only by setting “No Delete”, “No Insert”, “No Merge”, “No Update” to True as well as make views read-only at responsibility level.

Attachment:- Click here to Download Project Sif

: : : E n j o y :-) : : :

Assignment Manager Crash and SBL-GEN-03001: Error allocating DynArrCreate Organization Skill Item

2011-08-17T00:02:00.001-07:00

Approximately year back we faced this issue where Assignment Manager was crashing with "SBL-GEN-03001: Error allocating DynArrCreate Organization Skill Items" as error.Upon more analysis I found that this is memory related issue caused by huge orphan records in "S_BU_SKILL_IT". In our environment we are creating Organization Assignment condition and skill items almost on daily to support business requirement. Process we followed programmatically is delete organization conditions and recreate organization assignment condition as per latest data.

To be very specific, orphan records are due to cascade delete was set to None on "Organization Skill/Organization Skill Item" instead of "Delete".
Since this happened in production we had following option to choose from.

Short Term:
Delete records in S_BU_SKILL_IT which does not have reference in S_BU_SKILL. There is vanilla configuration which does not delete records from Organization Skill Item (S_BU_SKILL_IT) when Organization Skill (S_BU_SKILL) is deleted.
- Stop Assignment Manager and Batch assignment manager.
- Build pl/SQL script to delete records wherein there is no reference to s_bu_skill.
- Once delete is done. Delete rule cache for assignment manager
- Restart Assignment Manager and Batch Assignment Manager
Long Term:
Configuration change to set Cascade delete property to "Delete" for link "Organization Skill/Organization Skill Item"

Due to urgency we took short term approach and created pl/sql process to delete records from s_bu_skill_it and used below code to perform the operation and later on we pushed configuration change as well to resolve issue permanently.

declare
   cursor src is
              select row_id from siebel.s_bu_skill_it a where bu_skill_id not in (select row_id from siebel.s_bu_skill b where b.ROW_ID = a.BU_SKILL_ID) ;
    v_cnt number :=0;
    v_recipients varchar2(200) := 'email_address';
    conn utl_smtp.connection;
    v_err_msg varchar2(200);
begin
     FOR cur1 IN src LOOP
        EXIT WHEN src %NOTFOUND;
             delete from siebel.s_bu_skill_it where row_id = cur1.row_id;
             v_cnt := v_cnt +1 ;
             if v_cnt > 100000 then
                commit;
                v_cnt :=0;
             end if;
     end loop;
     commit;
commit;
exception
    when others then
        commit;
        v_err_msg :=substr(SQLERRM, 1, 200);
        DBMS_OUTPUT.PUT_LINE(v_err_msg);
end;

Call stack during crash:

sslcshar +0x190dc = SSstring::operator=() +0xc
sslcshar +0x25235 = CCFMiscUtil::GetAssertOnErrorList() +0x25
sslcshar +0x37f61 = scfErrorBase::LogError() +0x91
sslcasgn +0x41a2c = GetWLObjName() +0x9d0c
sslcasgn +0x4492b = StartRules() +0xfab
sssaasgn +0x2245 = CSSAsgnBase::operator=() +0x1095
sssaasgn +0x2f5c = CreateSmiMThreadObj() +0x3bc
sssaasgn +0x57c7 = ReqCompCleanup() +0x27
siebmtsh +0x96ec = SmiCleanupDetTask() +0x118c
siebmtsh +0x273c6 = SmiRegisterThrdCleanUpFunc() +0x2546
kernel32 +0x2f23b = ProcessIdToSessionId() +0x209
Other References : Doc ID 1103948.1

Minimizing downtime during Siebel Production Go-live

2011-06-20T07:03:00.001-07:00

You might not agree with me but I don’t believe in Zero downtime concept and prefer to follow below method to minimize downtime during production cut over/go-live and to avoid unknown issues that might come in future like additional maintenance of SRF.

Typically on production cutover we perform Dev2Prod which involve stopping application server, exporting repository from source, importing into target instance, DDL Synch, generating browser script and updating browser script on web server . This takes approximate 1-2hr. If there are new indexes/column level changes on big tables then this might take 2-3hrs plus additional time to create external indexes if any. This excludes additional task like EIM,data updates or administrative task.

If we follow simple steps below then we can minimize downtime on production cut-over.

1. Only SRF replacement
- go for only SRF replacement when there are not physical changes to table structure like column changes or indexes and no changes to repository based objects like Integration Object, Workflow policy etc.
- stop production environment, replace srf, generate browser script, update browser script on web server either by restarting web server or using http://hostname/eservice/start.swe?SWECmd=UpdateWebImages&SWEPassword=abcdef (Additional one time administration required)
-Total downtime required – approximately 30-45min

2. SRF replacement and SIF import
- to avoid repository migration along with SRF replacement, you can alternatively export objects sifs and then import into target instance.
- stop application server, replace srf, generate browser script, import sifs, update browser script on web server either by restarting web server or using http://hostname/eservice/start.swe?SWECmd=UpdateWebImages&SWEPassword=abcdef (Additional one time administration required)
-Total downtime required – approximately 45min

3. Repository migration and SRF replacement
- Export Siebel repository ahead of time from source environment
- go for this option when there is changes in repository based objects like Integration Object, Workflow policy, Workflows, Assignment manager changes.
- to identify whether there are changes in such objects or not you can write sql statement as below and execute against source environment to take decision. If those statement leads to DDL Sync then you should perform DDL Sync as well.

select last_upd from S_TABLE where repository_id in (select row_id from s_repository where name='Siebel Repository')
order by last_upd desc

select * from S_COLUMN where TBL_ID in (select row_id from S_TABLE where repository_id in (select row_id from s_repository where name='Siebel Repository'))
order by last_upd desc

select * from s_index where TBL_ID in (select row_id from S_TABLE where repository_id in (select row_id from s_repository where name='Siebel Repository'))
order by last_upd desc

- to minimize production downtime you can import repository ahead of time using below method and during cut over stop application server, rename Siebel Repository1 to Siebel Repository, generate the browser script and restart web server to update browser script. Alternative you can update web server browser script using http://hostname/eservice/start.swe?SWECmd=UpdateWebImages&SWEPassword=abcdef (Additional one time administration required)

rem
rem Usage: samp <SiebelHome> <ODBC> <LANG>
rem

set SIEBEL_HOME=D:\Siebel\Tools
set ODBC=SSD Local Db default instance
set LANG=ENU
set FLE=D:\Siebel\Tools\SAMPLE\UTF8\SiebelRepository.dat

rem Prior to New Seed Import, remove ENU records from Sample DB
echo Please press [Enter] if you want to import Repository

echo or Ctrl-C and terminate batch job if not.
pause

%SIEBEL_HOME%\bin\repimexp /a I /g %LANG% /u SADMIN /p SADMIN /c "%ODBC%" /D SIEBEL /M y /R "Siebel Repository1" /F %FLE% /L %SIEBEL_HOME%/sample/UTF8/imprep.log

- Total downtime required - approximately 45-60min

4. Full Dev2Prod process
- this is full migration process which involves export and import of repository, DDL sync, srf replacement, browser script generation and updating browser script on web server.
- Total time requires – upto 2hrs (time varies based on physical changes)

If option 4 is your choice then by keeping only max two repositories in Siebel database speed up import process.

Times Square 270 degree view

2010-08-25T20:13:00.000-07:00

Export Siebel Repository from Local database.

2010-07-13T12:55:00.001-07:00

Today morning I came to know that our database was refreshed and we did not exported repository from server. I felt like all our efforts wiped out which we put on Siebel patching activity and crash resolution from last month. But after spending some time I thought we can use repository export from local data base.I did small test which worked fine and I was able to get most of the configuration since I had synchronized (full get) local database copy few days before refresh. I thought to share details with you.

I created batch file with below details.

ExportReposity_Local.bat

Set SIEBEL_HOME=D:\SIEBEL\TOOLS

REM example USER=BDHOBALE

Set USER=<localDBG_User>

REM example PASSWORD=BDHOBALE

Set PASSWORD=<localDBG_Password>

Set LNG=enu

-- use odbc connection used For local tool

Set ODBC="SSD Local Db Default instance"

%SIEBEL_HOME%\BIN\repimexp /a E /g %LNG% /u %USER% /p %PASSWORD% /c %ODBC% /D SIEBEL /M y /R "Siebel Repository" /F customer.dat /L exprep.log

For repimexp parameter detail click here

Once you execute above batch file, you will see below window with progress.

Finally end result.

You can use repeximp to import exported file into local database but you need pass different parameters.

How to identify changed Siebel Objects from SRF to SRF

2010-06-08T12:31:00.001-07:00

For SOX compliance audit, change log is important. In Siebel application since everything goes in single Siebel repository files (SRF) and it become little difficult to capture which different objects are changed from last srf to new srf.

Our options:

Use Version control software to keep track of what’s changed. (preferred) -- Link
Manual change capture details in excel sheet per enhancement/change request
User Siebel 8.1 tools to find out which all object changed from srf to srf.

Using Version Control software

Siebel Tools does provide support to use version control software and handled by using srcctrl.bat file. By modifying this batch file you can integrate to one of below software.

- Microsoft’s Visual SourceSafe
- PVCS Dimension
- MS Team Foundation (No clear support document stating supported with Siebel)

Bottom line here is Siebel tools provides integration using srcctrl.bat file wherein it uses command line operation provided by version control software. Version control software provides functionality inbuilt which you can find which all objects changed from start date to end date or using comments. Refer document provided by software for same.

Advantage:
- VSS provides capabilities to generate the change details so no additional efforts are required to generate report
- Automated method of version control with integration

Disadvantage:
- Changes will not be captured if integration is either not enabled or not selected

Reference URL: Click here

Manual Change capture

This is least preferred choice but more reliable if documentation is imposed on developers. Typically I document information in below format (example along with).

Change Request#	Object type	Object Name	Comments
CR-1XB2B	Business Component	Account	Modified to add new field from extension table.

Advantage:
- VSS provides capabilities to generate the change details so no additional efforts are required to generate report
- Automated method of version control with integration

Disadvantage:
- Changes will not be captured if integration is either not enabled or not selected
- If missed changes will not be captured

Reference URL: Click here

Using Siebel Tool 8.1

Siebel has added capability from Siebel V8.1 onward to find out the differences in SRF. I tried to use the same for 8.0 SRF and worked fine for me.

Find details below for using same.
- Install Siebel 8.1 Tools with Sample database
- Copy SRF for which you wanted to find out differences. Copy these two files in Tools bin directory.
- Use following command to invoke differences

d:\sba81\Tools\bin\siebdev /srfdiff siebel.srf siebel1.srf" d:\sba81\Tools\object /u sadmin /p sadmin /d sample

- or use Siebel Tools UI –> Menu –> Tools –> Utilities --> Compare SRFs

- Once all process is completed you will find log in output file as below.

Advantages:
- No need of manual tracking
- It will shows what is added or removed from one srf to another and vice versa.

Disadvantage:
- It captures one change per object and does not captured multiple changes against same object for different change requirement i.e. If object is changed for two change request then it will only capture as object changed and does not shows how many times it is changed.

Reference URL: Click Here

Siebel support document

2010-06-08T08:40:00.001-07:00

How To Troubleshoot Memory Leaks on Microsoft Windows [ID 477521.1]
Support Considerations to address Siebel Performance Issues [ID 564848.1]
How To Analyze and Modify Sort Orders [ID 477590.1]
Performance Configuration Checklist [ID 475223.1]
Siebel Marketing 7.7 Testing and Troubleshooting Guide [ID 478103.1]
Master Solution To Assist with Debugging, Troubleshooting and Resolving Siebel Performance Behaviors in Siebel Versions 7.7.x and 7.8.x [ID 473846.1]
Siebel Server Administration Troubleshooting Guide [ID 477442.1]
View is slow but SQL is fast [ID 481522.1]
Troubleshooting Guidelines for Siebel 7.7 Workflow [ID 478275.1]
Siebel 7.7 Workflow Best Practices [ID 477992.1]
Siebel 8.0 Upgrade - Important Steps to a Successful 8.0 Upgrade [ID 475427.1]
Refreshing Siebel Web Server without restart - http://webserver/callcenter/start.swe?SWECmd=UpdateWebImages&SWEPassword=passwd - passwd is defined in eapps.cfg by the WebUpdatePassword parameter – Reference Doc Id: 476506.1 & 476490.1
Siebel Marketing Technical Reference Guide for Siebel Pre-version 7.7 [ID 477883.1]
Generating Execution Plans for Oracle CBO [ID 475230.1]
How To Analyze and Modify Sort Orders [ID 477590.1]
How to get a list of denormalized columns for a given base column (Doc ID 785073.1)
How To Turn Up Logging on the Siebel Web Server Extension in Siebel Versions 7.x and 8.x? [ID 477185.1]
Enable SARM in Web Server [ID 495138.1]
What Performance Issues Can Arise from Using the Force Active Property? [ID 475643.1]
Configuring Siebel Enterprise and Server for SSL [ID 522389.1]
How do you enable secure socket layer (SSL) communications between client web browsers and the Siebel Web Server (SWSE) in Siebel 8? [ID 554303.1]
How can you change the Siebel SADMIN password? (Doc ID 475791.1)
How can Tracing be Increased for Assignment Manager? (Doc ID 476619.1)
How to check all candidate score in Assignment Manager (Doc ID 762635.1)
Compare two different SRF of same version using srfdiff –> Link
How to Perform an Unattended or Command Line Tools SRF Compile for Different Languages? [ID 538671.1] URL
Performance Tuning Guide for Siebel CRM Application on Oracle [ID 781927.1]
Important information for a successful Siebel version 8.x upgrade [ID 980532.1]
Generating Execution Plans for Oracle CBO [ID 475230.1]
Database Performance Considerations - Where indexes can improve performance and where not [ID 742064.1]
Slow scrolling in list applet [ID 1128253.1]
WHITE PAPER FOR SIEBEL CRM WITH COST BASED OPTIMIZER ON 10g [ID 743170.1]
Users timeout and orphan sessions [ID 511611.1]
How can we rename the SADMIN accounts. [ID 863008.1]
Error changing sadmin password [ID 825624.1]
Siebel upgrade from 7.8.x or 8.0.x to 8.1.1.x [ID 259.1]
Troubleshoot "couldn't enumerate buscomps" error message [ID: 1177784.1]
How To Troubleshoot RDBMS Errors Caused By Deleting Repositories Via Siebel Tools [ID 789849.1]
Performance Behaviors Related to eScript in Siebel Tools 8.x (Doc ID 475430.1)
Use the Same eScript Engine To Develop Coding, Compile the SRF, and Run the Application (Doc ID 478161.1)
Tools Debugger highlighting wrong line (Doc ID 497294.1)
eScript Engine (Doc ID 501428.1)
How to Configure the About View Popup Applet in the Standard Interactivity Mode Siebel Applications? (Doc ID 476804.1)
how to open a custom frame using eScript (Doc ID 488556.1)
Style Sheets (Doc ID 492208.1)
Removing buttons from partner portal application (Doc ID 544305.1)
764097.1 Siebel Reporting 8.x Migration FAQ
1117126.1 How to Configure Siebel 8 and BI Publisher in a Web Single Sign On Environment
1299481.1 Campaign Wave Launch Remains in Status "In Progress"
1221825.1 (Siebel) Support For Office 2010
1103065.1 How To Implement Siebel Security For Siebel BI Publisher 8 Reports With LDAP/ADSI Authentication
823360.1 Siebel BI Publisher 8 Reports Business Service
838460.1 Siebel Application Timeout Setting Guideline
811104.1 Siebel BI Publisher 8 Integration Concepts
728578.1 For best performance in which table should custom extension columns be created?
554203.1 Which intersection table for new Opportunity to Product M:M relationship?
556846.1 How To Create Integration Object Instances Programmatically
1298932.1 Why Installation of Siebel 8.1. x eMail Marketing Server ESD component is failing on Windows 2008 ?
726615.1 Specify search specification on applet populated using Caching VBC.
1298395.1 How To Deploy Sample SOA BPEL
859193.1 How to increase the HTTPSleepTime for the Siebel Reports Integration With Oracle BI Publisher
511097.1 Can EAI File Transport be used to write the output of Data Mapper to CSV file ?
477909.1 How Do I Display a Decimal Value in a Calculated Field Whose Value is Based on Condition?
534938.1 Save the same Decimal Digits as shown in UI
476536.1 Data type mismatch between fields in business component and columns in table
1134918.1 Workload Assignment Across Multiple Objects
483328.1 How To Automate Proposal Generation
834594.1 Is there vanilla business service to find working day
1296641.1 Get Excel Range From Escript/Vb
523812.1 Siebel Analytics with Oracle Partitioning
1295917.1 Need To Develop A B2B Integration For Client Using AIA And PIP
1295646.1 How to Prevent Assignment Manager from Assigning Organizations
738286.1 How to Backup Tools/Local databases with Siebel
477324.1 How To Troubleshoot Messages Generated while Running the Repository Upgrade in Siebel Versions 7.x and 8.x
266043.1 Support of Linux and Oracle Products on Linux
Smaller Changes in the appearance of the UI [ID 579649.1]
How Can You Inactivate or Suppress Applet Menu Items and Application Menu Items for an Applet? Can the order of the Applet Menu Items be changed? [ID 473948.1]
How To Test Siebel Inbound Web Services Using a Siebel Client [ID 473838.1]
Troubleshooting Guide for Document Server [ID 477788.1]
How To Troubleshoot Messages Generated During the Repository Merge in Siebel 7 and 8 [ID 477269.1]
Siebel Server Administration Troubleshooting Guide [ID 477442.1]
Siebel Data Validation Manager (DVM) Examples [ID 478298.1]
How To Use FINS Data Transfer Utilities in Siebel Applications Versions 7.7.x and 7.8.x [ID 473861.1]
808236.1 EIM job not logging transactions to file
475740.1 EIM error: "The selected record has been modified by another user since it was retrieved"
475597.1 How Can You Tune Your EIM Batches To Improve Performance?
476599.1 How can users dynamically inactivate button when no records are displayed in Siebel version 7.x and 8.x?
476567.1 How are index hints used in an Enterprise Integration Manager (EIM) process?
493124.1 How Is Quote Approvals Functioning?
523821.1 How Is the Functionality Behind Campaign - Create Opportunity Button/OnCreateOpptyClicked Method?
476458.1 What are the different tracing levels that can be set during an Enterprise Integration Manager (EIM) process?
824104.1 How to print all applets instead of a single one
1078695.1 How to encrypt the Credit Card Verification number (Verification Number field) and mask it via Siebel vanila configuration?
1302994.1 How to Trace ESD,BHD and CTD Daemons of Siebel 8.x eMail Marketing Server
488790.1 Clearing Object Manager Cache Through Command Line

Not related to Siebel…How to stop texting while driving ?

2010-06-07T20:06:00.001-07:00

I get scare whenever I see any person texting/talking and driving at same time, I give space for him to go. Reason behind is you never know what could happen if failed to focus on driving while on interstate or busy road.

Yesterday night I was looking statistics for texting and driving at same, almost every search I see accident in it. Some example searches are here

After going thru search result, thought came to my mind is how to stop texting and driving at same time, again talking over phone while driving is almost at same risk as texting and driving.

Now a days mobile comes with GPS enabled device so what not to take a advantage for blocking texting/talking while driving.

Simple logic to implement. If mobile device is detecting change in GPS data/location then block the key pad or disconnect current call or only display incoming call as message but disable to attend call unless it is stationary. While considering this we have to consider allowing emergency calls like 911.

Again I am not expert in GPS or mobile technology whereas simple blocking mechanism while mobile device is detecting change in GPS location will help to save lives.

Similar to this we should have something to block texting while in meetings too :)

Thanks

Technorati Tags: Texting,driving,mobile

Siebel User Usage Statistics

2010-06-04T08:54:00.001-07:00

For any application user statistics is very important. Usage show how frequently system is used used. For long time we wanted something for Siebel which will give clarity about system usage . We worked with Siebel and there was nothing to use and raised enhancement request CR# 12-1Y63OAN (Doc Id: 1116263.1). And last week I saw posting about some methods which we can use to achieve (Siebel Usage Collection) which triggered my thought to build something on similar way.

What are our options ?

Use Runtime events and business server : Usage Tracking Service --> Oracle bookshelf reference
This method is primarily used for capturing view activation hits and writes log into CSV or XML file which later can be analyzed.
Use Runtime events and customer business service and capture Application login event.
Wait for CR#12-1Y63OAN fix pack

Here I will explain on second option to achieve.

What we need ?

New runtime action event to capture Application Logon
Customer business service to capture details.

Business Service Details:
- SRF based
- Application business service (preferred)

Steps:

1. Login to Application and navigate to Site Map > Administration - Business Service and create new business service. Name it as per your naming stanard. For testing purpose I created TEST_BS

2. Create new method

3. Add logic to capture the details
For testing purpose I have captured few details and writting to log file. You can use custome logic as per your required. For example: store login instances against users, needs some tools configuration.

Code:
function Service_PreInvokeMethod (MethodName, Inputs, Outputs)

{

if(MethodName=="Test") 
{ 
var strString:String; 
var strString1:String; 
var dtDate:Date; 
dtDate = new Date(); 
strString1 = "" + dtDate.getMonth() + "," + + dtDate.getDay() + "," + + dtDate.getFullYear(); 
strString = 'Application Login Event,' + TheApplication().LoginName() + ',' + TheApplication().GetProfileAttr('ApplicationName') + ',' + strString1 + dtDate ; 
TheApplication().TraceOn("\\\\sharedDrive\\usage_$p_$t.log", "Allocation", "All"); 
TheApplication().Trace(strString ); 
TheApplication().TraceOff(); 
return(CancelOperation); 
}

return (ContinueOperation); 
}

4. Time to test.

Open shared location as in business service.

Once you open log file you will output as below.

5. Associate Runtime Event with Business service.

Navigate to Site Map > Administration - Runtime Event > Action Set and create record as follows.

Navigate to Events and associated run time event with action set

Once all set up is done please do not forget to reload the personalization.

With this step you are all set and all the logins into system are getting captured.

Have fun.

How to Create Siebel Like custom Tables (S_*) or Column within Tables without X_

2010-05-14T10:25:00.000-07:00

Creating custom column in Siebel provided tables, Siebel tools always adds X_ prefix and disabling "SymStrPrefix" parameter in tools.cfg does not help either.

So I came across backdoor solution to create custom columns in Siebel provided table. Again this method is not supported by Siebel. In my opinion X_ prefix is only to differentiate whether vanilla columns or custom columns, it does not provide any other meaning to me.

Here are steps for creating customer column in S_ORG_EXT without having X_ prefix.

Lock S_ORG_EXT table locally

In Column, create new column with name as TEST and populate all other properties. Once you save or step off from current record, tools will automatically rename as X_TEST

Next steps is to add S_ORG_EXT table object into archive. In Table Object , query for S_ORG_EXT and right click on it and select Add to Archive as below and same as S_ORG_EXT.sif on desktop.

Once sif file is created, open S_ORG_EXT.sif with any text editor and search for the column which we created X_TEST and change it to TEST and save file.

Now at this stage we have sif file modified to re-import into Tools. Open Siebel Tools and select Menu bar > Tools > Import from Archive and follow below steps.

With above steps we will be over-writing all configuration with configuration in file. To verify select table object and query on S_ORG_EXT and query on *TEST* in column.

Similarly you can create custom siebel table which starts with CX_.

Custom Siebel Component Monitoring Utility

2009-09-28T13:48:00.000-07:00

This post describe how custom monitoring tools can be developed to monitor siebel component.

Development of custom monitoring tool consist of following steps.

Steps:-
1. Get statistics
2. Spool statistics
3. Parse statistics
4. Send Alert
5. Building Wrapper

1. Get Statistics
To get Component statistics you can use srvrmgr utility provided by Siebel/Oracle. srvrmgr utility provide details for the component. For more about srvrmgr utiltiy please refer book shelf.

srvrmgr command provide differnt command out of which we will be using list component command. For demonstration purpose we are restricting out of this command to show statistics for component which start with Name SR%.

So final command will be as below.
list component SR%

Output this command is not really formatted well. So we will use different pre-command to format output, which we can parse to send alert.

set footer false
set header false
set delimiter ,

With about setting in place command will only return result related to component SR% without any addition heading or footing as such.

2. Spool statistics
Next step here is to spool the output of step 1. srvrmgr utility also provide the spooling feature. You can execute below statement to enable the spool.

set spool on
set spool c:\a.txt

3. Parsing statistics
Once you spool output of list component command, we need to build parsing utility or use one available with you. I have used my own utility which is VBS based as below.

4. Send Alert
Sending Alert is also important steps because we don't want to monitor system all time. So with parsed out you can send those thru email alert or to pager as per your requirement. I used VBS with CDO component to send the alert.

here is code which I have appeneded at bottom of code in step3.

5. Build wrapper

Building wrapper is last step because this the one which will be running all time and communicating to other component and results will be send to email.

Files Involved:-

1. CustomComponentMonitorUtilityWrapper.bat :- It's wrapper which calls srvrgmr command and parses the output using VBS and send alert.

2. servercmd.txt -- srvrmgr commands used to get the statistics

3. CustomComponentMonitorUtility.vbs - used to parse output and sends an email alert.

CustomComponentMonitorUtilityWrapper.bat

servercmd.txt

CustomComponentMonitorUtility.vbs

Output after running wrapper

Unattended Repository Migration

2009-08-11T13:53:00.000-07:00

Place holder.

Automated Process for Stop and Start Siebel Service

2009-08-11T13:52:00.000-07:00

Place holder.