EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB47332: "(Internal Error: DSSDocumentExecuteTask::Run(): Error calling DocumentInstance::Execute() , job 31627, Error Code=-2147212797.)" error message appears when executing report in MicroStrategy Web or Developer 9.4.1.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


The document describes a current defect in MicroStrategy 9.4.1 that can occur when a user attempts to run a report or dashboard based on a cube. The User will receive the error described when trying to execute a report or document in either MicroStrategy Web or Developer. This defect has been addressed in 9.4.1 Hotfix 4.

SUMMARY:
The document describes a current defect in Strategy 9.4.1 that can occur when a user attempts to run a report or dashboard based on a cube. The User will receive the error described when trying to execute a report or document in either Strategy Web or Developer. This defect has been addressed in 9.4.1 Hotfix 4.
 
SYMPTOM:
This issue can be seen when executing a document or report from Strategy Web or Developer. End users will receive the above mentioned error on all nodes except one and will not be able to fully execute the report or document. This issue can be seen after either a cube publication or object manager migration.
 
STEPS TO REPRODUCE:
Step 1: Create a view report on a cube that exists in both environments.
 

ka02R000000kWN3QAM_0EM440000002CKF.png

 
Step 2: Create an object manager package containing just a view report in Strategy Object Manager from a lower environment.
 

ka02R000000kWN3QAM_0EM440000002CKL.png

 
Step 3: Import the package into a multi-node cluster a non-primary node using Command Manager.
 

ka02R000000kWN3QAM_0EM440000002CKN.png

 
Step 4: Update schema on the node that the package was imported.
 

ka02R000000kWN3QAM_0EM440000002CKO.png

 
Step 5: Attempt to execute a report or document based on the cube on another node.
 
Step 6: End users will receive the error shown below:
 

ka02R000000kWN3QAM_0EM440000002CKH.png


Your request could not be processed. Please try again. If the problem persists, contact the Administrator. (Internal Error: DSSDocumentExecuteTask::Run(): Error calling DocumentInstance::Execute() , job 31627, Error Code=-2147212797)

 
CAUSE:
This issue is caused by a mismatch between cube index files on the primary node and secondary nodes and has been classified as a defect in Strategy 9.4.1
 
ACTION:
This issue has been addressed in 9.4.1 Hotfix 4, please update to this hotfix version to receive this fix.
 
WORKAROUND:
This issue has two workarounds if Administrators are not able to install 9.4.1 Hotfix 4.
 
The first workaround is as follows:
Step 1; Determine the cube that the report or document is based on.
Step 2: Unload and reload the above mentioned cube on each node.
 

ka02R000000kWN3QAM_0EM440000002CKK.png

 
The second workaround is as follows:
 
Step 1: Determine the cube that the report or document is based on.
Step 2: Create a view report on above mentioned cube in affected nodes.
 

ka02R000000kWN3QAM_0EM440000002CKP.png

 
Step 3: Execute report on each node.
 

ka02R000000kWN3QAM_0EM440000002CKM.png

 
VIDEO:
Here is a video guide of the workarounds above:
 
To Learn More:
To learn more regarding Object Manager and Command Manager, please see the System Administration Guide in the product manuals.
For additional information regarding Object Manager and Command Manager, please review the technotes in the 'Related links' section below.


Comment

0 comments

Details

Knowledge Article

Published:

April 5, 2017

Last Updated:

July 17, 2017