Fix for Overflow of Data Type

By - Jun 01, 2017

Symptom

Deployment fails at Process step.  The message indicates there is an overflow of the data type, see below.

Internal error: The operation terminated unsuccessfully.

Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 0.

Errors in the OLAP storage engine: An error occurred while the ‘MemberId’ attribute of the ‘Scenario_Scenario‘ dimension from the ‘{database name}’ database was being processed.

Errors in the back-end database access module. The read operation was cancelled due to an earlier error.

Server: The current operation was cancelled because another operation in the transaction failed.

Resolution

This issue happens when MemberId in dimension table exceeds its column data type restriction.  A common scenario that causes this issue is that we have Add Members function on the dashboard, and users keep adding more and more members to the dimension and it finally exceeds the limit.

Each dmension has a defined size.  The dimension size decides the data type of MemberId column.  Here is the valid MemberId range for each dimension size in Kepion.

To fix this issue, identify which dimension has the data overflow issue from the error message, and then follow this article to modify the dimension size.


Facebooktwitterlinkedinmail