Cannot create 'Genre'

Issue #487 resolved
Former user created an issue

Log below, adding mp3 all folders work except for 'Rat Pack' Christmas album. log message below, cannot create genre

2012-01-06 18:22:16,122 WARN [LibraryAdditionsCheckerThread] Cannot add file 15 - Jingle Bells - Sammy Davis Jr..mp3 because of an unexpected error. Message: Cannot create Genre with name American Popular Song Ballads Big Band Christmas Christmas / Chanukkah Christmas Music Holiday Pop Traditional Pop V/a Compilations Vocal Jazz Vocal Pop Xmas Vocal Collections org.serviio.db.dao.PersistenceException: Cannot create Genre with name American Popular Song Ballads Big Band Christmas Christmas / Chanukkah Christmas Music Holiday Pop Traditional Pop V/a Compilations Vocal Jazz Vocal Pop Xmas Vocal Collections at org.serviio.library.dao.GenreDAOImpl.create(GenreDAOImpl.java:62) at org.serviio.library.dao.GenreDAOImpl.create(GenreDAOImpl.java:34) at org.serviio.library.local.service.GenreService.findOrCreateGenre(GenreService.java:89) at org.serviio.library.local.service.AudioService.addMusicTrackToLibrary(AudioService.java:67) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:154) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:128) at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:78) Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'American Popular Song Ballads Big Band Christmas Christmas /&' to length 128. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.executeUpdate(Unknown Source) at org.serviio.library.dao.GenreDAOImpl.create(GenreDAOImpl.java:59) ... 6 more Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR 'American Popular Song Ballads Big Band Christmas Christmas /&' to length 128. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 16 more Caused by: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR 'American Popular Song Ballads Big Band Christmas Christmas /&' to length 128. 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.SQLVarchar.normalize(Unknown Source) at org.apache.derby.iapi.types.SQLVarchar.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.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 10 more

Comments (2)

  1. Log in to comment