Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Documents - 4MB Limit - How to Change?

web-app

All,

I'd like to be able to attach project documentation in the Documents folder, but some of our PDF files exceed the 4MB limit. I've tried changing the maxRequestLength in the web.config, but received the following error message:

could not insert: [CounterSoft.Gemini.Commons.Entity.DocumentEN][SQL: INSERT INTO geminiprojectdocuments (parentdocumentid, projectid, documentname, documentdesc, isfolder, contenttype, contentlength, documentdata) VALUES (?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()]

Thanks in advance for any insight you can provide!
cmhardage
· 1 		cmhardage
Tuesday, September 14, 2010, 12:20:03 AM
Replies (6)
helpful
0
not helpful

You should be able to do that out of the box. Can you please send the full error message (Administration -> System Log)?

Which version of Gemini are you running?
Mark Wing
· 9108 		Mark Wing
Tuesday, September 14, 2010, 10:23:26 AM
helpful
0
not helpful

We're running v3.7.2 Build 2784. We just upgraded from 3.6.5.

The complete error message is:

could not insert: [CounterSoft.Gemini.Commons.Entity.DocumentEN][SQL: INSERT INTO geminiprojectdocuments (parentdocumentid, projectid, documentname, documentdesc, isfolder, contenttype, contentlength, documentdata) VALUES (?, ?, ?, ?, ?, ?, ?, ?); select SCOPEIDENTITY()] at NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, ISessionImplementor session) at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) at NHibernate.Action.EntityIdentityInsertAction.Execute() at NHibernate.Engine.ActionQueue.Execute(IExecutable executable) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.PerformSave(Object entity, Object id, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.FireSave(SaveOrUpdateEvent event) at NHibernate.Impl.SessionImpl.Save(Object obj) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9, ISession x45b53be31e53d68b) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558, Boolean x8b15d0e18e6888d9) at CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xf606eb5e1032d933(BaseEN x6fcb9c1c812a0558) at CounterSoft.Gemini.DataProvider.x716797727916dc29.x7002b1ff59e93353(DocumentEN x52f8a4781efbc983) at CounterSoft.Gemini.Business.xb001641ee0d6359c.x7002b1ff59e93353(DocumentEN x52f8a4781efbc983) at CounterSoft.Gemini.Presenter.ProjectPresenter.CreateDocument(DocumentEN doc) at CounterSoft.Gemini.Web.Methods.ProjectHandler.AddDocuments(Int32 projectId)
cmhardage
· 1 		cmhardage
Tuesday, September 14, 2010, 4:12:21 PM
helpful
0
not helpful

Hmm... I had also increased executionTimeout. When I received the error message, I set it back to 90, and then set maxRequestLength back to 4096 per the post-install configuration directions.

When I only change maxRequestLength to 20480, I don't get the error message. Not sure whether that would be related or not. Interesting.
cmhardage
· 1 		cmhardage
Tuesday, September 14, 2010, 4:23:05 PM
helpful
0
not helpful

Yes, the maxRequestLength should be set to 44096 (around 40mb). is that not the case for you?
Mark Wing
· 9108 		Mark Wing
Tuesday, September 14, 2010, 4:39:07 PM
helpful
0
not helpful

The web.config that came with the installation files was indeed set to 44096, however, that was in conflict with the installation guide.

Per page 12 of the installation guide, in section 4. Post Installation Configuration, the documentation specifies:

4.2 File Upload Size Limit <!-- File Upload Settings --> <httpRuntime executionTimeout="90" maxRequestLength="4096" This setting controls the maximum permitted file size for files that are being attached to issues and comments within Gemini. Default is 4MB.

I changed maxRequestLength to 4096. When I realized that I needed to upload documentation that was over this limit, I changed it to 20480. I also changed the executionTimeout. I've since reset the executionTimeout to 90 (as I mentioned above).
cmhardage
· 1 		cmhardage
Tuesday, September 14, 2010, 4:56:59 PM
helpful
0
not helpful

Got you, we are in the process of re-writing our docs so will update that.
Glad all is well now.
Mark Wing
· 9108 		Mark Wing
Tuesday, September 14, 2010, 4:59:03 PM