Database designer ERROR: Could not validate schema search path:

Hari_rao

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?

mosheg

1. Did you select in admintools your schema name? or in a multi-schema database did you select all schemas for your design?
   See: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/GettingStartedGuide/UsingDatabaseDeisgner/RunningDBDwithAT.htm
2. What is the default serach_path for the user you run the database designer from?
   For example, try this in vsql:
   \c - dbadmin
   SHOW SEARCH_PATH;
3. If needed do: ALTER USER userXYZ SEARCH_PATH schema01,schema02, public;

Hari_rao

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.

SruthiA

@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

Hari_rao

Ok. I will discuss about upgradation to 9.3.1-2 with my Db Admin. Thanks @SruthiA and @mosheg