Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

View: New views
19 Messages — Rating Filter:   Alert me  

Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I am using Nuxeo dm 5.2 and postgres 8.3. I have an error when i upload same files with d&d plugin or when i import the file with the import button option from the web.
The error (i think) occurs when nuxeo tries to store data in postgres, the error message:

ERROR: invalid byte sequence for encoding "UTF8": 0x00

I have added the NXP-3675 in my Nuxeo code and with some files the problem is resolved (before the patch these files produced the error). But i still have the problem with other files. If i upload the file with the button 'new document - type file', the file will upload correctly.

With the new version 5.3 of nuxeo i encounter the same problem.

Any idea of this error?

Thank you very much in advance!

Yolanda

Here is the log with the error message:

ERROR [org.nuxeo.ecm.webapp.filemanager.FileManageActionsBean] Error importing p1607.jpg
org.nuxeo.ecm.core.api.ClientException: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.RollbackClientException. message: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.ClientException. message: Failed to save session
        at org.nuxeo.ecm.platform.filemanager.ejb.FileManagerBean.createDocumentFromBlob(FileManagerBean.java:114)
        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:597)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
        at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
        at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
        at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
        at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)
        at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)
        at org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)
        at $Proxy217.createDocumentFromBlob(Unknown Source)
        at org.nuxeo.ecm.webapp.filemanager.FileManageActionsBean.createDocumentFromBlob(FileManageActionsBean.java:236)
        at org.nuxeo.ecm.webapp.filemanager.FileManageActionsBean.addBinaryFileFromPlugin(FileManageActionsBean.java:222)
        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:597)
        at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
        at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
        at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
        at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
        at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
        at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
        at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
        at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
        at org.nuxeo.ecm.webapp.filemanager.FileManageActionsBean_$$_javassist_55.addBinaryFileFromPlugin(FileManageActionsBean_$$_javassist_55.java)
        at org.nuxeo.ecm.platform.ui.web.restAPI.PluginUploadRestlet.handle(PluginUploadRestlet.java:108)
        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:597)
        at org.jboss.seam.util.Reflections.invoke(Reflections.java:21)
        at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
        at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
        at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:46)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
        at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
        at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
        at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
        at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
        at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
        at org.nuxeo.ecm.platform.ui.web.restAPI.PluginUploadRestlet_$$_javassist_54.handle(PluginUploadRestlet_$$_javassist_54.java)
        at org.nuxeo.ecm.platform.ui.web.restAPI.SeamRestletFilter.doHandle(SeamRestletFilter.java:124)
        at org.restlet.Filter.handle(Filter.java:134)
        at org.restlet.Filter.doHandle(Filter.java:105)
        at org.restlet.Filter.handle(Filter.java:134)
        at org.restlet.Router.handle(Router.java:444)
        at com.noelios.restlet.ext.servlet.ServletConverter.service(ServletConverter.java:129)
        at org.nuxeo.ecm.platform.ui.web.restAPI.RestletServlet.service(RestletServlet.java:125)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.nuxeo.wss.servlet.WSSFilter.doFilter(WSSFilter.java:135)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.nuxeo.ecm.platform.ui.web.rest.FancyURLFilter.doFilter(FancyURLFilter.java:127)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.nuxeo.ecm.platform.ui.web.auth.NuxeoAuthenticationFilter.doFilter(NuxeoAuthenticationFilter.java:468)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.nuxeo.ecm.platform.web.common.requestcontroller.filter.NuxeoRequestControllerFilter.doFilter(NuxeoRequestControllerFilter.java:133)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.nuxeo.ecm.platform.web.common.exceptionhandling.NuxeoExceptionFilter.doFilter(NuxeoExceptionFilter.java:80)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        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:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.RollbackClientException. message: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.ClientException. message: Failed to save session
        at org.nuxeo.ecm.core.api.ejb.DocumentManagerBean.save(DocumentManagerBean.java:312)
        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:597)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
        at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
        at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:57)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.nuxeo.jboss.interceptors.NXSessionSynchronizationInterceptor.invoke(NXSessionSynchronizationInterceptor.java:157)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
        at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.security.RoleBasedAuthorizationInterceptor.invoke(RoleBasedAuthorizationInterceptor.java:166)
        at org.jboss.ejb3.security.RoleBasedAuthorizationInterceptor.invoke(RoleBasedAuthorizationInterceptor.java:115)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
        at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
        at org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:206)
        at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:119)
        at $Proxy225.save(Unknown Source)
        at org.nuxeo.ecm.platform.picture.extension.ImagePlugin.create(ImagePlugin.java:106)
        at org.nuxeo.ecm.platform.filemanager.service.FileManagerService.createDocumentFromBlob(FileManagerService.java:247)
        at org.nuxeo.ecm.platform.filemanager.ejb.FileManagerBean.createDocumentFromBlob(FileManagerBean.java:110)
        ... 108 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.ClientException. message: Failed to save session
        at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1670)
        at org.nuxeo.ecm.core.api.ejb.DocumentManagerBean.save(DocumentManagerBean.java:310)
        ... 147 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.DocumentException. message: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "picture" ("id", "headline", "genre", "typage", "origin", "slugline", "caption", "dateline", "byline", "source", "cropcoords", "language", "credit", "subheadline") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:138)
        at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1666)
        ... 148 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.storage.StorageException. message: Could not insert: INSERT INTO "picture" ("id", "headline", "genre", "typage", "origin", "slugline", "caption", "dateline", "byline", "source", "cropcoords", "language", "credit", "subheadline") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        at org.nuxeo.ecm.core.storage.sql.Mapper.insertSingleRow(Mapper.java:832)
        at org.nuxeo.ecm.core.storage.sql.Context.save(Context.java:382)
        at org.nuxeo.ecm.core.storage.sql.PersistenceContext.save(PersistenceContext.java:322)
        at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:217)
        at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:204)
        at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.save(ConnectionImpl.java:158)
        at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:136)
        ... 149 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.postgresql.util.PSQLException. message: ERROR: invalid byte sequence for encoding "UTF8": 0x00
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
        at sun.reflect.GeneratedMethodAccessor145.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
        at $Proxy376.execute(Unknown Source)
        at org.nuxeo.ecm.core.storage.sql.Mapper.insertSingleRow(Mapper.java:829)
        ... 155 more
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8799>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I also experiencing this problem
--
Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8808>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by Lubomir Chorbadjiev :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Check this links:

http://jira.nuxeo.org/browse/NXP-3905
http://jira.nuxeo.org/browse/NXP-4085

Regards,
Lubomir

jiveforums-ecm@... wrote:

> I also experiencing this problem
> --
> Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
> View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8808>
> _______________________________________________
> ECM mailing list
> ECM@...
> http://lists.nuxeo.com/mailman/listinfo/ecm
> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>
>  
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Could you create a JIRA and attach the file that causes problem ?
--
Posted by "arussel" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8814>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have created the next JIRA:

http://jira.nuxeo.org/browse/NXP-4297
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8815>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have tried this same file in 5.3 and it does not throw this error. The file is imported but only about 1/5th of the image is actually converted. This is the message that shows up on the console...

08:08:53,948 INFO  [ReadOp] readMetadata(java.io.ByteArrayInputStream@194d09a, 0)
08:08:53,948 INFO  [ReadOp] read(java.io.ByteArrayInputStream@1232605, 0)
08:08:53,948 INFO  [ReadOp] read(java.io.ByteArrayInputStream@f4a549, 0)
08:08:53,948 INFO  [ReadOp] read(java.io.ByteArrayInputStream@9661bb, 0)
08:08:53,963 WARN  [EditableImage] No default implementation of ScaleOp(xScale:0.5, yScale:0.5, quality:BEST) for model: BufferedImage@a2d8ca: type = 5 ColorMod
el: #pixelBits = 24 numComponents = 3 color space = java.awt.color.ICC_ColorSpace@50e960 transparency = 1 has alpha = false isAlphaPre = false ByteInterleavedRa
ster: width = 148 height = 200 #numDataElements 3 dataOff[0] = 2
08:08:53,963 INFO  [EditableImage] Found alternate implementation: it.tidalwave.image.jai.ScaleJAIOp@146da00
08:08:53,963 INFO  [EditableImage] >>>> CONVERT FROM using ImplementationFactory[class javax.media.jai.PlanarImage]
08:08:53,979 INFO  [EditableImage] >>>> NEW IMAGE PlanarImage[minX=0 minY=0 width=148 height=200 tileGridXOffset=0 tileGridYOffset=0 tileWidth=148 tileHeight=20
0 sampleModel=java.awt.image.PixelInterleavedSampleModel@300bc02 colorModel=ColorModel: #pixelBits = 24 numComponents = 3 color space = java.awt.color.ICC_Color
Space@50e960 transparency = 1 has alpha = false isAlphaPre = false] NEW IMAGE MODEL it.tidalwave.image.SerializableImageModelHolder@176fa06
08:08:53,979 WARN  [ScaleJAIOp] >>>> ScaleJAIOp is not optimized
--
Posted by "bgrant" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8827>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

i attached my file too
--
Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8837>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

@ythomas: it seems a patch resolved the issue http://jira.nuxeo.org/browse/NXP-4297 , could you check it and close the issue ?
--
Posted by "arussel" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8847>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I tried with the file:

P2008_030_Solara 3G_rev 102609.pdf

and I have no problem uploading this file with nuxeo 5.2 or 5.3 without applying NXP-4292. With my attached file i am still having the same problem, even updating with  NXP-4292 (all nuxeo-platform-imaging-*-20091108*.jar).

Now i have the next log:

2009-11-09 13:34:00,097 INFO  [it.tidalwave.image.op.ReadOp] readMetadata(java.io.FileInputStream@41a33020, 0)
2009-11-09 13:34:00,300 INFO  [it.tidalwave.image.op.ReadOp] read(java.io.FileInputStream@438f17eb, 0)
2009-11-09 13:34:00,471 WARN  [it.tidalwave.image.EditableImage] No default implementation of ScaleOp(xScale:0.6655791190864601, yScale:0.6655791190864601, quality:BEST) for model: BufferedImage@5ee9f4d0: type = 5 ColorModel: #pixelBits = 24 numComponents = 3 color space = java.awt.color.ICC_ColorSpace@6a8ba7d9 transparency = 1 has alpha = false isAlphaPre = false ByteInterleavedRaster: width = 613 height = 826 #numDataElements 3 dataOff[0] = 2
2009-11-09 13:34:00,471 INFO  [it.tidalwave.image.EditableImage] Found alternate implementation: it.tidalwave.image.jai.ScaleJAIOp@6c742ce7
2009-11-09 13:34:00,471 INFO  [it.tidalwave.image.EditableImage] >>>> CONVERT FROM using ImplementationFactory[class javax.media.jai.PlanarImage]
2009-11-09 13:34:00,486 INFO  [it.tidalwave.image.EditableImage] >>>> NEW IMAGE PlanarImage[minX=0 minY=0 width=613 height=826 tileGridXOffset=0 tileGridYOffset=0 tileWidth=613 tileHeight=826 sampleModel=java.awt.image.PixelInterleavedSampleModel@3062f02 colorModel=ColorModel: #pixelBits = 24 numComponents = 3 color space = java.awt.color.ICC_ColorSpace@6a8ba7d9 transparency = 1 has alpha = false isAlphaPre = false] NEW IMAGE MODEL it.tidalwave.image.SerializableImageModelHolder@43523784
2009-11-09 13:34:00,498 WARN  [it.tidalwave.image.jai.ScaleJAIOp] >>>> ScaleJAIOp is not optimized
2009-11-09 13:34:01,428 INFO  [it.tidalwave.image.op.ReadOp] read(java.io.FileInputStream@16b5b4d1, 0)
2009-11-09 13:34:01,529 WARN  [it.tidalwave.image.EditableImage] No default implementation of ScaleOp(xScale:0.25, yScale:0.25, quality:BEST) for model: BufferedImage@62c2ff42: type = 5 ColorModel: #pixelBits = 24 numComponents = 3 color space = java.awt.color.ICC_ColorSpace@6a8ba7d9 transparency = 1 has alpha = false isAlphaPre = false ByteInterleavedRaster: width = 613 height = 826 #numDataElements 3 dataOff[0] = 2
2009-11-09 13:34:01,529 INFO  [it.tidalwave.image.EditableImage] Found alternate implementation: it.tidalwave.image.jai.ScaleJAIOp@700478b5
2009-11-09 13:34:01,529 INFO  [it.tidalwave.image.EditableImage] >>>> CONVERT FROM using ImplementationFactory[class javax.media.jai.PlanarImage]
2009-11-09 13:34:01,529 INFO  [it.tidalwave.image.EditableImage] >>>> NEW IMAGE PlanarImage[minX=0 minY=0 width=613 height=826 tileGridXOffset=0 tileGridYOffset=0 tileWidth=613 tileHeight=826 sampleModel=java.awt.image.PixelInterleavedSampleModel@3062f02 colorModel=ColorModel: #pixelBits = 24 numComponents = 3 color space = java.awt.color.ICC_ColorSpace@6a8ba7d9 transparency = 1 has alpha = false isAlphaPre = false] NEW IMAGE MODEL it.tidalwave.image.SerializableImageModelHolder@3d98ae8a
2009-11-09 13:34:01,529 WARN  [it.tidalwave.image.jai.ScaleJAIOp] >>>> ScaleJAIOp is not optimized
2009-11-09 13:34:01,530 WARN  [it.tidalwave.image.jai.ScaleJAIOp] >>>> ScaleJAIOp is not optimized
2009-11-09 13:34:01,589 ERROR [org.nuxeo.ecm.core.storage.sql.TransactionalSession] Could not end transaction
org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "iptc" ("id", "time_created", "language", "city", "country_or_primary_location", "copyright_notice", "writer", "originating_program", "special_instructions", "source", "province_or_state", "keywords", "supplemental_categories", "record_version", "release_date", "original_transmission_ref", "caption", "release_time", "urgency", "by_line", "headline", "credit", "date_created", "by_line_title", "object_name", "category") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
.
.
.
.
.
.
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.postgresql.util.PSQLException. message: ERROR: invalid byte sequence for encoding "UTF8": 0x00
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
        at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
        at $Proxy375.execute(Unknown Source)
        at org.nuxeo.ecm.core.storage.sql.Mapper.insertSingleRow(Mapper.java:829)
        ... 155 more


Thanks,
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8854>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Did you try with the .jpg file that i attached?
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8855>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I tried your attached jpeg file on 5.3 (with the patch applied) running on Windows and the file imported without error.
--
Posted by "bgrant" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8857>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

With nuxeo default database i can import the files without problems, from "d&d pluging", "import button" and "new document" (type "picture" document) button.

The problem is when i use postgres 8.3, the d&d plugin and import button fail. I only can import the document with the "new document" option but only with document "file" option.

I work with debian lenny and postgres 8.3.

Did you try with postgres 8.3?

Thanks.
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8858>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

The problem is resolved patching with http://hg.nuxeo.org/nuxeo/nuxeo-features/rev/ab1702643555.
I tried with nuxeo 5.3.0 (patch) and postgres 8.3 and it is working correctly.

Thanks.
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8895>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Is there anyway I can get this working in 5.2.0-RC1.

I am being hammered by customers right now, and the upgrade to 5.3 has proven very difficult?

It happens repeatedly with different documents.  

please help if possible
--
Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8952>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

all of my documents are PDFs.  about 1 in 10 submitted by my customers result in this error.
--
Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8954>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I tried patching nuxeo dm 5.2 to solve this problem but the pacth is not working for this version.
I had to install nuxeo dm 5.3.0 and then i applied the patch but i didn't migrate my database, i installed a new database. But I had the problem with jpg files and metadata.

Before this problem i had other with pdf files, the problem was:

http://jira.nuxeo.org/browse/NXP-3675

In version 5.3 this pacth is applied and the problem is resolved. But i applied the next changes in BinaryTextListener.java class in version 5.2 solving problems just with pdf files:

http://hg.nuxeo.org/nuxeo/nuxeo-core/diff/287b7d10b2eb/nuxeo-core-storage-sql/nuxeo-core-storage-sql/src/main/java/org/nuxeo/ecm/core/storage/sql/coremodel/BinaryTextListener.java

You could try just pacthing nuxeo 5.2 with the last class, but to solve all the problems (pdf and jpg)  i had to migrate to nuxeo 5.3.0.

Yolanda
--
Posted by "ytomas" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8966>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.3)

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thank your for the advice.  I feel I am stuck at 5.2-RC1 right now b/c of data migration issues.

The change you suggest looks very relevant to my problem.  I am really trying to get this fixed asap, and I am perfectly willing to merge in changes and build on my own if someone can point me to the right changesets.

So, all my documents are PDFs.  Nothing else is submitted by customers.  
Do you have any tips on how I get my RC1 code base.  

I am very familiar with this link: http://www.nuxeo.org/xwiki/bin/view/FAQ/DownloadingNuxeoSources
Do I use hg clone http://hg.nuxeo.org/nuxeo#5.2-RC1

what would I put there for RC1?

-alexander

Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.api.DocumentException. message: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INS
ERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES (?, NX_TO_TSVECTOR(?), NX_TO_TSVECTOR(?), NX_TO_TSVECTOR(?))
        at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:140)
        at org.nuxeo.ecm.core.api.AbstractSession.save(AbstractSession.java:1599)        ... 185 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.storage.StorageException. message: Could not insert: INSERT INTO "fulltext" ("id", "fulltext", "simpletext", "binarytext") VALUES (?, NX_TO_TSVECTOR(?), NX_TO_TSVECTOR(?), NX_TO_TSVECTOR(?))
        at org.nuxeo.ecm.core.storage.sql.Mapper.insertSingleRow(Mapper.java:589)
        at org.nuxeo.ecm.core.storage.sql.Context.save(Context.java:370)
        at org.nuxeo.ecm.core.storage.sql.PersistenceContext.save(PersistenceContext.java:292)
        at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:209)
        at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:197)
        at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.save(ConnectionImpl.java:144)
        at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.save(SQLSession.java:138)
        ... 186 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.postgresql.util.PSQLException. message: ERROR: invalid byte sequence for encoding "UTF8": 0x00
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
        at sun.reflect.GeneratedMethodAccessor412.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:477)
        at $Proxy329.execute(Unknown Source)
        at org.nuxeo.ecm.core.storage.sql.Mapper.insertSingleRow(Mapper.java:587)
        ... 192 more
--
Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8968>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> {quote:title=ajbiv wrote:}
> I am very familiar with this link: http://www.nuxeo.org/xwiki/bin/view/FAQ/DownloadingNuxeoSources
> Do I use hg clone http://hg.nuxeo.org/nuxeo#5.2-RC1
> what would I put there for RC1?
{quote}

Go to that hg URL, click on "tags" at the top, and you'll see that the tag you want is #release-5.2.0-RC1
--
Posted by "fguillaume" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8969>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm

Re: Error invalid byte sequence for encoding "UTF8": 0x0 (nuxeo+postgres 8.

by jiveforums-ecm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

5.3.0 upgrade fixed these issues.
--
Posted by "ajbiv" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread: <http://www.nuxeo.org/discussions/thread.jspa?threadID=2996#8997>
_______________________________________________
ECM mailing list
ECM@...
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm