Staging Process Errors (Master Data Services)

When the staging process is complete, all processed records in the staging tables have a value in the ErrorCode column. These values are listed in the following table.

Code	Error	Occurs When/Details	Applies to Table
210001	The same member code exists multiple times in the staging table.	Your staging batch includes the same member code multiple times. Neither member is created or updated.	Leaf Consolidated Relationship
210003	The attribute values references a member that does not exist or is inactive.	When you stage domain-based attributes, you must use the code, rather than the name. Applies to ImportType 0, 1, and 2.	Leaf Consolidated
210006	The member code is inactive.	ImportType = 1 and you specified a member code that doesn’t exist.	Leaf Consolidated Relationship
210032	The hierarchy name is missing or is not valid.	The explicit hierarchy was not found or the HierarchyName value was blank.	Consolidated Relationship
210035	Because a code generation business rule does not exist, the MemberCode is required.	When creating or updating members, a MemberCode is always required, unless you are using automatic code generation. For more information, see Automatic Code Creation (Master Data Services).	Leaf Consolidated
210036	Because a code generation business rule exists, the MemberCode is not required.	When creating or updating members, a MemberCode is not required when you are using automatic code generation. However, you can specify a code if you choose. For more information, see Automatic Code Creation (Master Data Services).	Leaf Consolidated
210041	“ROOT” is not a valid member code.	The MemberCode value contains the word “ROOT.”	Leaf Consolidated Relationship
210042	“MDMUNUSED” is not a valid member code.	The MemberCode value contains the word “MDMUNUSED.”	Leaf Consolidated Relationship
210052	The MemberCode cannot be deactivated because it is used as a domain-based attribute value.	When ImportType = 3 or 4, staging fails if the member is used as an attribute value for other members. Either use ImportType 5 or 6 to set the value to NULL, or change the values before running the staging process.	Leaf Consolidated
300002	The member code is not valid.	Relationships: Either the parent or child member code does not exist. Leaf or Consolidated: ImportType = 3 or 4 and the member code does not exist.	Leaf Consolidated Relationship
300003	The member code already exists.	ImportType = 1 and you used a member code that already exists in the entity.	Leaf Consolidated
210011	When RelationshipType is 1, the ParentCode cannot be a leaf member.	Ensure that the ParentCode value is a consolidated member code.	Relationship
210015	The member code exists multiple times in the staging table for a hierarchy and a batch.	For an explicit hierarchy, you specified the location of the same member multiple times in the same batch.	Relationship
210016	The relationship could not be created because it would cause a circular reference.	This occurs when you try to assign a child as a parent.	Relationship
210046	The member cannot be a sibling of Root.	This occurs when RelationshipType = 2 (sibling) and either the ParentCode or ChildCode is Root. Members cannot be at the same level as the Root node; they can only be children.	Relationship
210047	The member cannot be a sibling of Unused.	This occurs when RelationshipType = 2 (sibling) and either the ParentCode or ChildCode is Unused. Members can only be children of the Unused node.	Relationship
210048	ParentCode and ChildCode cannot be the same.	The ParentCode value is the same as the ChildCode value. These values must be different.	Relationship
210043	The TargetType_ID must be 1 (parent) or 2 (sibling).	The TargetType_ID is neither 1 nor 2.	Relationship
210058	The import type is not valid.	The import type is not valid.	Leaf Consolidated

See Also

Tasks

View Errors that Occur During the Staging Process (Master Data Services)

Concepts

Importing Data (Master Data Services)