临时过程错误 (Master Data Services)Staging Process Errors (Master Data Services)

适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - 仅限 Windows 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance适用于:Applies to: 是SQL ServerSQL Server(所有支持的版本)yesSQL ServerSQL Server (all supported versions) - Windows only 是Azure SQL 托管实例Azure SQL Managed InstanceYesAzure SQL 托管实例Azure SQL Managed Instance

当临时过程完成后,临时表中的所有已处理记录在 ErrorCode 列中都对应一个值。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
210001210001 临时表中多次出现同一成员代码。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
210003210003 属性值引用不存在或非活动的成员。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. 适用于 ImportType012Applies to ImportType0, 1, and 2. Leaf

合并Consolidated
210006210006 该成员代码处于非活动状态。The member code is inactive. ImportType = 1 您指定了一个不存在的成员代码。ImportType = 1 and you specified a member code that doesn't exist. Leaf

合并Consolidated

关系Relationship
210032210032 该层次结构名称缺失或无效。The hierarchy name is missing or is not valid. 找不到显式层次结构或 HierarchyName 值为空白。The explicit hierarchy was not found or the HierarchyName value was blank. 合并Consolidated

关系Relationship
210035210035 因为不存在代码生成业务规则,所以 MemberCode 是必需的。Because a code generation business rule does not exist, the MemberCode is required. 创建或更新成员时,始终需要 MemberCode ,除非您使用的是自动代码生成。When creating or updating members, a MemberCode is always required, unless you are using automatic code generation. 有关详细信息,请参阅 )(Master Data Services 自动创建代码 For more information, see Automatic Code Creation (Master Data Services). Leaf

合并Consolidated
210036210036 因为存在代码生成业务规则,所以 MemberCode 不是必需的。Because a code generation business rule exists, the MemberCode is not required. 创建或更新成员时,如果您使用的是自动代码生成,则不需要 MemberCodeWhen 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. 有关详细信息,请参阅 )(Master Data Services 自动创建代码 For more information, see Automatic Code Creation (Master Data Services). Leaf

合并Consolidated
210041210041 “ROOT”不是有效的成员代码。"ROOT" is not a valid member code. MemberCode 值包含单词 "ROOT"。The MemberCode value contains the word "ROOT." Leaf

合并Consolidated

关系Relationship
210042210042 “MDMUNUSED”不是有效的成员代码。"MDMUNUSED" is not a valid member code. MemberCode 值包含单词 "MDMUNUSED"。The MemberCode value contains the word "MDMUNUSED." Leaf

合并Consolidated

关系Relationship
210052210052 由于将 MemberCode 用作基于域的属性值,所以无法停用该代码。The MemberCode cannot be deactivated because it is used as a domain-based attribute value. ImportType = 34 时,如果将成员用作其他成员的属性值,则过渡会失败。When ImportType = 3 or 4, staging fails if the member is used as an attribute value for other members. 使用 ImportType56 将值设置为 NULL,或者在运行暂存过程之前更改值。Either use ImportType5 or 6 to set the value to NULL, or change the values before running the staging process. Leaf

合并Consolidated
300002300002 该成员代码无效。The member code is not valid. 关系:不存在任何父或子成员代码。Relationships: Either the parent or child member code does not exist.

叶或合并: ImportType = 34 并且成员代码不存在。Leaf or Consolidated: ImportType = 3 or 4 and the member code does not exist.
Leaf

合并Consolidated

关系Relationship
300004300004 该成员代码已存在。The member code already exists. ImportType = 1 ,你使用了实体中已存在的成员代码。ImportType = 1 and you used a member code that already exists in the entity. Leaf

合并Consolidated
210011210011 RelationshipType1 时, ParentCode 不能为叶成员。When RelationshipType is 1, the ParentCode cannot be a leaf member. 确保 ParentCode 值是合并成员代码。Ensure that the ParentCode value is a consolidated member code. 关系Relationship
210015210015 对于层次结构和批次,该成员代码在临时表中多次出现。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
210016210016 未能创建该关系,因为它将引起循环引用。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
210046210046 该成员不能为“根”节点的同级。The member cannot be a sibling of Root. RelationshipType = 2 (同级) 并且 ParentCodeChildCodeRoot 时,会发生这种情况。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
210047210047 该成员不能为“未使用”节点的同级。The member cannot be a sibling of Unused. RelationshipType = 2 (同级) 并且 未使用 ParentCodeChildCode 时,就会发生这种情况。This occurs when RelationshipType = 2 (sibling) and either the ParentCode or ChildCode is Unused. 成员只能“未使用”节点的子级。Members can only be children of the Unused node. 关系Relationship
210048210048 ParentCodeChildCode 不能相同。ParentCode and ChildCode cannot be the same. ParentCode 值与 ChildCode 值相同。The ParentCode value is the same as the ChildCode value. 这些值必须不同。These values must be different. 关系Relationship

另请参阅See Also

查看在暂存 (Master Data Services 中发生的错误) View Errors that Occur During Staging (Master Data Services)
概述:导入表中数据 (Master Data Services)Overview: Importing Data from Tables (Master Data Services)