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

KB273106: "No available tables were found in the warehouse catalog." appears when trying to open Warehouse Catalog with DSN pointing to a CSV file saved in a network drive with MicroStrategy 9.4.1


Stefan Zepeda

Salesforce Solutions Architect • Strategy


No available tables were found in the warehouse catalog." appears when trying to open Warehouse Catalog with DSN pointing to a CSV file saved in a network drive with MicroStrategy 9.4.1

SYMPTOM:
In Strategy 9.4.1 windows 7 or 2008 R2 Server environment, when an Excel CSV/Text file is placed on a network drive, the file cannot be accessed by Warehouse Catalog to be used as a data source. 
 
STEPS TO REPRODUCE:

  • Place an Excel CSV file in a mapped network drive
ka02R000000kcbmQAA_0EM440000002C3d.jpeg
  • Create a DBI with connection type "Generic DBMS" that points to this file on the D drive
  • Open Strategy 9.4.1 Tutorial project and open Warehouse Catalog and change to the DBI created in the above step
  • No tables are available error is observed
ka02R000000kcbmQAA_0EM440000002C3c.jpeg

CAUSE:
This is a known issue in Strategy Developer 9.4.1.
 
ACTION:
This issue is addressed in Strategy Developer 9.5.1 and later releases. Upgrade to that version to take advantage of this fix.


Comment

0 comments

Details

Knowledge Article

Published:

April 11, 2017

Last Updated:

April 11, 2017