0 votes
110 views

I have downloaded the database file and the assessment data (both zolka files) from nexus and tried importing in openlca. I could import the data file, but am unable to import the assessment file. It shows some error. The screenshot of the Log file is attached. Kindly do help on this...

in openLCA by (120 points)

1 Answer

0 votes
by (85k points)
Sorry I cannot read the picture. Can you maybe just copy and paste the text it shows? Thank you
by (120 points)
The error msg shows as follows:
org.openlca.core.database.DatabaseException: Error while loading all Category
     at org.openlca.core.database.DatabaseException.logAndThrow(DatabaseException.java:16)
     at org.openlca.core.database.BaseDao.getAll(BaseDao.java:275)
     at org.openlca.core.database.CategoryDao.getRootCategories(CategoryDao.java:58)
     at org.openlca.core.database.upgrades.Upgrade6.exec(Upgrade6.java:68)
     at org.openlca.core.database.upgrades.Upgrades.run(Upgrades.java:39)
     at org.openlca.core.database.upgrades.Upgrades.on(Upgrades.java:30)
     at org.openlca.app.navigation.actions.db.DbActivateAction$ActivationCallback.runUpgrades(DbActivateAction.java:197)
     at org.openlca.app.navigation.actions.db.DbActivateAction$ActivationCallback.lambda$1(DbActivateAction.java:187)
     at org.openlca.app.WrappedJob.run(WrappedJob.java:30)
     at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
    Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: java.sql.SQLSyntaxErrorException: Column 'TAGS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'TAGS' is not a column in the target table.
    Error Code: 30000
    Call: SELECT id, description, last_change, model_type, name, ref_id, tags, version, f_category FROM tbl_categories WHERE (f_category IS NULL)
    Query: ReadAllQuery(referenceClass=Category sql="SELECT id, description, last_change, model_type, name, ref_id, tags, version, f_category FROM tbl_categories WHERE (f_category IS NULL)")
     at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)
     at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)
     at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482)
     at org.openlca.core.database.BaseDao.getAll(BaseDao.java:272)
     ... 8 more
    Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
    Internal Exception: java.sql.SQLSyntaxErrorException: Column 'TAGS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'TAGS' is not a column in the target table.
    Error Code: 30000
    Call: SELECT id, description, last_change, model_type, name, ref_id, tags, version, f_category FROM tbl_categories WHERE (f_category IS NULL)
    Query: ReadAllQuery(referenceClass=Category sql="SELECT id, description, last_change, model_type, name, ref_id, tags, version, f_category FROM tbl_categories WHERE (f_category IS NULL)")
     at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:342)
     at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:691)
     at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
     at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2096)
     at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:603)
     at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
     at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:261)
     at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:332)
     at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:728)
     at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2778)
     at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2731)
     at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:565)
     at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1224)
     at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:914)
     at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1183)
     at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:466)
     at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1271)
     at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2981)
     at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1895)
     at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1877)
     at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1842)
     at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:262)
     ... 10 more
    Caused by: java.sql.SQLSyntaxErrorException: Column 'TAGS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'TAGS' is not a column in the target table.
     at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
     at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source)
     at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
     at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1595)
     at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1544)
     at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:806)
     at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:628)
     ... 30 more
    Caused by: ERROR 42X04: Column 'TAGS' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'TAGS' is not a column in the target table.
     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
     at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
     at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
     at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
     at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown Source)
     at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown Source)
     at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
     at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
     at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
     at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
     at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
     at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
     at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
...