Nightly Cubes Job failing on step 4 - Purchasing AP Cubes - An error occurred while the Description attribute of the Contract Item dimension

Owned by Knowledge Assistant
Mar 09, 2022
1 min read



Description of Issue

The nightly refresh of Munis cubes is failing on step 4, which is the Purchasing AP Cubes

Build AP Cubes:Error: Errors in the OLAP storage engine: An error occurred while the 'Description' attribute of the 'Contract Item' dimension from the 'munprod_Purchasing AP Cubes' database was being processed



Context

  • Munis

  • V2017.1+

  • Cubes



Cause

Cubes has a limit of 1023 characters in a column, and the Contract Items Description field is MAX (millions of characters). Should client have data exceeding 1023 it will fail.



Resolution

Install MUN-342347 from the MIU when available.

There is currently no workaround for this issue.



Additional Information