XLSX import of sample data hanging

SEED-platform / seed

Standard Energy Efficiency Data (SEED) Platform™ is a web-based application that helps organizations easily manage data on the energy performance of large groups of buildings.

Other

107 stars 55 forks source link

XLSX import of sample data hanging #2392

Closed RDmitchell closed 4 years ago

RDmitchell commented 4 years ago

Expected Behavior

Should be able to import a sample XLSX ESPM file

Actual Behavior

Seems to hang on import

Steps to Reproduce

Org: LBNL 200 Cycle: 2015 Compliance Cycle

File: 2015-example-data-ESPM-Alerts-CustomID.xlsx https://drive.google.com/file/d/1p-KAgjKgkMEyBdtm9-1pyAmuJbQdNDZr/view?usp=sharing

15 records, 18 fields

Choose “Upload a Spreadsheet”

Program seems to hang on import, but no error messages looking at Developer Tools

Instance Information

Instance: dev1 SHA: 62ee5c4a

RDmitchell commented 4 years ago

Instance: seeddemostaging SHA: 62ee5c4a6

axelstudios commented 4 years ago

This should be fixed now - it was a temporary issue where the host ran out of disk space, and celery stopped working because redis could no longer persist to the disk. Just needed to restart the celery container

RDmitchell commented 4 years ago

Thx !

RDmitchell commented 4 years ago

instance: dev1 SHA: Org: LBNL Test 200 Cycle: 2015

@alex -- I am now getting this error when trying to import the 2015 file into the 2015 Data Set

axelstudios commented 4 years ago

Hmm, are you able to import other xlsx files? I was able to import the portfolio-manager-sample without running into issues:

RDmitchell commented 4 years ago

@axelstudios -- strangely, I am no longer getting that error, and seem to be able to import files. I will close this issue