When creating multimedia component with a binary file(more than 500MB), following error occured.
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.
So I modified configration on Content Manager Server as following.
- Increased value of "Seconds before a time out is generated when executing a query", in SDL Tridion Content Manger Configuration's Timeout Settings
- Increased following "transactionTimeout" value on Tridion.ContentManager.config.
<tridion.contentmanager> <repository categoryEnumerationLimit="0" /> <license licenseFilePath="license.xml" /> <session transactionTimeout="600" /> </tridion.contentmanager>
- Add following "serviceTimeouts" element to "TcmServiceHost.exe.config".
<behaviors> <serviceBehaviors> <behavior name="Tridion.ContentManager.ServiceHost.WindowsServiceHost.CoreServiceBehavior"> <serviceTimeouts transactionTimeout="00:10:00" />
I read this article to do those configurations. https://stackoverflow.com/questions/9508729/sdl-tridion-times-out-when-publishing-multiple-items
By those configuration, the problem was solved temporarily.However, after creating few multimedia components, following error occurred, and creating or deleting multimedia component failed.
A database error occurred while executing Stored Procedure "EDA_ITEMS_UPDATEBINARYCONTENT". Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
I tried following SQL, but it doesn't solve the promblem(I got this SQL from this page https://stackoverflow.com/questions/13565642/timeout-when-uploading-images)
SELECT 1 FROM BINARIES WHERE ID = -1 AND CONTENT IS NULL
How is it possible to create big size(500MB) multimedia component?