ITCanopy

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

Issue: When starting Siebel services receiving error: Windows could not start the Siebel Server [SERVER_NAME] on Local Computer. For more information, review the System Event Log. If this is non-Microsoft service, contact the service vendor, and refer to service-specific error code 2555922. Analysis: From Siebel Server Logs (UAT_ENT.STG-APP.log) found below error: 1. NSS - ErrCode 4597527  SysErr 0 2. SBL-SMI-00053: Internal: The Siebel Gateway name was not specified (smilobj) From Gateway Server Logs (NameSrvr.log) found below errors: DBCLog    DBCLogError    1    0000000262001088:0    2022-02-07 12:28:54    [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'SADMIN'. GenericLog    GenericError    1    0000000262001088:0    2022-02-07 12:28:54    (secmgr.cpp (2768) err=4597538 sys=127) SBL-SEC-10018: [Micro...

By default windows will store your activity history like when and what file or application you have opened and show in task view. This is helpful if you want to go back in past also troublesome if your machine is used by others, for disabling please follow the below steps: Go to Windows setting by pressing window button + i, or from start menu click on setting icon. From setting window search for Activity history privacy settings. From the Activity History setting uncheck the Store my activity history on this device and from below click on Clear button it will remove the previous history. All Done.

Data Defination Language (DDL) Create  Alter  Rename Truncate  Drop  Data Query Language (DQL) Select  Data Manipulation Language (DML) Insert Update Merge Delete Data Control Language (DCL) Grant Revok