ITCanopy

This article will guide you to make field case insensitive for Query/ Search in Siebel Tools. Login the application and navigate to applet for which we need to make field case insensitive. Get the applet name from Help > About View... Login the Siebel tools and query the applet name, from List Column or Control get the field name. Go to the Business Component and query the field name and get the Column name. Go to Table and query through Column name. Right click on the Column name and from menu click on Case Insensitivity... A wizard window will appear, click on Next button. Click on Finish button. Now query the table and Apply DDL. Compile the table on SRF (Server/ Dedicated Client). Login the application and check the change. Note: Oracle does not recommend making field search case insensitive. This slows down the search performance.

After completing the workflow you need to deploy. There are two ways either publish from tools or export workflow as xml and import from client side. My practice is to export workflow as xml and import. Errors: 1. 'EAI XML Read from File' service with method 'ReadEAIMsg' failed while processing XML from file *_temp_*.xml SBL-EAI-04264 2. The XML document cannot be converted to and XML hierarchy SBL-EAI-04110 3. XML Hierarchy Converter error - empty input message, expecting an XML document in <Value> of input arguments SBL-EAI-00246 Action: Facing above errors while importing workflow xml in Active Workflow Processes. Possible Reason & Solution: The drive on which Siebel is installed does not have free space. Try deleting log archives and dedicated logs if any. Make sure drive have empty space.

How to test/ invoke/ enable inbound web services on Siebel Dedicated Client To enable Web services on the Siebel Dedicated Web Client follow below steps: 1: Set the following parameters in the [Siebel] section of the application configuration file, such as publicsector.cfg EnableWebServices = TRUE WebServicesPort = 2330 (Port number on which to listen. The default is 2330) Save the config file and launch siebel application again, you will see a child siebel.exe process is running in back ground. This process is listening all in bound SOAP requests.   2: Open Application and navigate to Administration - Inbound web service and select web service you want to test. In Port Applet change Address URL as follows: http://<Machine Name>:<Port Number>?SWEExtSource=WebService&SWEExtCmd=Execute&UserName=<UserName>&Password=<PassWord> For Example: http://localhost:2330?SWEExtSource=WebService&SWEExtCmd=Execute&UserName=SADMIN&Password=SADMIN Th...

[1]Wrong field values or value types detected in field Street. Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299) [2]An error occurred while attempting to look up the transcode for the value 'Value-10' in table 'S_LST_OF_VAL' and of type 'LOV_TYPE' with language 'ENU'.(SBL-DAT-00592) [3]There were more rows than could be returned.  Please refine your query to bring back fewer rows(SBL-DAT-00500) See Also: There were more rows than could be returned error occurs when executing LookupValue in an UI data map (Doc ID 1925807.1) Changing the cursor configuration parameter from the Application CFG file will only work for dedicated Web client. In order to set this parameter value for the Siebel Web Client (thin client) you need to set named subsystem parameter DSMaxFetchArraySize. This parameter controls the maximum number of records that can be returned by a business component in ForwardBackw...

What is Position in Siebel? A position represent an actual job position in your organization. It determines the records that Siebel CRM displays to each user. A position can be a formal job title, such as the actual job title that the developer uses. It can also be any descriptive text. For example, Developer 1, Developer 2, and so forth. To log in to a Siebel application, an employee must be assigned a position. When you create positions and position skills, it is recommended that you do the following: To determine reporting relationships between positions and parent positions, refer to the organization chart for your company. Because you choose parent positions as you create new positions, start at the top of the organization chart and work your way down. Note that there is typically one position that does not include a parent position. For example, the CEO position typically does not report to a higher level. Multiple positions of a single user: It is Not possible to assign multiple...

Issue:   When trying to access Siebel app url, server is returning below: Error: The Server You Are Trying to Access is Either Busy Or Experiencing Difficulties Possible Reasons: Check if Siebel App services are running. If services are running and you are receiving the same Go to log folder and open the latest log file " PSCcObjMr_ara_test " and go to the end. Logs: 2021 2021-03-14 16:44:00 2021-03-14 16:44:00 +0400 00000003 001 003f 0001 09 PSCcObjMr_ara_test 39845995 14192 13008 E:\Siebel\8.2.2.0.0\ses\siebsrvr\log\PSCcObjMr_ara_test_0038_39845995.log 8.2.2.4 [23030] ARA ObjMgrSessionLog    Error    1    00000135604d4060:0    2021-03-14 16:44:00    (model.cpp (5980)) SBL-DAT-60237: حدث خطأ أثناء تحميل ملف الدليل diccache.dat. ObjMgrCTLog    Error    1    00000135604d4060:0    2021-03-14 16:44:00    (ctxtmgr.cpp (4567)) SBL-SVC-0020...

When trying to access, browser is returning below error: Error: Service Unavailable HTTP Error 503. The service is unavailable. Reason: This error occurs usually when default pool stopped. Solution: Go to Siebel web server, from the start open Internet Information Services (IIS) Manager and click on "Application Pools" From the Application Pools, right click on "DefaultAppPool" and from menu click on "Start". Wait for some time and re try to access the Siebel app url.

Please your wsdl file in Temp folder. E:\siebel\8.2.2.0.0\Tools_1\TEMP Open Siebel Tools and Login. Click on "New" button, "New Object Wizards" window will open go to "EAI" tab and select "Web Services". Click "OK". On "WSDL Import Wizard" provide the Project and specify the wsdl file using "Browse" button and click "Next>". In Next window click on "Finish" button. On Finish below objects will be created in the repository. in Tools Integration Object(s) Business Service(s) and in application Outbound web services. See Also: How to host middle ware or website on iis manager for Siebel How to create and publish Inbound Web Service in Siebel based on Workflow

You can use COMCreateObject("WScript.Shell") for displaying the custom message or for debugging the issues in eScript. This can be used in server script and in older versions of Siebel (which supports vb script). Below is the example: //Instantiate var msg = COMCreateObject( "WScript.Shell" ); //Display message msg.popup( "Custom text" + variable ,0, "Message title" ); //Example: of text and variable concatenation msg.popup( "Doc Num:" +docNum + " Owner Id:" +OwnerId+ " P Id:" +POAsrId,0, "Debus Script" ); You can use TheApplication() .RaiseErrorText( "Text" + variable); but Siebel will consider this as error and will not execute any code after this.

The application shortcuts run an executable program called siebel.exe, followed by various start-up options. If you want to create shortcut for Siebel Dedicated Client right click on desktop and from "New" select "Shortcut" and provide below (modify Siebel exe path and configuration file path accordingly) : D:\siebel\8.2.2.0.0\Client_1\BIN\siebel.exe /c D:\Siebel\8.2.2.0.0\Client_1\bin\enu\publicsector.cfg /b "C:\Program Files\Internet Explorer\iexplore.exe" If you want to set default user, password and data source add blow in shortcut's property Target field. When you run short cut Siebel will not ask for Credentials and Data source. /u SADMIN /p SADMIN /d ServerDataSrc Resulting string will look like below: D:\siebel\8.2.2.0.0\Client_1\BIN\siebel.exe /c D:\Siebel\8.2.2.0.0\Client_1\bin\enu\publicsector.cfg /b "C:\Program Files\Internet Explorer\iexplore.exe" /u SADMIN /p SADMIN /d ServerDataSrc For creating spool of dedicated client add bel...

About Environment Variables for System Logging The SIEBEL_LOG_EVENTS environment variable sets the event logging level, which determines the extent of information captured in the log file. More information is captured when the environment variable is set to a higher numeric value, and less information is captured when the variable is set to a lower numeric value. The numeric value is inversely proportional to the severity of the information—0 is more severe than 5 for instance. More disk space is consumed and performance is hindered when the value is set to a value of 5 than a value of 0. 0-Fatal 1-Errors 2-Warnings 3-Informational 4-Details 5-Diagnostic The SIEBEL_LOG_DIR environment variable determines the log file location. Set this variable to change the location from the default directory. Make sure this directory already exists, access permission to write a file in that location is available, and sufficient space is free to support the log file. Source: Oracle Docs Configure Sy...

Run below command on CMD, make sure to change paths according to your installation directory of Siebel: E:\siebel\8.2.2.0.0 \ses\siebsrvr\BIN\genbscript E:\Siebel\8.2.2.0.0 \Client_1\BIN\ENU\publicsector.cfg E:\Siebel\8.2.2.0.0 \sweapp\Public\enu enu pause Or open notepad and paste the above and save it as .bat file. Double click on bat file and browser scripts will start generating. E:\siebel\8.2.2.0.0\ses\siebsrvr\BIN\genbscript  > Scripts Generator Utility. E:\Siebel\8.2.2.0.0\Client_1\BIN\ENU\publicsector.cfg > CFG of Server. E:\Siebel\8.2.2.0.0\sweapp\Public\enu  > Browser scripts will be generated here. enu > Language. pause > After completing the generartion of Browser scripts CMD will not auto close unless press any key.

SELECT TYPE AS 'Type' ,VAL AS 'Display Value' ,NAME AS 'Language-Independent Code' ,LANG_ID AS 'Language Name' ,ORDER_BY AS 'Order' ,ACTIVE_FLG AS 'Active' ,TRANSLATE_FLG AS 'Translate' ,MULTI_LINGUAL_FLG AS 'Multilingual' FROM S_LST_OF_VAL WHERE 1=1 AND TYPE = ' LOV_TYPE '

1. Open Siebel Client, go to site map. 2. search: Administration - Personalization, open Test 3. enter your login and password and click on load. All profile attributes will show in Primary User Attributes Applet This will give you a list of all system profile attributes that get, set upon logging in to the Siebel Application. These profile attributes are available throughout the application. You can create and set your own profile attributes as well.

1. Open MS SQL Management Studio copy paste below query in query window. SELECT Prof.NAME AS 'Profile Name' ,ParNam.NAME AS 'Parameter Name' ,Par.VALUE AS 'Parameter Value' FROM S_CM_PROF Prof LEFT JOIN S_CM_PROF_PARM Par ON Par.CM_PROF_ID = Prof.ROW_ID LEFT JOIN S_CM_CNCTR_PARM ParNam ON ParNam.ROW_ID = Par.CM_CNCTR_PARM_ID WHERE 1=1 AND Prof.NAME = 'Email  Profile Name' 2. Go to site map in Siebel Client search for Communication Drivers and Profile, copy the name of desired Email profile and add it in above query. Run the query and you will have all parameters and their values of that profile.

To send and receive a mail two agents, message transfer agent and a message access agent are required. The message transfer agent transfers the message from client computer to the recipient’s mail server. Now, it’s the work of message access agent to pull the message from the mailbox present on the mail server at recipient’s side to the recipient’s computer. We have one message transfer agent i.e. SMTP (Simple Mail Transfer Agent), and we have two message access agents  POP (Post Office Protocol) and IMAP (Internet Mail Access Protocol). What is POP3? Post Office Protocol version 3 (POP3) is a standard mail protocol used to receive emails from a remote server to a local email client. POP3 allows you to download email messages on your local computer and read them even when you are offline. It is message access agent. It allows to retrieve and organize mails from mailbox on receiver mail server to receiver's computer. What is SMTP? Simple Mail Transfer Protocol (SMTP) is the s...

Blow points will guide you to create Asynchronous job. 1. Go to Server Jobs > My Jobs and create New. 2. Open MVG of Component/ Job and query  Workflow Process Manager in Name filed of MVG, select the record and click OK. Set your App Server name in Requested Server and Execution Server fields (not required Siebel will assign when executing the job). Copy ID for future reference. 2. Got o Job Details and check the Repeating? check box. Describe Repeat Unit and Repeat Interval and Scheduled Start fields as desired. 3. Go to Job Parameters applet and create New. Open Name MVG and query  Workflow Process Name and click Ok and in Value set your workflow name. 4. Recheck everything and on My Jobs applet click on Submit Job button.

Background: If you want to test workflow without invoking from applet or business component, below are the step by step points. Process: 0. Deploy workflow on Siebel Client. 1. Go to Administration - Business Services from Siebel Client site map. 2. On Business Services screen go to Simulator view. 3. Click on New button and open MVG of Service Name field. 4. Query Workflow Process Manager in Name field of MVG and click OK. 5. Open MethodName filed MVG and select  RunProcess and click OK. 6. Go to Input Argument Methods and click on New button and set  PropertySet in Type filed. 7. Open Property Name MVG and click on New button. 8. Set ProcessName value for Property Name filed and your workflow name in Value Field and click OK. 9. If you have to pass input parameters than repeat the same process described in point 8, set workflow process property name e.g. Object Id and its value and click OK. 10. Click OK on Property Set Properties ...