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 370
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 #SQL #Caché 0 7 0 693
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 385
Question Paul Riker · Mar 27, 2019 How can I link directly to a patient's chart in the Clinical Viewer? #HealthShare 1 4 0 421
Question Paul Riker · Oct 19, 2018 CCDA Anonymizer Does anyone have a tool or standard to anonymize CCDAs? #Tools #HealthShare 0 1 0 321
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 663
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 0 7 0 516
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 283
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 12,248
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 717