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?
Tagged:
0
Answers
See: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/GettingStartedGuide/UsingDatabaseDeisgner/RunningDBDwithAT.htm
For example, try this in vsql:
\c - dbadmin
SHOW SEARCH_PATH;
Yes, in admintools, I selected only the schema which my query uses .
And for the database user , I have added the schema to the SEARCH_PATH too. SHOW SEARCH PATH shows me the schema list which I'am working with in the query.
@Hari_rao It is a known issue and has been fixed in 9.3.1-2. Please find the release notes for the same
https://www.vertica.com/docs/ReleaseNotes/9.3.x/Vertica_9.3.x_Release_Notes.htm#9.3.1-2
Ok. I will discuss about upgradation to 9.3.1-2 with my Db Admin. Thanks @SruthiA and @mosheg