How to capture all warning and detail errors on DESIGNER_ADD_DESIGN_QUERIES_FROM_RESULTS

Jim_Krieger

I am running V7.0 Database Designer Programmatically - i.e. http://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/ProgrammersGuide/DBDAPI/AboutRunningDataba...
where I am loading 1,000's of queries ...

when I run SELECT DESIGNER_ADD_DESIGN_QUERIES_FROM_RESULTS ( 'jim091814', 'select q.request as QUERY_TEXT, 1 as QUERY_WEIGHT  from PERFORMANCE_ANALYSIS.query_requests_091814_100_LVL q');

I get 1,000's of error and warning messages i..e.

DETAIL:  Relation "RM_G2_DIAG_PMPM_NORM" does not existWARNING 2454:  Cannot load invalid query: SELECT * FROM (SELECT A.CATEGORY CATEGORY, COUNT(A.CATEGORY) ... long SQL that contains a TABLE not in this schema  
DETAIL:  Relation "RM_G2_DIAG_PMPM_NORM" does not exist
WARNING 3628:  Invalid character in hint at or near "(1" at character 24
WARNING 3628:  Invalid character in hint at or near "(10" at character 24
WARNING 3628:  Invalid character in hint at or near "(100" at character 24
WARNING 4857:  Syntax error in HINT at or near ")" at character 28


I query vs_output_event_history - but this does not have the detail and warnings 

SELECT  stage_type, iteration_number, total_query_count, remaining_query_count, max_step_number, current_step_number, current_step_description, table_id
FROM dw_test_1.v_dbd_jim091814_jim091814.vs_output_event_history

Any suggestions on where I can collect these DETAIL/WARNING ?

Prasanta_Pal

Make sure that the queries are not throwing any errors ( syntax error) before feeding them in Designer.