KB46225: "The warehouse catalog SQL contains a template string "#?Schema_Name?#" that must be completed before catalog updates can be run." error message appears when reading the Warehouse Catalog in MicroStrategy Developer 9.4.1 against MySQL Warehouse

Salesforce Solutions Architect • Strategy

This technical note documents an issue that occurs when reading the Warehouse Catalog against MySQL warehouse database

SYMPTOM:
"The warehouse catalog SQL contains a template string '?Schema_Name?#' that must be completed before catalog updates can be run." error message appears when reading the Warehouse Catalog in Strategy Developer 9.4.x - 10.x against MySQL Warehouse as shown below:


An error was detected while trying to read the warehouse catalog:
The warehouse catalog SQL contains a template string '#?Schema_Name?#' that must be completed before catalog updates can be run.
Do you want to modify the Warehouse Catalog Browser options to try solve this problem?
Please re-run the Warehouse Catalog Browser after you make your changes.

Attempting a manual read of the Warehouse Catalog results in the following error:


Unexpected Error.
The warehouse catalog SQL contains a template string '#?Schema_Name?#' that must be completed before catalog updates can be run.

CAUSE:
The issue is caused by the placeholder '#?Schema_NAME?#' found in one or both of the custom SQL statements for the 'Catalog - Read Settings' as the sample statement below:


SELECT DISTINCT TABLE_SCHEMA NAME_SPACE, 
TABLE_NAME TAB_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = '#?Schema_Name?#'

ACTION:
Manually replace the placeholder '#?Schema_Name?#' with the actual schema name containing the warehouse tables as the sample script below:


SELECT DISTINCT TABLE_SCHEMA NAME_SPACE,
TABLE_NAME TAB_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA ='TJI4JAN23U27'

Comment

0 comments

Details

Knowledge Article

Published:

May 26, 2017

Last Updated:

August 16, 2017

An error was detected while trying to read the warehouse catalog: The warehouse catalog SQL contains a template string '#?Schema_Name?#' that must be completed before catalog updates can be run. Do you want to modify the Warehouse Catalog Browser options to try solve this problem? Please re-run the Warehouse Catalog Browser after you make your changes.