KB47867: "No available tables were found in the warehouse catalog" error message appears when selecting "Select tables from the Warehouse Catalog" option after creating a new project in Project Creation Assistant 9.4.1.

• Strategy

SYMPTOM:
User encounters an issue shown below when creating a new project using Project Creation Assistant 9.4.1. The error is encountered when a user selects "Select tables from the Warehouse Catalog" option when the warehouse is Teradata version 13.10.


No available tables were found in the warehouse catalog. This can happen due to three possible causes:
a) All tables are already part of the project.
b) An incorrect custom SQL statement is being used, or
c) The warehouse connection is not defined correctly.

CAUSE:
This is a known issue with Project Creation Assistant 9.4.1.
ACTION:
Contact Strategy Technical Support for an update on this issue.
WORKAROUND:
When creating a new project, once the project is created select "OK" to save and exit out of Project Creation Assistant. Then, go into the Warehouse Catalog and add the appropriate tables so the facts and attributes can be created after.

Comment

0 comments

Details

Knowledge Article

Published:

April 12, 2017

Last Updated:

April 12, 2017