SBFSpot User Password wrong

Upload Software SBFspot
#21

Have reset USER and Installer pw again, and in SBFSpot, run through all three of the following, and making sure I type the right password in. Same result…
(*) Use last saved settings
( ) Create new config
( ) /usr/local/bin/sbfspot.3/SBFspot.cfg

Interestingly I am creating daily log files which appear to have meaningful content?

[07:05:41] INFO: Uploading 2 datapoints, starting with 20240426,06:55,27054314,0,0,240.86 => OK (200)
[07:10:43] INFO: Uploading datapoint: 20240426,07:05,27054320,36,0,240.37 => OK (200)
[07:15:42] INFO: Uploading datapoint: 20240426,07:10,27054325,60,0,240.31 => OK (200)
[07:20:41] INFO: Uploading datapoint: 20240426,07:15,27054330,60,0,240.16 => OK (200)
[07:25:42] INFO: Uploading datapoint: 20240426,07:20,27054336,72,0,240.92 => OK (200)
[07:30:39] INFO: Uploading datapoint: 20240426,07:25,27054343,84,0,241.43 => OK (200)
[07:35:41] INFO: Uploading datapoint: 20240426,07:30,27054350,84,0,241.64 => OK (200)
[07:40:41] INFO: Uploading datapoint: 20240426,07:35,27054359,108,0,240.55 => OK (200)
[07:45:40] INFO: Uploading datapoint: 20240426,07:40,27054367,96,0,241.79 => OK (200)
[07:50:47] INFO: Uploading datapoint: 20240426,07:45,27054377,120,0,240.38 => OK (200)
[07:55:43] INFO: Uploading datapoint: 20240426,07:50,27054386,108,0,239.65 => OK (200)
[08:00:40] INFO: Uploading datapoint: 20240426,07:55,27054397,132,0,239.285 => OK (200)

#22

So… humble apologies before I start… I did have the right password, I KNEW it - but I had set it on the inverter with CAPS on…

So now connecting successfully - and updating current data - but not the 11 day gap from 12 - 22 Apr. Running the command below:

/tmp/sunnyportal-py-master $ /usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv -ad60
SBFspot V3.9.8
Yet another tool to read power production of SMA solar inverters
© 2012-2023, SBF (GitHub - SBFspot/SBFspot: Yet another tool to read power production of SMA® solar/battery inverters)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -v -finq -nocsv -ad60
Reading config ‘/usr/local/bin/sbfspot.3/SBFspot.cfg’
Sat Apr 27 12:24:46 2024: INFO: Starting…
sunrise: 06:59
sunset : 17:35
Connecting to Local Network…
Initialising…
SUSyID: 125 - SessionID: 814921184
Device IP address: 192.168.1.114 from config
Inverter replied: 192.168.1.114 → 409:3006906963
Logon OK
SUSyID: 409 - SN: 3006906963
Device Name: SB5.0-1AV-41 963
Device Class: Solar Inverters
Device Type: Sunny Boy 5.0
Software Version: 04.00.75.R
SUSyID: 409 - SN: 3006906963
Grid Power Out : 3120W
Grid Power In : 0W
SUSyID: 409 - SN: 3006906963
Device Status: Ok
Packet status: 21
SUSyID: 409 - SN: 3006906963
Device Temperature: Information not available
SUSyID: 409 - SN: 3006906963
GridRelay Status: Closed
SUSyID: 409 - SN: 3006906963
Energy Production:
EToday: 11.104kWh
ETotal: 27084.802kWh
Operation Time: 17976.19h
Feed-In Time : 17311.01h
00464B01 28 Sat Apr 27 12:24:46 2024 ‘Grid voltage phase L1 against L2’ NaN NaN NaN NaN
00464C01 28 Sat Apr 27 12:24:46 2024 ‘Grid voltage phase L2 against L3’ NaN NaN NaN NaN
00464D01 28 Sat Apr 27 12:24:46 2024 ‘Grid voltage phase L3 against L1’ NaN NaN NaN NaN
00464E01 28 Sat Apr 27 12:24:45 2024 ‘’ 99 99 99 99
SUSyID: 409 - SN: 3006906963
DC Spot Data:
MPPT 1 Pdc: 1.974kW - Udc: 278.85V - Idc: 7.081A
MPPT 2 Pdc: 1.984kW - Udc: 309.07V - Idc: 6.419A
Calculated Total Pdc: 3.958kW
AC Spot Data:
Phase 1 Pac : 3.760kW - Uac: 249.66V - Iac: 15.090A
Phase 2 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Phase 3 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Total Pac : 3.760kW - Calculated Pac: 3.760kW
Efficiency : 95.00%
SUSyID: 409 - SN: 3006906963
Grid Freq. : 50.01Hz
SUSyID: 409 - SN: 3006906963
Current Inverter Time: 27/04/2024 12:24:45
Inverter Wake-Up Time: 27/04/2024 06:33:01
Inverter Sleep Time : 27/04/2024 12:24:46

  • ArchiveDayData() *

startTime: 27/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 26/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 25/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 24/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 23/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 22/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 21/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 20/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 19/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 18/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 17/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 16/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 15/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 14/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 13/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 12/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 11/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 10/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 09/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 08/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 07/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 06/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 05/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 04/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 03/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 02/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 01/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 31/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 30/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 29/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 28/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 27/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 26/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 25/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 24/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 23/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 22/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 21/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 20/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 19/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 18/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 17/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 16/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 15/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 14/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 13/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 12/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 11/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 10/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 09/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 08/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 07/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 06/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 05/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 04/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 03/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 02/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 01/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 29/02/2024 00:00:00

  • ArchiveDayData() *

startTime: 28/02/2024 00:00:00

  • ArchiveMonthData() *

startTime: 01/04/2024 13:00:00
Reading events: 2024-Apr-01
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Sat Apr 27 12:24:50 2024: INFO: Done.

#23

In the meantime it became a 5d gap…

Check in the db if there is data available (example for missing 16 APR 2024):

sqlite3 /home/pi/smadata/SBFspot.db
sqlite> .header on
sqlite> select * from vwdaydata where strftime('%Y%m%d',timestamp) = '20240416' LIMIT 10;

You should see some records (10 because of the LIMIT 10)

TimeStamp|Name|Type|Serial|TotalYield|Power|PVoutput
2024-04-16 20:45:00|SB4000TL - 2100276197|SB 4000TL-20|2100276197|54614026|0|1

If you don’s see any records, there is no data for that day

The last field (PVoutput) is a flag to indicate if the record has been uploaded. If it’s empty or ‘null’ is has not been uploaded.
If it’s 1 it has been uploaded. To re-upload it, set the flag to ‘null’ (all records for the whole day):

sqlite> update daydata set pvoutput=null where strftime("%Y%m%d", date(timestamp, 'unixepoch', 'localtime'))='20240416';

Then, upload for that day should restart.

See also SBFspot wiki

#24

BTW, your graphs look ugly… what happens to the Power (green line)? It looks like there is some kind of limit around 1800W and drops to 0W if higher. Very strange.

#25

OK - so there is no data for those days - I’ll move on :slight_smile:
Thanks for all of your support - I’ve taken many notes and learnt a lot! I won’t trouble you again with the same problem!!

#26

Did you modify the view vwPvoData?
In SQLite, can you execute .schema vwpvodata to show the definition?

image
image928×412 52.5 KB

#27

This power issue started around 01JUL2021 : no more generation and a power limit of 1800Watt

image
image862×271 25.8 KB

#28

No, not modified intentionally: (I’d be happy to reset or change to a more sensible view - any recommendations). Also keen to bottom out the 1800w limit - thanks for looking deeper than what I was originally looking for…

sqlite> .schema vwpvodata
CREATE VIEW vwPvoData AS
SELECT dd.Timestamp,
dd.Name,
dd.Type,
dd.Serial,
dd.TotalYield AS V1,
CASE WHEN dd.Power > 1800
THEN 0
ELSE dd.Power
END AS V2,
cons.EnergyUsed AS V3,
cons.PowerUsed AS V4,
spot.Temperature AS V5,
spot.Uac1 AS V6,
NULL AS V7,
NULL AS V8,
NULL AS V9,
NULL AS V10,
NULL AS V11,
NULL AS V12,
dd.PVoutput
FROM vwDayData AS dd
LEFT JOIN vwAvgSpotData AS spot
ON dd.Serial = spot.Serial AND dd.Timestamp = spot.Nearest5min
LEFT JOIN vwAvgConsumption AS cons
ON dd.Timestamp = cons.Nearest5min
ORDER BY dd.Timestamp DESC
/* vwPvoData(TimeStamp,Name,Type,Serial,V1,V2,V3,V4,V5,V6,V7,V8,V9,V10,V11,V12,PVoutput) */;
sqlite>

#29

(Power limit in Sunny Boy is 5000W)

#30

I’ve pulled the Power data direct from Sunny Portal - see below

Screenshot 2024-04-29 082053
Screenshot 2024-04-29 082053950×386 14.8 KB

compared to same data uploaded to PVOutput

Screenshot 2024-04-29 082803
Screenshot 2024-04-29 082803971×384 27.9 KB

Interestingly, if I click on Previous Day on the above graph, they are all the same (at least in the previous week) where Power drops to zero very early in the day and stays there until early afternoon - but is inconsistent with Power graphs from Sunny Boy - so indicates an issue with the data logging rather than the solar system itself?

#31

It is caused by this line:

CASE WHEN dd.Power > 1800
THEN 0
ELSE dd.Power
END AS V2

For some reason you changed the view as described here

Replace the 1800 with 7500 or better yet, replace it by the original: dd.Power AS V2

CREATE VIEW vwPvoData AS
SELECT dd.Timestamp,
dd.Name,
dd.Type,
dd.Serial,
dd.TotalYield AS V1,
dd.Power AS V2,
...

Then, clear the PVoutput flag as described above and the data will re-upload with correct power values.
Since you’re a donator you can re-upload till 90 days back

#32

Thanks (again!)

View has been updated. Is there a way to modify the following so that it does the 90 days in the one command?

sqlite> update daydata set pvoutput=null where strftime("%Y%m%d", date(timestamp, ‘unixepoch’, ‘localtime’))=‘20240416’;

#33

I was expecting this question :wink:

Try this:

update daydata set pvoutput=null where date(timestamp,'unixepoch')>date('now','-90 day');

Graph is already much better…

image
image928×409 31.3 KB

#34

hmmm, command above ran successfully, but it appears that I’ve broken something - it’s now 8:41 and no update since 8:05

Detail I hope will be useful:

pi@raspberrypi:~ $ ./checkstatus.sh
● SBFspotUpload.service - SBFspot Upload Daemon
Loaded: loaded (/usr/local/bin/sbfspot.3/SBFspotUpload.service; enabled; vend
Active: active (running) since Wed 2024-05-01 08:23:07 AEST; 18min ago
Main PID: 516 (SBFspotUploadDa)
Tasks: 1 (limit: 3720)
CGroup: /system.slice/SBFspotUpload.service
└─516 /usr/local/bin/sbfspot.3/SBFspotUploadDaemon

May 01 08:23:07 raspberrypi systemd[1]: Started SBFspot Upload Daemon.

===========================

sqlite3 /home/pi/smadata/SBFspot.db
SQLite version 3.27.2 2019-02-25 16:06:06
Enter “.help” for usage hints.
sqlite> .schema vwpvodata
CREATE VIEW vwPvoData AS
SELECT dd.Timestamp,
dd.Name,
dd.Type,
dd.Serial,
dd.TotalYield AS V1,
dd.Power AS V2,
cons.EnergyUsed AS V3,
cons.PowerUsed AS V4,
spot.Temperature AS V5,
spot.Uac1 AS V6,
NULL AS V7,
NULL AS V8,
NULL AS V9,
NULL AS V10,
NULL AS V11,
NULL AS V12,
dd.PVoutput
FROM vwDayData AS dd
LEFT JOIN vwAvgSpotData AS spot ON dd.Serial = spot.Serial AND dd.Timestamp = spot.Nearest5min
LEFT JOIN vwAvgConsumption AS cons ON dd.Timestamp = cons.Nearest5min
ORDER BY dd.Timestamp DESC
/* vwPvoData(TimeStamp,Name,Type,Serial,V1,V2,V3,V4,V5,V6,V7,V8,V9,V10,V11,V12,PVoutput) */;

=========================

sqlite> select * from vwdaydata where strftime(’%Y%m%d’,timestamp) = ‘20240501’ LIMIT 10;
TimeStamp|Name|Type|Serial|TotalYield|Power|PVoutput
2024-05-01 08:55:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128641|1656|
2024-05-01 08:50:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128503|1440|
2024-05-01 08:45:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128383|732|
2024-05-01 08:40:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128322|588|
2024-05-01 08:35:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128273|600|
2024-05-01 08:30:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128223|504|
2024-05-01 08:25:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128181|480|
2024-05-01 08:20:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128141|432|
2024-05-01 08:15:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128105|312|
2024-05-01 08:10:00|SB5.0-1AV-41 963|Sunny Boy 5.0|3006906963|27128079|180|
sqlite>

==============

pi@raspberrypi:~ $ ./dataupload.sh
SBFspot V3.9.8
Yet another tool to read power production of SMA solar inverters
© 2012-2023, SBF (GitHub - SBFspot/SBFspot: Yet another tool to read power production of SMA® solar/battery inverters)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -v -finq -nocsv -ad60
Reading config ‘/usr/local/bin/sbfspot.3/SBFspot.cfg’
Wed May 1 09:08:22 2024: INFO: Starting…
sunrise: 07:03
sunset : 17:30
Connecting to Local Network…
Initialising…
SUSyID: 125 - SessionID: 966000076
Device IP address: 192.168.1.114 from config
Inverter replied: 192.168.1.114 → 409:3006906963
Logon OK
SUSyID: 409 - SN: 3006906963
Device Name: SB5.0-1AV-41 963
Device Class: Solar Inverters
Device Type: Sunny Boy 5.0
Software Version: 04.01.15.R
SUSyID: 409 - SN: 3006906963
Grid Power Out : 1344W
Grid Power In : 0W
SUSyID: 409 - SN: 3006906963
Device Status: Ok
Packet status: 21
SUSyID: 409 - SN: 3006906963
Device Temperature: Information not available
SUSyID: 409 - SN: 3006906963
GridRelay Status: Closed
SUSyID: 409 - SN: 3006906963
Energy Production:
EToday: 1.056kWh
ETotal: 27129.040kWh
Operation Time: 18015.15h
Feed-In Time : 17348.34h
00464B01 28 Wed May 1 09:08:21 2024 ‘Grid voltage phase L1 against L2’ NaN NaN NaN NaN
00464C01 28 Wed May 1 09:08:21 2024 ‘Grid voltage phase L2 against L3’ NaN NaN NaN NaN
00464D01 28 Wed May 1 09:08:21 2024 ‘Grid voltage phase L3 against L1’ NaN NaN NaN NaN
00464E01 28 Wed May 1 09:08:22 2024 ‘’ 98 98 98 98
SUSyID: 409 - SN: 3006906963
DC Spot Data:
MPPT 1 Pdc: 0.124kW - Udc: 281.66V - Idc: 0.433A
MPPT 2 Pdc: 1.853kW - Udc: 331.88V - Idc: 5.603A
Calculated Total Pdc: 1.977kW
AC Spot Data:
Phase 1 Pac : 1.862kW - Uac: 247.50V - Iac: 7.553A
Phase 2 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Phase 3 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Total Pac : 1.862kW - Calculated Pac: 1.862kW
Efficiency : 94.18%
SUSyID: 409 - SN: 3006906963
Grid Freq. : 50.02Hz
SUSyID: 409 - SN: 3006906963
Current Inverter Time: 01/05/2024 09:08:22
Inverter Wake-Up Time: 01/05/2024 06:37:02
Inverter Sleep Time : 01/05/2024 09:08:21

  • ArchiveDayData() *

startTime: 01/05/2024 00:00:00

  • ArchiveDayData() *

startTime: 30/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 29/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 28/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 27/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 26/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 25/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 24/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 23/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 22/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 21/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 20/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 19/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 18/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 17/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 16/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 15/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 14/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 13/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 12/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 11/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 10/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 09/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 08/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 07/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 06/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 05/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 04/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 03/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 02/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 01/04/2024 00:00:00

  • ArchiveDayData() *

startTime: 31/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 30/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 29/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 28/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 27/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 26/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 25/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 24/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 23/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 22/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 21/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 20/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 19/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 18/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 17/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 16/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 15/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 14/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 13/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 12/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 11/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 10/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 09/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 08/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 07/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 06/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 05/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 04/03/2024 00:00:00

  • ArchiveDayData() *

startTime: 03/03/2024 00:00:00

  • ArchiveMonthData() *

startTime: 01/04/2024 13:00:00

  • ArchiveMonthData() *

startTime: 01/03/2024 12:00:00
Reading events: 2024-Apr-01
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Untranslated item found! Parameter “Speedwire meter serial no.” set successfully. |lv04c| to |lv048|
Wed May 1 09:08:27 2024: INFO: Done.

#35

Is SBFspot running every 5 minutes via cron?

crontab -l

Not sure about that, but I think when you want to re-upload with new (changed) data you need to erase that day on PVOutput first

#36

Good job! Deleted the last partially uploaded day (1 May), and it has backfilled the missing data, and continued to run updates - but then stopped!
I deleted the last partial day in PVOutput at 0825, saw that it was all working fine - but it has stopped at 0920! Have restarted device, checked status of SBF, but still nothing from 0920

#37

My previous question still stands:

#38

Sorry, yes:

pi@raspberrypi:~ $ ./checkstatus.sh
● SBFspotUpload.service - SBFspot Upload Daemon
Loaded: loaded (/usr/local/bin/sbfspot.3/SBFspotUpload.service; enabled; vend
Active: active (running) since Sat 2024-05-04 08:25:04 AEST; 24h ago
Main PID: 490 (SBFspotUploadDa)
Tasks: 1 (limit: 3720)
CGroup: /system.slice/SBFspotUpload.service
└─490 /usr/local/bin/sbfspot.3/SBFspotUploadDaemon

May 04 08:25:04 raspberrypi systemd[1]: Started SBFspot Upload Daemon.
lines 1-9/9 (END)
pi@raspberrypi:~ $ crontab -l

SBFspot

*/5 6-22 * * * /usr/local/bin/sbfspot.3/daydata
55 05 * * * /usr/local/bin/sbfspot.3/monthdata
pi@raspberrypi:~ $

#39

Any thoughts on the above? I did have a look at No uploads to PVOutput.org · SBFspot/SBFspot Wiki · GitHub but didn’t see anything untoward…

Hoping I haven’t lost you :wink:

#40

When you run SBFspot manually the daemon starts uploading, so to me it looks like SBFspot isn´t running automatically every 5 minutes…

Can you show us the content of daydata script?