SQL Inbound Adapter - Not returning all the records it should from a View in Micrsoft SQL Server
I am currently working on a issue with WRC on one of my Inbound SQL Adapters not returning all the records it should be. If I looked at the count of the records in Ensemble and compare it to that of a Microsoft SQL View, Ensemble seems to be off by a few records here and there. I am using a full dynamic select statement in my settings of the adapter.
SELECT Text, PhysicianLastName, PhysicianFirstName, PhysicianAddress1, PhysicianAddress2, PhysicianCity,
PhysicianState, PhysicianZip, PhysNum, InsertDate, FaxK, EnsIndex, MRN, AccountNum, FirstName, LastName
FROM vUHEpicMailEns
Order By FaxK
I have added some trace elements but the missing records are not getting even to the point of trace.
Has anyone run into this issue?
I am thinking of changing the Dynamic SQL to call a Stored Procedure instead that way eliminating some of the overhead and possible contention. This way its just reading Microsoft SQL Memory to Ensemble Memory. How would one go about and execute a Stored Procedure in OnProcessInput() of the SQL Inbound Adapter class?