Unable to run Database Designer

[prsekhar13]

hi
I am new to Vertica database Administration, I am unable to run database designer for all schemas in my database , Can any one tell how to run DBD for all schemas.
We have 12 schemas in my database. Up to 7 schemas I am able to run DBD but rest of the schemas are in disable state in admin tools so i am unable to select the schema to run dbd.
we are using vertica6.1 version
please give me the solutions.


Thanks,
Rajashekar .P

[JimKnicely]

What do you mean by unavailable? Can you not select them with an "X" in admintools on the "Select schema(s) for design" screen?

[prsekhar13]

Yes. schema wise i am running DBD so When i try to select 8th schema in an order its not populating with "X" .

[prsekhar13]

Please give me the reply for this ...

[scutter]

Since noone in this forum seems to have encountered this issue, you’re probably better off asking in the Vertica Community (https://community.vertica.com/vertica) or open a Technical Support ticket.

—Sharon

[JimKnicely]

Yeah, I have to agree with Sharon. I can not duplicate the behavior you describe.

Is there a failed DBD session on the schema? Maybe that can cause an issue???

[prsekhar13]

I have checked there is no failed DBD session exist and i have cleared the DBD work space too.
Even i checked on my local vertica Environment by creating 8 schemas but getting same issue.
Any how I will raise support ticket. Thanks for your replies.


Thanks,
Raj.P