search

Jishar13 / pvbeancounter

Automatically exported from code.google.com/p/pvbeancounter
1 stars 0 forks source link

The program don't send automatically data and give an error on datatime. #102

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?

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

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

What Operating system (XP, Vista, Windows 7 - 32bit or 64bit)?
xp 32 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)

30/08/2011 11.52.43 :T5 ExecutionManager :ExecutionStateManager: State: Running
30/08/2011 11.52.43 :T5 ExecutionManager :InverterManagerManager: StartService: 
connecting to database: Data Source=C:\PVRecords\pvhistory.s3db
30/08/2011 11.52.43 :T5 ExecutionManager :InverterManagerManager: Loading 
Inverter Managers
30/08/2011 11.52.43 :T5 ExecutionManager :InverterManagerManager: NextFullDay 
set to no older than 23/07/2011 0.00.00 for manager Id 2
30/08/2011 11.52.43 :T5 ExecutionManager :Sunny Explorer: Inverter Manager - Id 
= 2 loaded
30/08/2011 11.52.43 :T6 SunnyExplorerInverterManager :Sunny Explorer: DoWork - 
Inverter Manager - Id = 2 - manager running
30/08/2011 11.52.43 :T5 ExecutionManager :InverterManagerManager: Inverter 
Managers Loaded
30/08/2011 11.52.43 :T7 PVOutput :PVOutputUtilities: pvoutput.org update started
30/08/2011 11.52.47 :T6 SunnyExplorerInverterManager :ExtractYieldRecords: 
SunnyExplorerCSVParser.ExtractDataLines: Error reading csv data - Line: 
26/08/2011 00:00:00;568,981;0,000 - Error: Stringa non riconosciuta come valore 
DateTime valido.
30/08/2011 11.52.47 :T6 SunnyExplorerInverterManager :Sunny Explorer: 
ExtractYield - status: before UpdateFromDirectory - exception: Riferimento a un 
oggetto non impostato su un'istanza di oggetto.
30/08/2011 11.52.57 :T7 PVOutput :PVOutputUtilities: pvoutput.org - Auto 
Backload completed
30/08/2011 11.53.10 :T8 :PVService: Stop requested
30/08/2011 11.53.10 :T5 ExecutionManager :ExecutionStateManager: Shutdown 
Requested
30/08/2011 11.53.10 :T5 ExecutionManager :ExecutionStateManager: State: Shutdown
30/08/2011 11.53.10 :T6 SunnyExplorerInverterManager :Sunny Explorer: DoWork - 
Inverter Manager - Id = 2 - manager stopping
30/08/2011 11.53.12 :T7 PVOutput :PVOutputUtilities: pvoutput.org update stopped
30/08/2011 11.53.25 :T5 ExecutionManager :ExecutionStateManager: Shutdown

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

  <?xml version="1.0" encoding="utf-8" ?> 
- <configuration>
  <host value="" /> 
  <database value="pvhistory.s3db" /> 
  <username value="" /> 
  <password value="" /> 
  <logfile value="PVService.log" /> 
  <databasetype value="SQLite" /> 
  <providertype value="Proprietary" /> 
  <providername value="System.Data.SQLite" /> 
  <oledbname value="" /> 
  <connectionstring value="" /> 
  <defaultdirectory value="C:\PVRecords" /> 
  <defaultmanagertype value="Sunny Explorer" /> 
  <pvoutputapikey value="ebbef5768bbf9a88873a8c89bdfe44d008efcf12" /> 
  <pvoutputsiteid value="3495" /> 
  <servicestarttime value="06:00:00" /> 
  <servicestoptime value="21:00:00" /> 
  <servicewakeinterval value="00:23:00" /> 
  <servicesuspendinterval value="01:37:00" /> 
  <servicesuspendtype value="sleep" /> 
  <enablepvoutput value="true" /> 
  <logtrace value="" /> 
- <appliancelist>
- <appliance>
  <applianceno value="0" /> 
  <storereading value="true" /> 
  <isconsumption value="true" /> 
  <isinverteryield value="" /> 
  <adjusthistory value="true" /> 
  <storehistory value="true" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="1" /> 
  <storereading value="" /> 
  <isconsumption value="" /> 
  <isinverteryield value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="2" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="3" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="4" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="5" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="6" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="7" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="8" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
- <appliance>
  <applianceno value="9" /> 
  <storereading value="" /> 
  <isinverteryield value="" /> 
  <isconsumption value="" /> 
  <adjusthistory value="" /> 
  <storehistory value="" /> 
  <calibrate value="1" /> 
  </appliance>
  </appliancelist>
- <invertermanagerlist>
- <invertermanager>
  <serialport /> 
  <instanceno value="1" /> 
  <managertype value="Sunny Explorer" /> 
  <enabled value="true" /> 
  <sunnyexplorerpath value="C:\Programmi\SMA\Sunny Explorer\SunnyExplorer.exe" /> 
  <firstfullday value="23/07/2011" /> 
  <sunnyexplorerplantname value="SunnyExplorer" /> 
  <sunnyexplorerpassword value="0000" /> 
  <resetfirstfullday value="true" /> 
  <resetfirstfulldayset value="29/08/2011 15:01:15" /> 
  </invertermanager>
- <invertermanager>
  <serialport /> 
  <instanceno value="1" /> 
  <managertype value="SMA Bluetooth" /> 
  <enabled value="" /> 
  </invertermanager>
- <invertermanager>
  <serialport /> 
  <instanceno value="1" /> 
  <managertype value="CMS" /> 
  <enabled value="" /> 
  </invertermanager>
- <invertermanager>
  <serialport /> 
  <instanceno value="1" /> 
  <managertype value="Current Cost" /> 
  <enabled value="" /> 
  </invertermanager>
- <invertermanager>
  <serialport /> 
  <instanceno value="1" /> 
  <managertype value="SMA WebBox" /> 
  <enabled value="" /> 
  </invertermanager>
  </invertermanagerlist>
  <dateformat value="dd/MM/yyyy" /> 
- <pvoutputdaylist>
- <pvoutputday>
  <day value="30/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="29/08/2011" /> 
  <forceload value="true" /> 
  <forceloadset value="29/08/2011 18:11:19" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="28/08/2011" /> 
  <forceload value="true" /> 
  <forceloadset value="29/08/2011 18:11:20" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="27/08/2011" /> 
  <forceload value="true" /> 
  <forceloadset value="29/08/2011 18:11:23" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="26/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="25/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="24/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="23/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="22/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="21/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="20/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="19/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="18/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
- <pvoutputday>
  <day value="17/08/2011" /> 
  <forceload value="" /> 
  <forceloadset value="" /> 
  </pvoutputday>
  </pvoutputdaylist>
  <initialsave value="false" /> 
  <firstfullday value="23/07/2011" /> 
  <pvoutputdatainterval value="5" /> 
  <pvlivedays value="14" /> 
  <monitormeters value="" /> 
  <enableeveningsuspend value="false" /> 
  <meterportname value="" /> 
  <usecctemperature value="false" /> 
  <monitorinverters value="" /> 
  </configuration>

Please provide any additional information below.

I had try to change all the number's format (. , ecc.) but with no results.

thanks

Original issue reported on code.google.com by stefa...@gmail.com on 30 Aug 2011 at 11:46

GoogleCodeExporter commented 8 years ago 
Please upload the following

settings.xml
PVservice.log

and one of your SunnyExplorer.csv inverter output files.

Please use the "Attach a file" (paperclip) link to upload the files.

This is clearly a locale / dateformat issue. The csv file will provide the date 
format details.

Dennis M-F

Original comment by DennisMackayFisher on 30 Aug 2011 at 12:02

GoogleCodeExporter commented 8 years ago 
Thank you for your kindly and fast response.

I am trying from 2 days to solve the problem.
Stefano.

Original comment by stefa...@gmail.com on 30 Aug 2011 at 12:51

GoogleCodeExporter commented 8 years ago 
Please upload the following

settings.xml
PVservice.log

and one of your SunnyExplorer.csv inverter output files.

Please use the "Attach a file" (paperclip) link to upload the files. This is 
below the "Add a comment..." text entry box.

Dennis M-F

Original comment by DennisMackayFisher on 30 Aug 2011 at 8:22

GoogleCodeExporter commented 8 years ago

Original comment by stefa...@gmail.com on 30 Aug 2011 at 10:48

GoogleCodeExporter commented 8 years ago

Original comment by stefa...@gmail.com on 30 Aug 2011 at 10:51

GoogleCodeExporter commented 8 years ago 
I had sent the files...
there are not solution for my problem?

I have the difficulty for the language, too. 
I'm italian, and my english is not much good.

thanks.
Stefano

Original comment by stefa...@gmail.com on 31 Aug 2011 at 3:16

GoogleCodeExporter commented 8 years ago 
I have been away for a couple of days. I will take a look today

Dennis M-F

Original comment by DennisMackayFisher on 3 Sep 2011 at 10:10

GoogleCodeExporter commented 8 years ago 
I have made a change in the current test version that I hope will solve the 
problem. I cannot verify that it fixes the problem as I believe it is 
associated with the "Culture" settings on your PC. I have set the Sunny 
Explorer date conversion to "InvariantCulture". I am hoping this will solve 
your problem.

This version will be released soon, probably as 1.7.0.0.

Dennis M-F

Original comment by DennisMackayFisher on 3 Sep 2011 at 11:42

GoogleCodeExporter commented 8 years ago 
1.7.0.0 is available now

Dennis M-F

Original comment by DennisMackayFisher on 4 Sep 2011 at 1:49

GoogleCodeExporter commented 8 years ago 
GREAT Dennis and GREAT  PVBC !!
The version 1.7.0.0. works and has solved the problem.

Now remains only one small problem:
after run once PVBC, probably this currupted SunniExplorer.sx2 that cannot be 
running again.
I must created a new SunniExplorer.sx2 again.

The error is:
System.FormatException in 
SMA.Data.Xml.Transformation.XmlTotWhOutItem.Read(XmlReader reader)
String was not recognized as a valid DateTime.

When I have a new SunniExplorer.sx2, the PVBC runs again!

Stefano

Original comment by stefa...@gmail.com on 4 Sep 2011 at 11:15

GoogleCodeExporter commented 8 years ago 
The user corrected the problem by running the PVBC Service as SYSTEM rather 
than LOCAL_SERVICE

Closing Now

Original comment by DennisMackayFisher on 11 Sep 2011 at 2:43