Issue with characters

[mirthe]

Hi, I have just purchased the Pro version and tried to identify my library.

It seems I am facing problems with this album:

Nightwish - Human. :II: Nature.

Do note the interesting characters, including the . as suffix.

When trying to rename the files, I get the following errors:

could not execute statement

null id in com.jthink.songlayer.SongProcessed entry (don’t flush the Session after an exception occurs).

Using the ‘Support files’ i attached my logs. For now, I decided to manually move the album. However it might be interesting to investigate this issue as I had to reset my database.

Album on Discogs

[paultaylor]

Hi, i think the issue is actually due to the huge performer list on the MusicBrainz version of release, this is making the ARTIST field too long for database and causing error

https://musicbrainz.org/release/88f833e7-b386-4599-a363-4e8f8cd09658

looking into it further but found this error in logs

Caused by: org.h2.jdbc.JdbcSQLDataException: Value too long for column """ARTIST"" VARCHAR(1000) SELECTIVITY 4": "'Roger Harvey; Caroline Dale; Marco Hietala; Tarja Turunen; Tuomas Holopainen; Emppu Vuorinen; Jukka Nevalainen; Andy Findon; Fr... (1071)"; SQL statement:
insert into SongProcessed (id, albumArtist, albumName, artist, composer, filename, recNo, reportId, version, work) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-199]

[paultaylor]

Raised https://jthink.atlassian.net/browse/SONGKONG-2539

[mirthe]

Oops yes, I think they put in the whole orchestra haha. Thank you for investigating this.

[paultaylor]

And fixed in SongKong 10.3 Blur