Importing Database via the Database initializer not possible about cityenergyanalyst HOT 11 CLOSED

Hi @KFSchlager,

For the "+ Browse for databases path" button bug, we have fixed it for the GUI but you would have to manually update it on your end for now, without having to reinstall it.

You can extract the attached file and replace the app.asar file that is found in your CEA installation path:
e.g.

C:\Users\foobar\Documents\CityEnergyAnalyst\dashboard\resources\app.asar

app.asar.zip

Let me know if that works for you.

from cityenergyanalyst.

Hi @reyery
yes, that worked. Thank you very much!

from cityenergyanalyst.

Hi @reyery

the PermissionError still occurs, but the "+ Browse for databases path" button works now.

from cityenergyanalyst.

Hi @KFSchlager, would you mind sharing me the whole log of the script that produces the error? I am not able to reproduce it on my end.

from cityenergyanalyst.

I will close this issue for now. Let me know if it is still an issue.

from cityenergyanalyst.

Hej!
This is also an issue for me, and it does not work to replace the app.asar for me, when I try it then I can't open the CEA dashboard anymore. Only way to get back into the CEA is to re-install it, but face the same issue when I try to import any database.

This is the error:

Job Output for 1 - data-initializer
City Energy Analyst version 3.35.4
Running `cea data-initializer` with the following parameters:
- general:scenario = C:\Users\moma0061\Videos\reference-case-open\TEST0307\test1
  (default: {general:project}\{general:scenario-name})
Traceback (most recent call last):
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\setuptools\_distutils\file_util.py", line 33, in _copy_file_contents
    os.unlink(dst)
PermissionError: [WinError 32] Det går inte att komma åt filen eftersom den
används av en annan process: 'C:\\Users\\moma0061\\Videos\\reference-case-open\\TEST0307\\test1\\inputs\\technology\\archetypes\\CONSTRUCTION_STANDARD.xlsx'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\worker.py", line 146, in worker
    run_job(config, job, server)
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\worker.py", line 108, in run_job
    script(config=config, **parameters)
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\api.py", line 60, in __call__
    self._runner.__call__(*args, **kwargs)
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\api.py", line 38, in script_runner
    script_module.main(config)
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\datamanagement\data_initializer.py", line 70, in main
    data_initializer(locator=locator,
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\datamanagement\data_initializer.py", line 42, in data_initializer
    copy_tree(complete_databases_path, complete_output_directory)
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\setuptools\_distutils\dir_util.py", line 185, in copy_tree
    copy_file(
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\setuptools\_distutils\file_util.py", line 163, in copy_file
    _copy_file_contents(src, dst)
  File "C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\setuptools\_distutils\file_util.py", line 35, in _copy_file_contents
    raise DistutilsFileError(
distutils.errors.DistutilsFileError: could not delete 'C:\Users\moma0061\Videos\reference-case-open\TEST0307\test1\inputs\technology\archetypes\CONSTRUCTION_STANDARD.xlsx': Det går inte att komma åt filen eftersom den
används av en annan pro- data-initializer:databases-path = C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\databases\CH
  (default: )
- data-initializer:databases = ['archetypes', 'assemblies', 'components']
  (default: ['archetypes', 'assemblies', 'components'])
Running data-intializer with scenario = C:\Users\moma0061\Videos\reference-case-open\TEST0307\test1
Running data-intializer with databases located in = C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\databases\CH
Copying databases from C:\Users\moma0061\Videos\dependencies\micromamba\envs\cea\lib\site-packages\cea\databases\CH
Copying databases to C:\Users\moma0061\Videos\reference-case-open\TEST0307\test1\inputs\technology

from cityenergyanalyst.

Hi @moaapplepie

Thanks for raising this.
It looks like it is not a unique case now..

Currently, @reyery tried a few times to replicate the error and we still could not..We will dig into it.
During the installation process, did you select "install for everyone" or "install for me only"?

from cityenergyanalyst.

Hej @ShiZhongming and @reyery.

Thank you for your swift response, and help with this issue! I think I chose "install for me only" :)

from cityenergyanalyst.

Hi,
I think i chose "install for me only" too

from cityenergyanalyst.

My error log is the following:

City Energy Analyst version 3.35.4
Running cea data-initializer with the following parameters:

• general:scenario = C:\Users\user\Downloads\08032024test\1test
  (default: {general:project}{general:scenario-name})
  Traceback (most recent call last):
  File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\setuptools_distutils\file_util.py", line 33, in _copy_file_contents
  os.unlink(dst)
  PermissionError: [WinError 32] Der Prozess kann nicht auf die Datei zugreifen, da sie von einem anderen Prozess verwendet wird: 'C:\Users\user\Downloads\08032024test\1test\inputs\technology\components\CONVERSION.xlsx'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\worker.py", line 146, in worker
run_job(config, job, server)
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\worker.py", line 108, in run_job
script(config=config, **parameters)
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\api.py", line 60, in call
self._runner.call(*args, **kwargs)
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\api.py", line 38, in script_runner
script_module.main(config)
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\datamanagement\data_initializer.py", line 70, in main
data_initializer(locator=locator,
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\datamanagement\data_initializer.py", line 48, in data_initializer
copy_tree(complete_databases_path, complete_output_directory)
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\setuptools_distutils\dir_util.py", line 185, in copy_tree
copy_file(
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\setuptools_distutils\file_util.py", line 163, in copy_file
_copy_file_contents(src, dst)
File "C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\setuptools_distutils\file_util.py", line 35, in _copy_file_contents
raise DistutilsFileError(
distutils.errors.DistutilsFileError: could not delete 'C:\Users\user\Downloads\08032024test\1test\inputs\technology\components\CONVERSION.xlsx': Der Prozess kann nicht auf die Datei zugreifen, da sie von einem anderen Prozess verwendet wird

• data-initializer:databases-path = C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\databases\CH
  (default: )
• data-initializer:databases = ['archetypes', 'assemblies', 'components']
  (default: ['archetypes', 'assemblies', 'components'])
  Running data-intializer with scenario = C:\Users\user\Downloads\08032024test\1test
  Running data-intializer with databases located in = C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\databases\CH
  Copying databases from C:\Program Files\CityEnergyAnalyst\dependencies\micromamba\envs\cea\lib\site-packages\cea\databases\CH
  Copying databases to C:\Users\user\Downloads\08032024test\1test\inputs\technology

from cityenergyanalyst.

This should be resolved in the new version v3.35.5. Let me know if it is still an issue.

from cityenergyanalyst.