Problem after re-installing SBFspot

[roelvdh]

Edit:
Comment lines in the first Code and the bottom of the second Code were converted to Headings and I tried to edit that by changing #'s to >'s, creating vertical lines

The SD-card of my old Raspi 2 suddenly broke and I had to re-install SBFspot on a new SD. SQLite works fine, but the data seem not to be archived at /home/pi/smadata/2024 and, also, there are funny Error 21 lines (from SMA) in the logs. Nothing was changed in the 2 inverters. I include 1 cfg file and 1 log file. Actually, I use 2 cfg files for 2 inverters and have modified daydata and monthdata accordingly (that worked better for me than using Multiple Inverter).

cfg1:

SMA Inverter's Bluetooth address
Linux : hcitool scan
BTAddress=00:80:25:26:xx:xx

Multi Inverter Support: Default=0 Disabled
MIS_Enabled=0

BTConnectRetries
Number of Bluetooth Connection attempts (1-15; Default=10)
BTConnectRetries=10

User password (default 0000)
Password=xxxxxxxxxxxxxxxxxxxxxxx

Plantname
Plantname=Roel1

OutputPath (Place to store CSV files)
Linux : /home/pi/smadata/%Y
%Y %m and %d will be expanded to Year Month and Day
OutputPath=/home/pi/smadata/%Y

OutputPathEvents (Place to store CSV files for events)
If omitted, OutputPath is used
OutputPathEvents=/home/pi/smadata/%Y/Events

Timezone
Select the right timezone in date_time_zonespec.csv
Timezone=Europe/Amsterdam

Position of pv-plant https://www.gps-coordinates.net/maps
Latitude=52.xxxxxxx
Longitude=4.yyyyyyy

Locale
Default en-US
Locale=en-US

DateTimeFormat (default %d/%m/%Y %H:%M:%S)
DateTimeFormat=

DateFormat (default %d/%m/%Y)
DateFormat=%d/%m/%Y

TimeFormat (default %H:%M:%S)
TimeFormat=%H:%M:%S

DecimalPoint (comma/point default comma)
DecimalPoint=comma

Calculate Missing SpotValues
CalculateMissingSpotValues=0
etc. etc.
End of Config

log1:

SBFspot V3.9.8
Yet another tool to read power production of SMA solar inverters
(c) 2012-2023, SBF (https://github.com/SBFspot/SBFspot)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -v -ad1 -am0 -ae1 -cfg/usr/local/bin/sbfspot.3/SBFspot1.cfg.rvdh
Reading config '/usr/local/bin/sbfspot.3/SBFspot1.cfg.rvdh'
Sat Apr 27 12:35:01 2024: INFO: Starting...
sunrise: 06:19
sunset : 20:59
Connecting to 00:80:25:26:xx:xx (1/10)
Initialising...
SUSyID: 125 - SessionID: 978806982
SMA netID=01
Serial Nr: 77570578 (2002191736)
BT Signal=73.3%
Logon OK
Failed to get current plant time (-1)
SetPlantTime returned an error: -1
SUSyID: 99 - SN: 2002191736
Device Name:      Schuin dak
Device Class:     Solar Inverters
Device Type:      SB 1600TL-10
Software Version: 12.12.206.R
Packet status: 21
SUSyID: 99 - SN: 2002191736
Device Status:      Ok
Packet status: 21
SUSyID: 99 - SN: 2002191736
Device Temperature: Information not available
Packet status: 21
getGridRelayStatus returned an error: 21
SUSyID: 99 - SN: 2002191736
Energy Production:
        EToday: 1.461kWh
        ETotal: 19484.151kWh
        Operation Time: 49422.78h
        Feed-In Time  : 40432.71h
Packet status: 21
getSpotDCPower returned an error: 21
Packet status: 21
getSpotACPower returned an error: 21
SUSyID: 99 - SN: 2002191736
DC Spot Data:
        MPPT 1 Pdc:   0.000kW - Udc: 230.00V - Idc:  1.806A
        MPPT 2 Pdc:   0.000kW - Udc:   0.00V - Idc:  0.000A
        Calculated Total Pdc:   0.000kW
AC Spot Data:
        Phase 1 Pac :   0.000kW - Uac: 230.10V - Iac:  1.684A
        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.387kW - Calculated Pac:   0.000kW
        Efficiency  :    0.00%
SUSyID: 99 - SN: 2002191736
Grid Freq. : 49.98Hz
SUSyID: 99 - SN: 2002191736
Current Inverter Time: 27/04/2024 12:35:14
Inverter Wake-Up Time: 27/04/2024 12:35:14
Inverter Sleep Time  : 27/04/2024 12:35:15
>ArchiveDayData() 
startTime: 27/04/2024 00:00:00
Reading events: 2024-Apr-01
Sat Apr 27 12:35:16 2024: INFO: Done.

1 Record from SQLite|vwspotdata:

2024-04-27 14:57:03|2024-04-27 14:55:00|Schuin dak|SB 1600TL-10|2002191736|0|0|1.746|0.0|222.0|0.0|0|0|0|1.551|0.0|0.0|232.5|0.0|0.0|0|0|0|3246|19485936|49.98|49425.1|40435.1|73.7|OK|?|

Note the final "?" for GridRelay

[roelvdh]

I tried to insert the missing last 3 days into the database. The log correctly mentions 3 ArchiveDayData's, and the data exist in SQLite, but the data will just not appear in /home/pi/smadata/2024. Last part of the log:

SUSyID: 99 - SN: 2002191736
Current Inverter Time: 27/04/2024 17:21:06
Inverter Wake-Up Time: 27/04/2024 17:21:06
Inverter Sleep Time  : 27/04/2024 17:21:07
********************
* ArchiveDayData() *
********************
startTime: 27/04/2024 00:00:00
********************
* ArchiveDayData() *
********************
startTime: 26/04/2024 00:00:00
********************
* ArchiveDayData() *
********************
startTime: 25/04/2024 00:00:00
Reading events: 2024-Apr-01
Sat Apr 27 17:21:07 2024: INFO: Done.

[sbf-]

Comment lines in the first Code and the bottom of the second Code were converted to Headings and I tried to edit that by changing #'s to >'s, creating vertical lines

Just select your text and click the code block function <>

[sbf-]

but the data will just not appear in /home/pi/smadata/2024

You mean no CSV files?
What is the CSV_export setting in the config file? If the data is in the DB, there should be a CSV if the export is not disabled

[roelvdh]

Thank you for reminding me I urgently need new glasses. CSV_export should be on default=1, but it stood at 0 for some unknown reason.

[roelvdh]

Code worked very funny. I used the "<>" and then part of the #-s for comment were translated into big Headings. It may be my browser though.

[roelvdh]

I am still wondering about the SMA Error 21's. Certainly not a SBFspot problem but do you happen to know what they mean? I can't remember I had those errors in the past.

[sbf-]

Error 21 is returned when a certain data item is not available. For example, not all inverters return internal temperature.

This is OK:

Packet status: 21
SUSyID: 99 - SN: 2002191736
Device Temperature: Information not available

This is never OK, all inverters should return power production for DC and AC

Packet status: 21
getSpotDCPower returned an error: 21
Packet status: 21
getSpotACPower returned an error: 21

Maybe a full debug log (-d5 -v5) can show something. Attach it as a file, do not copy/paste the output in this thread.

[roelvdh]

Status21_Inverter1.txt
Status21_Inverter2.txt
I appreciate your help. Only Inverter1 has the Status 21 errors.

[roelvdh]

sbf.txt
Working with SBFspot on a remote Raspi means a lot of cd-ing in a PuTTY screen. I made a tiny batch file (in Dutch) that exists in every directory associated with SBFspot and makes life a bit easier. SBFspot is a great program you can leave alone for many years but that causes you to forget its file structure. Put something like this in all 3 directories (~/smadata, /usr/local/bin/sbfspot.3, /var/log/sbfspot.3), chmod +x it and fly from directory to directory.

[sbf-]

It seems the SB 1600TL-10 doesn't understand the code to get AC/DC power values. I'll see what I can do to fix it.
In the meantime you can set CalculateMissingSpotValues=1 in the config to let SBFspot calculate the values.

[sbf-]

@roelvdh If you are willing to generate a USB trace while connecting with SunnyExplorer, please contact me via e-mail (s.b.f at skynet.be)