FAQ  •  Register  •  Login

ERROR 22003

<<

stephendhill

Serviio lover

Posts: 72

Joined: Sat Jan 30, 2010 9:59 am

Location: UK

Post Fri Feb 28, 2014 8:48 pm

ERROR 22003

2014-02-28 20:12:16,256 WARN [LibraryAdditionsCheckerThread] Cannot add file 08 Estelle - In the Rain.flac because of an unexpected error. Message: Cannot create MusicTrack with title In the Rain
... 10 more
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.
Avid Serviio user
Pure Flow One | Samsung LE40B650 | Samsung UE40F6320 | Sony PS3 | Ubuntu 14.04
<<

stephendhill

Serviio lover

Posts: 72

Joined: Sat Jan 30, 2010 9:59 am

Location: UK

Post Sat Mar 01, 2014 8:31 am

Re: ERROR 22003

Derby log:
----------------------------------------------------------------
Fri Feb 28 20:11:28 GMT 2014:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.10.1.1 - (1458268): instance a816c00e-0144-7a1f-7dbb-00004ddc491f
on database directory /shared_data/serviio/serviio-1.4/library/db with class loader sun.misc.Launcher$AppClassLoader@1a16869
Loaded from file:/shared_data/serviio/serviio-1.4/lib/derby.jar
java.vendor=Sun Microsystems Inc.
java.runtime.version=1.6.0_24-b07
user.dir=/
os.name=Linux
os.arch=i386
os.version=3.2.0-59-generic-pae
derby.system.home=/shared_data/serviio/serviio-1.4/library
derby.stream.error.file=../log/derby.log
Database Class Loader started - derby.database.classpath=''
Avid Serviio user
Pure Flow One | Samsung LE40B650 | Samsung UE40F6320 | Sony PS3 | Ubuntu 14.04
<<

stephendhill

Serviio lover

Posts: 72

Joined: Sat Jan 30, 2010 9:59 am

Location: UK

Post Sat Mar 01, 2014 8:37 am

Re: ERROR 22003

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
Avid Serviio user
Pure Flow One | Samsung LE40B650 | Samsung UE40F6320 | Sony PS3 | Ubuntu 14.04
<<

stephendhill

Serviio lover

Posts: 72

Joined: Sat Jan 30, 2010 9:59 am

Location: UK

Post Sat Mar 01, 2014 8:54 am

Re: ERROR 22003

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
Avid Serviio user
Pure Flow One | Samsung LE40B650 | Samsung UE40F6320 | Sony PS3 | Ubuntu 14.04
<<

stephendhill

Serviio lover

Posts: 72

Joined: Sat Jan 30, 2010 9:59 am

Location: UK

Post Sat Mar 01, 2014 9:07 am

Re: ERROR 22003

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).
Avid Serviio user
Pure Flow One | Samsung LE40B650 | Samsung UE40F6320 | Sony PS3 | Ubuntu 14.04
<<

stephendhill

Serviio lover

Posts: 72

Joined: Sat Jan 30, 2010 9:59 am

Location: UK

Post Sat Mar 01, 2014 11:25 pm

Re: ERROR 22003

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.
Avid Serviio user
Pure Flow One | Samsung LE40B650 | Samsung UE40F6320 | Sony PS3 | Ubuntu 14.04

Return to Serviio Support & Help

Who is online

Users browsing this forum: No registered users and 78 guests

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by ST Software for PTF.