临时过程错误 (Master Data Services)Staging Process Errors (Master Data Services)
适用于:Applies to: SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions) - 仅限 Windows
Azure SQL 托管实例Azure SQL Managed Instance
Azure SQL 托管实例Azure SQL Managed Instance适用于:Applies to:
SQL ServerSQL Server(所有支持的版本)
SQL ServerSQL Server (all supported versions) - Windows only
Azure SQL 托管实例Azure SQL Managed Instance
Azure 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. 适用于 ImportType0、 1 和 2。Applies 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. | 创建或更新成员时,如果您使用的是自动代码生成,则不需要 MemberCode 。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. 有关详细信息,请参阅 )(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 = 3 或 4 时,如果将成员用作其他成员的属性值,则过渡会失败。When ImportType = 3 or 4, staging fails if the member is used as an attribute value for other members. 使用 ImportType5 或 6 将值设置为 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 = 3 或 4 并且成员代码不存在。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 | RelationshipType 为 1 时, 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 (同级) 并且 ParentCode 或 ChildCode 为 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 |
210047210047 | 该成员不能为“未使用”节点的同级。The member cannot be a sibling of Unused. | 当 RelationshipType = 2 (同级) 并且 未使用 ParentCode 或 ChildCode 时,就会发生这种情况。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 | ParentCode 和 ChildCode 不能相同。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)