Page 1 of 1

Error Importing DataLog

Posted: Wed Jul 24, 2013 2:03 pm
by andylaurence
I finally used my RCP in anger this weekend, but when importing the three logs, I got this error:

"Failed to prepare Insert DatalogRow statement"

What am I doing wrong? I'm running the latest firmware (1.1.13) and the latest RaceAnalyzer (1.1.12).

As an aside, it's great to finally see brake pedal usage (just on/off for now), oil pressure (but I need to adjust the resistor for better resolution) and wheel speed (which only seems to show a small number of RPMs and varies wildly irrespective of speed). I'm sure the accelerometer readings will become more accurate when I more solidly mount the box, although a 10 point moving average looks pretty good.

Posted: Mon Aug 05, 2013 11:53 am
by andylaurence
Anyone else getting this or have any ideas? I've tried the logs on different workstations and the same thing each time. Logs appear to be complete and I can analyse them in Excel, but that's time consuming...

Posted: Wed Aug 07, 2013 11:46 am
by andylaurence
53 views and nobody had this problem? Anyone any ideas at all? Can anyone else import my logs?

Posted: Wed Aug 07, 2013 8:35 pm
by smig
andylaurence wrote:53 views and nobody had this problem? Anyone any ideas at all? Can anyone else import my logs?
I'd give it a try if I could figure out how to download the file from www.bigupload.com without having to register/signup.

Posted: Thu Aug 08, 2013 4:45 am
by Mr. Wednesday
I got a failure with a more detailed error message, attached.

Try manually editing the log file to remove the '.' character in the oil pressure channel name. I think that's screwing up the program.

Posted: Thu Aug 08, 2013 8:04 am
by andylaurence
Good spot! So punctuation is not a good idea with channel names then. I've now been able to import all my logs by amending the channel name. Is there a way that this could be either limited when inputting the name of the channel or caught by some better error catching on the import script?