DataMappingException unable to map 'Actor'

[AlexRies]

Hi team,

I can’t get in to Sonarr anymore (I get stuck at the loading screen) the log file gives me this:

JSON Line
And:
The Exception Line

I’ve added images to show the bad character as it doesn’t show up in a text paste. My main question is: where is this piece of JSON coming from (I’m guessing it’s not thetvdb service as it’s malformatted), I haven’t done anything specific with Sonarr recently so I can’t tell what the cause is or when this happens.

Version Info:

{
  "version": "2.0.0.3732",
  "buildTime": "2016-01-15T02:11:50Z",
  "isDebug": false,
  "isProduction": true,
  "isAdmin": true,
  "isUserInteractive": false,
  "startupPath": "C:\\ProgramData\\NzbDrone\\bin",
  "appData": "C:\\ProgramData\\NzbDrone",
  "osVersion": "6.2.9200.0",
  "isMonoRuntime": false,
  "isMono": false,
  "isLinux": false,
  "isOsx": false,
  "isWindows": true,
  "branch": "master",
  "authentication": "basic",
  "sqliteVersion": "3.8.7.2",
  "urlBase": "",
  "runtimeVersion": "4.0.30319.34209"
}

[markus101]

Its coming from Sonarr’s database, somehow the JSON was corrupted when saving the series (The Last Ship) to the database.

A few solutions:

Edit the database and fix it (open nzbdrone.db in a SQLite editor) and then run UPDATE Series SET Actors = [] WHERE Title = 'The Last Ship'.

Use the API to delete the series, but you’d need to know the series ID from the database

Restore a backup of the DB

[AlexRies]

Thanks Markus, this helped. I had to update multiple series, and had to clear out the Season, Actors, Ratings likes with [], [] and { } respectively. I don’t know why this happened it was structural for two of my shows though with the same mess with all these columns. The Actors and the Ratings had the weird STX character in it, The Seasons had a random “s” and some mal formatting with parenthesis outside of a string.

The Seasons weird formatting was this:

[
  {
    "seasonNumber": 0,
    "monitored": false,
    *images": []
  },
  {
    "seasonNumber": 1,
    "monitored": true,
    "imiges": [
      s
        "coverType": "poster",
        "url": "http://thetvdb.com/banners/seasons/295743-1.jpg"
      }
  ( ]
  }
]

Could this be some freak threading issue while writing to the database?

[markus101]

Its possible, but I fear anything is just a guess. I know we saw a similar issue a number of times with a bad mono version, but updating past it always solved it, this is the first time I recall it being an issue on Windows.