nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

a Picture upload error in 5.8 HF05

adam_bo_

After the picture upload there is no preview of it. In the logfile is recorded:

2014-01-31 18:26:30,701 WARN [Transaction] Error ending association for XAResource org.apache.geronimo.transaction.manager.WrapperNamedXAResource@4e3d3e45; transaction will roll back. XA error code: -3 javax.transaction.xa.XAException ...

Caused by: org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "image_metadata" ("id", "icc_profile", "white_balance", "pixel_xdimension", "yresolution", "copyright", "color_space", "date_time_original", "orientation", "xresolution", "user_comment", "image_description", "pixel_ydimension", "iso_speed_ratings", "equipment", "fnumber", "focal_length", "exposure_time") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:606) ...

Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "image_metadata" ("id", "icc_profile", "white_balance", "pixel_xdimension", "yresolution", "copyright", "color_space", "date_time_original", "orientation", "xresolution", "user_comment", "image_description", "pixel_ydimension", "iso_speed_ratings", "equipment", "fnumber", "focal_length", "exposure_time") VALUES ('c85a74b1-f253-441e-bdcf-d440a2aef14f', NULL, 'auto', 3264, 72, NULL, 'SRGB', '2014-01-31 10:43:44.000000 +01:00:00', 'TOP_LEFT', 72, 'KJKJAKJKJAdz?ecuteBatch(AbstractJdbc2Statement.java:2893) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:590) ... 20 more

Caused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ... 25 more

Find more posts tagged with

Comments

Florent_Guillau

The stack trace is incomplete at the end, we're missing a detailed cause.

Florent_Guillau

I updated the original question with your stack trace. Please don't use the answers section to post things that are not answers.

Florent_Guillau

The cause is:

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

So one of the strings that is passed contains a U+0000 character, which PostgreSQL forbids. Which string exactly is difficult to determine using just the logs, but it seems to be the EXIF UserComment field that contains garbage

We'll see if the strings can be sanitized a bit before being saved into the Nuxeo document. I opened NXP-13682 for this. If possible please attach to that ticket an example image for which the problem occurs (if the image can be freely distributed — if not, please send it by email to me, fg@nuxeo.com).

adam_bo_

I will send it by email

Thomas_Roger

The User-Comment metadata can be a binary. There is already an issue tracking that