03-01-2016 6:04 PM - edited 02-04-2024 3:18 AM
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
Did you resolve this issue I am getting same error now ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.