search

rtmill / Data-Quality-Analysis

The PEDSnet Data Quality Assessment Toolkit (OMOP CDM)
BSD 2-Clause "Simplified" License
1 stars 0 forks source link

sql syntax error from level2 condition_occurrence #9

Open rtmill opened 5 years ago

rtmill commented 5 years ago 
INFO [2018-11-20 21:00:46] Failed to generate CONDITION_OCCURRENCE report, see dqa.log for more details. : Error: <SQL> 'SELECT *
FROM (SELECT "date_field", "time_field", "time_day", "time_month", "time_year", "date_day", "date_month", extract(year from "date_field") AS "date_year"
FROM (SELECT "date_field", "time_field", "time_day", "time_month", "time_year", "date_day", extract(month from "date_field") AS "date_month"
FROM (SELECT "date_field", "time_field", "time_day", "time_month", "time_year", extract(day from "date_field") AS "date_day"
FROM (SELECT "date_field", "time_field", "time_day", "time_month", extract(year from "time_field") AS "time_year"
FROM (SELECT "date_field", "time_field", "time_day", extract(month from "time_field") AS "time_month"
FROM (SELECT "date_field", "time_field", extract(day from "time_field") AS "time_day"
FROM (SELECT "condition_start_date" AS "date_field", "condition_start_datetime" AS "time_field"
FROM (SELECT "condition_start_date", "condition_start_datetime"
FROM dbo."condition_occurrence") "eitsfcywjx") "mikrvvvcqh") "sgcuzrcppo") "phnidtcpnu") "ujchwvabsu") "cppfagwozy") "opfjuuotzq") "uembbeyleh"
WHERE (("time_day" != "date_day") AND ("time_month" != "date_month") AND ("time_year" != "date_year"))'
  nanodbc/nanodbc.cpp:1587: 42000: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'from'.
callahanc5 commented 5 years ago

This is specific to SQL Server.