Error "SVR_ERR_RELATIONSHIP_MEMBER_NOT_FOUND" When Importing Dimension in LCM (Doc ID 1355546.1)

Last updated on AUGUST 02, 2016

Applies to:

Hyperion Financial Management - Version 11.1.1.3.00 and later
Information in this document applies to any platform.

Symptoms

When importing the Dimension in LCM, it shows the error
"SVR_ERR_RELATIONSHIP_MEMBER_NOT_FOUND:Relationship Member <Member_Name> does not exist at parent <Member_Name>."

Error in Job Console for the Import operation:

Type: Error
Action: Update Relationship Property
Member: <Member_Name>

All 'Hierarchy' property updates for member '<Memeber Name>' were rolled back due to a validation error; please correct the properties in error indicated in the validation message and re-import the 'Hierarchy' section for this member property updates. ValidationMessage: 'Relationship Member <Relationship_Member_Name> does not exist at parent <Relationship_Member_Name>.'




Errors in EPMA Log
================
2011-08-15 09:10:38,133 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.hyperion.awb.web.common.BaseServiceException - Dimension 'Entity' has 4 import error(s), Refer job Id 1608 for further details.
2011-08-15 09:10:38,133 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.hyperion.awb.web.lcm.ArtifactManager - Error code is AWB_WEB_ERR_LCM_IMPORT_ARTIFACTS_PATHNAME
2011-08-15 09:10:38,211 [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR com.hyperion.awb.web.lcm.ArtifactManager - doImportArtifacts: Error importing 'Entity' at path '/Dimensions (Shared)'
com.hyperion.awb.web.common.BaseServiceException: Dimension 'Entity' has 4 import error(s), Refer job Id 1608 for further details.
at com.hyperion.awb.web.lcm.collection.AbstractAppDimensionsArtifactCollection.verifyImportResults(AbstractAppDimensionsArtifactCollection.java:130)
at com.hyperion.awb.web.lcm.collection.AbstractAppDimensionsArtifactCollection.importSharedDimensions



Errors in Dimension Server Log
========================
2011-08-15 09:10:35,992 [13] Hyperion.CommonServices.Exceptions.BaseException.LogException(:0) - SVR_ERR_RELATIONSHIP_MEMBER_NOT_FOUND:Relationship Member <Relationship_Member_Name> does not exist at parent <Relationship_Member_Name>
Hyperion.DimensionServer.Interface.Exceptions.AutomatorException: Relationship Member 59768 does not exist at parent 57123.
at Hyperion.DimensionServer.Automators.ActionItem.FindRelationshipMember(Int32 libraryID, Int32 dimensionID, Int32 parentID, Int32 memberID)
at Hyperion.DimensionServer.Automators.ActionItem.FindRelationshipMember(String libraryName, String applicationName, String dimensionName, String parentName, String memberName)
at Hyperion.DimensionServer.Automators.RelationshipMemberActionItem.get_RelationshipMember()
at Hyperion.DimensionServer.Automators.SetMemberSortOrder.Execute()
at Hyperion.DimensionServer.ImportEngine.SortChildren(Dimension existingDim, String parent, List`1 hierSectionItemList)
at Hyperion.DimensionServer.ImportEngine.CheckSortOrder(ImportDimension dim)
at Hyperion.DimensionServer.ImportEngine.<CheckSortOrder>b__8(ImportDimension dim)
at Hyperion.DimensionServer.ImportProfile.IterateDimensions(Action`1 action)
at Hyperion.DimensionServer.ImportEngine.ParseAndExecuteImport()
at Hyperion.DimensionServer.ImportEngine.StartImport()



When looking at the <Relationship_Member_Name> in the application or in the Shared Library, it does not show up. However the <Member_Name> is present in the Shared library and application as well.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms