Cannot upload data automatically

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Turn on SunnyExplorer.  Start PVBean
2.Leave for 30 mins or so - nothing happens.
3.Need to Export data manually from SunnyExplorer and then data uploads

What is the expected output? Would think that it automatically uploads once 
start
What do you see instead? Nothing

What version of the product are you using - 1.5.0.5 32bit

What Operating system - Windows 7 - 64bit

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)

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 em...@miskeljin.com on 20 Jul 2011 at 12:06

[GoogleCodeExporter]

Please check "Trace" on the Log Files tab. Save Settings and run the service 
for 30 minutes.

Upload the resultant log to this issue. This will show more detail of the 
SunnyExplorer activity.

Original comment by DennisMackayFisher on 21 Jul 2011 at 10:08

• Changed state: Accepted

[GoogleCodeExporter]

I have had it checked but will keep it running for 30 mins or during the day 
and let you know how the file looks

Original comment by em...@miskeljin.com on 21 Jul 2011 at 10:24

[GoogleCodeExporter]

Ok had it running tonight and it did load automatically

Here is the files

Original comment by em...@miskeljin.com on 22 Jul 2011 at 9:39

[GoogleCodeExporter]

Doesnt seem to be working last few nights

Need to manually export data and then it uploads it

Original comment by em...@miskeljin.com on 26 Jul 2011 at 9:52

[GoogleCodeExporter]

Please install 1.5.0.9

Check Trace on the Log Files tab and try again.

Upload the PVService.log file after 30 minutes of operation. Ensure you do this 
while the inverter is available for access.

Dennis M-F

Original comment by DennisMackayFisher on 26 Jul 2011 at 10:41

[GoogleCodeExporter]

Ok Have tried new version 1.5.10 and still no data uploading

Now I can't force an upload either

I have included my logs

Original comment by em...@miskeljin.com on 28 Jul 2011 at 12:30

[GoogleCodeExporter]

You have encountered the problem reported in Issue 66.

Do you have SQLite .Net installed?

If you do can you provide details of the version you have installed?

I have been unable to resolve Issue 66 to date. I suggest you reinstall 1.5.0.5 
(available unded Deprecated downloads).

I am looking for a solution to Issue 66 but I have had no success to date.

When 1.5.0.5 is installed, please Check Trace on the Log Files tab and save 
settings.

Upload the PVService.log file after 30 minutes of operation. Ensure you do this 
while the inverter is available for access. I will try to diagnose the problem 
using the old version.

Dennis M-F

Original comment by DennisMackayFisher on 28 Jul 2011 at 9:04

[GoogleCodeExporter]

Thanks

I don't have SQLite installed as I didn't realise I had to but will now install 
the latest version.  But my data till now has been from me doing a forced 
upload, but this has stopped working for me now too.

I will go back to 1.5.0.5 and will install the latest SQLite.net

Thanks for all the support

Original comment by em...@miskeljin.com on 28 Jul 2011 at 10:54

[GoogleCodeExporter]

Please do not install SQLite .Net

It is part of PVBC and should not require installation.

I have just loaded an attempt to fix Issue 66 here:

http://code.google.com/p/pvbeancounter/downloads/list?can=4&q=&colspec=Filename+
Summary+Uploaded+ReleaseDate+Size+DownloadCount

Please try v1.5.0.11

It may fix the problem. I cannot verify myself.

Original comment by DennisMackayFisher on 28 Jul 2011 at 11:00

[GoogleCodeExporter]

Dennis

I am not sure if you have me confused with someone else

I will not install SQLite but I don't have the problem in 66 I have the problem 
above where data is not being automatically uploaded when I have it running 
during the day.  I seem to be able to get it to work by forcing SE to export 
data and then manually Force upload but otherwise it is not grabbing data Live 
every 5 mins and uploading daily

I will run version 11 tomorrow and see what happens

Original comment by em...@miskeljin.com on 28 Jul 2011 at 11:16

[GoogleCodeExporter]

Just did a manual upload with version 5 and it worked for yesterday (not at 
home so can't do todays data)

Original comment by em...@miskeljin.com on 28 Jul 2011 at 11:19

[GoogleCodeExporter]

I know it looks confusing.

The line below:

14/07/2011 12:22:45 PM :T6 ExecutionManager :ExecutionStateManager: exception: 
GenDatabase - constructor - cannot find provider: System.Data.SQLite : 
Exception has been thrown by the target of an 
invocation.GenericConnector.GenException

was in the PVService.log file you uploaded. It was the reason 1.5.0.6 stopped 
uploading anything.

1.5.0.11 may resolve the SQLite issue allowing you to use the latest PVBC 
version.

1.5.0.6 to 1.5.0.10 produced this problem for some users.

Dennis M-F

Original comment by DennisMackayFisher on 28 Jul 2011 at 11:21

[GoogleCodeExporter]

OK - will try it tomorrow and then provide feedback

Cheers

Original comment by em...@miskeljin.com on 28 Jul 2011 at 11:49

[GoogleCodeExporter]

everytime I click on Start Service it goes grey for about 5 secs then lights up 
again - It is not starting under 11

Original comment by em...@miskeljin.com on 29 Jul 2011 at 1:08

[GoogleCodeExporter]

Using 1.5.0.5 and getting a small descrepancy between Live and Daily totals for 
my last 2 days - Live data is correct while the Daily is out by about 0.2KW.  
Normally I delete the daily data and then upload it but that is not working 
today

Original comment by em...@miskeljin.com on 29 Jul 2011 at 11:17

[GoogleCodeExporter]

Ok I just tried 1.5.0.12 - It runs now

Still not automatically running during the day and I need to "Export data" 
under SunnyExplorer for it to upload data

Original comment by em...@miskeljin.com on 30 Jul 2011 at 10:35

[GoogleCodeExporter]

I suspect your computer has Bluetooth drivers that do not allow access by 
accounts such as Local Service (used by PVBC).

This means that when the PVBC service runs Sunny Explorer, the Bluetooth 
drivers refuse access, or have permissions set somewhere that prevent access.

You should see the failures in the log if you check "Trace" of the Log Files 
tab and save settings.

I have seen comments by some users indicating that they removed the "Toshiba" 
bluetooth drivers and allowed generic drivers to be installed. I have no direct 
experience of this.

Other found the following helpful:

To change the service execution account:

1) Open "Control Panel" - "Administrative Tools" - "Services"
2) Scroll down to "PV Bean Counter - Yield Data Capture"
3) Open it (double click)
4) Select the "Log On" tab
5) "Local Service" will be checked - Check "Local System account"
6) Click OK
7) Stop and Restart the PVPC service

If this solves the problem, you will need to do this whenever you reinstall 
PVBC.

Others have found that they needed to use different Bluetooth hardware. The USB 
adapters are relatively inexpensive. Broadcom and microsoft drivers seem to 
work well. I did use Toshiba Bluetooth for a while without trouble but others 
seem to have encountered issues such as you describe.

Dennis M-F

Original comment by DennisMackayFisher on 31 Jul 2011 at 7:41

• Added labels: Type-Setup
• Removed labels: Type-Defect

[GoogleCodeExporter]

Hi Dennis

Thanks for the advice - I am using a Dell Laptop with Dell drivers - will give 
it a go over the next few days and see how I go.  I always check Trace and will 
keep looking at the trace.

Thanks alot for the support, the worst case scenario is that I upload at the 
end of the day (which is no big deal really)

I am planning on going OS for longer than 14 days soon - is 14 days the limit 
to upload data retrospectively?

Original comment by em...@miskeljin.com on 31 Jul 2011 at 12:00

[GoogleCodeExporter]

Well tried the update but did not work

never mind - I can download at night and all works that is good enough for me

many thanks
Robert

Original comment by em...@miskeljin.com on 1 Aug 2011 at 8:42

[GoogleCodeExporter]

Try configuring your own User Id and Password as the account used by PVService. 
Similar to Comment 17 above.

Dennis M-F

Original comment by DennisMackayFisher on 1 Aug 2011 at 10:57

[GoogleCodeExporter]

As in comment 17 above - Step 5 - Put in my Current Account name and password 
(that I use for windows logon)

Original comment by em...@miskeljin.com on 1 Aug 2011 at 11:13

[GoogleCodeExporter]

Yes,

It may allow Sunny Explorer to access the Bluetooth when run by the PVBC 
service.

Dennis M-F

Original comment by DennisMackayFisher on 1 Aug 2011 at 11:15

[GoogleCodeExporter]

I formatted my Laptop last night and started from scratch

When I installed 1.5.0.12 (32 bit version - I am running x64 Windows Pro) I 
hjit the start button, and nothing happens.  If I delete the PV Service file, 
it all works - any suggestions?

Original comment by em...@miskeljin.com on 2 Aug 2011 at 12:40

[GoogleCodeExporter]

Well trying even 1.5.0.5 I cannot get it to start

Not sure what I am doing - it keeps flashing on start but nothing happens, just 
keeps returning to start

Original comment by em...@miskeljin.com on 2 Aug 2011 at 9:50

[GoogleCodeExporter]

I suspect the problem relates to the lodation of the Default Directory. The 
PVBC service will normally have very limited permissions inside a user's 
personal directories. That is why I recommend C:\PVRecords.

You must ensure that the PVService user (Local Service after a standard 
install) has full permissions to create and destroy files and directories 
inside the Default Directory.

I suggest you go back to C:\PVService or some other location where Local 
Service has appropriate file and directory access permissions.

I do not understand:

"If I delete the PV Service file, it all works"

If it worked why did you change it?

Dennis M-F

Original comment by DennisMackayFisher on 2 Aug 2011 at 10:11

[GoogleCodeExporter]

Hi Dennis

Absolutely - you are right - using C:\PVRecords works fine (I had it on the 
desktop just for easy convenience)

If I kept deleting the PVRecords file it would start running for the first time 
(but not actually upload) 

I tried changing the Bluetooth settings to add my account and I could add my 
username but the Password section, every time I would add it more "dots" would 
be added than my password.  Not sure if this is a safety setting to blank the 
correct number of letters in password but didn't seem to work.

At this stage it is very easy to upload once a day at the end of the day

Once again, many thanks 

Original comment by em...@miskeljin.com on 2 Aug 2011 at 11:20

[GoogleCodeExporter]

The using "Local System Account" change (17) worked for me - had been going 
around in circles - but now working!
John Downe

Original comment by johnwdo...@gmail.com on 23 Aug 2011 at 2:45

[GoogleCodeExporter]

Also needed to change Bluetooth from WIDCOMM to Microsoft "stacks" using 
http://bluetoothinstaller.com - All working fine now!

Original comment by johnwdo...@gmail.com on 24 Aug 2011 at 10:58

[GoogleCodeExporter]

Thanks for the bluetooth solution. I will add details to the Wiki

Dennis M-F

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

• Changed state: Done