The cancel query feature allows users to stop the slow or incorrect queries. If the query does not return records within a given number of seconds (the timeout period), a dialog box appears, which allows the user to cancel the query.
The cancel query feature is enabled through the CancelQueryTimeOut parameter in the [SWE] section of the application configuration file (CFG).
Generate reports in spreadsheet based on business scenarios on a periodical basis and sharing the reports to the respective teams.The task will be repetitive in nature which involves manual interventionSolution :An automated batch job (VBS/Shell/BAT) that can generate the reports in a pre-defined format with required business criteria (dynamically) by connecting to the intended database.Respective team will be notified via mail with the required reportsBenefits :
The Server Request Broker and Server Request Processor are two vital components for managing requests for component execution on the Siebel servers. These pre-defined components provided in Siebel are used to handle the requests on Siebel servers effectively by using optimum strategies of load balancing on both single and multi-server deployments.
When loading data through EIM process, we normally use Pl/SQL procedures to fetch and process huge volume of records and then load the data to EIM Interface tables. There are scenarios when the normal way of data loading into EIM tables take long time due to the bulk volume of records. Typical usage of SQL queries result in performance bottleneck issues due to the frequent context switches between the SQL and Pl/SQL engine
Implementation :
Through EIM process we load bulk amount of data from an external system to Siebel base tables. The performance of these EIM jobs has to be maintained at optimum levels in order to reduce the load on the Siebel application and database servers. The following tips will help you in improving the EIM performance. Do a round of validation in development environment before running the EIM jobs on Production systems
The challenge was to find out which OS user, through which DB login and from which machine the table has been locked and the type of lock that has been applied.
Situation: Application performance issue; Table Lock
Solution: Two options to find out,
1. Lock query: Sample query and sample output.
When extending a custom column in Siebel 8.X which have case and accent insensitive (CIAI) enabled, running EIM mapping wizard creates corresponding mapping in EIM table. After which running an EIM job will cause the job to fail with the following error
"SBL-EIM-00205: NULL target table for relation!" followed by "Failed to load the application dictionary"
Root Cause :
This article is written to demonstrate how attachments can be migrated through EIM from source into target Siebel system. This document gives you an overview of loading attachments in Siebel, various entities in which attachments can be tied, processes involved in loading through eim, etc, Also, at the end of this document there is a case study available in loading attachments against Accounts through EIM.
Microsoft SQL Server provides a completely new enterprise extraction, transformation, and loading (ETL) platform called SQL Server Integration Services (SSIS) that ships with the features, tools, and functionality to build both classic and innovative kinds of ETL-based applications.
