Using DBD programmatically --> no output generated

Moderator: NorbertKrupa

Post Reply
aas1974
Newbie
Newbie
Posts: 6
Joined: Sat Jun 07, 2014 4:43 pm

Using DBD programmatically --> no output generated

Post by aas1974 » Sun Jun 08, 2014 5:23 pm

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)

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Using DBD programmatically --> no output generated

Post by id10t » Mon Jun 09, 2014 11:11 am

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:19 pm, edited 1 time in total.

aas1974
Newbie
Newbie
Posts: 6
Joined: Sat Jun 07, 2014 4:43 pm

Re: Using DBD programmatically --> no output generated

Post by aas1974 » Mon Jun 09, 2014 3:18 pm

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.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Using DBD programmatically --> no output generated

Post by NorbertKrupa » Mon Jun 09, 2014 3:55 pm

Have you followed the Workflow for Running Database Designer Programmatically, checked permissions, and dropped the designer workspace if necessary?
Checkout vertica.tips for more Vertica resources.

aas1974
Newbie
Newbie
Posts: 6
Joined: Sat Jun 07, 2014 4:43 pm

Re: Using DBD programmatically --> no output generated

Post by aas1974 » Mon Jun 09, 2014 8:41 pm

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

Post Reply

Return to “Vertica Database Development”