none
ERR210003 Error - The AttributeValue references a member that does not exist or is inactive.

    Pregunta

  • Hi,

    Has anyone come across the error "ERR210003 Error - The AttributeValue references a member that does not exist or is inactive." where the AttributeValue is populated with the namespace of the MemberIdentifier?

    The AttributeValue is a reference to a Domain-based attribute, that if it doesn't exist we handle by creating an Orphan member in the reference entity that will later be updated when the actual data flows in to MDS.

    Regards,

    Scott.

    martes, 01 de noviembre de 2011 1:24

Respuestas

  • hi Scott

    here are some populating examples:

    http://sqlblog.com/blogs/mds_team/archive/2010/02/10/staging-examples.aspx

    Updating attribute values 
    You can use the Attributes staging table (tblStgMemberAttribute) to update attribute values. For more information about the fields in this table, see Attributes Staging Table.

    The following example shows how you could update an attribute for a leaf member, a consolidated member, and a collection.

     

    INSERT INTO mdm.tblStgMemberAttribute (ModelName, EntityName, MemberType_ID, MemberCode, AttributeName, AttributeValue) VALUES

    (N'Product', N'Product', 1, N'BK-M101', N'DaysToManufacture',N'4'), 
    (N'Product', N'Product', 2, N'MW', N'Owner', N'Gisli Olafsson'), 
    (N'Product', N'Product', 3, N'JR', N'Description', N'John Yokim''s Products')

    but this example doesn't show for a domain based attribute update,so :

    ________________

    when you update a domain based attribute entityname should be the name of the child entity

    membertype_id, by default is "leaf".

    membercode will be the code of your domain based (parent) attribute member.

    attributename will be the name of the domain based attribute field that you want to update.

     attribute value will be the domain based attribute field value that you want to update.

    Regards,



    Xavier Averbouch
    Microsoft Community Contributor
    Avanade , FRANCE
    If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful".
    miércoles, 02 de noviembre de 2011 12:43

Todas las respuestas

  • hi Scott

    here are some populating examples:

    http://sqlblog.com/blogs/mds_team/archive/2010/02/10/staging-examples.aspx

    Updating attribute values 
    You can use the Attributes staging table (tblStgMemberAttribute) to update attribute values. For more information about the fields in this table, see Attributes Staging Table.

    The following example shows how you could update an attribute for a leaf member, a consolidated member, and a collection.

     

    INSERT INTO mdm.tblStgMemberAttribute (ModelName, EntityName, MemberType_ID, MemberCode, AttributeName, AttributeValue) VALUES

    (N'Product', N'Product', 1, N'BK-M101', N'DaysToManufacture',N'4'), 
    (N'Product', N'Product', 2, N'MW', N'Owner', N'Gisli Olafsson'), 
    (N'Product', N'Product', 3, N'JR', N'Description', N'John Yokim''s Products')

    but this example doesn't show for a domain based attribute update,so :

    ________________

    when you update a domain based attribute entityname should be the name of the child entity

    membertype_id, by default is "leaf".

    membercode will be the code of your domain based (parent) attribute member.

    attributename will be the name of the domain based attribute field that you want to update.

     attribute value will be the domain based attribute field value that you want to update.

    Regards,



    Xavier Averbouch
    Microsoft Community Contributor
    Avanade , FRANCE
    If a post answers your question, please click "Mark As Answer" on that post and "Vote as Helpful".
    miércoles, 02 de noviembre de 2011 12:43
  • Thanks Xavier.

    miércoles, 07 de marzo de 2012 8:04