ITCanopy

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

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

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

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

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

Introduction: Siebel Personalization Event Triggered Logs identify all the events triggered by the Siebel or by action performed by the user. Below is the example: Personalization log created 04/04/23 12:20:30 Platform:    Dedicated Client Application: Siebel Public Sector Language:    ENU SRF:         C:\Siebel\15.0.0.0.0\Client\OBJECTS\enu\siebel_sia.srf {F(Personalization)T(1680592830)M(N)A(Siebel Public Sector)L(ENU)S(C:\Siebel\15.0.0.0.0\Client\OBJECTS\enu\siebel_sia.srf)E(Y)Y(Y)I(Y)U(N)} ------------------------------------------------------------------------------- Event, at 04/04/23 12:20:30.252, sequence 1 Object type: Application Object name: Siebel Public Sector Event:       Login Sub-event:    No events registered. {S(1)T(1680592830.252)U(ATIF)K(13)Y(Event)N(Y)} ------------------------------------------------------------------------------- Setup Profile, at 04/04/2...

APPLIES TO: Siebel Tools - Version 8.1.1.1 SIA [21211] and later Information in this document applies to any platform. GOAL How to display external web page in a modal popup window using symbolic URL? SOLUTION 1. Create calculated field in Account buscomp: name = TestSymbolicURL calculated value = TestSymbolicURL 2. Create new form applet using the new object wizard with following properties: name = Account Symbolic URL Popup Applet buscomp = Account web template = Analytics Applet type = base Select TestSymbolicURL field in the wizard to be included in the applet. Deselect all button controls in the wizard. The wizard will create control in the applet Set the following control properties: name = Test field = TestSymbolicURL field retrieval type = Symbolic URL HTML display mode = EncodeData HTML type = Text field type = BC Field Edit the class property of the created applet and set it to: class = CSSSWEFramePopup 3. Create new button control on SIS Account Entry Applet with following p...

Description: Configured the Pick Applet for selecting the records from Contact. But when selecting the record Siebel is returning below error: SBL-DAT-00249: An error has occurred getting the pick list business component %1 for field %2 in business component %3. SBL-DAT-00249: An error has occurred getting the pick list business component Contacts NBR for field Full Name in business component Asset Contacts. Solution: Open the Object Manager logs and search the error. From the error scroll up. In my case below is logs part. ObjMgrBusCompLog    Warning    2    00000004637f1bdc:0    2022-11-24 23:27:03    (sqlbcdef.cpp (2799)) SBL-DAT-00466: Multi value link definition 'Organization' does not exist for business component definition 'Contacts NBR'. ObjMgrBusCompLog    Error    1    00000004637f1bdc:0    2022-11-24 23:27:03    (buscomp.cpp (12...

Workflow instance monitor have three separate tables. One for logging workflow run (workflow instance), second for its steps execution to log (workflow steps) and third for logging the values of each process property value against each step of workflow (workflow process properties). If you increase the Workflow Monitoring level over the time tables space and DB load will be increase and sometimes instance monitor will be stopped working (Check Siebel Workflow Instance Monitor not working to fix this issue) . Its a good practice to delete the old workflow instance monitor records. Below are the queries for deleting the data. Its better to delete only old data and Year is perfect condition. Workflow Instance select count(*) from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' --delete from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' Workflow Instance Steps select count(*) from S_WFA_INSTP_LOG where EXTRACT(YEAR FROM TO_DATE(created))=...

Issue Description: Configured the Audit Trail for "My Business Component"on Dev Tools and compiled the changes. From Application side map navigated to "Administration - Audit Trail". Created a new record and provided the Business Component name in "Audit Trail Buscomp" applet. Added fields in "Audit Trail Field" applet. Tested and all good. Compiled the objects on Prod srf and when adding the business component in "Audit Trail Buscomp" applet Siebel opened "Business Components" pick applet with no records. Conclusion and Solution: Get the table name from "Business Components" pick applet's BC and run a query on Prod SQL. SELECT * FROM S_BUSCOMP WHERE NAME = 'My Business Component' And there was no record. Now add "My Business Component" to sif file and import it on Production tools. Now when you run the above query it will return record and you will also be able to add record in "Audit Trai...

Description: Configured a new Pick Applet and after compilation when tested, OK button was disabled. Forced the OK button to enable by using CanInvoke = TRUE. When tested Siebel returned below error: SBL-UIF-00348: Method PickRecord is not allowed here. Possible Solutions: Make sure Business Component is not read only for the selected record. Filed on which Pick Applet is configured is not read only on Business Component level. Filed on which Pick Applet is configured Immediately Post Change, Link Specification check boxes are checked.

1: Error Join in business component definition '%1' has source fields that come from tables '%2' and '%3' (SBL-DAT-00452). 2: Steps on which error occurred 2.1. In Business Component created new Join by providing table, alias and outer join flag checked. 2.2. In Join Specification created new record provided the destination column and source field (field is based on base table of the business component). 2.3. In Join Specification created new record provided the destination column and source field (field is based on other table, added using join). 2.4. Created new field based on the new join and exposed in applet. 2.5. Compiled the objects and open Siebel application. 2.6. When navigate to view Siebel returned the above error. 3: Findings and Conclusion: When inspecting the Object Manager (Public Sector) logs could not able to find the exact reason but just the above error. When checked on Oracle Docs found out that documentation is saying that in Join Specific...

0: Overview Sometime as per the requirements you need to display 3rd party web page inside Siebel to achieve that there are two simple steps which are described here in details. 1: Prepare BIP Report URL In this post requirement is to show Oracle BI Publisher report inside Siebel Applet with report filters. 1.1. First Oracle BIP Developer will create report and share report link and important thing here is to ask BIP Developer to share the link without BIP Header page shown in below image. And link will look like this (Removed default filter details as they will auto set when report will open) : http://BIPServer:PORT/xmlpserver/FOLDER/REPORT_NAME.xdo?_xpf=&_xpt=0&_xdo=%FOLDER_PATH%2FREPORT_NAME.xdo&_xmode=2&_xt=REPORT_TITLE&_xf=pdf&_xana=view&_xautorun=false 1.2. Now simply divide this URL into input parameters so that we can configure this URL into Siebel Application. "&" is the key from where you can determine the parameter name and their val...

Issue Details: In "Active Workflow Processes" Monitoring Level of  workflow is set to "3 - Detail" but when check the "Workflow Instance Monitor" there are no "Step Instances". Step to find the root cause: Set the Workflow Monitoring Level to "3 - Detail". Increase the Application Object Manager (in this case Public Sector) logs to level 5. Re login the application and invoke the workflow.  Find the Public Sector OM logs. (Path: C:\Siebel\15.0.0.0.0\ses\siebsrvr\log) Open the log file (PSCcObjMgr_enu_*.log) and search "Instantiating". When you find your Workflow step name (set in workflow) scroll down and find the place where Siebel is inserting the "Step Instance" and "Process Properties". Carefully read the end lines and you will find the issue. In my case below was the issue mentioned in logs: SQLParseAndExecute    Execute    5    000000fa635f2ee4:0    2022-10-31 21:10:15    OCIStmtExecute: DML erro...

  There are two ways one is that you change the date format on server level but this will cause issue like if you are getting date in business component and parsing it with some business rule and when you change the date format you need to modify operation everywhere. Below solution is simple and easy to execute. Follow below simple steps to achieve your desired date format. Open Siebel Tools. In Tool go to Applet and query the applet where you want to change the date display format. Now from list or control query the desired date field. Scroll right or use tab to find the "Display Format". Now from below you can make your own date format. For example as per my requirements I am using "DD-MMM-YYYY" after compiling the applet on UI date will display "21-Sep-2022". Format mask Description: YYYY or yyyy four digit year such as 2017 YY or yy last two digits of year such as 17 M month with no leading zero 1-12 MM Two digit month 01-12 MMM Three letter month suc...

Issue Steps (Siebel UI): Go to Contact Screen and Contact List. Drilldown Contact Name and Attachment Detail View. Click on New Button in Attachment applet, select file. Step off, or click on save button. Siebel Return an error. Error Details: [1]Error occurred while creating file in filesystem. Please contact your system administrator. (SBL-SVC-00184) [2]Error occurred while opening file 'S_CONTACT_ATT_ROWID.SAF'.(SBL-UIF-00229) Issue Steps (Siebel Workflow): Invoke workflow which is trying to add attachment using EAI Siebel Adapter. Error Details: [1]Error Invoking service 'EAI Siebel Adapter', method 'Upsert' at step 'Upsert Attachment'.(SBL-BPR-00162) [2]Method 'New Record' of business component 'Email Attachments' (integration component 'Email Attachments') for record search specification '[Parent Id] IS NULL' returned the following error: "Error occurred while opening file 'S_CONTACT_ATT_ROWID.SAF'.(SBL-...

Design the workflow. Add new Business Process step on workflow canvas. Add below Business Service Name and Method. Business Service Name: Outbound Communications Manager Business Service Method: SendMessage Now go to " Multi Value Property Window " and Input Arguments and set the arguments as below. AttachFileList > Attachment File path (C:\Siebel\xx.0.0.0.0\ses\siebsrvr\temp\S-WEB-APP_8364_9620_0_Attachment Name.pdf) CommProfile > Communication Profile Name through which Siebel will send the Email MsgBody > Email Body MsgSubject > Email Subject MsgToList > Destination Email (t@t.com; a@a.com) Save the workflow deploy and test. If you need to add attachment from Siebel Contact, Service Request or Case attachment please check the below article: How to get Siebel attachment as file in Workflow If you don't know how to configure or find the working " CommProfile " parameter value please check the below article: Setting up Communication Profil...

You might need to extract a specific file from Siebel Attachments or want to attach that file in Email as attachment. To achieve that Siebel provide a vanilla business service which will get file and return its path. Prepare the workflow and drag drop the Business Service step on workflow canvas. Open properties and set the as below: Business Service Name: FINS Industry BC Facility Service Business Service Method: GetFile Now go to " Multi Value Property Window " and add the below Input Arguments : AttachmentId > Row Id of specific attachment which you want to get as file. BusObjName > Business Object name in which Attachment Business Component is present. FileBusCompName > Attachment Business Component Name. FileNameField > Attachment Name Field. If you are not sure which field is in your case, query " FILE_NAME " in Business Component Column and use that Field Name which query will return. RootBusCompName > If Attachment Business Component is...

For setting up Communication profile you need Sender Address, SMTP Server IP and Port. Setting up Profile is pretty simple just follow below steps: Login the application. Go to site map by click on sitemap icon or pressing Ctrl + Shift + a. Search for " Communication Drivers and Profiles " which is sub child of " Administration - Communication ". In " Communications Drivers " applet find " Internet SMTP/POP3 Server " record and select. Scroll down to " Profiles " applet. Create New Record and set the appropriate name. Now scroll down to " Profile Parameter Overrides " applet and create new records with these parameters: From Address LogDebug SMTP Server SMTP Server Port If there are existing Profiles you might see an additional parameter " Siebel Server ". Its values is usually is gateway server name or IP but if you are not sure don't add this, Siebel will auto define when this profile is called. If you defined ...

When using " Communications Outbound Manager " business service Siebel create a job record in " S_SRM_REQUEST " table. You can easily check the status of these jobs by using below query which is written for MS SQL Manager Studio. SELECT STATUS ,CREATED,ROW_ID,DESC_TEXT,ENTERPRISE_NAME,EXEC_SRVR_NAME,PARAM_VAL,RESP_TEXT,COMPLETION_TEXT FROM S_SRM_REQUEST WHERE 1=1 AND DATEPART ( YEAR ,CREATED) = '2022' AND DATEPART ( MONTH ,CREATED) = '04' AND DATEPART ( DAY ,CREATED) = '06' AND ( PARAM_VAL LIKE '%SendMessage%' OR PARAM_VAL LIKE '%CreateRequest%' ) ORDER BY CREATED DESC