EAI Object Manager Parameters for Tracing SQL and Log

EAI Siebel Adapter Performance

EAI Query Specification
EAI Siebel Adapter
EAI UI Data Services Events
Web Service Inbound
SQL Error
SQL Parse and Execute
SQL Slow Query
Workflow Performance

How to use OPATCH to install QF?

How to Install QF from 8.1.1.1 using oPatch [ID 845450.1]

Basic Rules:

1. To apply Patch on Mobile Web Client/Tools, change directory to webclient\OPatch & Tools\OPatch folder
2. Run the command "OPatch apply




"

Visibility

HOWTO use session management web services to log in as SADMIN and create data under a different user ? [ID 747584.1]

Visibility Search Spec of Siebel

My Quotes - [Sales Team Rep Id] = PositionId() AND [IsPCQuoteType] = 'N'


My Team's Quotes - [Sales Rep Reports To] = PositionId() AND [IsPCQuoteType] = 'N'


All Quotes  - [Organization Id] = OrganizationId() AND [IsPCQuoteType] = 'N'


All Quotes Across Organization - No Search Spec

How to increase the EAI object manager log

To produce the EAI Object Manager detailed log, Please log in to server manager command line and issue the command:




Eg: srvrmgr> change evtloglvl %=5 for comp EAIObjMgr_ENU
Eg: srvrmgr> change param enableserviceargtracing=true for comp EAIObjMgr_ENU



After you get the logs, reset the object manager log to the usual level:

Eg: srvrmgr> change evtloglvl %=1 for comp EAIObjMgr_ENU
Eg: srvrmgr> change param enableserviceargtracing=false for comp EAIObjMgr_ENU



Some logs should be generated on LOG directory.
- Logs with dmp extension.
- EAI Component log.

How to genererate Session Toke Id when Integrating with External Application?

When there is a need to Integrate with External Application like ASP or JSP Siebel Requires to generate a session token which is called GUIDs in web world.



What are GUIDs?


GUIDs or Global Unique Identifiers are Unique IDs generated in software applications to uniquely identify any particular entity. Row Ids are unique across a Siebel environment hence cannot be used as a unique identfier when integrating with other applications, the GUIDs are unique globally.






To generate a GUID, the following Business Service can be used.

Business Service: FINS Teller Converter Extensions
Method: GenerateID

Inputs: IDType Value: GUID
Outputs: GUID in the PropertySet Value






Code:


Input.SetProperty("IDType", "GUID");
bsTeller = TheApplication().GetService("FINS Teller Converter Extensions");
bsTeller.InvokeMethod("GenerateID", Input, Output);
GUIDValue = Output.GetValue();



Sample GUIDs: B5065590-930E-11DE-A110-00212837A7C6, B5065591-930E-11DE-A110-00212837A7C6

Thanks to ZAP My Siebel for providing the above valuable information

Strange Error While logging Siebel Sampel DB - User Name and Password Entered is Wrong

Then I increased the Siebel Logging by setting the Environment Variable "SIEBEL_LOG_EVENTS" as 5

I saw the below error in the siebel.log


SBL-DAT-00228: Unable to load the scripting extension language DLL '%1'! Scripting was enabled in this instance of Siebel, but the DLL which is needed


Then I googled and found the following solution from support web and http://www.error-codes.info



Scripting was enabled in this instance of Siebel, but the DLL which is needed to implement it could not be loaded.?


Changes
ST eScript engine must be set to "FALSE" to fix this error.


Cause
ST eScript engine parameter


Solution
ST eScript engine must be set to "False".

Siebel Workflow Tip - How to query a BC from different BO without Creating Sub Process

How to Query a BC from Different BO without creating sub process in a Workflow?

1. Create a Business Service Step with the following properties

Business Service Name: Inbound E-mail Database Operations
Method: FindRecord

2. In the Input Arguments of this Business Service Steps fill the following arguments

Input Argument       Type              Value
BusObject               Literal            
BusComp                Literal            
QueryFields             Literal            
ValueFields              Literal            

For each query field create a new Input Argument and mention the RHS of the query as Property Property / Literal / Expression for eg
Account                   Process Property       prpAccount
Contact                    Process Property       prpContact

Based on the value passed in the process property prpAccount and prpContact the data will get filtered in the BC mentioned in the BusComp input argument

3. In the output Arguments of this Business Service Steps fill the following arguments

For each field mentioned in the"ValueFields" input argument create a new Output argument for example

Email                       Output Argument    prpEmail

"The field value mentioned is retrieved and get stored in the Process property.  In our example Email Property of the Contact will be retrieved and get stored in the process property prpEmail.