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

KB43352: "SQL Generation CompleteError in Process method of Component: QueryEngineServer, Project ' ', Job 478, Error Code =-2147467259" error message appears when executing reports in MicroStrategy Developer and Web 10.x.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article describes an issue where an error can happen when trying to run reports in a clustered environment.

SYMPTOM:
A user receives the error "SQL Generation CompleteError in Process method of Component: QueryEngineServer, Project ' ', Job 478, Error Code =-2147467259" when running a report in Strategy Web and Desktop v9.3.0 with a clustered Intelligence Server configuration.

ka02R000000kca3QAA_0EM440000002CqG.png

SQL Generation CompleteError in Process method of Component: QueryEngineServer, Project ' ', Job 478, Error Code =-2147467259
In DSSErrors.log, this is the only message seen. The user is also able to update Schema as well as view SQL in results.
 
CAUSE:
One possible cause is that an attribute definition stored in the Intelligence Server memory contains inconsistency.
 
ACTION:
This issue can be resolved by unload and re-load affected projects.


Comment

0 comments

Details

Knowledge Article

Published:

April 11, 2017

Last Updated:

April 11, 2017