Special Characters in Attachment Name

Seems like the special characters in a image attachment are causing problems when SMART tries to process the data queue item.
Emily's initial assement: "zip files probably don't support special characters. We can do some testing - I suggest making a ticket. This probably has wide-ranging effects as it effects all files in the system."

Leave a comment

on 2018-08-01 13:32 *

By egouge

I tested this with 6.1 on our local connect server and couldn't not reproduce any issues with the special characters or spaces in the filename.

on 2018-08-01 14:24 *

By egouge

From the connect server:

SEVERE: java.nio.file.InvalidPathException: Malformed input or input contains unmappable characters: /var/appdata/9d970e1b57f94dd58b9c8def5d9ce61c/patrol/ad6c0ea315c7425c98c12f4a3239c1bf/F1-carriqui de monta?a.JPG
java.sql.SQLException: java.nio.file.InvalidPathException: Malformed input or input contains unmappable characters: /var/appdata/9d970e1b57f94dd58b9c8def5d9ce61c/patrol/ad6c0ea315c7425c98c12f4a3239c1bf/F1-carriqui de monta?a.JPG
        at org.wcs.smart.connect.replication.changelog.ChangeLogDeserializer$1.execute(ChangeLogDeserializer.java:100)
        at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)
        at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1943)
        at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1940)
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:293)
        at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1961)
        at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1947)
        at org.wcs.smart.connect.replication.changelog.ChangeLogDeserializer.processFile(ChangeLogDeserializer.java:62)
        at org.wcs.smart.connect.uploader.sync.PostgresqlChangeLogDeserializer.processFile(PostgresqlChangeLogDeserializer.java:57)
        at org.wcs.smart.connect.uploader.sync.PostgresqlSyncProcessor.applyChangeLog(PostgresqlSyncProcessor.java:147)
        at org.wcs.smart.connect.uploader.sync.PostgresqlSyncProcessor.processFile(PostgresqlSyncProcessor.java:136)
        at org.wcs.smart.connect.uploader.sync.SyncUploadCaProcessor.processItem(SyncUploadCaProcessor.java:89)
        at org.wcs.smart.connect.uploader.ItemProcessManager.processItem(ItemProcessManager.java:77)
        at org.wcs.smart.connect.uploader.UploaderProcessor.run(UploaderProcessor.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.nio.file.InvalidPathException: Malformed input or input contains unmappable characters: /var/appdata/9d970e1b57f94dd58b9c8def5d9ce61c/patrol/ad6c0ea315c7425c98c12f4a3239c1bf/F1-carriqui de monta?a.JPG
        at sun.nio.fs.UnixPath.encode(UnixPath.java:147)
        at sun.nio.fs.UnixPath.<init>(UnixPath.java:71)
        at sun.nio.fs.UnixFileSystem.getPath(UnixFileSystem.java:281)
        at org.wcs.smart.connect.uploader.sync.PostgresqlChangeLogDeserializer.processFileInsert(PostgresqlChangeLogDeserializer.java:89)
        at org.wcs.smart.connect.replication.changelog.ChangeLogDeserializer$1.execute(ChangeLogDeserializer.java:94)
        ... 20 more

on 2018-08-07 14:23 *

By jeffloun2

Summary changed from Special Characters in Connect Data Queue Causes Problem to Special Characters in Attachment Name

on 2018-08-08 12:40 *

By egouge

Status changed from New to Invalid

I tested out attachments with special characters without any issues.

This user was using an odd collection of SMART Desktop v4 with a Connect server using smart 4.0 jar files which may have lead to the problem. Once they resolve their version issues they should retest and let us know if they continue to have problems.

on 2018-09-21 18:03 *

By jeffloun2

Status changed from Invalid to In-Progress

We got the version issues fixed and the above error occurs again on the attachment filename with a special character in it:

Sep 21, 2018 9:29:18 PM org.wcs.smart.connect.uploader.sync.SyncUploadCaProcessor processItem
SEVERE: java.nio.file.InvalidPathException: Malformed input or input contains unmappable characters: /var/appdata/9d970e1b57f94dd58b9c8def5d9ce61c/patrol/86fc0e3d4b744cf48a0e167355cd3226/Trochas cacer?a 20-2-2018 S6.jpg
java.sql.SQLException: java.nio.file.InvalidPathException: Malformed input or input contains unmappable characters: /var/appdata/9d970e1b57f94dd58b9c8def5d9ce61c/patrol/86fc0e3d4b744cf48a0e167355cd3226/Trochas cacer?a 20-2-2018 S6.jpg
at org.wcs.smart.connect.replication.changelog.ChangeLogDeserializer$1.execute(ChangeLogDeserializer.java:103)
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)
at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1943)
at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1940)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:293)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1961)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1947)
at org.wcs.smart.connect.replication.changelog.ChangeLogDeserializer.processFile(ChangeLogDeserializer.java:65)
at org.wcs.smart.connect.uploader.sync.PostgresqlChangeLogDeserializer.processFile(PostgresqlChangeLogDeserializer.java:59)
at org.wcs.smart.connect.uploader.sync.PostgresqlSyncProcessor.applyChangeLog(PostgresqlSyncProcessor.java:147)
at org.wcs.smart.connect.uploader.sync.PostgresqlSyncProcessor.processFile(PostgresqlSyncProcessor.java:136)
at org.wcs.smart.connect.uploader.sync.SyncUploadCaProcessor.processItem(SyncUploadCaProcessor.java:89)
at org.wcs.smart.connect.uploader.ItemProcessManager.processItem(ItemProcessManager.java:77)
at org.wcs.smart.connect.uploader.UploaderProcessor.run(UploaderProcessor.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.nio.file.InvalidPathException: Malformed input or input contains unmappable characters: /var/appdata/9d970e1b57f94dd58b9c8def5d9ce61c/patrol/86fc0e3d4b744cf48a0e167355cd3226/Trochas cacer?a 20-2-2018 S6.jpg
at sun.nio.fs.UnixPath.encode(UnixPath.java:147)
at sun.nio.fs.UnixPath.<init>(UnixPath.java:71)
at sun.nio.fs.UnixFileSystem.getPath(UnixFileSystem.java:281)
at org.wcs.smart.connect.uploader.sync.PostgresqlChangeLogDeserializer.processFileInsert(PostgresqlChangeLogDeserializer.java:91)
at org.wcs.smart.connect.replication.changelog.ChangeLogDeserializer$1.execute(ChangeLogDeserializer.java:97)
... 20 more

on 2018-09-21 18:05 *

By jeffloun2

(Comment removed)

on 2018-09-21 18:05 *

By jeffloun2

Milestone changed from 6.1 to 6.2

Milestone updated at changed from 2018-08-01 09:42:59 -0700 to 2018-09-21 15:05:17 -0700

on 2018-09-25 13:53 *

By jeffloun2

Their file exactly works fine in 6.1 as well.
I also setup a 4.1 Connect server and sync'd changes with no error after adding the file as an attachment.

on 2018-10-03 16:58 *

By egouge

Assigned to set to jeffloun2

on 2018-10-12 14:13 *

By jeffloun2

Status changed from In-Progress to Invalid

Haven't heard anything back on the latest suggestions to try and isolate this problem.

Name	Size
image.png	23.8 KB	Added by jeffloun2 on 2018-08-01 - Upload new version

Trochas cacería 20-2-2018 S6.jpg	5.22 MB	Added by jeffloun2 on 2018-09-21 - Upload new version

Drop the files anywhere in this page to upload them as attachments.

Add a Relation

Related Tickets

Add people from your team or external to follow ticket activity

jeffloun2

Attachments

Related Tickets

Followers

Special Characters in Attachment Name

Related Tickets

Add people from your team or external to follow ticket activity

Followers will receive email updates about new ticket activity or emails sent to smart-cs+2518@tickets.assembla.com

Attachments

Related Tickets

Followers

Special Characters in Attachment Name

Granting access, please wait...

Related Tickets

Add people from your team or external to follow ticket activity

Followers will receive email updates about new ticket activity or emails sent to smart-cs+2518@tickets.assembla.com