19 Replies Latest reply on Aug 31, 2007 8:17 AM by flavio.carmo

    Error Uploading files over 1MB

      I get a system error when I upload files over 1MB in size.  Under this limit the system uploads fine.  From the error trace:

       

      com.jivesoftware.base.database.DatabaseException: com.jivesoftware.base.database.dao.DAOException: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

       

      The progress bar goes to 100% and then after a few seconds throws this error. I have tried this with different types and sizes of file with the same result.

       

      Sun SDK

      Sun Glassfish

      DB2 Express 9.1

       

      I can send along the appserver log if this would help.

       

      Thanks!

        • Re: Error Uploading files over 1MB

          hi st91402,

           

          I'd love to take a look at your log files: aaron@jivesoftware.com

           

          Cheers,

           

          AJ

          • Re: Error Uploading files over 1MB

            Apparently the default size for a blob type column in DB2 is.... 1MB.  So the solution is to update the following table / columns with a larger column size:

             

            jiveAttachData.attachmentData (this table / column stores attachments)

            jiveDocumentBody.bodyData (this table / column stores the body of binary documents)

             

            I created an issue to update the installation screens and documentation with a warning about the default size:

             

            http://www.jivesoftware.com/issues/browse/CS-1171

             

            Cheers,

             

            AJ

            • Re: Error Uploading files over 1MB

              Thanks!  I manually entered the ALTER command indicated in your fix in a DB2 command window and it reset the length as specified.

               

              I was able to upload a 5MB file without difficulty

              • Re: Error Uploading files over 1MB

                In addition to the database settings, Clearspace has an attachment size limit which can be set.  There is a issue where Clearspace will only allow attachments of up to 15MB regardless of the value specified in the attachment size.

                 

                The work around is to create a system property called docbody.maxBodySize and set it to the same value of your attachment size.

                 

                An issue tracker has been setup for this:

                 

                http://www.jivesoftware.com/issues/browse/CS-1184

                 

                Many thanks to AJ for his help on this!

                  • Re: Error Uploading files over 1MB

                    Is there anywhere that lists out what all the possible system properties are?

                     

                    Thanks!

                     

                    Jeremy

                      • Re: Error Uploading files over 1MB

                        hi Jeremy,

                         

                        There isn't a place currently. We're trying to update the admin console so that most of the system properties have a corresponding UI input point so that you don't have to set these properties. 

                         

                        Cheers,

                         

                        AJ

                          • Re: Error Uploading files over 1MB

                            I hate to say that I am having a similar issue again with a new 1.1.0 setup on Windows XP Pro, Tomcat 6, MySQL5.  I have added the new jiveProperty

                            docbody.maxBodySize=153600 and added the max_allowed_packet=150M to the section of my.ini file.  I get a system error on uploading files 10MB and over.  What else should I check here?

                             

                            Thanks

                             

                            D.

                              • Re: Error Uploading files over 1MB

                                hi Bob,

                                 

                                A system error is indicative of a problem at the database level. Clearspace will show you a nice error message if the upload is larger than we allow at the system level, but you'll get a system error if something is wrong at the database level.  Can you login to mysql and run the following query:

                                 

                                show variables like 'max%' ;

                                 

                                Does the max_allowed_packet variable you set match the value in the resulting list?

                                 

                                Cheers,

                                 

                                AJ

                                  • Re: Error Uploading files over 1MB

                                    yes i get max_allowed_packet = 157285376

                                     

                                    also the error is this if i goto more details, perhaps it may shed more light on the problem?

                                     

                                    Status Code: 500

                                    Exception Type: null

                                    Error Message:

                                    Request URI: /clearspace/doc-upload.jspa

                                    Stack Trace:

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:259)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.community.web.filter.SetResponseCharacterEncodingFilter.doFilter(SetResponseCharacterEncodingFilter.java:62)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)

                                    com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.community.web.JiveActionContextCleanUp.doFilter(JiveActionContextCleanUp.java:46)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:73)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.community.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:43)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:71)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.community.web.filter.ApplicationInitializedFilter.doFilter(ApplicationInitializedFilter.java:95)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    com.jivesoftware.base.database.dao.DAOContextCleanUpFilter.doFilter(DAOContextCleanUpFilter.java:32)

                                    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)

                                    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

                                    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

                                    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)

                                    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                                    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)

                                    org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

                                    org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)

                                    org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)

                                    org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)

                                    org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)

                                    org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:686)

                                    java.lang.Thread.run(Unknown Source)

                                    javax.servlet.ServletException: Filter execution threw an exception

                          • Re: Error Uploading files over 1MB

                            Hi. I get the same error here. The following log is my last attempt of edit a wiki document and attach a file. The same error shows up every time when i attach a file.

                             

                             

                            System Error

                             

                            We're sorry but a serious error has occurred in the system. If you are a system administrator please click "more details" below for more information about this error.

                            More Details

                             

                                 

                            • Status Code: 500

                                 

                            • Exception Type: null

                                 

                            • Error Message:

                                 

                            • Request URI: /clearspace/doc-edit.jspa

                                 

                            • Stack Trace:

                                      o com.jivesoftware.community.impl.DbAttachment.(DbAttachment.java:105)

                                      o com.jivesoftware.community.impl.DbDocument.createAttachment(DbDocument.java:1339)

                                      o com.jivesoftware.community.proxy.DocumentProxy.createAttachment(DocumentProxy.java:346)

                                      o com.jivesoftware.community.action.DocCreateAction.addAttachments(DocCreateAction.java:1058)

                                      o com.jivesoftware.community.action.DocCreateAction.validate(DocCreateAction.java:345)

                                      o com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:154)

                                      o com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)

                                      o com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.jivesoftware.community.web.webwork.JiveObjectLoaderInterceptor.intercept(JiveObjectLoaderInterceptor.java:55)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:233)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.jivesoftware.community.action.LocaleInterceptor.intercept(LocaleInterceptor.java:71)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.jivesoftware.community.web.webwork.JiveIOCInterceptor.intercept(JiveIOCInterceptor.java:706)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.jivesoftware.community.web.webwork.AuthInterceptor.intercept(AuthInterceptor.java:60)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.jivesoftware.community.web.webwork.JiveLoginInterceptor.intercept(JiveLoginInterceptor.java:42)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:186)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.jivesoftware.community.web.webwork.ModuleCheckInterceptor.intercept(ModuleCheckInterceptor.java:49)

                                      o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)

                                      o com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)

                                      o com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:225)

                                      o com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)

                                      o com.jivesoftware.community.web.webwork.JiveFilterDispatcher.doFilter(JiveFilterDispatcher.java:53)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.community.web.filter.SetResponseCharacterEncodingFilter.doFilter(SetResponseCharacterEncodingFilter.java:62)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)

                                      o com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.community.web.JiveActionContextCleanUp.doFilter(JiveActionContextCleanUp.java:46)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.community.web.filter.SetRequestCharacterEncodingFilter.doFilter(SetRequestCharacterEncodingFilter.java:73)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.community.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:43)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:71)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.community.web.filter.ApplicationInitializedFilter.doFilter(ApplicationInitializedFilter.java:95)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o com.jivesoftware.base.database.dao.DAOContextCleanUpFilter.doFilter(DAOContextCleanUpFilter.java:32)

                                      o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                      o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                      o org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)

                                      o org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

                                      o org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

                                      o org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)

                                      o org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                                      o org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)

                                      o org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

                                      o org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)

                                      o org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)

                                      o java.lang.Thread.run(Unknown Source)

                                 

                            • com.jivesoftware.base.database.DatabaseException: com.jivesoftware.base.database.dao.DAOException: java.sql.SQLException: Io exception: Connection reset

                             

                            Im running clearspace 1.5 (just updated the day before yesterday from 1.3, passing by 1.4). The db is Oracle 9.2.0.6 and running on Tomcat 6, on Windows Server 2003 Enterprise.

                             

                            Any tips?

                              • Re: Error Uploading files over 1MB

                                hi Flavio,

                                 

                                How big is the file?  Which Oracle JDBC driver are you using?  How much memory do you have allocated to Tomcat?

                                 

                                Cheers,

                                 

                                AJ

                                  • Re: Error Uploading files over 1MB

                                    Hi AJ,

                                     

                                    im having problems with files larger than 10kb... is pretty weird. Before the 1.3->1.4->1.5 upgrade, i could upload files larger than 10 MB easily.... bunch of PDF, xls, doc, jpg, etc... but now, the only file that i can upload are the little ones xml or txt files.

                                     

                                    Im using the classes12.jar from the Oracle Enterprise 9.2.0.6.

                                     

                                    The memory is the standard configuration for the Tomcat 6.

                                     

                                    The box is a Pentium D 2 GHZ 1GB RAM. I´ve 10 users, so i will migrate to a core 2 duo 6300 box next month. But until the last upgrade, the server is a little slow, but no problem with uploads....

                                     

                                    Regards,

                                     

                                    Flavio