I finally managed to set up my optimization run with RVX objective file in JEPLUS+EA.
The run is starting normally but stopps after the first generation:-( No error is shown. It just does not continue.
I did several trials and only the provided RVX example is running fine. But in this example no data is collected from the SQL. Is the SQL extraction by the RVX maybe not working in JEPLUS+EA???
Below you find my rvi file.
eplusout.eso
eplusout.csv
Heating:Electricity
Cooling:Electricity
0
!-sqlite
! Output file name; Column headers; SQL command
HVAC_Electricity;HVAC Electricity Intensity [kWh/m2];SELECT Value FROM TabularDataWithStrings WHERE (TableName='Utility Use Per Conditioned Floor Area' AND RowName='HVAC' AND ColumnName='Electricity Intensity')
Construction_Cost;Construction Cost [NPR]; SELECT Value FROM TabularDataWithStrings WHERE (TableName='Construction Cost Estimate Summary' AND RowName='Cost Estimate Total (~~$~~)' AND ColumnName='Current Bldg. Model')
!-end sqlite
!-objectives
! Name of the objective; unit; formula (c0, c1, c2... are columns in the result table generated from the statements above)
Heating Electriciy;kWh;c1/1000/3600
Cooling Electriciy;kWh;c2/1000/3600
HVAC Electriciy;kWh/m2;c3
!-end objectives
RVX file:
{
"notes": "Some notes about this RVX",
"rvis": [
{
"fileName": "my.rvi",
"tableName": "SimResults"
}
],
"sqls": [
{
"tableName": "HVAC_Electricity_Intensity",
"columnHeaders": "HVAC Electricity Intensity [kWh/m²]",
"sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (TableName='Utility Use Per Conditioned Floor Area' AND RowName='HVAC' AND ColumnName='Electricity Intensity')"
},
{
"tableName": "Construction_Cost",
"columnHeaders": "Construction Cost [NPR]",
"sqlcommand": "SELECT Value FROM TabularDataWithStrings WHERE (TableName='Construction Cost Estimate Summary' AND RowName='Cost Estimate Total (~~$~~)' AND ColumnName='Current Bldg. Model')"
}
],
"userVars": [
{
"identifier": "v0",
"formula": "c0/1000/3600",
"caption": "Heating Electricity [kWh]",
"report": true
},
{
"identifier": "v1",
"formula": "c1/1000/3600",
"caption": "Cooling_Electricity [kWh]",
"report": true
},
{
"identifier": "v2",
"formula": "c2",
"caption": "HVAC Electricity Intensity [kWh/m²]",
"report": true
},
{
"identifier": "v3",
"formula": "c3/100",
"caption": "Construction Cost [USD]",
"report": true
}
],
"objectives": [
{
"identifier": "t1",
"formula": "v0",
"caption": "Heating Electricity [kWh]",
"scaling": false,
"min": 0,
"max": 10000,
"weight": 1
},
{
"identifier": "t2",
"formula": "v1",
"caption": "Cooling Electricity [kWh]",
"scaling": false,
"min": 0,
"max": 10000,
"weight": 1
}
]
}
The ERROR file (client.err) shows following:
2015-08-21 12:12:04,179 WARN [main] vis.JFrameMO ( ) - File watcher util failed to register .
java.io.IOException: Incorrect function.
at sun.nio.fs.WindowsWatchService$Poller.implRegister(Unknown Source)
at sun.nio.fs.AbstractPoller.processRequests(Unknown Source)
at sun.nio.fs.WindowsWatchService$Poller.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2015-08-21 12:12:05,320 ERROR [main] vis.JFrameMO ( ) - File watcher error with folder Z:\Simulation_Pedro\_Sim_DoubleCottage_V13\Biratnagar\DoubleCottage_V13
java.io.IOException: Incorrect function.
at sun.nio.fs.WindowsWatchService$Poller.implRegister(Unknown Source)
at sun.nio.fs.AbstractPoller.processRequests(Unknown Source)
at sun.nio.fs.WindowsWatchService$Poller.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2015-08-21 12:13:02,508 ERROR [AWT-EventQueue-0] vis.JFrameMO ( ) - File watcher error with folder Z:\Simulation_Pedro\_Sim_DoubleCottage_V13\Biratnagar\DoubleCottage_V13_EplusV8.3
java.io.IOException: Incorrect function.
at sun.nio.fs.WindowsWatchService$Poller.implRegister(Unknown Source)
at sun.nio.fs.AbstractPoller.processRequests(Unknown Source)
at sun.nio.fs.WindowsWatchService$Poller.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2015-08-21 12:13:32,474 ERROR [AWT-EventQueue-0] vis.JFrameMO ( ) - File watcher error with folder Z:\Simulation_Pedro\_Sim_DoubleCottage_V13\Biratnagar\DoubleCottage_V13_EplusV8.3
java.io.IOException: Incorrect function.
at sun.nio.fs.WindowsWatchService$Poller.implRegister(Unknown Source)
at sun.nio.fs.AbstractPoller.processRequests(Unknown Source)
at sun.nio.fs.WindowsWatchService$Poller.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2015-08-21 12:14:15,977 INFO [AWT-EventQueue-0] jeplus.JEPlusEA_Main ( ) - Simulation will be carried out locally. jeplus.cfg is loaded.
2015-08-21 12:14:16,525 INFO [Thread-18] agent.EPlusAgent ( ) - Job DC-0_0_0_0_2_1_3_4_0_0_0 started. 3 more to go!
2015-08-21 12:14:16,634 INFO [Thread-18] agent.EPlusAgent ( ) - Job DC-0_0_0_0_2_2_5_6_0_0_0 started. 2 more to go!
2015-08-21 12:14:16,754 INFO [Thread-18] agent.EPlusAgent ( ) - Job DC-0_0_0_0_1_13_7_0_0_0_0 started. 1 more to go!
2015-08-21 12:14:16,884 INFO [Thread-18] agent.EPlusAgent ( ) - Job DC-0_0_0_0_5_13_1_5_0_0_0 started. 0 more to go!
2015-08-21 12:14:17,102 INFO [Thread-18] agent.EPlusAgent ( ) - Nearly there ...
2015-08-21 12:15:47,775 INFO [Thread-18] agent.EPlusAgent ( ) - Local batch simulation controller is FINISHED [Que=0, Run=0, Fin=4]
2015-08-21 12:15:47,775 INFO [Thread-18] agent.EPlusAgent ( ) - Local agent stopped.
2015-08-21 12:15:47,775 INFO [Thread-18] agent.EPlusAgent ( ) - Collecting results ...
2015-08-21 12:15:47,822 INFO [Thread-18] agent.EPlusAgent ( ) - Standard RVI result collector collected 4 simulation reports in Z:\Simulation_Pedro\_Sim_DoubleCottage_V13\Biratnagar\output\RunTimes.csv
2015-08-21 12:15:47,822 INFO [Thread-18] agent.EPlusAgent ( ) - Standard RVI result collector collected job index table in Z:\Simulation_Pedro\_Sim_DoubleCottage_V13\Biratnagar\output\SimJobIndex.csv
2015-08-21 12:15:50,744 INFO [Thread-18] agent.EPlusAgent ( ) - ESO result collector collected 4 rows of simulation results in SimResults.csv
2015-08-21 12:15:52,493 INFO [Thread-18] agent.EPlusAgent ( ) - SQLite result collector collected 52 rows of simulation results in Heating_Electricity.csv Cooling_Electricity.csv HVAC_Electricity_Intensity.csv Construction_Cost.csv Annual_Electricty_Cost.csv LCC_PV_GrandTotal.csv LCC_PV_Capital.csv LCC_PV_Operation.csv U-Value_ExtWall.csv U-Value_Roof.csv U-Value_GrFloor.csv U-Value_Window.csv SHGC_Windows.csv
2015-08-21 12:15:52,619 INFO [Thread-18] agent.EPlusAgent ( ) - Combined result table AllCombinedResults.csv is created.
2015-08-21 12:15:52,666 INFO [Thread-18] agent.EPlusAgent ( ) - Derivative result table AllDerivedResults.csv is created.
2015-08-21 12:15:52,666 INFO [Thread-18] agent.EPlusAgent ( ) - All done!
2015-08-21 12:15:52,666 INFO [Thread-18] agent.EPlusAgent ( ) - Simulation finished at: Fri, 21 Aug 2015 12:15:52
2015-08-21 12:15:52,666 INFO [Thread-18] agent.EPlusAgent ( ) - Total execution time = 96 seconds.
