Beta 5 import issue after crash

Arc App Support
1

Hello Matt,

I am experiencing an issue with the new beta 5. After updating from beta 4 to beta 5 on Sunday, the application crashed every time I launched it. So I deleted the application and reinstalled it. But now importing the old LocoKit Database is failing: importing locomotion samples systematically fails at 7%.

Oh, of course and unfortunately, I only have a partial backup of Arc Editor (it stops at 15 August).

Here is an extract from the logs:

[10:30:31.369] [IMPORTING] Starting Places import
[10:30:31.411] [IMPORTING] Places import completed
[10:30:31.411] [IMPORTING] Starting Timeline Items import
[10:30:36.160] [IMPORTING] Timeline Items import completed
[10:30:36.160] [IMPORTING] Starting Samples import
[10:31:36.161] --1--
[10:31:41.384] [ERROR] [IMPORTING] Database import failed: SQLite error 19: Sample disabled state must match parent item disabled state - while executing `INSERT OR IGNORE INTO "locomotionSample" ("id", "lastSaved", "date", "secondsFromGMT", "source", "sourceVersion", "movingState", "recordingState", "disabled", "timelineItemId", "latitude", "longitude", "altitude", "horizontalAccuracy", "verticalAccuracy", "speed", "course", "classifiedActivityType", "confirmedActivityType", "stepHz", "xyAcceleration", "zAcceleration", "heartRate", "rtreeId") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`
[10:31:41.385] [ERROR] [MISC] SQLite error 19: Sample disabled state must match parent item disabled state - while executing `INSERT OR IGNORE INTO "locomotionSample" ("id", "lastSaved", "date", "secondsFromGMT", "source", "sourceVersion", "movingState", "recordingState", "disabled", "timelineItemId", "latitude", "longitude", "altitude", "horizontalAccuracy", "verticalAccuracy", "speed", "course", "classifiedActivityType", "confirmedActivityType", "stepHz", "xyAcceleration", "zAcceleration", "heartRate", "rtreeId") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`
[10:32:08.411] [LIFECYCLE] ArcTimelineEditorApp.enteredBackground()
[10:32:11.553] [LIFECYCLE] ArcTimelineEditorApp.becameActive()

Do you have any advice for me?

1 Like
2

Oh! My bad. The new build(s) added a database constraint, in preparation for workout importing, that TimelineItems can only have LocomotionSamples with same disabled state (eg is item is disabled, it can only have disabled samples, and vice versa). I guess some of the old LocoKit data doesn’t adhere to that rule, so the importer is failing once it gets to that data.

I’ll fix the importer to work around that data inconsistency, and hopefully get a new build out today. Once that new build arrives you should be able to do a full old LocoKit import again.

3

Well, isn’t that the point of beta versions, to discover these issues?

Thank you for these explanations: I’ll wait for the next beta version.

1 Like
4

Heh. True.

I got that issue fixed yesterday, but in the process discovered some other weaknesses in the old LocoKit and JSON importers, that I’m planning on finishing up fixing today. Hopefully will have a new build out this afternoon.

5

Take your time, there’s no rush. I can wait a few days without Arc Editor. :blush:

1 Like
6

The new build got delayed by a couple of days due to food poisoning :face_vomiting: Fun times!

I’ll get it shipped today. I actually managed to get a bunch of improvements into the importers, both old LocoKit and JSON, before I got taken out by bacterial enemies.

7

New build should be live now! Imports should be working properly again :+1:t3:

8

Thanks Matt : it works perfectly.

1 Like