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

KB36617: "Relation does not exist" error message appears when running a report in MicroStrategy 9.x and 10x against Vertica database


Community Admin

• Strategy


In MicroStrategy 9.x, when running SQL query against a Vertica database warehouse, the following error occurs: QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ERROR: relation "xxx" does not exist; Error in Process method of Component: QueryEngineServer, Project pepe, Job 2170, Error Code= -2147212544.

SYMPTOM:
In Strategy 9.x, when running SQL query against a Vertica database warehouse, the following error occurs:


QueryEngine encountered error: Execute Query failed. Error type: Odbc error. 
Odbc operation attempted: SQLExecDirect. ERROR: relation "xxx" does not exist; 
Error in Process method of Component: QueryEngineServer, Project pepe, Job 2170, Error Code= -2147212544.

CAUSE: 
The stage name in a Vertica database has not yet been added to the warehouse catalog.
ACTION: 
Go to the menu Tools in the warehouse catalog window and choose 'Table prefix' to add the Stage name as prefix to the tables, as shown below:

ka04W000000OhaIQAS_0EM440000002JGa.png
ka04W000000OhaIQAS_0EM440000002JGZ.png

 


Comment

0 comments

Details

Knowledge Article

Published:

May 12, 2017

Last Updated:

May 12, 2017