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

  • DataException after upgrade to jahia 7.0.0.0 and jahia 7.1.0.0
    2015/08/08 10:45

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

  • Number of messages  57
    Registration date Aug 8, 2015
    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

    ?

  • Re: DataException after upgrade to jahia 7.0.0.0 and jahia 7.1.0.0
    2015/09/15 13:07

    bharatkasodariya <p>?</p>

  • Number of messages  57
    Registration date Sep 15, 2015
    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