Can't upload to pvoutput

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Configure with SQLite, monitor Sunny Explorer, Current Cost Meters 
2. Add pvoutput details
3. Haven't specified any specific suspend control parameters

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

Expect entries to appear in pvoutput, however none are uploaded. Doesn't matter 
if switch off current cost meter monitoring. CSV files are being created, 
pvhistory.s3db is being modified.  Can get to upload to pvoutput using other 
app (sma-uploader - pvupload).

What version of the product are you using (e.g. 1.4.1.9 32bit)?

1.5.0.12

What Operating system (XP, Vista, Windows 7 - 32bit or 64bit)?
Windows 7 64 bit

Which Database Type (MySQL, MS Access, SQLite - If Access, 32bit or 64bit)?
SQLite

Are there any unusual messages in PVService.log? (upload a copy to this
issue if there are)

Can't find anything unusual in the log file.  Not sure what to look for. 
Detailed logging was enabled for Friday 12th/Sat 13th.

Please upload your settings.xml file with the issue. This answers many
questions I would otherwise need to ask.

Please provide any additional information below.

Original issue reported on code.google.com by sportsfr...@gmail.com on 15 Aug 2011 at 3:35

[GoogleCodeExporter]

I suspect that PVBC is extracting csv files into the "Default Directory". 
However PVBC cannot find the csv files using the expected file name. The file 
name is determined by the "Plant Name" entered into Sunny Explorer when the 
SunnyExplorer.sx2 file is created.

If this is correct, the csv files will still be located in the Default 
Directory. When PVBC is working correctly, the csv files are moved to the 
Archive directory after thay are processed.

I suggest you recreate the SunnyExplorer.sx2 file as described in the Wiki.

Ensure that the Plant Name entered into Sunny Explorer when you create the .sx2 
matches the value in the PVBC configuration.

Dennis M-F

Original comment by DennisMackayFisher on 15 Aug 2011 at 9:24

• Changed state: Accepted
• Added labels: Type-Setup
• Removed labels: Type-Defect

[GoogleCodeExporter]

Can you please upload the csv files for 16/8/2011 and 17/8/2011

Can you also please upload a copy of your SQLite database (pvhistory.s3db)

The logs you posted above indicate that PVBC is seeing constant changes in the 
data already loaded to pvoutput. This is triggering retransmission of datasets 
to pvoutput. This is causing you to hit the 60 / hour limit over and over again.

What type of inverter are you using? It appears to be producing output records 
at varying intervals (based on the log contents). 

Original comment by DennisMackayFisher on 18 Aug 2011 at 9:56

[GoogleCodeExporter]

I recreated the SunnyExplorer file from scratch and it now is working ok.  Not 
really sure why it wouldn't work with an alternatively named file though.

I'm using a Sunny Boy 3800.  As of tomorrow I will also have a Sunny Boy 2500 
to connect to, so things may get interesting over the weekend.

Files are attached.

I'm going to attempt to convert it to a SQL Server DB ultimately.

Original comment by sportsfr...@gmail.com on 18 Aug 2011 at 11:10

[GoogleCodeExporter]

I had some trouble connecting to the SQL Server Database but have got this 
working now by specifying the connect string manually and creating an SQL 
Server Authenticated password.  Also had to tweak the default schema setting as 
this defaulted to dbo and needed to be pvhistory.  All working now though and 
uploading to pvoutput.

Over the weekend I will be adding Current Cost metering once we reconfigure the 
meter box so that consumption can be measured correctly.

Very nice product!

Original comment by sportsfr...@gmail.com on 19 Aug 2011 at 12:28

[GoogleCodeExporter]

Glad you have succeeded.

Dennis M-F

Original comment by DennisMackayFisher on 4 Sep 2011 at 12:34

• Changed state: Done