R Data Frame download options failing

[j-lorrey]

General Issue Information

Description

The R Data Frame (Metadata) and R Data Frame (Results) download options are not working in the OpenStudio Cloud Management Console. The RServe log shows RuntimeError (could not create R dataframe).

[12:58:24.369521 INFO] Started GET "/analyses/3b89a4a8-8685-4bed-92f8-36244fc9e19f/variables/download_variables.rdata" for 172.31.21.183 at 2022-03-31 12:58:24 +0000
[12:58:24.370166 INFO] Processing by VariablesController#download_variables as RDATA
[12:58:24.370201 INFO] Parameters: {"analysis_id"=>"3b89a4a8-8685-4bed-92f8-36244fc9e19f"}
[12:58:24.526207 INFO] {"display_name"=>["Apply the Measure to a SINGLE SpaceType, ALL the SpaceTypes or NONE.", "Apply the Measure to a SINGLE Space, ALL the Spaces or NONE.", "Multiplier for Luminaire.", "Multiplier for OtherEquipment.", "Multiplier for number of people.", "Multiplier for Internal Mass.", "Multiplier for infiltration.", "Multiplier for Ventilation.", "Multiplier for Lights.", "Multiplier for Electric Equipment.", "Multiplier for Gas Equipment.", "Electric NMBE limit (%)", "Electric CVRMSE limit (%)", "Gas NMBE limit (%)", "Gas CVRMSE limit (%)", "Fuel Oil#2 NMBE limit (%)", "Fuel Oil#2 CVRMSE limit (%)", "Which Unit System do you want to use?", "Model Summary", "Annual Overview", "Monthly Overview", "Utility Bills/Rates", "Envelope Summary", "Space Type Breakdown", "Space Type Summary", "Interior Lighting Summary", "Plug Loads Summary", "Exterior Lighting", "Water Use Equipment", "HVAC Load Profiles", "Zone Conditions", "Zone Overview", "Zone Equipment Detail", "Air Loops Detail", "Plant Loops Detail", "Outdoor Air", "Cash Flow", "Site and Source Summary", "Schedule Overview", "Report monthly fuel and enduse breakdown to registerValue", "Remove sql files from run directory", "Remove eso files from run directory", "Remove audit files from run directory", "Remove osm files from run directory", "Remove idf files from run directory", "Remove bnd files from run directory", "Remove eio files from run directory", "Remove shd files from run directory", "Remove mdd files from run directory", "Remove rdd files from run directory", "Remove csv files from run directory", "Remove Sizing Run Directories files from run directory", "electricity_consumption_cvrmse", "electricity_consumption_nmbe", "natural_gas_consumption_cvrmse", "natural_gas_consumption_nmbe", "electricity_consumption_actual", "electricity_consumption_modeled", "natural_gas_consumption_actual", "natural_gas_consumption_modeled", "electricity_cvrmse_within_limit", "electricity_nmbe_within_limit", "natural_gas_cvrmse_within_limit", "natural_gas_nmbe_within_limit"], "display_name_short"=>["space_type", "space", "Luminaire_multiplier", "OtherEquipment_multiplier", "People_multiplier", "InternalMass_multiplier", "Infiltration_multiplier", "Ventilation_multiplier", "Lights_multiplier", "ElectricEquipment_multiplier", "GasEquipment_multiplier", "electric_nmbe_limit", "electric_cvrmse_limit", "gas_nmbe_limit", "gas_cvrmse_limit", "fuel_oil_nmbe_limit", "fuel_oil_cvrmse_limit", "units", "building_summary_section", "annual_overview_section", "monthly_overview_section", "utility_bills_rates_section", "envelope_section_section", "space_type_breakdown_section", "space_type_details_section", "interior_lighting_section", "plug_loads_section", "exterior_light_section", "water_use_section", "hvac_load_profile", "zone_condition_section", "zone_summary_section", "zone_equipment_detail_section", "air_loops_detail_section", "plant_loops_detail_section", "outdoor_air_section", "cost_summary_section", "source_energy_section", "schedules_overview_section", "reg_monthly_details", "sql", "eso", "audit", "osm", "idf", "bnd", "eio", "shd", "mdd", "rdd", "csv", "Sizing Run Directories", "electricity_consumption_cvrmse", "electricity_consumption_nmbe", "natural_gas_consumption_cvrmse", "natural_gas_consumption_nmbe", "electricity_consumption_actual", "electricity_consumption_modeled", "natural_gas_consumption_actual", "natural_gas_consumption_modeled", "electricity_cvrmse_within_limit", "electricity_nmbe_within_limit", "natural_gas_cvrmse_within_limit", "natural_gas_nmbe_within_limit"], "export"=>[false, false, false, false, false, false, false, false, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, true, true, true, true, true, true], "maximum"=>[nil, nil, nil, nil, nil, nil, nil, nil, 1, 1, 1, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "measure_id"=>["27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6"], "metadata_id"=>[nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "minimum"=>[nil, nil, nil, nil, nil, nil, nil, nil, 0.25, 0.25, 0.25, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "name"=>["space_type", "space", "Luminaire_multiplier", "OtherEquipment_multiplier", "People_multiplier", "InternalMass_multiplier", "Infiltration_multiplier", "Ventilation_multiplier", "general_calibration_measure_multiplier.Lights_multiplier", "general_calibration_measure_multiplier.ElectricEquipment_multiplier", "general_calibration_measure_multiplier.GasEquipment_multiplier", "electric_nmbe_limit", "electric_cvrmse_limit", "gas_nmbe_limit", "gas_cvrmse_limit", "fuel_oil_nmbe_limit", "fuel_oil_cvrmse_limit", "units", "building_summary_section", "annual_overview_section", "monthly_overview_section", "utility_bills_rates_section", "envelope_section_section", "space_type_breakdown_section", "space_type_details_section", "interior_lighting_section", "plug_loads_section", "exterior_light_section", "water_use_section", "hvac_load_profile", "zone_condition_section", "zone_summary_section", "zone_equipment_detail_section", "air_loops_detail_section", "plant_loops_detail_section", "outdoor_air_section", "cost_summary_section", "source_energy_section", "schedules_overview_section", "reg_monthly_details", "sql", "eso", "audit", "osm", "idf", "bnd", "eio", "shd", "mdd", "rdd", "csv", "Sizing Run Directories", "calibration_reports_enhanced.electricity_consumption_cvrmse", "calibration_reports_enhanced.electricity_consumption_nmbe", "calibration_reports_enhanced.natural_gas_consumption_cvrmse", "calibration_reports_enhanced.natural_gas_consumption_nmbe", "calibration_reports_enhanced.electricity_consumption_actual", "calibration_reports_enhanced.electricity_consumption_modeled", "calibration_reports_enhanced.natural_gas_consumption_actual", "calibration_reports_enhanced.natural_gas_consumption_modeled", "calibration_reports_enhanced.electricity_cvrmse_within_limit", "calibration_reports_enhanced.electricity_nmbe_within_limit", "calibration_reports_enhanced.natural_gas_cvrmse_within_limit", "calibration_reports_enhanced.natural_gas_nmbe_within_limit"], "objective_function"=>[false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, false, false, false, false, false, false, false, false, false, false], "objective_function_group"=>[nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, 1, 2, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "objective_function_index"=>[nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, 0, 1, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "output"=>[false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, true, true, true, true, true, true], "perturbable"=>[false, false, false, false, false, false, false, false, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false], "pivot"=>[false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false], "static_value"=>[nil, nil, nil, nil, nil, nil, nil, nil, 1, 1, 1, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "units"=>[nil, nil, nil, nil, nil, nil, nil, nil, "", "", "", nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, "%", "%", "%", "%", "", "", "", "", "", "", "", ""], "value_type"=>["string", "string", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "string", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double"], "visualize"=>[false, false, false, false, false, false, false, false, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, true, true, true, true, true, true], "measure_name"=>["general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced"], "measure_display_name"=>["General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced"], "type_of_variable"=>["unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "variable", "variable", "variable", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "output", "output", "output", "output", "output", "output", "output", "output", "output", "output", "output", "output"], "objective_function_target"=>[5, 15]}
[12:58:24.527512 INFO] outhash is {"display_name"=>["Apply the Measure to a SINGLE SpaceType, ALL the SpaceTypes or NONE.", "Apply the Measure to a SINGLE Space, ALL the Spaces or NONE.", "Multiplier for Luminaire.", "Multiplier for OtherEquipment.", "Multiplier for number of people.", "Multiplier for Internal Mass.", "Multiplier for infiltration.", "Multiplier for Ventilation.", "Multiplier for Lights.", "Multiplier for Electric Equipment.", "Multiplier for Gas Equipment.", "Electric NMBE limit (%)", "Electric CVRMSE limit (%)", "Gas NMBE limit (%)", "Gas CVRMSE limit (%)", "Fuel Oil#2 NMBE limit (%)", "Fuel Oil#2 CVRMSE limit (%)", "Which Unit System do you want to use?", "Model Summary", "Annual Overview", "Monthly Overview", "Utility Bills/Rates", "Envelope Summary", "Space Type Breakdown", "Space Type Summary", "Interior Lighting Summary", "Plug Loads Summary", "Exterior Lighting", "Water Use Equipment", "HVAC Load Profiles", "Zone Conditions", "Zone Overview", "Zone Equipment Detail", "Air Loops Detail", "Plant Loops Detail", "Outdoor Air", "Cash Flow", "Site and Source Summary", "Schedule Overview", "Report monthly fuel and enduse breakdown to registerValue", "Remove sql files from run directory", "Remove eso files from run directory", "Remove audit files from run directory", "Remove osm files from run directory", "Remove idf files from run directory", "Remove bnd files from run directory", "Remove eio files from run directory", "Remove shd files from run directory", "Remove mdd files from run directory", "Remove rdd files from run directory", "Remove csv files from run directory", "Remove Sizing Run Directories files from run directory", "electricity_consumption_cvrmse", "electricity_consumption_nmbe", "natural_gas_consumption_cvrmse", "natural_gas_consumption_nmbe", "electricity_consumption_actual", "electricity_consumption_modeled", "natural_gas_consumption_actual", "natural_gas_consumption_modeled", "electricity_cvrmse_within_limit", "electricity_nmbe_within_limit", "natural_gas_cvrmse_within_limit", "natural_gas_nmbe_within_limit"], "display_name_short"=>["space_type", "space", "Luminaire_multiplier", "OtherEquipment_multiplier", "People_multiplier", "InternalMass_multiplier", "Infiltration_multiplier", "Ventilation_multiplier", "Lights_multiplier", "ElectricEquipment_multiplier", "GasEquipment_multiplier", "electric_nmbe_limit", "electric_cvrmse_limit", "gas_nmbe_limit", "gas_cvrmse_limit", "fuel_oil_nmbe_limit", "fuel_oil_cvrmse_limit", "units", "building_summary_section", "annual_overview_section", "monthly_overview_section", "utility_bills_rates_section", "envelope_section_section", "space_type_breakdown_section", "space_type_details_section", "interior_lighting_section", "plug_loads_section", "exterior_light_section", "water_use_section", "hvac_load_profile", "zone_condition_section", "zone_summary_section", "zone_equipment_detail_section", "air_loops_detail_section", "plant_loops_detail_section", "outdoor_air_section", "cost_summary_section", "source_energy_section", "schedules_overview_section", "reg_monthly_details", "sql", "eso", "audit", "osm", "idf", "bnd", "eio", "shd", "mdd", "rdd", "csv", "Sizing Run Directories", "electricity_consumption_cvrmse", "electricity_consumption_nmbe", "natural_gas_consumption_cvrmse", "natural_gas_consumption_nmbe", "electricity_consumption_actual", "electricity_consumption_modeled", "natural_gas_consumption_actual", "natural_gas_consumption_modeled", "electricity_cvrmse_within_limit", "electricity_nmbe_within_limit", "natural_gas_cvrmse_within_limit", "natural_gas_nmbe_within_limit"], "export"=>[false, false, false, false, false, false, false, false, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, true, true, true, true, true, true], "maximum"=>[nil, nil, nil, nil, nil, nil, nil, nil, 1, 1, 1, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "measure_id"=>["27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "27793eac-e9df-4f28-9334-42dc27d343f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "48201321-30eb-4fba-a9b9-47ac53b49688", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "5d0b6e1e-703c-42c5-a8f4-8a7a91a9352e", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6", "c1f859f0-d247-47b6-bef3-987848e2b8f6"], "metadata_id"=>[nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "minimum"=>[nil, nil, nil, nil, nil, nil, nil, nil, 0.25, 0.25, 0.25, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "name"=>["space_type", "space", "Luminaire_multiplier", "OtherEquipment_multiplier", "People_multiplier", "InternalMass_multiplier", "Infiltration_multiplier", "Ventilation_multiplier", "general_calibration_measure_multiplier.Lights_multiplier", "general_calibration_measure_multiplier.ElectricEquipment_multiplier", "general_calibration_measure_multiplier.GasEquipment_multiplier", "electric_nmbe_limit", "electric_cvrmse_limit", "gas_nmbe_limit", "gas_cvrmse_limit", "fuel_oil_nmbe_limit", "fuel_oil_cvrmse_limit", "units", "building_summary_section", "annual_overview_section", "monthly_overview_section", "utility_bills_rates_section", "envelope_section_section", "space_type_breakdown_section", "space_type_details_section", "interior_lighting_section", "plug_loads_section", "exterior_light_section", "water_use_section", "hvac_load_profile", "zone_condition_section", "zone_summary_section", "zone_equipment_detail_section", "air_loops_detail_section", "plant_loops_detail_section", "outdoor_air_section", "cost_summary_section", "source_energy_section", "schedules_overview_section", "reg_monthly_details", "sql", "eso", "audit", "osm", "idf", "bnd", "eio", "shd", "mdd", "rdd", "csv", "Sizing Run Directories", "calibration_reports_enhanced.electricity_consumption_cvrmse", "calibration_reports_enhanced.electricity_consumption_nmbe", "calibration_reports_enhanced.natural_gas_consumption_cvrmse", "calibration_reports_enhanced.natural_gas_consumption_nmbe", "calibration_reports_enhanced.electricity_consumption_actual", "calibration_reports_enhanced.electricity_consumption_modeled", "calibration_reports_enhanced.natural_gas_consumption_actual", "calibration_reports_enhanced.natural_gas_consumption_modeled", "calibration_reports_enhanced.electricity_cvrmse_within_limit", "calibration_reports_enhanced.electricity_nmbe_within_limit", "calibration_reports_enhanced.natural_gas_cvrmse_within_limit", "calibration_reports_enhanced.natural_gas_nmbe_within_limit"], "objective_function"=>[false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, false, false, false, false, false, false, false, false, false, false], "objective_function_group"=>[nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, 1, 2, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "objective_function_index"=>[nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, 0, 1, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "output"=>[false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, true, true, true, true, true, true], "perturbable"=>[false, false, false, false, false, false, false, false, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false], "pivot"=>[false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false], "static_value"=>[nil, nil, nil, nil, nil, nil, nil, nil, 1, 1, 1, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil], "units"=>[nil, nil, nil, nil, nil, nil, nil, nil, "", "", "", nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, nil, "%", "%", "%", "%", "", "", "", "", "", "", "", ""], "value_type"=>["string", "string", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "string", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "boolean", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double", "double"], "visualize"=>[false, false, false, false, false, false, false, false, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, true, true, true, true, true, true], "measure_name"=>["general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "general_calibration_measure_multiplier", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "openstudio_results", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "server_directory_cleanup", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced", "calibration_reports_enhanced"], "measure_display_name"=>["General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "General Calibration Measure Multiplier", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "OpenStudio Results", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Server Directory Cleanup", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced", "Calibration Reports Enhanced"], "type_of_variable"=>["unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "variable", "variable", "variable", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "output", "output", "output", "output", "output", "output", "output", "output", "output", "output", "output", "output"], "objective_function_target"=>[5, 15]}
[12:58:24.546236 INFO] Completed 500 Internal Server Error in 176ms (MongoDB: 0.1ms | Allocations: 66462)
[12:58:24.546564 FATAL]
RuntimeError (could not create R dataframe):

app/controllers/variables_controller.rb:240:in `write_and_send_input_variables_rdata'
app/controllers/variables_controller.rb:135:in `block (2 levels) in download_variables'
app/controllers/variables_controller.rb:128:in `download_variables'
[12:58:27.163054 INFO] Started GET "/analyses/3b89a4a8-8685-4bed-92f8-36244fc9e19f/download_data.rdata?export=true" for 172.31.21.183 at 2022-03-31 12:58:27 +0000
[12:58:27.163732 INFO] Processing by AnalysesController#download_data as RDATA
[12:58:27.163770 INFO] Parameters: {"export"=>"true", "id"=>"3b89a4a8-8685-4bed-92f8-36244fc9e19f"}
[12:58:27.184387 INFO] finished fixing up data: 0.015900878
[12:58:27.184455 INFO] mapping variables
[12:58:27.184680 INFO] finished mapping variables: 0.000217995
[12:58:27.184703 INFO] Start map/reduce
[12:58:27.238893 INFO] Finished map/reduce: 0.054177272
[12:58:27.238955 INFO] Start as_json
[12:58:27.243253 INFO] Finished as_json: 0.004289682
[12:58:27.243288 INFO] Start collapse
[12:58:27.244185 INFO] finished merge: 0.000888375
[12:58:27.244279 INFO] starting conversion of data to column vectors
[12:58:27.245913 INFO] finished conversion: 0.001625803
[12:58:27.250121 INFO] starting creation of data frame
[12:58:27.267125 INFO] finished data frame: 0.01697847
[12:58:27.267427 INFO] Completed 500 Internal Server Error in 104ms (MongoDB: 0.1ms | Allocations: 36278)
[12:58:27.267753 FATAL]
RuntimeError (could not create R dataframe):

Reproduction steps:

1. Run a job in PAT.
2. Open the OpenStudio Cloud Management console and click "View Analysis" for that job.
3. Under downloads, click on either "R Data Frame (Metadata)" or "R Data Frame (Results)".

Actual outcome:

Running on cloud with kubernetes:

Clicking either link shows "We're sorry, but something went wrong". Developer tools console shows a status code of 500 (internal server error) for the GET request.

Running locally:

Clicking either link shows an Internal Server Error with the message "Can't start Rserve".

Expected outcome:
The R data frame exists and is downloaded.

Other information (i.e. issue is intermittent):
This appears to happen 100% of the time.

Error on Remote Server Details

AMI version being used: OpenStudio Server: 3.3.0

Server management log file: server_mgmt_log.txt

[tijcolem]

@j-lorrey We had an issue with rserver not starting up correctly due to k8s cpu and mem limits being too aggressive. Can you please try the updated patched version https://github.com/NREL/openstudio-server-helm/releases/tag/v3.3.0-1 and let us know if this is still a problem.

[j-lorrey]

Hi @tijcolem, I'm seeing this with the patched version as well.

[brianlball]

the Rdata frame must be created in a common location between the web and Rserve containers. I change the location to /mnt/openstudio/tmp