Find slow running queries on MS SQL Server

Source Below query will helps you find the queries which have taken a lot of time in milliseconds. To confirm that you have query performanc...

How to check Communications Outbound Manager jobs status SQL

When using " Communications Outbound Manager " business service Siebel create a job record in " S_SRM_REQUEST " table. Y...

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

Make a Field Case Insensitive for Search in Siebel

This article will guide you to make field case insensitive for Query/ Search in Siebel Tools. Login the application and navigate to applet f...

Find record query loop in Siebel eScript

  var EngBO, EngBC, EngId, RecordCount, withRecord, UserName, UserId; EngBO = TheApplication().GetBusObject("My Business Object");...

There were more rows than could be returned Siebel SBL-EAI-04376

Steps: IO with two ICs as parent child,  trying to query using business service "EAI Siebel Adapter" method "Query" in c...

How to query or find record in Siebel Business Component

You can perform query operation on Business Component through Workflow, eScript with the help of Siebel Operation, Inbound E-mail Database O...

How to get Siebel user responsibilities from database through Sql query

SELECT u.LOGIN as "User ID" ,res.NAME as "Responsibility" FROM S_USER u left join S_PER_RESP ri on ri.PER_ID = u.R...

How to add SearchSpec (query) on Applet Load Event through Applet Server Script in Siebel

If record is found every time when user navigate to Applet that record will be displayed. If record is not found Applet will be empty but u...

How to Find Record (query) in Business Component through Siebel Workflow

Add new Business Service step in Siebel Workflow, set its properties as below: Business Service Name: Inbound E-mail Database Operations...

How to Query Page in Integration Object IO and get desired number of records using EAI Siebel Adapter business service in Siebel Workflow

Why Pagination in Siebel Inbound Web Service? When creating Inbound Web Services in Siebel for external system consumption data might be hug...

How to query in Integration Object IO using EAI Siebel Adapter business service in Siebel Workflow

IO must be compiled on SRF (EAI, SIA) and Deployed to run time data base for which you want to execute query in Siebel Workflow. Add new ...

How to get List of values LOVs of Siebel from Database through SQL Query

SELECT TYPE AS 'Type' ,VAL AS 'Display Value' ,NAME AS 'Language-Independent Code' ,LANG_ID AS 'Language Na...

How to change length of Column through SQL query in Siebel

Get Row Id of Column from Siebel Tools and replace below: SELECT ROW_ID, NAME AS 'Column Name', LENGTH AS 'Column Length...

Siebel DB Backup through SQL Query

Replace values in highlighted with lime color according to your configuration. BACKUP DATABASE [SiebelDB] TO DISK = N' E :\\ Fold...

How to unlock Workflow in Siebel Tools from Database Table through SQL query

Background: For working on an object in Siebel tools you need to lock it and usually developer forget to unlock after working on the object....

How to get Siebel Workflow Instance Monitor values from Database through SQL query

Below is the query for getting workflow instance monitor values from table: select wfdl.NAME as 'WF Name' ,wfdl.DEPLOY_STATUS_C...