Article - CS258014

SyncDB process failed with error "Circular hierarchy references detected" in Servigistics

Modified: 09-Dec-2025   


Applies To

  • Servigistics Service Parts Management 10.7 to 14.0.2.0

Description

  • Synchronize Database (SyncDB) process failed with error: java.lang.reflect.InvocationTargetException
  • Autopilot.log contains error like:
    • ERROR com.svg.core.util.EventLog - Task Synchronize Database failed with message: java.lang.reflect.InvocationTargetException
      java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
              at com.svg.core.process.syncdb.SyncConnector.postSyncDB(SyncConnector.java:442)
              at com.svg.core.process.syncdb.SyncConnector.process(SyncConnector.java:31)
              at com.svg.core.process.ThreadableConnector.process(ThreadableConnector.java:20)
              at com.svg.core.process.BatchConnectorImpl.doRun(BatchConnectorImpl.java:89)
              at com.svg.core.process.BatchConnectorImpl.access$000(BatchConnectorImpl.java:26)
              at com.svg.core.process.BatchConnectorImpl$1.doInTransaction(BatchConnectorImpl.java:77)
              at com.svg.core.database.TransactionUtil.execute(TransactionUtil.java:51)
              at com.svg.core.process.BatchConnectorImpl.run(BatchConnectorImpl.java:74)
              at com.svg.core.task.BatchTask.runConnector(BatchTask.java:84)
              at com.svg.core.task.AbstractTask.run(AbstractTask.java:216)
              at com.svg.core.task.BatchTask.run(BatchTask.java:70)
              at sun.reflect.GeneratedMethodAccessor424.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
              at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
              at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
              at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
              at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
              at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
              at com.sun.proxy.$Proxy750.run(Unknown Source)
              at com.svg.core.service.impl.TaskServiceImpl$1.run(TaskServiceImpl.java:434)
              at java.lang.Thread.run(Thread.java:745)
              at com.svg.core.util.ThreadUtil$1.run(ThreadUtil.java:43)
      Caused by: java.lang.reflect.InvocationTargetException
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at com.svg.core.process.syncdb.SyncConnector.postSyncDB(SyncConnector.java:440)
              ... 29 more
      Caused by: com.svg.planning.process.meo.replenishmentnetwork.HierarchyValidationException: Transforming the LocID, ReplSourceLocID relationships into a hierarchy for PartID: ##### caused exception: Circular hierarchy references detected. Loc Gid ##### appears as a descendent and an ancestor in the same branch of hierarchy, #####
              at com.svg.planning.process.meo.replenishmentnetwork.LocationHierarchyGenerator.findUpToDateHierarchyStructures(LocationHierarchyGenerator.java:44)
              at com.svg.planning.process.meo.replenishmentnetwork.LocNodeGenerator.buildHierDataStructures(LocNodeGenerator.java:132)
              at com.svg.planning.process.meo.replenishmentnetwork.LocNodeGenerator.run(LocNodeGenerator.java:343)
              ... 34 more
 
This is a printer-friendly version of Article 258014 and may be out of date. For the latest version click CS258014