0

عند تسجيل الدخول تظهر رسالة خطأ Database transaction isolation level is not correct, please contact our support team and provide them the following message: TIL is READ COMMITTED

  • retag add tags

عند تسجيل الدخول او فتح نافذة جديدة تظهر رسالة الخطأ التالية

Database transaction isolation level is not correct, please contact our support team and provide them the following message: TIL is READ COMMITTED

ما الحل؟

Ahmed Qasid's avatar
5.8k
Ahmed Qasid
asked 2018-11-26 14:27:31 +0200
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

1

If you are using sql server 2008

USE [master];
DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE host_name  = ('DBNAME')

EXEC(@kill);

ALTER DATABASE DBNAME
SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE DBNAME
SET ALLOW_SNAPSHOT_ISOLATION ON;

omar's avatar
11
omar
answered 2018-11-28 15:14:10 +0200
Ahmed Qasid's avatar
5.8k
Ahmed Qasid
updated 2018-11-29 03:17:23 +0200
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments
0

السبب في هذه المشكلة هو Transaction Isolation Level

قم بايقاف تشغيل التومكات ثم شغل الجملة التالية (بعد استبدال DBNAME باسم قاعدة بيانات العميل الصحيح)

USE [master];
DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE database_id  = db_id('DBNAME')

EXEC(@kill);
ALTER DATABASE DBNAME
SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE DBNAME
SET ALLOW_SNAPSHOT_ISOLATION ON;

ALTER DATABASE DBNAME
SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT ON;

اذا كانت نسخة ال sql server 2014 او اقل اقد تحدث معك مشكلة بسبب الجملة الاخيرة

ALTER DATABASE DBNAME
SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT ON;

قم بحذفها من الاستعلام و شغل مرة اخري اذا ظهرت معك رسالة خطأ

Ahmed Qasid's avatar
5.8k
Ahmed Qasid
answered 2018-11-26 14:29:35 +0200, updated 2018-11-26 14:32:27 +0200
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer