cancel
Showing results for 
Search instead for 
Did you mean: 

Datahub 5.7 error when sending a WPDBBY IDOC

former_member1031459
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Did you resolve this issue I am getting same error now ?