Thursday, October 13, 2011

How to Sort data in VBC

Business Requirement: Customer wanted to open a new IE window from within Siebel and freeze Siebel application until the new window is closed.


Technical Solution: Used Siebel browser-script function theApplication().ShowModalDialog() to achieve this requirement.The function "theApplication().ShowModalDialog()" opens a new IE window from within Siebel and does not allow any operation in Siebel application until the new IE window is closed.

The syntax for ShowModalDialog() function is as follows:

TheApplication().ShowModalDialog(sURL [, vArguments] [, sFeatures])

One of the server was showing status as Stopping since a long.

1. I killed the process from Task Manager

2. Siebel Services are getting up and showing up in the MS Services
3. Not showing as available server when checked by command line / application (Site Map -> Server Management)
4. Checked logs
5. found the issue as - SBL-SMI-00147: Version check failed because: Error: cannot get version of installed components (ENU sia)

Reason : File sslcver.dll got corrupted from ROOT\BIN\ENU

Resolution : copy file (sslcver.dll) from ROOT\BIN or ROOT\BIN\ (in our case it was ROOT\BIN\FIN as we have Finnish as one of the language) and put it in ROOT\BIN\ENU

Restart Services

NOTE: This may happen for ENUSIA or SIA

Pick List User Keys

In case of dynamic picklists, pick map may bring many fields,One of the tasks the integration object designer needs to perform is to determine which of these fields is used to identify the required field.
for example:

Consider a field Accout which is a dynamic picklist and contains many fields such as Account, Account Location, Account Integration Id, Currency Code,Price List, and so on

If the PicklistUserKeys user property on the integration component field that is mapped to the field with the picklist (in the example above: Account) is not defined, then any integration component fields that are mapped to columns in the U1 index of business component's base table, and are present in the pickmap will be used by the EAI Siebel Adapter to find the matching record in the picklist. (In the example above, this would be Account and Account Location.)

In cases where the default user key for the picklist does not satisfy your business requirements (for example, Account Integration Id should be solely used instead of the default user key to pick an Account), or you want to make the user key explicit for performance reasons, then use the

PicklistUserKeys user property.

Syntax  for Integration component Field User Property: 

Name: PicklistUserKeys Value : PickmapFieldname

Eg: Name: PicklistUserKeys Value : Account Integration Id

Friday, October 7, 2011

Assignment Manager

Normally after the Assignment Manager runs, it replaces the employees, positions previously set by users to the ones that match the assignment rules. But if in any particular case you want to ensure that the employees, positions added by the users is retained even after the Assignment Manager runs then go to Tools -> Workflow Policy Object -> Assignment Object and set the "Keep Manual Assigned " flag to True for the corresponding object. This will ensure that the old employees, positions added are kept along with the new ones added by the Assignment Manager.

Issue with respect to "Workflow Utilities/Echo" business service method during 7.8 to 8.1 Siebel Upgrade.

Setting property values using "Workflow Utilities/Echo" method to a Siebel Message follow the correct sequence.

Eg: If we want to set a property existing in a SiebelMessage, the sequence property should be arranged in a way so that the input argument "SiebelMessage" should contain the highest sequence.

Business Service/Method: Workflow Utilities/Echo

Input Argument:

Ignore Permission Errors OnDelete

This Integration component user property set to Y can be used to suppress the errors that arise from having the NoDelete user properties set to Y.


The error is ignored and processing continues.

For Example,

An Integration Object : Order Entry Orders IO has two Integration Components :

Order Entry - Orders and
Order Entry - Line Items (Parent IC : Order Entry - Orders)

Generally Orders have multiple line items.

If an Inbound request XML message contains Order record details ; and only few Line Item Record Details (Not all line items).

And if this input is passed to 'EAI Siebel Adapter' Business Service and Method Update

This Operation will update only the line Items as mentioned in Input XML message ; but will delete the line items which are not mentioned in XML Message

Only use of IC user Property NoDelete was giving errors.
To avoid this use Integration Component User Property for IC Order Entry - Line Items

NoDelete with value Y and IgnorePermissionErrorsOnDelete with value Y

Saturday, October 1, 2011

How to set more than 500 values in static picklist?

In Tools, at the business component called PickList Generic, you will notice that it has a property called Prefetch Size, which is by default set to 500.


There is also a related property called Maximum Cursor Size, which should be set to the same value as Prefetch Size.

If you change these values, you will be able to change the number of values displayed in the picklist.