Skip to main content

Posts

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

No user key can be used for the Integration Component instance 'IO Name' error in Siebel

Error: Error invoking service 'EAI Siebel Adapter', method 'Update' at step 'Workflow Step Name'.(SBL-BPR-00162)--No user key can be used for the Integration Component instance 'Integration Component Name'.(SBL-EAI-04397) Steps to Reproduce: Created new Integration Component in Siebel Tools and set Id field (system default) as the Integration Component User Key. Created Data map in Siebel Client. Added a query step in workflow and get the response in Siebel Message process property. (EAI Siebel Adapter, Query) Added Data Map step and used above response. (EAI Data Transformation Engine,Execute) Added Update step and used the response of Data Map step. (EAI Siebel Adapter, Update) Deployed the workflow and run. On Run received the above error. Reason & Solution: From the Workflow instance logs got the Siebel Message value (from Step 3 and 4) and on inspection found out that Id tag was missing. When checked and compare the Id field in Integration compo...

Common Data Types and Conversion in UiPath Studio

What are data types? As you can guess by the name, data types describe the kind of data a variable can hold. For example, if the data type is Int32, then the variable must hold an integer. Likewise, if the data type is a String, then the variable must hold a text. Data types Listed below are some of the most commonly used ones. System.String System.String   stores texts. This type of data comes with many methods of data manipulation that will be explained in detail in another lesson, namely Data Manipulation with Strings in Studio. Numeric(category)   These variables store numbers. There are different sub-types of numerical variables. For example: Int32 -   System.Int32   (signed integers): 10, 299, -100 Long -   System.Int64   (long integers): 54354353430, -11332424D Double -   System.Double   (allows decimals, 15-16 digits precision): 19.1234567891011 System.Boolean   stores one of two value:  True or False Collection(category) Collec...

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 a user in DB MS SQL Studio

Below steps will guide you to create user in Microsoft SQL Management Studio and in Siebel. First create login, open MS SQL Management Studio and connect with database.Run below SQL statement. CREATE LOGIN <user-name> WITH PASSWORD = '<password>'; CREATE LOGIN EAIUSER WITH PASSWORD = 'EAIUSER'; Now create user in database. The SQL create user command takes the following syntax: create user <user-name> for login <login-name> create user EAIUSER for login EAIUSER Now you need to provide permissions to newly created user in database. There are tow ways based on user role in the organization select the appropriate method. One to provide the rights of specific database or assign the Membership role to newly created user. Expand the DB and go to Security/Users and find or add filter for new user as seen below. Right click and open properties. Now go Securables and click on Search button. A new window will popup as seen below. Check the Specific Objects...

How to provide access of selected Server Realated screen to a Siebel user

Requirements: Need to provide the access of "Administrator - Server Management" to a non siebel admin user. Process: Created a new responsibility named "Admin-ServerManagement" with below views and added the user. 'Server Server/Task View' or 'Server Task/Info Log View' or 'Server Server/Component/Task View' or 'Enterprise Server/Server View' or Server Task History List View or Process Failure Diagnostics or 'Server Task/Parameter View' or 'Server Task/State Value View' or 'Server Task/Statistic View' or 'Server Session/Info Log View' or 'Server Session/Parameter View' or 'Server Session/State Value View' or 'Server Session/Statistic View' or 'Server Server/Session View' or 'Server Server/Compgroup View' or 'Server Server/Info Log View' or 'Server Server/Statistic View' or 'Server Server/Task View' or Batch Job Submission View or Repeating ...