<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:atom="http://www.w3.org/2005/Atom" version="2.0"><channel><title>Answers to: Database conversion stays forever on "SET READ_COMMITTED_SNAPSHOT ON"</title><link>https://answers.axonivy.com/questions/875/database-conversion-stays-forever-on-set-read_committed_snapshot-on</link><description>&lt;p&gt;If I convert the Ivy System Database from version 4.2 (Database version 25) to 4.3 (DB version 30) or newer the conversion stays forever on (is blocked on) the task "&lt;code&gt;SET READ_COMMITTED_SNAPSHOT ON&lt;/code&gt;".&lt;br&gt;
The conversion dialog looks like this:&lt;img alt="SET READ_COMMITTED_SNAPSHOT ON" src="/upfiles/conversion_blocked_on_set_read_committed_snapshot.png"&gt;
What is wrong? Is my database to big? Is there any fix or workaround?&lt;/p&gt;</description><atom:link href="https://answers.axonivy.com/questions/875/database-conversion-stays-forever-on-set-read_committed_snapshot-on" rel="self"></atom:link><language>en</language><lastBuildDate>Mon, 21 Jul 2014 17:35:56 -0400</lastBuildDate><item><title>Answer by Christian Strebel</title><link>https://answers.axonivy.com/questions/875/database-conversion-stays-forever-on-set-read_committed_snapshot-on/876</link><description>&lt;p&gt;This happens only I there is another connection to this Microsoft SQL Server database is open. Just close all connections to the database and then the conversion goes on. Normally closing the "SQL Server Management Studio" solves the problem.&lt;/p&gt;</description><dc:creator xmlns:dc="http://purl.org/dc/elements/1.1/">Christian Strebel</dc:creator><pubDate>Mon, 21 Jul 2014 17:35:56 -0400</pubDate><guid>https://answers.axonivy.com/questions/875/database-conversion-stays-forever-on-set-read_committed_snapshot-on/876</guid></item></channel></rss>