Error adding person with special character in name

Issue #1165 resolved
Petr Nejedly repo owner created an issue

2021-04-16 08:41:51,730 WARN [MediaFileIndexer] Cannot add file /volume1/Zenek/Egyéb/Barsi Balázs ofm előadásai és prédikációi/051-060/A pap feladata.mp3 because of an unexpected error. Message: Cannot create Person with name ß?
org.serviio.db.dao.PersistenceException: Cannot create Person with name ß?
at org.serviio.library.dao.PersonDAOImpl.createPerson(PersonDAOImpl.java:808)
at org.serviio.library.dao.PersonDAOImpl.addPersonToMusicAlbum(PersonDAOImpl.java:160)
at org.serviio.library.local.service.AudioService.findOrCreateAlbum(AudioService.java:566)
at org.serviio.library.local.service.AudioService.addMusicTrackToLibrary(AudioService.java:63)
at org.serviio.library.local.indexing.MediaFileIndexer.addNewMediaFile(MediaFileIndexer.java:85)
at org.serviio.library.local.indexing.DefaultLibraryMonitor.fileAdded(DefaultLibraryMonitor.java:52)
at org.serviio.library.local.indexing.pipe.PipeManager$PipeProcessingConsumer.lambda$0(PipeManager.java:174)
at java.util.Optional.ifPresent(Optional.java:159)
at org.serviio.library.local.indexing.pipe.PipeManager$PipeProcessingConsumer.run(PipeManager.java:169)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink CHAR 'SS' to length 1.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.serviio.library.dao.PersonDAOImpl.createPerson(PersonDAOImpl.java:805)
... 9 more
Caused by: ERROR 22001: A truncation error was encountered trying to shrink CHAR 'SS' to length 1.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.normalize(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.normalize(Unknown Source)
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 14 more

Comments (1)

  1. Log in to comment