SBFSpot User Password wrong

Upload Software SBFspot
#15

Lol, that’s all tied up with my dual install of SBFSpot and also sunnyportal-py…

I ran the update with -ad60 and I could see much more data scroll on the screen so that was good - hasn’t yet updated the missing days on PVOutput (45delprat 6.600kW). Figured that might be a scheduled task on their end so we’ll see…

I ran the update per GitHub, and still ran into the USER password being wrong (see below) - interesting, because I now am seeing updates in PVOutput (for 25 and 26 Apr…)

Output of both the -ad60 command, and also the version update below:

pi@raspberrypi:~ $ /usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv -startdate:20240412 -ad60
SBFspot V3.5.2
Yet another tool to read power production of SMA solar inverters
© 2012-2018, 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 -startdate:20240412 -ad60
Reading config ‘/usr/local/bin/sbfspot.3/SBFspot.cfg’
Fri Apr 26 07:55:17 2024: INFO: Starting…
sunrise: 06:58
sunset : 17:36
Connecting to Local Network…
Initializing…
SUSyID: 125 - SessionID: 851127955 (0x32BB2E93)
Inverter IP address: 192.168.1.114 from SBFspot.cfg
Logon OK
SUSyID: 409 - SN: 3006906963
Device Name: SB5.0-1AV-41 963
Device Class: Solar Inverters
Device Type: Sunny Boy 5.0 AV-41
Software Version: 04.00.75.R
Serial number: 3006906963
SUSyID: 409 - SN: 3006906963
Device Status: Ok
SUSyID: 409 - SN: 3006906963
Device Temperature: 0.0°C
SUSyID: 409 - SN: 3006906963
GridRelay Status: Closed
SUSyID: 409 - SN: 3006906963
Pac max phase 1: 5000W
Pac max phase 2: 0W
Pac max phase 3: 0W
SUSyID: 409 - SN: 3006906963
Energy Production:
EToday: 0.083kWh
ETotal: 27054.397kWh
Operation Time: 17960.91h
Feed-In Time : 17296.08h
SUSyID: 409 - SN: 3006906963
DC Spot Data:
String 1 Pdc: 0.085kW - Udc: 277.57V - Idc: 0.308A
String 2 Pdc: 0.118kW - Udc: 292.70V - Idc: 0.404A
SUSyID: 409 - SN: 3006906963
AC Spot Data:
Phase 1 Pac : 0.128kW - Uac: 239.13V - Iac: 0.876A
Phase 2 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Phase 3 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Total Pac : 0.128kW
SUSyID: 409 - SN: 3006906963
Grid Freq. : 49.97Hz
SUSyID: 409 - SN: 3006906963
Current Inverter Time: 26/04/2024 07:55:16
Inverter Wake-Up Time: 26/04/2024 06:31:08
Inverter Sleep Time : 26/04/2024 07:55:15

  • ArchiveDayData() *

startTime = 6617ECE0 → 12/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 66169B60 → 11/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 661549E0 → 10/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 6613F860 → 09/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 6612A6E0 → 08/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 66114750 → 07/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 660FF5D0 → 06/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 660EA450 → 05/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 660D52D0 → 04/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 660C0150 → 03/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 660AAFD0 → 02/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 66095E50 → 01/04/2024 00:00:00

  • ArchiveDayData() *

startTime = 66080CD0 → 31/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 6606BB50 → 30/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 660569D0 → 29/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 66041850 → 28/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 6602C6D0 → 27/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 66017550 → 26/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 660023D0 → 25/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65FED250 → 24/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65FD80D0 → 23/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65FC2F50 → 22/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65FADDD0 → 21/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F98C50 → 20/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F83AD0 → 19/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F6E950 → 18/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F597D0 → 17/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F44650 → 16/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F2F4D0 → 15/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F1A350 → 14/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65F051D0 → 13/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65EF0050 → 12/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65EDAED0 → 11/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65EC5D50 → 10/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65EB0BD0 → 09/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E9BA50 → 08/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E868D0 → 07/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E71750 → 06/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E5C5D0 → 05/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E47450 → 04/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E322D0 → 03/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E1D150 → 02/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65E07FD0 → 01/03/2024 00:00:00

  • ArchiveDayData() *

startTime = 65DF2E50 → 29/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65DDDCD0 → 28/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65DC8B50 → 27/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65DB39D0 → 26/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D9E850 → 25/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D896D0 → 24/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D74550 → 23/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D5F3D0 → 22/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D4A250 → 21/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D350D0 → 20/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D1FF50 → 19/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65D0ADD0 → 18/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65CF5C50 → 17/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65CE0AD0 → 16/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65CCB950 → 15/02/2024 00:00:00
ArchiveDayData returned an error: -1

  • ArchiveDayData() *

startTime = 65CB67D0 → 14/02/2024 00:00:00

  • ArchiveDayData() *

startTime = 65CA1650 → 13/02/2024 00:00:00

  • ArchiveMonthData() *

startTime = 660A1520 → 01/04/2024 13:00:00
Reading events: 2024-Apr-01
Fri Apr 26 07:55:28 2024: INFO: Done.

pi@raspberrypi:~ $ cd /tmp
pi@raspberrypi:/tmp $ sudo bash -c “$(curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config)”
SBFspot Configuration Tool V1.3.5
Running on Raspberry Pi 4 Model B Rev 1.1
Checking whiptail… Installed.
architecture=armhf
Raspbian GNU/Linux 10 (buster)
username=pi
userhome=/home/pi
Minimum SBFspot version supported by this tool is 3.5.0
Request to install latest version (3.9.8)
Searching for existing configuration(s)…
Reading defaults from /var/tmp/sbfspot.3/sbfspot.defaults… Done
Saving defaults to /var/tmp/sbfspot.3/sbfspot.defaults… Done
Performing some checks before installation… Done
Downloading sbfspot-sqlite-arm-linux-buster.tar.gz
Copying files…
SBFspot.db exists
Checking database…
Schema Version=1
Saving existing SBFspot.cfg… Done
Configuring SBFspot… Done
Running SBFspot…
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 -ad0 -am0 -ae0 -sp0 -nocsv -nosql -finq -cfg/usr/local/bin/sbfspot.3/SBFspot.cfg
Reading config ‘/usr/local/bin/sbfspot.3/SBFspot.cfg’
Fri Apr 26 08:01:55 2024: INFO: Starting…
sunrise: 06:58
sunset : 17:36
Connecting to Local Network…
Initialising…
SUSyID: 125 - SessionID: 964633696
Device IP address: 192.168.1.114 from config
Inverter replied: 192.168.1.114 → 409:3006906963
Fri Apr 26 08:01:55 2024: CRITICAL: Logon failed. Check ‘USER’ Password
Fri Apr 26 08:01:55 2024: INFO: Done.
Installation aborted
pi@raspberrypi:/tmp $

#16

No, it should start almost immediately.
Just remove the -startdate:20240412 from the command line like this:

/usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv -ad60

#17

Still not happy with the password

pi@raspberrypi:/usr/local/bin/sbfspot.3 $ /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’
Fri Apr 26 17:03:15 2024: INFO: Starting…
sunrise: 06:58
sunset : 17:36
Connecting to Local Network…
Initialising…
SUSyID: 125 - SessionID: 904615930
Device IP address: 192.168.1.114 from config
Inverter replied: 192.168.1.114 → 409:3006906963
Fri Apr 26 17:03:15 2024: CRITICAL: Logon failed. Check ‘USER’ Password
Fri Apr 26 17:03:15 2024: INFO: Done.

#18

That will not change unless you have the correct user pw…
But with -installer -password:**** it works, no?

#19

I’ve synchronised both user and installer to the same one, and 100% confident SBFspot is using that too (set and reset multiple times cos I can’t get rid of the error - connecting with that pw with Sunny Explorer too

#20

Last option I have is to check if there aren´t any spaces before or after the PW in SBFspot.cfg

#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.