ITCanopy

This article will guide you to enable Hibernate button in Windows power button options. Follow below simple steps: Right Click on Battery icon and from the menu select "Power Options." In Power Options windows from left side click on "Choose what the power buttons do". From the new window you can see "Shutdown settings" are currently read only mode, to enable click on "Change setting that are currently unavailable". Now "Shutdown settings" are editable. Click on "Hibernate" check box and then on "Save changes" button. Now its time to check the change. Press Windows button from your key board or click on Windows icon and then power button icon. Hibernate option is available now:

In Siebel if you copy the value from field (which have line break character) and paste in notepad it will look fine, but when you use query step in workflow or script and check the logs, the search spec will have a large white space due the line break character stored in data base of that specific column and query will not work. For removing line breaks in a field you can use below eSciprt. Line breaks in strings Windows: \r\n carriage return followed by newline character. Linux: \n just a newline character. Regular Expression: if(MethodName == "Remove LB CR")     {         var vTemp = Inputs.GetProperty("vIn");         vTemp = vTemp.replace( /[\r\n]+/gm, "");         Outputs.SetProperty("vOut",vTemp);         return (CancelOperation);     }   See Also: How to remove Line Break when selecting data from SQL Server

When you run SELECT query and copy the result to notepad or excel instead of one row columns with new line character shifts to new row. char(13) is carriage return (is a control character or mechanism used to reset a device's position to the beginning of a line of text) and char(10) is line feed (new line). Below query will eliminate carriage return and new lines from a column of a table. The inner replace replaces line feed and the outer replace replace carriage return SELECT Replace ( Replace( X_DIVISION, CHAR (10), '' ), CHAR (13), '' ) FROM S_CASE_X WHERE PAR_ROW_ID = '1-8I4G98D' Source: Stackoverflow 28628342, Wikipedia See Also: How to remove Line Breaks from a string using Siebel eScript

Error: No user key can be used for Integration Component instance 'IC NAME'.(SBL-EAI-04397) Cause: In this case the behavior was encountered on Siebel CRM 8.1 release, where customer had another definition of the same IO deployed in the run time database. The IO deployed in the run time database was later amended to incorporate some changes in the user key fields. Next 'EAI Siebel Adapter' was invoked with a SiebelMessage corresponding to the amended/latest IO definition, which was compiled in the srf but not re-deployed in the runtime database. Since in version 8.1, IOs are first read from the cache and then from the SRF, this made 'EAI Siebel Adapter' to ignore the amended IO definition and throw the user key error. From experience gathered, it is seen that similar incidents can often arise when the "Deploy the Integration Object" checkbox is selected while creating an IO (using the EAI Siebel Wizard). In order to avoid such incidents due to inconsis...

This Article will cover below points: How to create DB View in Microsoft SQL Server. How to provide permissions to DB View. How to export DB View to .sql file. How to create DB View in Microsoft SQL Server: Connect MS SQL Server to Siebel DB. Expand the Siebel DB and navigate to Views Right click on Views and Select New View.. This might take few minutes on first use and it will open below new window from where you can create db view by selecting Table, Views etc. But I prefer to write query and directly use.Click on Close button. On Close you can see a new query window with three sections.  1st section will show the table/ view relational diagram. 2nd section will show the Columns and their details. 3rd window will have the SQL query. Copy and Paste the SQL query in 3rd section and click on other section, MS SQL Server will auto create the relation diagram and populate the Column details. From the top tool bar click on Save button and MS SQL Server will ask for DB View name, pr...

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.

Open the properties of Siebel Dedicated Application (Siebel Public Sector - ENU) shortcut. From the Target field get the cfg path which might look like this: " c:\Siebel\15.0.0.0.0\Client\bin\enu\publicsector.cfg " if you are using the vanilla cfg. You need modify the below CMD command as per your Siebel installation directory. C:\Siebel\15.0.0.0.0\ses\siebsrvr\BIN\genbscript C:\Siebel\15.0.0.0.0\Client\bin\enu\publicsector.cfg C:\Siebel\15.0.0.0.0\Client\PUBLIC\enu enu This is path of Browser Script generating Utility: C:\Siebel\15.0.0.0.0\ses\siebsrvr\BIN\genbscript This is the path of Siebel Dedicated Client cfg path: C:\Siebel\15.0.0.0.0\Client\bin\enu\publicsector.cfg Below is the path where Browser Script Utility will generate the Browser Scripts. Make sure this is correct as Siebel Dedicated Client get the Browser Scripts from this path ( *\Client\PUBLIC\enu ). C:\Siebel\15.0.0.0.0\Client\PUBLIC\enu Open the Windows Command Prompt and paste the above command and press ...