Hello. I want to upload a GPX file, but I get the error "Issue while inserting job into database". Not very descriptive IMO. There's nothing about this in the documentation. What should I do? The file is exported from Sports Tracker 4.12 for Nokia.
asked
27 Apr '11, 19:32
haael
152●4●4●9
accept rate:
0%
edited
28 Apr '11, 21:31
TomH ♦♦
3.2k●8●35●40
Did you receive an email from OSM server about success or failure of your GPX upload?
You can also check
I have successfully uploaded lots of GPX traces but one bounced the other day because it had a dash or back slash in the name. I removed it and the file uploaded ok. but It took me a few minutes to guess the problem
If you open your GPX file with a text editor it should consist of a few lines of name and creator informtion followed by a large list on lats and longs each with date and time. if it does not have these time stamps it will not upload. you can see a good trace by down loading one from the traces list and then opening with a text editor.
answered
27 Apr '11, 23:16
andy mackey
11.9k●76●128●263
accept rate:
4%
I have reinstalled SportsTracker and now it works. It seems that the timestamps were the problem. Both good and bad GPX files had timestamps, but the latter had only zeroes in them.
The good file:
<trkpt lat="51.140517" lon="16.890212">
<ele>157.5</ele>
<desc>Speed 2.7 km/h Distance 0.00 km</desc>
<time>2011-04-28T20:44:54.02</time>
<name>2</name>
<sym>Dot</sym>
</trkpt>
The bad file:
<trkpt lat="51.121407" lon="16.879287">
<ele>161.0</ele>
<desc>Speed 2.3 km/h Distance 0.00 km</desc>
<time>0-01-01T00:00:00.00</time>
<name>2</name>
<sym>Dot</sym>
</trkpt>
So much walking for nothing, so sad :). The web interface should return a little boit more descriptive error message, though.
Thanks for help for all.
I've checked the logs, and those dodgy timestamps were indeed the problem because the database rejected them as invalid.
A quick web search finds eactly three hits:
In the previous two cases it appears that dodgy data** was the problem, so it may be in your case as well. Perhaps you could check that or upload it somewhere else so that someone could have a look?
** specifically NaN or nan (i.e. "not a number") in fields that should have been numeric
answered
27 Apr '11, 22:
error ×244
gpx ×225
import ×174
question asked: 27 Apr '11, 19:32
question was seen: 4,518 times
last updated: 28 Apr '11, 21:31
Don't manage loading a gpx and then editing it to a path in OSM
problem with gps trace upload: disappears from the page after being listed as "waiting".
GPX file : no time tag
[closed] No error message when a GPX upload fails?
Wie kann ich .itm-Daten in GPX-Dateien umwandeln?
[closed] How to import a gpx without time tags?
how to import a twl file to osm
Uploading a GPX from TTGpsLogger doesn't work
[closed] Upload GPX track...no display on profile, no error of OSM server, no mail
[closed] Osmosis import - Files was unexpected at this time
First time here? Check out the FAQ!