Error from SSMS due to invalid scale with latest VistA DDL
Final Release Note
Description
This query:
select * from Openquery(ROCTO,'Select distinct p.patient_id,id.code_number,pn.Narrative,p1.date_resolved
from patient p
left outer join problem1 p1 on p.patient_id=p1.patient_name
left outer join icd_diagnosis id on p1.diagnosis=icd_diagnosis_id
left outer join PROVIDER_Narrative PN on p1.provider_narrative=pn.provider_narrative_id
left outer join expressions ex on p1.problem=ex.expressions_id
where patient_id = 1')
fails with this error:
Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "ROCTO" supplied inconsistent metadata for a column. The column "patient_id" (compile-time ordinal 1) of object "Select distinct p.patient_id,id.code_number,pn.Narrative,p1.date_resolved
from patient p
left outer join problem1 p1 on p.patient_id=p1.patient_name
left outer join icd_diagnosis id on p1.diagnosis=icd_diagnosis_id
left outer join PROVIDER_Narrative PN on p1.provider_narrative=pn.provider_narrative_id
left outer join expressions ex on p1.problem=ex.expressions_id
where patient_id = 1" was reported to have a "SCALE" of 6 at compile time and 0 at run time.
According to a customer, this seems to have started with MR YDBOctoVistA!13 (merged) on the VistA DDL Repository. However, it's not clear that that is the real cause of the issue. It needs further investigation.
Draft Release Note
TBD