Therefore, close the database and delete the _olca_/updates folder in your database (the database location is /openLCA-data-1.4/databases/) then, re-open the database. If the update manager does not open and you still get this error, you can try to force openLCA to re-execute the updates. When you open the database the update manager should open and you should be able to update the database. With the restore function ( Navigation > right click > restore database) you can import the zolca file. It seems that something went wrong with the database update. However, there are maybe still issues with database updates, e.g. Also, the problem with the old openLCA LCIA method pack seems to be fixed. DatabaseException: failed to execute query: select id,ref_id,name,description,version,last_change,f_category from tbl_dq_systemsĪt .DatabaseException.logAndThrow(DatabaseException.java:16)Īt .lectAll(BaseDao.java:319)Ĭaused by: 圎rrorException: Table/View 'TBL_DQ_SYSTEMS' does not exist.Ĭlosing this issue because this was for openLCA 1.6 and we are now on openLCA 1.7. 圎rrorException: Table/View 'TBL_DQ_SYSTEMS' does not exist.Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .jdbc.EmbedPreparedStatement.(Unknown Source)Īt .jdbc.EmbedPreparedStatement20.(Unknown Source)Īt .jdbc.EmbedPreparedStatement30.(Unknown Source)Īt .jdbc.EmbedPreparedStatement40.(Unknown Source)Īt .jdbc.EmbedPreparedStatement42.(Unknown Source)Īt .Driver42.newEmbedPreparedStatement(Unknown Source)Īt .(Unknown Source)Īt .prepareStatement(ConnectionHandle.java:1024)Īt .BaseDao.execute(BaseDao.java:344)Īt .lectAll(BaseDao.java:315)Īt .RootEntityDao.getDescriptors(RootEntityDao.java:68)Īt .(DQSystemImport.java:29)Īt .(DatabaseImport.java:78)Īt .(DatabaseImport.java:34)Īt .io.DbImportWizard$n(Unknown Source)Īt .ModalContext$n(ModalContext.java:122)Ĭaused by: : Table/View 'TBL_DQ_SYSTEMS' does not exist.Īt .(Unknown Source)Īt .(Unknown Source)Ĭaused by: ERROR 42X05: Table/View 'TBL_DQ_SYSTEMS' does not exist.Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)Īt .(Unknown Source)ĮRROR - failed to import data quality systemsįailed to execute query: select id,ref_id,name,description,version,last_change,f_category from tbl_dq_systems Table/View 'TBL_DQ_SYSTEMS' does not exist.
ERROR - failed to execute query: select id,ref_id,name,description,version,last_change,f_category from tbl_dq_systems
0 kommentar(er)
