Re: ERROR 22003

Posted:
Sat Mar 01, 2014 8:37 am
by stephendhill
Think I missed important part of log, so here's the rest:
at org.apache.derby.iapi.types.SQLSmallint.setValue(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
Caused by: ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
... 14 more
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
Caused by: java.sql.SQLException: The resulting value is outside the range for the data type SMALLINT.
... 7 more
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:86)
at org.serviio.util.JdbcUtils.setIntValueOnStatement(JdbcUtils.java:186)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setInt(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
Caused by: java.sql.SQLDataException: The resulting value is outside the range for the data type SMALLINT.
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.run(LibraryAdditionsCheckerThread.java:83)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:134)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:134)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.searchForNewFiles(LibraryAdditionsCheckerThread.java:145)
at org.serviio.library.local.metadata.LibraryAdditionsCheckerThread.addNewMediaFile(LibraryAdditionsCheckerThread.java:185)
at org.serviio.library.local.service.AudioService.addMusicTrackToLibrary(AudioService.java:93)
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:38)
at org.serviio.library.dao.MusicTrackDAOImpl.create(MusicTrackDAOImpl.java:91)
org.serviio.db.dao.PersistenceException: Cannot create MusicTrack with title Shine
2014-02-28 20:21:45,807 WARN [LibraryAdditionsCheckerThread] Cannot add file 12 Estelle - Shine.flac because of an unexpected error. Message: Cannot create MusicTrack with title Shine
Re: ERROR 22003

Posted:
Sat Mar 01, 2014 8:54 am
by stephendhill
Dump of metadata (ffmpeg -f ffmetadata):
;FFMETADATA1
TITLE=Shine
ARTIST=Estelle
ALBUM ARTIST=Estelle
album_artist=Estelle
ALBUM=Shine
DISC=412860
track=12
YEAR=2008
ORGANIZATION=Wea Japan
GENRE=R&B
DATE=2008
ISRC=075678995422
ENCODER=MediaMonkey 4.1.0
ENSEMBLE=Estelle
Re: ERROR 22003

Posted:
Sat Mar 01, 2014 9:07 am
by stephendhill
Also of interest is the fact that Logitech Media Server, which is running on the same machine as Serviio, has no problem with these tracks (there's more than one track of this album being bounced by Serviio for some reason).
Re: ERROR 22003

Posted:
Sat Mar 01, 2014 11:25 pm
by stephendhill
This turned out to be the 'part #' (otherwise known as 'Disc #').
Looks like there's a bug in Serviio when a part number is included in the metadata.
I have raised Issue #767 in BitBucket.