3 Replies Latest reply on Nov 26, 2007 4:00 PM by scott.hirdes

    Error uploading/inserting images in 1.7

      I am getting the following error when trying to insert/upload an image when creating a document.

       

      Error Code: HTTP Error, File name: file.png, Message: 406

       

      I have images enabled, store in db (also tried store in filesystem, same error), max images = 50, max size = 4096.

      Database = 10g Enterprise Edition Release 10.1.0.4.0

      Driver = Oracle JDBC driver 9.0.1.5.0

       

      The following exception shows up in the logs:

      +

      2007.11.15 09:58:44 java.sql.SQLException: Io exception: Broken pipe

      com.jivesoftware.base.database.TransactionException: java.sql.SQLException: Io exception: Broken pipe

              at com.jivesoftware.base.database.JDBCTransaction.rollback(JDBCTransaction.java:105)

              at com.jivesoftware.community.impl.DbImage.<init>(DbImage.java:67)

              at com.jivesoftware.community.impl.DbImageManager.createImage(DbImageManager.java:75)

              at com.jivesoftware.community.impl.DbDocument.createImage(DbDocument.java:1423)

              at com.jivesoftware.community.proxy.DocumentProxy.createImage(DocumentProxy.java:438)

              at com.jivesoftware.community.action.ImagePicker.addImages(ImagePicker.java:692)

              at com.jivesoftware.community.action.ImagePicker.execute(ImagePicker.java:624)

              at com.jivesoftware.community.action.ImagePicker.doBackgroundUpload(ImagePicker.java:560)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:585)

              at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)

              at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)

              at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)

              at com.jivesoftware.community.web.webwork.FlashInterceptor.intercept(FlashInterceptor.java:40)

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

              at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:88)

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

              at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:88)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

              at com.jivesoftware.community.web.webwork.JiveIOCInterceptor.intercept(JiveIOCInterceptor.java:712)

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

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

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

              at com.jivesoftware.community.web.webwork.AuthInterceptor.intercept(AuthInterceptor.java:89)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

              at com.jivesoftware.community.web.filter.MaintenanceFilter.doFilter(MaintenanceFilter.java:81)

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

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

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

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

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

              at com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:77)

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

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

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

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

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

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

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

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

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

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

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

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

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

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)

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

              at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)

              at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

              at java.lang.Thread.run(Thread.java:595)

      +

        • Re: Error uploading/inserting images in 1.7
          scott.hirdes

          Hi,

           

          It looks like the database connection is getting dropped.  Is there any information in your database logs?

           

          thanks,

           

          Scott

            • Re: Error uploading/inserting images in 1.7

              Hi Scott, I have a full trace log, not sure what information would be useful from that:

               

              Here is the error summary.

              +*** SERVICE NAME:(SYS$USERS) 2007-11-15 09:59:43.455

                  • SESSION ID:(245.118) 2007-11-15 09:59:43.455

                  • 2007-11-15 09:59:43.455

              ksedmp: internal or fatal error

              ORA-00600: internal error code, arguments: , , , , [], [], [], []

              Current SQL statement for this session:

              INSERT INTO jiveImageData (imageID, imageData) VALUES (:1, :2)


              Call Stack Trace


              calling              call     entry                argument values in hex

              location             type     point                (? means dubious value)


               


               


               


              sdtcs_getexecname: use overriding value for executable

              sdtcs_getexecname: ignored overriding value

              ksedmp()557         call     ksedst()0           0 ? 0 ? 0 ? 1 ? 0 ? 0 ?

              ksfdmp()14          call     ksedmp()0           3 ? BFFFD0A0 ? A32D41A ?

                                                                 C0A78A0 ? 3 ? C09CAB8 ?

              kgeriv()188         call     ksfdmp()0           C0A78A0 ? 3 ?

              kgesiv()113         call     kgeriv()0           C0A78A0 ? B6A30020 ? 302D ?

                                                                 3 ? BFFFD10C ?

              ksesic3()39         call     kgesiv()0           C0A78A0 ? B6A30020 ? 302D ?

                                                                 3 ? BFFFD10C ? 302D ? 3 ?

                                                                 BFFFD10C ?

              opitsk()1781        call     ksesic3()0          302D ? 0 ? 49 ? 0 ? 0 ? 49 ?

                                                                 0 ? 0 ? 2E ? 0 ?

              opiino()1070        call     opitsk()0           0 ? 0 ? C0A1B60 ? C0F8EE8 ?

                                                                 89 ? 0 ?

              opiodr()1585        call     knpc_pricd()3297    3C ? 4 ? BFFFEE58 ?

              opidrv()550         call     opiodr()0           3C ? 4 ? BFFFEE58 ? 0 ?

              sou2o()103          call     opidrv()0           3C ? 4 ? BFFFEE58 ?

              main()225           call     sou2o()0            BFFFEE3C ? 3C ? 4 ?

                                                                 BFFFEE58 ? B6C92EE0 ? 2 ?

              __libc_start_main()  call     main()+0             2 ? BFFFEEB4 ? BFFFEEC0 ?

              +170                                               B75FE518 ? 2 ? 827A078 ?

              +

                • Re: Error uploading/inserting images in 1.7
                  scott.hirdes

                  Hi,

                   

                  From looking at this log and doing some Google research, it looks like this ORA-00600 error you are seeing in the database logs is a result of an issue with the database.  It doesn't appear to be a problem with application.

                   

                  As such, I would recommend contacting Oracle about what the error means for the database.

                   

                  thanks,

                   

                  Scott