_ErrorLogFactLoad
The _ErrorLogFactLoad table logs fact load errors of operations on cubes. This table is useful for debugging.
This table describes _ErrorLogFactLoad:
| Column | Type | Description |
|---|---|---|
| JobId | BigInteger | The ID of a job which has an error. |
| ErrorCode | Integer | OLAP error code. |
| ErrorDimIdx | Integer | Index of the dimension whose element-coordinate is causing this error. NULL if not relevant or available. |
| ElementNN | String(256) | Element in the NNth coordinate position. As many elements as there are dimensions in the cube. The rest are NULL. |
| ElementCaptionNN | String(256) | Caption of element in the NNth coordinate position. As many as there are elements. NULL if not available. |
| FactType | Integer |
Enumerator.
NULL for ClearCubeRegion. |
| ValueNumeric | Real | Numeric value attempted to write to cell. Might be NULL. |
| ValueString | Text | String value attempted to write to cell. Might be NULL. |
| Comment | Text | User defined comment. |
General information
ElementNN and ElementCaptionNN are 0-based coordinate positions of dimensions within the cube. The elements begin with Element00 and end with a possible Element29. The base of 0 reflects how the dimensions are indexed within the cube. There are a maximum of 30 allowable dimensions.
FactType on this table is not quite the same as on FactType on the _FactLoadParameter table, which also has a third option for Numeric No Sum. Here, no distinction is made between this and 1 (Numeric).