go to post Scott Roth · Jan 10, 2020 Everything I have read from Microsoft says this error has to do with a linked server. However where I am trying to select from is a view and has no linked server involved.
go to post Scott Roth · Jan 6, 2020 I am struggling with understanding how to display the table within the CSP page. In reading the document it mentions ZEN, but as we have been told not to use ZEN because ZEN is going away. So how can I display the SQL table in a table format that could be updated instead of the form document mentioned above? Most of the examples are only 1 or 2 rows. I am looking at a 25 rows x 6 columns table to display and update. I got the above to work, just trying to make it more friendly. Thanks Scott
go to post Scott Roth · Nov 21, 2019 Here is an interesting outcome from playing around. Before I could not open the osuwmc.TestClin in either studio or the Management portal after an upgrade/compile to 2019.1.1. So I was wondering if I should just look at the file. So I exported it from studio, looked at it on my local desktop, then imported it locally from my desktop. I was able to compile it through studio without issues, and Management Portal was able to see the production as well. Weird.....
go to post Scott Roth · Nov 21, 2019 I have tried UpgradeAll() also without any luck. Is it possible to just Show and Set qualifiers on just one production to tell me whats wrong with it? I can't open the production class in studio either.
go to post Scott Roth · Nov 15, 2019 Have you used JDBC drivers before? I have a couple of connections that I have created through JDBC to connect to Oracle to pull data from an Oracle table to create an HL7 message. Currently we are using the Oracle JDBC driver to connect to the Oracle system.
go to post Scott Roth · Oct 30, 2019 I figured it out on my own. It did not like <assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp(k1).OBX:ObservationValue(1).AlternateText}",tRemainder)' property='tSC' action='set' /> I had to change it to <assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp("_k1_").OBX:5.5",.tRemainder)' property='tSC' action='set' />
go to post Scott Roth · Oct 15, 2019 So far we have ended up with like 4 routing rules just for ADT alone to get it do the Ancillary systems.
go to post Scott Roth · Oct 14, 2019 When we were going through our conversion from egate to Ensemble, it was suggested not to have anymore that 25 rules within a Business Router. Anymore than that caused us severe performance issues when it came to making sure our downstream systems was receiving the messages in time. Scott Roth
go to post Scott Roth · Oct 8, 2019 I am not aware that a CSV could be read in via EnsLib.File.PassthroughService. From what I was taught a CSV would have to be mapped to a RecordMap then you can parse out the CSV using EnsLib.RecordMap.Service.FileService. https://docs.intersystems.com/healthconnect20191/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_recmap Scott
go to post Scott Roth · Oct 3, 2019 From what I read is the basic purge does not take care of the orphaned messages. That's why there is this manual step we have to configure.
go to post Scott Roth · Sep 19, 2019 Not sure if this will answer your question or not, but we had to move to the jTDS JDBC driver in order to pass an AD account through a connection. jdbc:jtds:sqlserver://(server name/port) ;instance=tp;domain=osumc;useNTLMv2=true;cacheMetaData=true;prepareSQL=2;
go to post Scott Roth · Sep 9, 2019 When I feed a lab result through with OBX:3.1 valued, it is not being identified in this WHEN statement. Any other suggestions?
go to post Scott Roth · Sep 5, 2019 I should of explained this a bit better.We have 3 servers, 2 (A,B) Locally, 1 (C) offsite.Currently we are running on Server B. If I do a backup of Server B on 2015.2.2, can I restore it on Server C after it has been upgraded to 2019.1. I was wondering if the Full System Backups were compatible across versions of Health Share/Health Connect, since 2019.1 everything changed from ccontrol to iris.I thought I would give this a shot before bugging WRC, but I'll go ahead and ask them.ThanksScott
go to post Scott Roth · Aug 29, 2019 https://www.amazon.com/Cach%C3%A9-ObjectScript-MUMPS-Technical-Learning/dp/1466499087/ref=sr_1_fkmr0_1?keywords=Cache%60+object+script+and+mumps&qid=1567084211&s=gateway&sr=8-1-fkmr0
go to post Scott Roth · Apr 16, 2019 so how would the code block look like for the following... How do I return the EnsLib.SQL.Snapshot?ThanksScott
