The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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?



Leave a Comment

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