Error 3521: Improper Qualified Name (too many dots)

kas

Hello,

I am getting the following error "Error 3521: Improper Qualified Name (too many dots) when running a workflow that has been running just fine for a long time. It is a SQL query using a Vertica ODBC connection in an Input tool. Query is below. The query runs fine in DBeaver currently as well.

(

Select

edw_semantic_vw.sem_agreement_current_vw.agreement_nr,

edw_semantic_vw.sem_agreement_current_vw.pt1_kind_cde,

edw_semantic_vw.sem_agreement_current_vw.paid_to_dt,

edw_semantic_vw.sem_agreement_current_vw.agreement_status_cde,

edw_semantic_vw.sem_agreement_current_vw.agreement_status_reason_cde,

edw_semantic_vw.sem_agreement_current_vw.agreement_status_reason_nm

From

edw_semantic_vw.sem_agreement_current_vw

Where

edw_semantic_vw.sem_agreement_current_vw.agreement_source_cde = 'Vntg1' and edw_semantic_vw.sem_agreement_current_vw.agreement_status_cde not in ('Nb','Nr','Un')

And edw_semantic_vw.sem_agreement_current_vw.agreement_status_dt > (Current_Date - 100))

UNION (

Select

edw_semantic_vw.sem_agreement_current_vw.agreement_nr,

edw_semantic_vw.sem_agreement_current_vw.pt1_kind_cde,

edw_semantic_vw.sem_agreement_current_vw.paid_to_dt,

edw_semantic_vw.sem_agreement_current_vw.agreement_status_cde,

edw_semantic_vw.sem_agreement_current_vw.agreement_status_reason_cde,

edw_semantic_vw.sem_agreement_current_vw.agreement_status_reason_nm

From

edw_semantic_vw.sem_agreement_current_vw

Where

edw_semantic_vw.sem_agreement_current_vw.agreement_source_cde = 'Vntg1' and edw_semantic_vw.sem_agreement_current_vw.agreement_status_cde not in ('Nb','Nr','Un'))

Any thoughts would be greatly appreciated.

Thank you,

Kim

kas

Quotes weren't the answer...ungrouping the first part of the query fixed my issue...nothing else needed changing.

I solved my problem.