Skip to Content
0
Mar 01, 2016 at 06:04 PM

Datahub 5.7 error when sending a WPDBBY IDOC

82 Views

Hi,

We are using Datahub 5.7.0.2-RC1 and when sending an IDOC information of a specific SAP bonusbuy (WPDBBY) we are getting the following error after the composition process and before the publication process.

 2016-03-01 09:49:23,788 [DEBUG] [c.h.d.s.i.AbstractTransactionManagingActionHandler] Handling Event PerformPublicationEvent{actionId=4, systemUrl='http://localh
 ost:7080/datahub-webapp/v1', targetPublicationIds=[22]}
 2016-03-01 09:49:23,796 [ERROR] [c.h.d.s.i.AbstractTransactionManagingActionHandler] Previous event failure PerformPublicationEvent{actionId=4, systemUrl='http:
 //localhost:7080/datahub-webapp/v1', targetPublicationIds=[22]}
 javax.persistence.PersistenceException: Error attempting to apply AttributeConverter
         at org.hibernate.type.descriptor.converter.AttributeConverterSqlTypeDescriptorAdapter$2.doConversion(AttributeConverterSqlTypeDescriptorAdapter.java:137
 ) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.type.descriptor.converter.AttributeConverterSqlTypeDescriptorAdapter$2.doExtract(AttributeConverterSqlTypeDescriptorAdapter.java:115) ~
 [hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:267) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:338) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1695) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1627) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.getRow(Loader.java:1514) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:725) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.processResultSet(Loader.java:952) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.doQuery(Loader.java:920) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.doList(Loader.java:2553) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.doList(Loader.java:2539) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2369) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.Loader.list(Loader.java:2364) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:496) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:231) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) ~[hibernate-core-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final]
         at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449) ~[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final]
         at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:190) ~[querydsl-jpa-3.5.1.jar:na]
         at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:238) ~[querydsl-jpa-3.5.1.jar:na]
         at com.hybris.datahub.repository.jpa.impl.DefaultTargetItemJpaRepository.findTargetItemsByPublication(DefaultTargetItemJpaRepository.java:195) ~[datahub
 -service-5.7.0.2-RC1.jar:5.7.0.2-RC1]
         at com.hybris.datahub.repository.jpa.impl.DefaultTargetItemJpaRepository.findTargetItemsByPublication(DefaultTargetItemJpaRepository.java:173) ~[datahub
 -service-5.7.0.2-RC1.jar:5.7.0.2-RC1]
         at com.hybris.datahub.service.impl.DefaultPublicationActionService.findTargetItemsByPublication(DefaultPublicationActionService.java:339) ~[datahub-serv
 ice-5.7.0.2-RC1.jar:5.7.0.2-RC1]
         at sun.reflect.GeneratedMethodAccessor365.invoke(Unknown Source) ~[na:na]
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_45]
         at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) ~[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) ~[spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
         at com.sun.proxy.$Proxy123.findTargetItemsByPublication(Unknown Source) ~[na:na]
         at com.hybris.datahub.service.impl.PublicationActionHandler.lambda$null$104(PublicationActionHandler.java:146) [datahub-service-5.7.0.2-RC1.jar:5.7.0.2-
 RC1]
         at com.hybris.datahub.service.impl.PublicationActionHandler$$Lambda$146/1012669006.accept(Unknown Source) ~[na:na]
         at java.util.Iterator.forEachRemaining(Iterator.java:116) ~[na:1.8.0_45]
         at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) ~[na:1.8.0_45]
         at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580) ~[na:1.8.0_45]
         at com.hybris.datahub.service.impl.PublicationActionHandler.lambda$deleteEmptySubPublications$105(PublicationActionHandler.java:145) [datahub-service-5.
 7.0.2-RC1.jar:5.7.0.2-RC1]

Not all WPDBBY failed. We are using the following connectivity settings:

dataSource.className=com.microsoft.sqlserver.jdbc.SQLServerDataSource dataSource.jdbcUrl=jdbc:sqlserver://localhost;responseBuffering=adaptive;loginTimeout=10;databaseName=xxxx

media.dataSource.className=com.microsoft.sqlserver.jdbc.SQLServerDataSource media.dataSource.jdbcUrl=jdbc:sqlserver://localhost;responseBuffering=adaptive;loginTimeout=10;databaseName=xxxx

We have used the kernel.autoInitMode=create-drop property to recreate the database tables. We have even drop and recreate the full database and still getting this issue.

The database is MSSQLServer 2014 and the JDBC driver used is sqljdbc-4.0.2206.100.jar

Could not find a way to upload the IDOC here.

We appreciate any help you can provide to us.

Thanks