PV out system ID error

Topics: 5. Support
Jul 17, 2015 at 5:21 AM
I installed SBSspot on windows 10 machine. Everything works, only the upload to PVoutput won't. Get these errors:

[06:40:37] ERROR: Uploading 30 datapoints, starting with 20150716,06:30,1756922,0 Unauthorized 401: Invalid System ID
[06:41:45] ERROR: Uploading 30 datapoints, starting with 20150716,06:30,1756922,0 Unauthorized 401: Invalid System ID
[06:42:54] ERROR: Uploading 30 datapoints, starting with 20150716,06:30,1756922,0 Unauthorized 401: Invalid System ID
[06:44:02] ERROR: Uploading 30 datapoints, starting with 20150716,06:30,1756922,0 Unauthorized 401: Invalid System ID
[06:45:10] ERROR: Uploading 30 datapoints, starting with 20150716,06:30,1756922,0 Unauthorized 401: Invalid System ID

It seems there is a invalid system ID, but my system ID is 39108 (checked) and in SBFspotupload I have entered: PVoutput_SID=2007308981:39108

What can be wrong else?
Coordinator
Jul 17, 2015 at 6:32 AM
Check also your API key (PVOutput_Key)
Jul 17, 2015 at 11:13 AM
Edited Jul 17, 2015 at 11:14 AM
API key is right

'#PVoutput_Key
'#Sets PVoutput API Key
PVoutput_Key=ee0b38330e30e336668d29b22dec38755372c1b2

and in PVout also: ee0b38330e30e336668d29b22dec38755372c1b2
Coordinator
Jul 17, 2015 at 12:59 PM
Really don't have a clue...
No spaces around the SID (in config file)?
Also, when you change the config file, stop/start the service (config is only read at service start)
Jul 17, 2015 at 1:34 PM
I will take a look at home. If so, can I mail you the config file etc. Please mail me your mail to g.groet@gmail.com
Jul 17, 2015 at 7:26 PM
No spaces detected. Created a new PVout SID. Restarted the SBFspotupload service and got this in log:

[21:23:45] INFO: Starting ServiceWorkerThread()
[21:23:47] WARNING: oosterweg2 is not yet member of SBFspot Team. Consider joining at http://pvoutput.org/listteam.jsp?tid=613
[21:23:47] INFO: Uploading 30 datapoints, starting with 20150716,06:30,1756922,0 => OK (200)
[21:23:47] ERROR: batch_set_pvoflag() returned attempt to write a readonly database

Seems getting better, don't understand ERROR: batch_set_pvoflag() returned attempt to write a readonly database.
Jul 17, 2015 at 7:29 PM
SID is now: oosterweg2

It has uploaded only data from yesterday from 6.30 AM till 9.00 AM, nothing from after yesterdag 9.00 AM. Is that odd???
Coordinator
Jul 17, 2015 at 8:31 PM
It has uploaded only data from yesterday from 6.30 AM till 9.00 AM, nothing from after yesterdag 9.00 AM. Is that odd???
30 datapoints per batch (12/hour) but the service fails to flag the items sent. It will resend the same records every time.
Is the service running as SYSTEM account?
Marked as answer by groetg on 7/18/2015 at 12:23 AM
Jul 18, 2015 at 7:22 AM
Running service as SYSTEM account was the solution. Now every minute 30 datapoints are being uploaded. Thank you VERY much
Jul 18, 2015 at 7:30 AM
Services stops after have uploaded all daily data from 16/7 and Today is 18/7. Why Does iT stops?
Coordinator
Jul 18, 2015 at 9:03 AM
That's because there is no more data to upload.
Run SBFspot once with -ad15 argument. This will fill the db with data of 2 weeks, the maximum that PVOutput allows (unless you have donated to PVO)
When this is done, you'll see it uploads the rest of the 2 weeks back.
Anyway, glad it works now - don't forget to become an SBFspot team member on PVOutput ;-)
Jul 18, 2015 at 9:07 AM
I am sorry, how do I run SBFspot once with -ad15 argument. I don't understand how I should do that.
Coordinator
Jul 18, 2015 at 12:15 PM
run cmd.exe
in cmd box change directory to SBFspot and run it:
cd c:\Program Files\SBFspot.3
SBFspot -v5 -ad15 -finq
That's all!
Jul 18, 2015 at 2:39 PM
That works, only do it as SYSTEM account probably, now the errors in CMD are:
04/07/2015 21:45:00 : 1707.092kWh - 0.000W
04/07/2015 21:50:00 : 1707.092kWh - 0.000W
04/07/2015 21:55:00 : 1707.092kWh - 0.000W

04/07/2015 22:00:00 : 1707.092kWh - 0.000W

ExportDayDataToCSV()
Error: [day_data]sqlite3_step() returned : attempt to write a readonly database

Hoe do I give the SBFspot -v5 -ad15 -finq command as SYSTEM account??
Jul 18, 2015 at 2:43 PM
Obviously run cmd.exe as administrator. After I did that, it works, they are being uploaded now. Thanks again, I will become a member!!
Coordinator
Jul 18, 2015 at 7:00 PM
It looks like your SBFspot.db is in "C:\Program Files\SBFspot.3" (Read-only location for non-admin users)
I think it's better to store it in "C:\Users\All Users\SMAdata" (read/write) as mentioned in the documentation.
Aug 30, 2015 at 8:39 AM
Yesterday the PC with SBFSPOT was offline whole day, no I missed data from 29th of August. How can I upload data from that day?
Coordinator
Aug 31, 2015 at 7:24 AM
Run sbfspot with -adxx parameter (where xx is the number of days back)
V3.0.8 has a -startdate option (sbfspot -ad1 -startdate 20150829)
There will be no spotdata because these values aren't stored in your inverter's memory