Jahia Dev Forum > DataException after...

0 (0 Good)
0 (0 Bad)

DataException after upgrade to jahia 7.0.0.0 and jahia 7.1.0.0

by  bharatkasodariya »  2015/08/08 10:45

Migrated from Jahia 6.6 to 7.0.0.0 and then 7.0.0.0 to 7.1.0.0.

Error thrown during jahia start after migration. It was also in 7.0.0.0

2015-08-08 16:03:34,807: ERROR [SqlExceptionHelper] - Bad value for type long : <jnt = 'http://www.jahia.org/jahia/nt/1.0'>
<jmix = 'http://www.jahia.org/jahia/mix/1.0'>
2015-08-08 16:03:34,811: ERROR [NodeTypeRegistry] - org.hibernate.exception.DataException: could not execute query
javax.jcr.RepositoryException: org.hibernate.exception.DataException: could not execute query
        at org.jahia.services.content.nodetypes.NodeTypesDBServiceImpl.readCndFile(NodeTypesDBServiceImpl.java:166)
        at org.jahia.services.content.nodetypes.NodeTypeRegistry$ProviderNodeTypeRegistryHolder.<clinit>(NodeTypeRegistry.java:148)
        at org.jahia.services.content.nodetypes.NodeTypeRegistry.deployDefinitionsFileToProviderNodeTypeRegistry(NodeTypeRegistry.java:178)
        at org.jahia.services.content.JCRStoreProvider.deployDefinitions(JCRStoreProvider.java:686)
        at org.jahia.services.content.JCRStoreProvider.deployDefinitions(JCRStoreProvider.java:666)
        at org.jahia.services.content.JCRStoreService.deployDefinitions(JCRStoreService.java:277)
        at org.jahia.modules.external.modules.ModulesDataSource.registerCndFiles(ModulesDataSource.java:375)
        at org.jahia.modules.external.modules.ModulesDataSource.start(ModulesDataSource.java:348)
        at org.jahia.modules.external.ExternalContentStoreProvider.start(ExternalContentStoreProvider.java:168)
        at org.jahia.modules.external.modules.osgi.ModulesSourceSpringInitializer.mountSourcesProvider(ModulesSourceSpringInitializer.java:160)
        at org.jahia.modules.external.modules.osgi.ModulesSourceSpringInitializer.mountBundle(ModulesSourceSpringInitializer.java:191)
        at org.jahia.modules.external.modules.osgi.ModulesSourceActivator$1.bundleChanged(ModulesSourceActivator.java:109)
        at org.apache.felix.framework.util.EventDispatcher.invokeBundleListenerCallback(EventDispatcher.java:913)
        at org.apache.felix.framework.util.EventDispatcher.fireEventImmediately(EventDispatcher.java:834)
        at org.apache.felix.framework.util.EventDispatcher.fireBundleEvent(EventDispatcher.java:516)
        at org.apache.felix.framework.Felix.fireBundleEvent(Felix.java:4531)
        at org.apache.felix.framework.Felix.startBundle(Felix.java:2169)
        at org.apache.felix.framework.Felix.setActiveStartLevel(Felix.java:1368)
        at org.apache.felix.framework.FrameworkStartLevelImpl.run(FrameworkStartLevelImpl.java:308)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.DataException: could not execute query
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
        at org.hibernate.loader.Loader.doList(Loader.java:2529)
        at org.hibernate.loader.Loader.doList(Loader.java:2512)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2342)
        at org.hibernate.loader.Loader.list(Loader.java:2337)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
        at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
        at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
        at org.hibernate.internal.StatelessSessionImpl.list(StatelessSessionImpl.java:579)
        at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
        at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:909)
        at org.jahia.services.content.nodetypes.NodeTypesDBServiceImpl.readCndFile(NodeTypesDBServiceImpl.java:157)
        ... 19 more
Caused by: org.postgresql.util.PSQLException: Bad value for type long : <jnt = 'http://www.jahia.org/jahia/nt/1.0'>
<jmix = 'http://www.jahia.org/jahia/mix/1.0'>
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2999)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2171)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getClob(AbstractJdbc2ResultSet.java:443)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getClob(AbstractJdbc2ResultSet.java:431)
        at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$1.doExtract(ClobTypeDescriptor.java:60)
        at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
        at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:261)
        at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257)
        at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:247)
        at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:332)
        at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2926)
        at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1673)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1605)
        at org.hibernate.loader.Loader.getRow(Loader.java:1505)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:713)
        at org.hibernate.loader.Loader.processResultSet(Loader.java:943)
        at org.hibernate.loader.Loader.doQuery(Loader.java:911)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)
        at org.hibernate.loader.Loader.doList(Loader.java:2526)
        ... 29 more

  (bharatkasodariya)

Number of messages  57
Registration date
0 (0 Good)
0 (0 Bad)

Re: DataException after upgrade to jahia 7.0.0.0 and jahia 7.1.0.0

by  bharatkasodariya »  2015/09/15 13:07

?

  (bharatkasodariya)

Number of messages  57
Registration date
0 (0 Good)
0 (0 Bad)

Re: Re: DataException after upgrade to jahia 7.0.0.0 and jahia 7.1.0.0

by  shyrkov »  2015/09/21 12:45

Hello Bharat,

on which step of migration do you get this error?

Have you been able to successfully migrate from 6.6 to 7.0.0.0 and start (without errors) the migrated Digital Factory instance? Were the errors only happenning after later migration to 7.1.0.0?

Which fix applier ("package" or "webapp") have you used to migrate from 6.6 to 7.0 and later to 7.1?

Could you, please, double check that the DB connections settings, usually in <digital-factory-web-app-dir>/META-INF/context.xml (on an installation with an Apache Tomcat), are correct?

 

Kind regards

Sergiy

Sergiy Shyrkov (shyrkov)

Number of messages  407
Registration date
Contact
Share
Feedback

Get in touch

Whether you are a current user or if you are just evaluating Jahia, we are here to help.

Contact us

Share this page