Cannot save big(500MB) binary file as multimedia component

Question

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?

Answer 1

Why would you want to put such a big file in CMS? should not do that.

Think about when you publish it. it will move from CMS to CD server ie. 500 MB file, it will throttle your publishing queue.

if you want to do that. check following link it may help

http://docs.sdl.com/LiveContent/content/en-US/SDL_Tridion_2013/CME_concept_242A17EC385644C8A77F2C976576492C

Answer 2

SDL Web is not a document management system. It is not best practice to store large media files in SDL Web. Doing so would cause issues during publishing of such assets, clogging your publishing queue and deteriorating the editor's experience.

Instead, it is recommended to use a media asset repository for such large files such as SDL Media Manager or a CDN, and simply reference the final URL of the asset into an SDL Web's multimedia component for instance. Or using ECL (External Content Library) such as SDL's connector for Media Manager which makes it easy for editors to insert external assets (coming from MediaManager) directly into their Tridion managed pages. MediaManager then serves the assets from its CDN, also ensuring the best performance for end users.

Learn more on SDL Media Manager here

ECL Connector for MediaManager Documentation