My Oracle Support Banner

Siebel Application Performance Impacted by MS SQL error [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot continue the execution because the session is in the kill state. (Doc ID 2611460.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.
Microsoft SQL Server 2016

Symptoms

Long running SQL queries causing slow performance issues for object manager tasks. Siebel end users not able to execute SQL on Service Request Detail View.

For Example: The S_EVT_ACT is the biggest table and all queries are showing slow performance or SQL failures. The corresponding Object Manager logs are showing MS SQL Database connectivity errors when you executing SQL:


Further noted high CPU spike issues on Microsoft database SQL server.

Changes

 Applied the SP2 on Microsoft SQL Server 2016 database

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.