The Vertica Database Forums

Hi,
I am running database designer programmatically in Vertica Analytic Database v7.0.1-3 , all steps complete successfully but DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY creates empty designer and deployment scripts. Can someone please guide me , if there is something I am missing.

csi_owner=> \i call_dbd.sql
SET
DESIGNER_DROP_DESIGN
----------------------
0
(1 row)

DESIGNER_CREATE_DESIGN
------------------------
0
(1 row)

DESIGNER_ADD_DESIGN_TABLES
----------------------------
11
(1 row)

DESIGNER_SET_DESIGN_KSAFETY
-----------------------------
0
(1 row)

DESIGNER_SET_DESIGN_TYPE
--------------------------
0
(1 row)

DESIGNER_SET_OPTIMIZATION_OBJECTIVE
-------------------------------------
0
(1 row)

DESIGNER_ADD_DESIGN_QUERY
---------------------------
1
(1 row)

DESIGNER_ADD_DESIGN_QUERIES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Number of accepted queries =21
Number of queries referencing non-design tables =0
Number of unsupported queries =0
Number of illegal queries =0

(1 row)

DESIGNER_WAIT_FOR_DESIGN
--------------------------
0
(1 row)

DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY
-----------------------------------------
0
(1 row)

Hi!

[DELETED]

There is no error while adding query. The count 1 means, it has added 1 query. If the query has syntax error , error will be spit out.

Have you followed the Workflow for Running Database Designer Programmatically, checked permissions, and dropped the designer workspace if necessary?

Yes. I followed the same document. On the other note, when I use DESIGNER_DESIGN_PROJECTION_ENCODINGS , it does spit out the output.