Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Database designer ERROR: Could not validate schema search path:

I'm trying to run Database Designer using the Design Type incremental for a particular query. The query runs in vsql without error but since its too slow, I tried using the database designer on the same query. But when I proceed with it, I get an error:

Designer did not run successfully
Unknown error while running Database Designer.
Err: ERROR: Could not validate schema search path: my schema name
Design process may still be executing in the background.
Press to return to the Administration Tools menu.

I checked Search_path and it has my schema listed but I still get this error. What could I be missing here?

Tagged:

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.