Error appears when trying to create a process in openlca 1.8

Question

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 :

121431

JavaFX Application Thread

ERROR

org.openlca.core.database.ProcessDao

Error while inserting Process

JavaFX Application Thread

ERROR

org.openlca.app.wizards.ProcessWizard

244981

ModalContext

ERROR

org.openlca.core.database.references.Search

Error 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

Comments

Hello again.
What Can I do to make sure the update manager updates my database?

Answer 1

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?