Developer forum

Which version of DW are you using?
I can see that the transaction which is failing is related to copying of item list relations and we made some changes related to that about a year ago.
Maybe you need to upgrade?

/Morten

9.15.6 :-)

You can use a custom connection string - part of the connection string can increase connection timeout.

How many pages and items do you have?

1645 all in all.

Hi Nicolai,

Could this be related to a transaction timeout? It seems like the error message "The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements" also can happens when the transaction times out.
In DW CopyArea method there is a timeout of 45 minutes, but this properly not take affect if the maxTimeout is not added or configured in the machineSettings on the server.

The default value of transaction timeout is 10 minuttes which matches the time the process ends before all content is copied (stops when about 30% of content is copied).
Before configuring system settings, is there a way we can speed up the copy process (e.g database indexes)?

<system.transactions>
    <machineSettings maxTimeout="00:30:00" /> <!-- 30 minutes -->
</system.transactions>

Best regards,
Niels Foldager

Hi Nicolai. Have you had a chance to look at the comment from Niels?