Work Order Cube failing on step 5 due to duplicate attribute key error on assets with the same asset code and asset type short description

Owned by Knowledge Assistant
Sept 12, 2023
1 min read



Description of Issue

Work Order Cube failing on step 5 due to duplicate attribute key error on assets with the same asset code and asset type short description

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_WMAssetDim', Column: 'AssetNumber', Value: ''; Table: 'dbo_WMAssetDim', Column: 'AdminDeptCode', Value: 'xxxx'; Table: 'dbo_WMAssetDim', Column: 'AssetType', Value: xxxx; Table: 'dbo_WMAssetDim', Column: 'AssetCategory', Value: xxxx; Table: 'dbo_WMAssetDim', Column: 'AssetCode', Value: xxxx. The attribute is 'Asset Description'.



Context

  • Enterprise Asset Management 

  • EAM 



Cause

Defect 



Resolution

Install MUN-469377 once it's been released

Workaround: There is currently no workaround for this issue. If you need additional assistance or to create a support case to track the issue, please contact Enterprise ERP Assets and Civic Support



Additional Information