+2 votes


I am a new user for openlca.

I already succeed to import methods database. 

However, when I tried to import LCIA method and  I follow this procedure: file > import > select "import entire database" > from exported zolca files > select the file on my computer > Finish.

A message is displayed : "An error occured - database import failed"
When I open the error details : this what I see :

16mainINFOorg.openlca.julia.JuliaTry to load Julia libs and bindings from C:\Users\tan.s\AppData\Local\openLCA
16mainINFOorg.openlca.julia.Juliaload module OPEN_BLAS with library C:\Users\tan.s\AppData\Local\openLCA\libjolcablas.dll
16mainINFOorg.openlca.julia.JuliaLibrary C:\Users\tan.s\AppData\Local\openLCA\libjolcaumf.dll is missing; Julia bindings for UMFPACK not loaded
16mainINFOorg.openlca.julia.JuliaJulia bindings loaded
16mainINFOorg.openlca.app.AppLoaded Julia-BLAS solver as default matrix solver
16Worker-0INFOorg.openlca.app.devtools.python.Pythoninitialize Python interpreter
10887416ModalContextINFOorg.openlca.app.db.DatabaseListwrite database configurations to C:\Users\tan.s\openLCA-data-1.4\databases.json
10888139ModalContextINFOorg.openlca.core.database.derby.DerbyDatabaseinitialize database folder C:\Users\tan.s\openLCA-data-1.4\databases\FirstDatabase, create=false
11107789ModalContextINFOorg.openlca.core.database.derby.DerbyDatabaseinitialize database folder C:\Users\tan.s\AppData\Local\Temp\207a0a0a-b657-4d3b-acb5-106c8db9ab0a, create=false
11108230JavaFX Application ThreadERRORorg.openlca.app.wizards.io.DbImportWizarddatabase import failed
     at org.openlca.app.wizards.io.DbImportWizard$ImportDispatch.run(DbImportWizard.java:149) 
     at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119) 
    Caused by: java.lang.IllegalStateException: A transaction is already running 
     at org.openlca.app.db.IndexUpdater.beginTransaction(IndexUpdater.java:16) 
     at org.openlca.app.wizards.io.DbImportWizard$ImportDispatch.run(DbImportWizard.java:138) 
     ... 1 more
11137909ModalContextINFOorg.openlca.core.database.derby.DerbyDatabaseinitialize database folder C:\Users\tan.s\AppData\Local\Temp\bbb6a2bb-0bcb-47a6-9bf5-9ef623ad10ee, create=false
11138341JavaFX Application ThreadERRORorg.openlca.app.wizards.io.DbImportWizarddatabase import failed

Please help me!!



in openLCA by (170 points)
retagged by
by (140 points)
Hello, yes, it could be nice to know the solution for this problem, because I'm having the same problem. Regards, Nuno Lapa

1 Answer

0 votes
by (23.5k points)
Best answer

Apologies for the inconvenience! This seems to be a problem with the new openLCA version which we will fix as soon as possible! In the meantime,

1) Download the methods as usual and import them into openLCA via right-click restore; open the database which contains only the methods and export the database as JSON-LD file; import the exported methods into an existing database

2) Use openLCA 1.7.2 https://sourceforge.net/projects/openlca/files/openlca_framework/

Of course we will provide a fixed openLCA 1.7.3 version as soon as possible!

by (23.5k points)