Skip to Content
author's profile photo Former Member
0
Former Member
Dec 23, 2016 at 05:44 PM

No reference canonical item found with a type: CanonicalPricingSalesAreaMapping, and conditions

787 Views

Hi all,

I'm trying to setup a Data Hub with Hybris 6.2. I'm using a SAP Retail system and installed the Industry Pack Retail 2.2.

When replicating article master data from SAP to Hybris I get the following exception:

{code} o reference canonical item found with a type: CanonicalPricingSalesAreaMapping, and conditions: [] 2016-12-23 16:56:09,359 [ERROR] [c.h.d.s.s.i.CompilableSpelExpressionProcessor] No reference canonical item found with a type: CanonicalPricingSalesAreaMapping, and conditions: [] 2016-12-23 16:56:09,364 [ERROR] [c.h.d.s.p.i.DefaultCanonicalToTargetItemConverterService] Failed to create a target item from CanonicalItem{id='3', integrationKey=' 0000017751', status=SUCCESS, dataPool='DataHubPoolEntity{id=0, name=GLOBAL}', fields='{scaleQuantity=null, amount=314.10, productId=000000000000002302, endDate=99991 231, unitFactor=1, salesOrganization=CS01, unit=PCE, conditionId=0000017751, productGroup=null, currency=EUR, conditionType=VKP0, distributionChannel=C1, userGroup=n ull, startDate=20160208}'} com.hybris.datahub.service.spel.TransformationExpressionException: Could not transform by expression resolve('CanonicalPricingSalesAreaMapping', 'SAPCONFIGURATION_PO OL').catalogVersion at com.hybris.datahub.service.spel.impl.CompilableSpelExpressionProcessor.transform(CompilableSpelExpressionProcessor.java:94) ~[datahub-service-6.2.0.1-RC1. jar:6.2.0.1-RC1] at com.hybris.datahub.service.publication.impl.DefaultCanonicalToTargetItemConverterService.populateAttributeFromCanonicalItem(DefaultCanonicalToTargetItemCo nverterService.java:94) ~[datahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at com.hybris.datahub.service.publication.impl.DefaultCanonicalToTargetItemConverterService.lambda$populateTargetItem$26(DefaultCanonicalToTargetItemConverte rService.java:82) ~[datahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(Unknown Source) ~[na:1.8.0_60] at java.util.stream.ReferencePipeline$2$1.accept(Unknown Source) ~[na:1.8.0_60] at java.util.HashMap$KeySpliterator.forEachRemaining(Unknown Source) ~[na:1.8.0_60] at java.util.stream.AbstractPipeline.copyInto(Unknown Source) ~[na:1.8.0_60] at java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source) ~[na:1.8.0_60] at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(Unknown Source) ~[na:1.8.0_60] at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(Unknown Source) ~[na:1.8.0_60] at java.util.stream.AbstractPipeline.evaluate(Unknown Source) ~[na:1.8.0_60] at java.util.stream.ReferencePipeline.forEach(Unknown Source) ~[na:1.8.0_60] at com.hybris.datahub.service.publication.impl.DefaultCanonicalToTargetItemConverterService.populateTargetItem(DefaultCanonicalToTargetItemConverterService.j ava:82) ~[datahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at com.hybris.datahub.service.publication.impl.DefaultCanonicalToTargetItemConverterService.convert(DefaultCanonicalToTargetItemConverterService.java:57) ~[d atahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_60] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_60] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_60] at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_60] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.7.RELEASE.jar:4.2.7.RELE ASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) [spring-tx-4.2.7.RELEASE.jar:4. 2.7.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) [spring-tx-4.2.7.RELEASE.j ar:4.2.7.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.7.RELEASE.jar:4.2.7.RELEASE] at com.sun.proxy.$Proxy165.convert(Unknown Source) [na:na] at com.hybris.datahub.akka.actor.TargetItemCreator.createTargetItem(TargetItemCreator.java:58) [datahub-service-akka-6.2.0.1-RC1.jar:6.2.0.1-RC1] at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:26) ~[akka-actor_2.11-2.4.8.jar:na] at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:21) ~[akka-actor_2.11-2.4.8.jar:na] at scala.PartialFunction$class.applyOrElse(PartialFunction.scala:123) ~[scala-library-2.11.5.jar:na] at akka.japi.pf.UnitCaseStatement.applyOrElse(CaseStatements.scala:21) ~[akka-actor_2.11-2.4.8.jar:na] at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:170) ~[scala-library-2.11.5.jar:na] at akka.actor.Actor$class.aroundReceive(Actor.scala:484) ~[akka-actor_2.11-2.4.8.jar:na] at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:47) ~[akka-actor_2.11-2.4.8.jar:na] at akka.actor.ActorCell.receiveMessage(ActorCell.scala:526) ~[akka-actor_2.11-2.4.8.jar:na] at akka.actor.ActorCell.invoke(ActorCell.scala:495) ~[akka-actor_2.11-2.4.8.jar:na] at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:257) ~[akka-actor_2.11-2.4.8.jar:na] at akka.dispatch.Mailbox.run(Mailbox.scala:224) ~[akka-actor_2.11-2.4.8.jar:na] at akka.dispatch.Mailbox.exec(Mailbox.scala:234) ~[akka-actor_2.11-2.4.8.jar:na] at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) ~[scala-library-2.11.5.jar:na] at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) ~[scala-library-2.11.5.jar:na] at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) ~[scala-library-2.11.5.jar:na] at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) ~[scala-library-2.11.5.jar:na] Caused by: com.hybris.datahub.service.spel.MissingReferenceException: No reference canonical item found with a type: CanonicalPricingSalesAreaMapping, and conditions : [] at com.hybris.datahub.service.spel.impl.DefaultItemResolver.resolveReference(DefaultItemResolver.java:83) ~[datahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at com.hybris.datahub.service.spel.impl.DefaultItemResolver.resolve(DefaultItemResolver.java:57) ~[datahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at com.hybris.datahub.service.spel.impl.ResolveMethodExecutor.execute(ResolveMethodExecutor.java:49) ~[datahub-service-6.2.0.1-RC1.jar:6.2.0.1-RC1] at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:129) ~[spring-expression-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.expression.spel.ast.MethodReference.getValueInternal(MethodReference.java:85) ~[spring-expression-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.expression.spel.ast.CompoundExpression.getValueRef(CompoundExpression.java:51) ~[spring-expression-4.2.7.RELEASE.jar:4.2.7.RELEASE] at org.springframework.expression.spel.ast.CompoundExpression.getValueInternal(CompoundExpression.java:87) ~[spring-expression-4.2.7.RELEASE.jar:4.2.7.RELEAS E] {code}

I defined a SAPProductSalesAreaToCatalogMapping and a SAPPricingSalesAreaToCatalog mapping too.

Any idea, how to solve this problem?

Thank you in advance for your help.

Best regards