Skip to main content

Posts

Grant Permissions to users for Siebel Folders

Open Command Prompt  CMD (if necessary run as admin) and run below commands: App icacls "C:\Siebel\8.1.1.11.0\ses" /grant EveryOne:F /T /C Web icacls "C:\Siebel\8.1.1.11.0\eappweb" /grant EveryOne:F /T /C Gateway icacls "G:\Siebel\8.1.1.11.0\ses" /grant EveryOne:F /T /C From Microsoft Docs: icacls Displays or modifies discretionary access control lists (DACLs) on specified files, and applies stored DACLs to files in specified directories. To save the DACLs for all files in the C:\Windows directory and its sub directories to the ACLFile file, type: icacls c:\windows\* /save aclfile /t To restore the DACLs for every file within ACLFile that exists in the C:\Windows directory and its subdirectories, type: icacls c:\windows\ /restore aclfile To grant the user User1 Delete and Write DAC permissions to a file named "Test1", type: icacls test1 /grant User1:(d,wdac) To grant the user defined by SID S-1-1-0 Delete and Write DA...

All Outbound Request in Siebel SQL Query

--All Outbound Requests-- SELECT SCR.REQ_NUM AS 'Request #' ,SCR.STATUS_CD AS 'Status' --,SCR.CM_SRVR_COMP_NAME AS 'Component Name' --,SCR.NAME AS 'Description' ,SCR.STATUS_MSG AS 'Status Message' --,SCR.DFLT_MEDIUM_CD AS 'Default Preference' --, AS 'Recipient Group' ,SCR.PROC_START_DT AS 'Start Time' ,SCR.PROC_END_DT AS 'End Time' ,SCR.CREATED AS 'Created' ,SCRU.LOGIN AS 'Created By' --,SCR.COMMENTS AS 'Comments' --Comm Request Source-- ,SCRS.SRC_ROW_ID AS 'Id' --Comm Package-- ,SDCP.NAME AS 'Name' ,SDCP.MEDIA_TYPE_CD AS 'Channel Type' --Request Recipient Source --,RCS.ROW_ID ,RCS.SR_NUM AS 'SR No' --Customer Record ,(ISNULL(CUS.FST_NAME, '') + ' ' + ISNULL(CUS.MID_NAME, '') + ' ' + ' ' + ISNULL(CUS.LAST_NAME, '')) AS 'Name ENU' FROM S_COMM_REQ SCR --Comm Parent Request LEFT JO...

Find SQL Table Fragmentation

For checking table fragmentation use below: DBCC SHOWCONTIG ('S_CONTACT') DBCC SHOWCONTIG (tablename) DBCC SHOWCONTIG (tablename, indexname) Response: DBCC SHOWCONTIG scanning 'S_CONTACT' table... Table: 'S_CONTACT' (1353212021); index ID: 1, database ID: 6 TABLE level scan performed. - Pages Scanned................................: 13919 - Extents Scanned..............................: 1742 - Extent Switches..............................: 1742 - Avg. Pages per Extent........................: 8.0 - Scan Density [Best Count:Actual Count].......: 99.83% [1740:1743] - Logical Scan Fragmentation ..................: 0.02% - Extent Scan Fragmentation ...................: 6.89% - Avg. Bytes Free per Page.....................: 956.4 - Avg. Page Density (full).....................: 88.18% DBCC execution completed. If DBCC printed error messages, contact your system administrator. ----- For fragmentation use below: DBCC DBREINDEX ('S_CONTAC...

Free Alternatives of Microsoft Notepad for Windows

Microsoft Notepad: Notepad is a simple text editor for Microsoft Windows and a basic text-editing program which enables computer users to create documents and comes with Windows OS by default. It is a common text-only editor. The resulting files typically saved with the .txt extension and have no format tags or styles.  Wikipedia If you are looking for alternatives to the Notepad, below is the list describing Notepad alternatives having a lot of functions. 1. Notepad++ Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment. Based on the powerful editing component Scintilla, Notepad++ is written in C++ and uses pure Win32 API and STL which ensures a higher execution speed and smaller program size. By optimizing as many routines as possible without losing user friendliness, Notepad++ is trying to reduce the world carbon ...

How to configure/ Schedule Asynchronous Jobs from Siebel Client

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.

How to Simulate/ run Workflow from Siebel Client for testing without invoking

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

How to pass username and password in outbound web service from Siebel Workflow

Below process will help you to pass username and password in outbound web service from Siebel. Follow below steps: 1. Open Siebel Application login with admin user go to site map and search Web Services. 2. Go to Outbound Web Service and query for your desired web service for which you want to pass username and password. 3. Go to Operations Applet and select "Username/Password - clear text" Authentication Type for desired method. 4. Clear Cache (on Outbound Web Services Applet) 5. Go to workflow and on business service step through which you are calling outbound web service. 6. Add "siebel_transport_header:Authorization" as Input Argument with Type "Literal". 7. Convert username and password in Base64 with below format:     username:password 8. Add converted credentials  against "siebel_transport_header:Authorization" in Value as below:    Basic dXNlcm5hbWU6cGFzc3dvcmQ= 9. Save, Deploy and Test.