KB47742: “Cube instance cannot be loaded into memory due to error -2147213425” error occurs when loading cube from secondary node

• Strategy

In MicroStrategy 9.x or newer running in Linux with centralized caching which is a CIFS share, below error may occur when loading cubes from secondary node: "Cube instance XXX cannot be loaded into memory due to error -2147213425.".

SYMPTOM:
In Strategy 9.x or newer running in Linux with centralized caching which is a CIFS share, below error may occur when loading cubes from secondary node.


 Cube instance GUID cannot be loaded into memory due to error -2147213425.
Cube command failed with error -2147072540.

Below entries can be found in DSSErrors.log and there is no error in cube trace:


2013-11-26 16:44:28.589-06:00 Exception occurred while reading data from the stream: Cannot read data: data is not in array.
2013-11-26 16:44:28.590-06:00 Exception occurred while reading data from the stream: Not enough data for reading
2013-11-26 16:44:28.590-06:00 Exception occurred while reading data from the stream: Not enough data for reading
2013-11-26 16:44:28.699-06:00 Cube instance XXX cannot be loaded into memory due to error -2147213425.
2013-11-26 16:44:28.700-06:00 Intelligent Cube (XXX) for locale English (United States) is not published. The Intelligent Cube must be published before this report can be executed. You can publish the cube by Right Mouse Clicking on the cube and selecting republish.

CAUSE:
One possible cause is that there is an issue with the mount the Intelligence Server is attempting to read the cube file from.

ACTION:
Contact Linux administrator to resolve this issue.

One option is to correct this problem with mount option forcedirectio. Refer to below online source for details on this:
http://www.cyberciti.biz/tips/disable-caching-on-the-cifs-nfs-client.html

Third Party Software Installation WARNING
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.

Comment

0 comments

Details

Knowledge Article

Published:

March 30, 2017

Last Updated:

March 30, 2017

2013-11-26 16:44:28.589-06:00 Exception occurred while reading data from the stream: Cannot read data: data is not in array. 2013-11-26 16:44:28.590-06:00 Exception occurred while reading data from the stream: Not enough data for reading 2013-11-26 16:44:28.590-06:00 Exception occurred while reading data from the stream: Not enough data for reading 2013-11-26 16:44:28.699-06:00 Cube instance XXX cannot be loaded into memory due to error -2147213425. 2013-11-26 16:44:28.700-06:00 Intelligent Cube (XXX) for locale English (United States) is not published. The Intelligent Cube must be published before this report can be executed. You can publish the cube by Right Mouse Clicking on the cube and selecting republish.