SYMPTOM
The following error occurred in executing a report against Denodo database
Error: SQL Generation Complete
QueryEngine encountered error: Fetch failed.
Error type: Invalid operation. Attempted to fetch an empty result..
Error in Process method of Component: QueryEngineServer, Project XXXXX, Job 97, Error Code= -2147212544.
The following error occurs in pass 0: Fetch failed.
Error type: Invalid operation. Attempted to fetch an empty result.
CAUSE
SQL generated the column name and table name with single quote whereas no single quote generated from Denodo database like below example:
select a11.`prch_qtr_id_yq` `QTR_ID`,
a11.`frd_us_tran_amt_exc_csh_sqpy` `WJXBFS8`
from `iv_XXXXXX_dmstc` a11
For the details references, please check the following knowledge base articles:
KB47069: Column pattern for columns with lowercase letters is different than column pattern setting for a database instance using the "Denodo 5.0" connector in MicroStrategy Developer 9.4.x and 10.x
KB320442: New in MicroStrategy Secure Enterprise 10.x - SQL support for case sensitive database objects
ACTION
Please modify from '#0' to #0 on below two VLDB properties , Uppercase In Columnname Pattern and Advanced Table Pattern in VLDB.xml file.
<Setting>
<Name>Uppercase In Columnname Pattern</Name>
<MaxValues>1</MaxValues>
<GroupID>5</GroupID>
<Type>0</Type>
<DataSourceType>9</DataSourceType>
<ReportType>3</ReportType>
<DisplayName>Uppercase In Columnname Pattern</DisplayName>
<DisplayLevel>2</DisplayLevel>
<ShowSQLPreview>0</ShowSQLPreview>
<SQLPreview1/>
</Setting>
<Setting>
<Name>Advanced Table Pattern</Name>
<MaxValues>1</MaxValues>
<GroupID>5</GroupID>
<Type>0</Type>
<DataSourceType>25</DataSourceType>
<DisplayName>Advanced Table Pattern</DisplayName>
<DisplayLevel>2</DisplayLevel>
<ShowSQLPreview>0</ShowSQLPreview>
<SQLPreview1/>
</Setting>
