+2 votes
1.6k views

Hello,

I want to create processes in using the ecoinvent 3.4 apos unit database. Unfortunately, this is not possible since this error appears as I click on 'Finish' when trying to create the process:

javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException 
    Internal Exception: java.sql.SQLSyntaxErrorException: 'PRECEDING_DATASET' is not a column in table or VTI 'APP.TBL_PROCESS_DOCS'. 
    Error Code: 20000 

continues to......

    Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException 
    Internal Exception: java.sql.SQLSyntaxErrorException: 'PRECEDING_DATASET' is not a column in table or VTI 'APP.TBL_PROCESS_DOCS'. 
    Error Code: 20000 

The log file is extremely long and A LOT of error but the errors are mainly the following :

121431JavaFX Application ThreadERRORorg.openlca.core.database.ProcessDaoError while inserting Process
JavaFX Application ThreadERRORorg.openlca.app.wizards.ProcessWizard
244981ModalContextERRORorg.openlca.core.database.references.SearchError executing native query 'SELECT DISTINCT f_owner, f_source FROM tbl_source_links WHERE f_owner IN (430224,659601,725162,528555,725165,463008 and a thousand more numbers!!!! )

Can anyone help me with this problem? The database is provided by my university since I am doing a study (a full LCA on a house) in a class. I do not have a very broad knowledge with software errors. I hope my problem makes sense.

Thank you in advance.

BR, Buket

in openLCA by (140 points)
edited by
by (23.6k points)
edited by
... works perfectly fine on my computer with ecoinvent apos UP. What operating system are you using? Maybe you can share your database with us.
by (13.5k points)
edited by
It seems like the database update failed. Did you get an error in the database update? When you open the update manager (Database > Update manager) and click on `Executed updates` is the `Update to database schema v8` checked? You can also try to run the update again (after a backup of your database): open the Python editor (Window > Developer tools > Python), paste this script into the editor: https://raw.githubusercontent.com/GreenDelta/olca-updates/master/update-src/005_db_schema_update_v8_59_5b/script.py and run it.
by (140 points)
I have looked into the 'Executed updates' and the v8 update does not have a green check point. So I think you are right in terms of the update fail. How can I fix this?
I tried to load the script as you said, but unfortunately it did not work. I got an error message saying 'failed to evaluate script' .. :/
by (13.5k points)
Could you post the full error message (also from the log-file/logging console)? Maybe this is the reason why the update failed.
by (140 points)
file:///C:/Users/buket%C3%B6zpolat/openLCA-data-1.4/log.html
by (140 points)
I do not know how to post the log-file.. Could you maybe try to explain?
by (23.6k points)
You can upload it somewhere e.g. on WeTransfer or https://send.firefox.com. Another alternative is https://pastebin.com/
by (140 points)
Hello again.
What Can I do to make sure the update manager updates my database?

1 Answer

0 votes
by (113k points)
Hi, it seems the update did not work. Do you know from which openLCA version the database file is? The update to openLCA 1.7 changed quite a lot and takes some time.If you have not worked with the database before I would recommend you start the update again with a new copy of the database file (or, get a version for openLCA 1.8/1.9). Would this work for you?
...