Skip to main content

Posts

Showing posts with the label EAI

SBL-DAT-00102: Data Transform Error. No entry for lookup key in EAI Value Map. Key: '%1' Type: '%2' Direction: '%3' - Siebel EAI Value Map

Error: Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'Map'.(SBL-BPR-00162)--Data Transform Error. No entry for lookup key in EAI Value Map.   Key:   'Administration Fees'   Type: 'External-Siebel'   Direction: 'Siebel Outbound'(SBL-DAT-00102) SBL-DAT-00102: Data Transform Error. No entry for lookup key in EAI Value Map. Key: '%1' Type: '%2' Direction: '%3' Reason: Value is not defined in EAI Value Map for Outbound direction. External system have different value for "Administration Fees". If this was working before that means external entity have changed the value in their system. Below details will help and guide you to resolve this error and understand the EAI Value Map. EAI Value Map: This is similar to List of Values but defined and use is different. Use case is when integrating with external system most likely external system will have different list of values. S...

How to configure None session type in Siebel Web Service request

Below error was received when invoking Siebel IP15 Web Service through php client (Web Application). In Soap request Session Type was set to None.     Error Code: 10944642 Error Message: Error: Inbound SOAP Message - Session Token is missing or invalid or has expired. Siebel will only ask for Session Token when calling web service with Session Type Stateless. On investigation it was clear that we need to add below parameters to eai.cfg file to run web service with Session Type None. AllowAnonymous = TRUE Impersonate = False Search for AllowAnonUsers in cfg and paste above parameters under it. CFG can be found on path: C:\Siebel\15.0.0.0.0\ses\siebsrvr\BIN\enu Save the cfg file and restart the Siebel services and test. Soap Header:    <soapenv:Header>       <UsernameToken xmlns="http://siebel.com/webservices">username</UsernameToken>       <PasswordText xmlns="http://siebel.com/webservices">pass...

How to create Integration Object in Siebel through Object Wizard

 Integration Objects: Integration objects are logical representations of Siebel business objects or external application data, such as externally defined XML documents. An integration object is metadata stored in the Siebel Repository. One integration object can be mapped to another integration object. Instances of integration objects are used in integration processes for data exchange. About the Structure of Integration Objects: The Siebel integration object provides a hierarchical structure that represents a complex data type. Most specifically, prebuilt EAI integration objects describe the structure of Siebel business objects, SAP IDOCs, SAP BAPIs, XML, and external data. Most integration projects require the use of an integration object that describes Siebel business objects, either in an outbound direction such as a query operation against a Siebel integration object, or in an inbound direction such as a synchronize operation against a Siebel integration object. An integration...

Operation 'Method Name' is expecting a response but no response was received.(SBL-EAI-04311) in Siebel

Siebel is returning below error, when invoking Outbound Web Service through Workflow. Error Code (SBL-BPR-00162)--IDS_EAI_WS_OD_RESPONSE_EXPECTED Error Message Error invoking service 'Business Service', method 'Method Name' at step 'Workflow Step Name'.(SBL-BPR-00162)--Operation 'Method Name' is expecting a response but no response was received.(SBL-EAI-04311) You should be getting above error while invoking Outbound Web Service through Workflow. Reason: Web Service might be unavailable at the host location. The machine on which Siebel Web Server is installed is not able to access the end point URL. Solution: Check with Vendor. Add entry of End Point URL in Windows Host file or exclude from Firewall and Antivirus.

How to Query Page in Integration Object IO and get desired number of records using EAI Siebel Adapter business service in Siebel Workflow

Why Pagination in Siebel Inbound Web Service? When creating Inbound Web Services in Siebel for external system consumption data might be huge and web service either take time or timeout when invoking. So in this scenario we need to introduce the pagination. When calling the web service external system will request the page size meaning number of rows in one request. Prerequisite: IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to execute query in Siebel Workflow. Process: Add new Business Service step in Siebel Workflow, set its properties as below: Business Service Name: EAI Siebel Adapter Business Service Method: QueryPage Set the values of Input Arguments as below: Input Argument: OutputIntObjectName Type: Literal Value: IO Name Input Argument: SearchSpec Type: Expression Value: "[IC Name.Field Name] = '" + [&Process Property Name] + "'" Sample Expression: "[IC Name.Field Name] ...

How to upsert data in Integration Object IO using EAI Siebel Adapter business service in Siebel Workflow

Why Integration Component: We use IO in Siebel for inbound and outbound integration. But we can use IO for normal use as well. For example you have requirement to move data (rows) from one business component to an other. Looping is the long way you can make IO and do this in one go. Just query, use data map if you need to modify the data or destination business component have different fields name and insert or upsert the data in other business component or in the same if only data modification is required. Upsert method is interesting choice because on defined user keys in IO you can update the data if no key matches siebel will insert new row. Below is the process of using "Upsert" method of "EAI Siebel Adapter" business service using workflow business service step. Procedure: IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to upsert (insert/ update) data in Siebel using Workflow and we have to prepare SiebelMessage befo...

How to prepare Datamap using EAI Data Transformation Engine business service in Siebel Workflow

What is Data map? Data maps usually use to process data in bulk. Data map is based on Source and Destination integration objects. And then we map the integration components and after that their fields source and destination. Source field can be expression or integration component field coming from the SiebelMessage.   Below is process of invoking data map using business service step in Siebel workflow.   Procedure: Add new Business Service step in Siebel Workflow, set its properties as below: Business Service Name: EAI Data Transformation Engine Business Service Method: Execute Set the values of Input Arguments as below: Input Argument: MapName Type: Literal Value: Data Map Name Input Argument: OutputIntObjectName Type: Literal Value: IO Name Input Argument: SiebelMessage Type: Process Property Property Name:  SiebMessage Note: SiebMessage cloud be repose from Query in IO or from Web Service input and it should be based on above "IO Name" and ...

How to query in Integration Object IO using EAI Siebel Adapter business service in Siebel Workflow

IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to execute query in Siebel Workflow. Add new Business Service step in Siebel Workflow, set its properties as below: Business Service Name:  EAI Siebel Adapter Business Service Method:  Query Set the values of Input Arguments as below: Input Argument: OutputIntObjectName Type: Literal Value: IO Name Input Argument: SearchSpec Type: Expression Value: "[IC Name.Field Name] = '" + [&Process Property Name] + "'" Set the values of Output Arguments as below: Property Name: SiebelMsg  Type: Output Argument Output Argument: SiebelMessage SiebelMsg is a process property with type hierarchical. Below are some SearchSpec expressions: "[IC Name.Field Name] = Today() AND [IC Name.Field Name] = '"+LookupValue("LOV_TYPE","Value")+"'" "[Id]= '"+[&Object Id] +"'...