User lacks privilege or Object not found

[Former Member]

Hey Experts!

I have executed the upgrade from 6.4 to 6.7 in our local system. To check whether our application runs fine we took the data folder from 6.4 and put it in the 6.7 codebase. On doing this exercise we get the following error on server startup :

Any idea on this how can we move forward with out validations ?

 enter code hereCaused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SEALED in statement [UPDATE medias SET hjmpTS = ? ,modifiedTS=?,p_datapk=?,p_location=?,p_locationhash=?,p_size=? WHERE PK = ? AND (sealed IS NULL OR sealed=0)]
         at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at de.hybris.platform.jdbcwrapper.ConnectionImpl.prepareStatement(ConnectionImpl.java:630) ~[coreserver.jar:?]
         at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.storeChanges(GenericBMPBean.java:1557) ~[coreserver.jar:?]
         at de.hybris.platform.persistence.GenericBMPBean.ejbStore(GenericBMPBean.java:313) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.executeEntityStore(Transaction.java:1606) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.executeEJBModifications(Transaction.java:1562) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.flushDelayedStore(Transaction.java:1518) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.commit(Transaction.java:665) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.finishExecute(Transaction.java:1215) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1202) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1157) ~[coreserver.jar:?]
         at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2107) ~[coreserver.jar:?]
         at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2082) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.storeAttributes(ItemModelConverter.java:1739) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.save(ItemModelConverter.java:836) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.wrapper.ModelWrapper.save(ModelWrapper.java:363) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.saveOthers(ResolvingModelPersister.java:68) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.persist(ResolvingModelPersister.java:53) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveViaJalo(DefaultModelService.java:1185) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.doJaloPersistence(DefaultModelService.java:744) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.persistWrappers(DefaultModelService.java:1129) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.performPersistenceOperations(DefaultModelService.java:721) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAllInternal(DefaultModelService.java:715) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAll(DefaultModelService.java:695) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.save(DefaultModelService.java:643) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.media.impl.DefaultMediaService$3.execute(DefaultMediaService.java:592) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1192) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1157) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.media.impl.DefaultMediaService.setStreamForMedia(DefaultMediaService.java:572) ~[coreserver.jar:?]
         ... 26 more
 Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SEALED
         at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.error.Error.error(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.ParserDML.XreadAndResolveBooleanValueExpression(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.ParserDML.compileUpdateStatement(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.ParserCommand.compilePart(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.ParserCommand.compileStatement(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.Session.compileStatement(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.StatementManager.compile(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.Session.execute(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source) ~[hsqldb-2.3.4.jar:2.3.4]
         at de.hybris.platform.jdbcwrapper.ConnectionImpl.prepareStatement(ConnectionImpl.java:630) ~[coreserver.jar:?]
         at de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState.storeChanges(GenericBMPBean.java:1557) ~[coreserver.jar:?]
         at de.hybris.platform.persistence.GenericBMPBean.ejbStore(GenericBMPBean.java:313) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.executeEntityStore(Transaction.java:1606) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.executeEJBModifications(Transaction.java:1562) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.flushDelayedStore(Transaction.java:1518) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.commit(Transaction.java:665) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.finishExecute(Transaction.java:1215) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1202) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1157) ~[coreserver.jar:?]
         at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2107) ~[coreserver.jar:?]
         at de.hybris.platform.jalo.Item.setAllAttributes(Item.java:2082) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.storeAttributes(ItemModelConverter.java:1739) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter.save(ItemModelConverter.java:836) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.wrapper.ModelWrapper.save(ModelWrapper.java:363) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.saveOthers(ResolvingModelPersister.java:68) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister.persist(ResolvingModelPersister.java:53) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveViaJalo(DefaultModelService.java:1185) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.doJaloPersistence(DefaultModelService.java:744) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.persistWrappers(DefaultModelService.java:1129) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.performPersistenceOperations(DefaultModelService.java:721) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAllInternal(DefaultModelService.java:715) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.saveAll(DefaultModelService.java:695) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService.save(DefaultModelService.java:643) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.media.impl.DefaultMediaService$3.execute(DefaultMediaService.java:592) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1192) ~[coreserver.jar:?]
         at de.hybris.platform.tx.Transaction.execute(Transaction.java:1157) ~[coreserver.jar:?]
         at de.hybris.platform.servicelayer.media.impl.DefaultMediaService.setStreamForMedia(DefaultMediaService.java:572) ~[coreserver.jar:?]
         ... 26 more

[mpern]

Have you run the update running system on the 6.4 database?

The attribute (column) SEALED was introduced with 6.6 for all(!) item types.