Question Paul Riker · Aug 14, 2019 Joining two tables from two separate SQL Connections: References to an SQL Connection must constitute a whole subquery SQLCONNECT1 = tableUsersSQLCONNECT2=tableLogEntriesselect * from tableusers u, tablelogentries e where e.userid = u.useridI keep getting the error References to an SQL Connection must constitute a whole subquery #SQL #Caché 0 1 0 542
Question Paul Riker · Jun 6, 2019 "Failed to acquire exclusive lock" on insert I have a custom process that is parsing HL7 and inserting it into a table. Periodically the inserts fail with # due to error: ERROR #5803: Failed to acquire exclusive lock on instance of.... Traditional databases would wait until the lock is removed then do the insert, but cache fails. I'm sure it's my coding approach. How can I work around this? A Try/Catch loop? Thanks in advance. #Databases #ObjectScript #Caché 0 7 0 961
Question Paul Riker · Mar 29, 2019 Ensemble as a Data lake We have been storing raw messages in a MySQL database for DR and ad hoc purposes. We are thinking of using an Ensemble instance as our data lake instead. We could segregate the source data by namespace or by global. But either way we'll want a custom global to index the data for data retrieval performance purposes. Anyone else taking this approach? Any feedback? #Big Data #Databases #Indexing #Ensemble 0 2 0 488
Question Paul Riker · Mar 27, 2019 How can I link directly to a patient's chart in the Clinical Viewer? #HealthShare 1 4 0 590
Question Paul Riker · Oct 19, 2018 CCDA Anonymizer Does anyone have a tool or standard to anonymize CCDAs? #Tools #HealthShare 0 1 0 425
Question Paul Riker · Apr 24, 2018 Custom Purge Job I want to create an interface specific purge job. Please let me know if there are any holes in my approach. I realize that an interface that went from HospitalAService to HospitalARouter to PracticeBOperation would require two separate executes in my example below, but I want that granularity as there are some intermediate steps in our workflows that we don't need to retain messages for. #System Administration #Ensemble 1 2 0 841
Question Paul Riker · Dec 27, 2017 Studio Templates and Add Ons We do not use the out of the box web server (57772) for HealthConnect, we run a stand alone instance of Apache with https enabled. Now when I go to Tools > Templates > Web Form Wizard, I get an error Navigation Cancelled. I get a similar error when I try Tools > Add Ons > Add On. Any ideas? #Studio #Ensemble #Health Connect 0 7 0 731
Question Paul Riker · Nov 20, 2017 SQL to analyze processes by config Does anyone know how to return the sys.process table with the corresponding configname item for each process? Also, is there a key for the Job Type field? #SQL #System Administration #Caché 0 4 0 366
Question Paul Riker · Nov 16, 2017 SQL Convert yyyymmdd string to mm/dd/yyyy Any suggestions on the most efficient way to convert yyyymmdd string to mm/dd/yyyy? #SQL #Caché 0 7 0 13.6K
Question Paul Riker · Sep 5, 2017 Dynamic Update SQL Statement Is it possible to execute a sql update statement from objectscript? This code isn't working for me. #ObjectScript #SQL #Caché 0 4 0 885
Question Paul Riker · Apr 18, 2017 Base64 MLLP I have a client sending us data MLLP in base64 format. I'm using the EnsLib.HL7.Adapter.TCPInboundAdapter adapter. What setting do I change to accept the base64? #Business Service #Ensemble 0 2 0 551
Question Paul Riker · Apr 4, 2017 DTL Condition where field = """" I have an EMR sending double quotes "" as the value. How do I write criteria to find this match in a DTL?PV1|1|A|||||1111111111^Doctor^MR|||||||||||||||||||||||||||||||||||||20170331|""source.{PV1:DischargeDateTime()}="""" didn't work #DTL #Ensemble 0 2 0 709
Question Paul Riker · Mar 24, 2017 How to clear an interative field entirely in a DTL GT1|1|1|Test^Test||123 Building^123 Building^Brooklyn^NY^11220^United States^^^Kings|^PRN^PH^^^^^^^^^(111) 111-1111~^PRN^CP^^^^^^^^^(222) 222-2222|||""|IN|DGH^DaughterI'm trying to clear the phone number completely.Remove target.{GT1(1):GuarantorPhNumHome()} still gives me _~_ #DTL #Ensemble 0 2 0 429
Question Paul Riker · Dec 13, 2016 How to reference a specific field in a DTL I want to set the value in the second field of OBX-5, or OBX-5-2. My schema is not broken down to that granular level, so I can't just click OBX-5-2 to populate it. I tried a few variations without success. target.{PIDgrpgrp().ORCgrp().OBXgrp(1).OBX:ObservationValue(1).2} target.{PIDgrpgrp().ORCgrp().OBXgrp(1).OBX:ObservationValue(1)(2)} target.{PIDgrpgrp().ORCgrp().OBXgrp(1).OBX:ObservationValue(1.2)} Any ideas? #DTL #Ensemble 0 4 0 877
Question Paul Riker · Dec 1, 2016 Reference EnsLib.HL7.Message.Source in Router I have a router that is feed by a file adapter service. I want to evaluate the subfolder in the source property within the router. Any ideas? #Business Rules #Ensemble 0 2 0 335
Question Paul Riker · Nov 7, 2016 Carriage Return in OBX5.5 that is a base64 PDF I am calling a custom class in my transformation and brings back a base64, but my hl7 is doing a carriage return after about 70 characters of the base64. Any ideas how to work around this? #DTL #Object Data Model #Ensemble 0 1 0 737
Question Paul Riker · Nov 4, 2016 Round to next whole number How can I round to the next whole number?.1 = 11.2 = 21.7 = 2 #ObjectScript #Ensemble 0 11 0 1.7K
Question Paul Riker · Oct 31, 2016 Hourly Scheduled Task I'm trying to schedule a task hourly. It's currently set to execute "Daily" but run every 60 minutes. It's only running daily. Do I need to change the "Daily" to OnDemand in order to get it to run hourly? #System Administration #Ensemble 0 2 0 1.2K
Question Paul Riker · Oct 18, 2016 ProvideAndRegisterRequest to HS.Message.XMLMessage Transformation Is there a XSL to transform from ProvideAndRegisterRequest to HS.Message.XMLMessage? #Business Process (BPL) #DTL #Object Data Model #HealthShare 1 1 0 433
Question Paul Riker · Oct 17, 2016 Multicolumn Persistent List/Array Property I have a persistent class where I am logging each CCDA I receive. I want to store all of the providers associated to that CCDA (many to one). In a relational database, I would have a child table with a foreign key to the primary table. I'm guessing the equivalent to Cache would be 1. Create a custom class (ProviderList) with the properties I want to store.2. Add the class as a property of my CCDA persistent class.Property Providers as Array of ProviderList (SQLProjection = "table/column";Am I on the right track? #Object Data Model #Relational Tables #Caché 0 4 0 519