jonneytest / sma-bluetooth

Automatically exported from code.google.com/p/sma-bluetooth
0 stars 0 forks source link

No live outputs added to PVOutput.org #79

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. live uploads to pv output
2.
3.

What is the expected output? What do you see instead?

All of a sudden after several weeks of correct upload (smatool under cron job). 
Data upload has stopped on May 18th at 12.00. When I manually run vita -repost 
I only get the upload of the total day production but no more live data. No 
change has been done to the system.

What version of the product are you using? On what operating system?
0,17b on ubuntu 11.10 

Please provide any additional information below.
I attach the output of ./matool -v -d
22/5/2012 11:05:00  total=6993.861 Kwh current=0 Watts togo=0 i=11 crc=1
22/5/2012 11:10:00  total=6994.005 Kwh current=1728 Watts togo=0 i=23 crc=1
INSERT INTO DayData ( DateTime, Inverter, Serial, CurrentPower, EtotalToday ) 
VALUES ( FROM_UNIXTIME(1337677800),'5000TL',2100240743,1728, 6994.005 ) ON 
DUPLICATE KEY UPDATE DateTime=Datetime, Inverter=VALUES(Inverter), 
Serial=VALUES(Serial), CurrentPower=VALUES(CurrentPower), 
EtotalToday=VALUES(EtotalToday)
SELECT DATE_FORMAT(dd1.DateTime,'%Y%m%d'), DATE_FORMAT(dd1.DateTime,'%H:%i'), 
ROUND((dd1.ETotalToday-dd2.EtotalToday)*1000), dd1.CurrentPower, dd1.DateTime 
FROM DayData as dd1 join DayData as dd2 on 
dd2.DateTime=DATE_FORMAT(dd1.DateTime,'%Y%m%d0000000') WHERE 
dd1.DateTime>=Date_Sub(CURDATE(),INTERVAL 13 DAY) and dd1.PVOutput IS NULL and 
dd1.CurrentPower>0 ORDER BY dd1.DateTime ASC
url = 
http://pvoutput.org/service/r2/addbatchstatus.jsp?data=20120518,12:05,12859,3684
;20120518,12:10,13163,3648;20120518,12:15,13468,3660;20120518,12:20,13775,3684;2
0120518,12:25,14381,7272;20120518,12:30,14687,3672;20120518,12:35,14994,3684;201
20518,12:40,15301,3684;20120518,12:45,15607,3672;20120518,12:50,15911,3648;20120
518,12:55,16214,3636;20120518,13:00,16515,3612;20120518,13:05,16815,3600;2012051
8,13:10,17115,3600;20120518,13:15,17414,3588;20120518,13:20,17713,3588;20120518,
13:25,18003,3480;20120518,13:30,18283,3360;20120518,13:35,18565,3384;20120518,13
:40,18845,3360;20120518,13:45,19121,3312;20120518,13:50,19395,3288;20120518,13:5
5,19670,3300;20120518,14:00,19943,3276;20120518,14:05,20214,3252;20120518,14:10,
20483,3228;20120518,14:15,20750,3204;20120518,14:20,21014,3168;20120518,14:25,21
274,3120;20120518,14:30,21530,3072&key=79b3fda08d963ef8f1b98b6ea71d363d098b8369&
sid=7372
result = 22
url = 
http://pvoutput.org/service/r2/addbatchstatus.jsp?data=274,3120;20120518,14:30,2
1530,3072&key=79b3fda08d963ef8f1b98b6ea71d363d098b8369&sid=7372&key=79b3fda08d96
3ef8f1b98b6ea71d363d098b8369&sid=7372
result = 22

Original issue reported on code.google.com by gaetano.perrotta@gmail.com on 23 May 2012 at 10:56

GoogleCodeExporter commented 8 years ago
Search after interval in the source and change it from 13 days to 11 (there are 
two lines containing interval = 13 days which should be changed as I can 
remember) and compile again - then it should work. 

Original comment by christop...@googlemail.com on 23 May 2012 at 3:19

GoogleCodeExporter commented 8 years ago
If i give this URL to my browser i get:

Bad request 400: Power value [7272] too high for system size [4760]

If your System is realy only 4760 in Size, the value 7272 is bad!

So this is a Problem i have with 5000TL-21 too. Many times a day i get database 
entries which are to high and then the upload to pvoutput.org will fail.

As a workaround go into your database and search for entries which are looking 
bad.

For example use:
select * from DayData where CurrentPower>0;

When you find entries which are wrong (And i think you will) then delete dem 
with something like:
delete from DayData where CurrentPower>5000;
and
delete from DayData WHERE DateTime LIKE "1970-%%-%% %%:%%:%%";

I often have entries with 0 Seconds since 1970.

Greetings

Mario

Original comment by janus44...@gmail.com on 23 May 2012 at 9:40

GoogleCodeExporter commented 8 years ago
SOLVED some database entries were too high.
 GERAT 
Many Thanks to Mario 

Original comment by gaetano.perrotta@gmail.com on 24 May 2012 at 10:53