EPMA – удаление проблемных элементов




[AsyncAPIMethodThread] ERROR SVR_ERR_DAL_UPDATE_FAILED_DOESNT_EXIST:Attempted to update a row RelationshipRecord that does not exist: 1028,33,1,15489,5,FalseHyperion.DataAccessLayerCore.RowDoesNotExistException: Attempted to update a row RelationshipRecord that does not exist: 1028,33,1,15489,5,False
at Hyperion.DataAccessLayerCore.GenericDAO.Update[T](T instance)
at Hyperion.DimensionServer.DAO.DimensionMemberDAO.UpdateRelationship(RelationshipRecord relationship)
at Hyperion.DimensionServer.DimensionMember.ResortMemberList(List`1 originalSortList, Int32 StartIndex)
at Hyperion.DimensionServer.Dimension.RemoveMember(RelationshipMember member)
at Hyperion.DimensionServer.Automators.RemoveMember.Execute()
at Hyperion.DimensionServer.Proxies.MembersProxy.<>c__DisplayClass1c.<DeleteMembersEx>b__18(Object obj)
at Hyperion.DimensionServer.Proxies.AsyncHelper.ThreadExecute()

 

Данные действия имеет смысл проводить только при наличии текущей резервной копии репозитория EPMA



delete from DS_PROPERTY_MEMBER where I_MEMBER_ID in (select distinct I_MEMBER_ID
from DS_MEMBER where c_member_name in ( 'AB1210030')) ;

delete from DS_PROPERTY_MEMBER_ARRAY where I_MEMBER_ID in (select distinct I_MEMBER_ID
from DS_MEMBER where c_member_name in ( 'AB1210030') );

delete from DS_PROPERTY_RELATIONSHIP where I_CHILD_MEMBER_ID in ( select distinct I_MEMBER_ID
from DS_MEMBER where c_member_name in ( 'AB1210030') );

delete from DS_PROPERTY_RELATIONSHIP where I_PARENT_MEMBER_ID in (select distinct I_MEMBER_ID
from DS_MEMBER where c_member_name in ( 'AB1210030') );

delete from DS_RELATIONSHIP where I_CHILD_MEMBER_ID in (select distinct I_MEMBER_ID
from DS_MEMBER where c_member_name in ( 'AB1210030') );

delete from DS_RELATIONSHIP where I_PARENT_MEMBER_ID in (select distinct I_MEMBER_ID
from DS_MEMBER where c_member_name in ( 'AB1210030') );

delete from DS_MEMBER where c_member_name in ( 'AB1210030');