go to post Scott Roth · Mar 3, 2021 I am seeing the same error, below is what my cconsole.log is displaying 03/03/21-12:57:08:095 (39846580) 0 tpopen for host www.osumc.edu device number 61400583 port 443 mode 0x8848 tcpmode 0x124 terminators ibfsz 8192 obfsz 8192 queuesize 5 timeout 5 tcpsbuf=0 tcprbuf=0, XY=off, BINDTO=10.82.124.9103/03/21-12:57:08:095 (50397494) 0 SSL/TLS configuration: OSUWMC03/03/21-12:57:08:097 (39846580) 0Cipher list: ALL:!aNULL:!eNULL:!EXP:!SSLv203/03/21-12:57:08:097 (39846580) 0Trusted certificate file: /ensemble/TestClin/mgr/LDAPKeyStore/OSUWMC_CA.cer03/03/21-12:57:08:097 (39846580) 0^MPeer verification option = 1, certificate depth = 903/03/21-12:57:08:097 (39846580) 0SSL/TLS client requested.03/03/21-12:57:08:100 (39846580) 0Verify error with X.509 certificate at depth 203/03/21-12:57:08:100 (39846580) 0Subject: /C=US/ST=New Jersey/L=Jersey City/O=The USERTRUST Network/CN=USERTrust RSA Certification Authority03/03/21-12:57:08:100 (39846580) 0Issuer: /C=GB/ST=Greater Manchester/L=Salford/O=Comodo CA Limited/CN=AAA Certificate Services03/03/21-12:57:08:100 (39846580) 0Error: 20, unable to get local issuer certificate03/03/21-12:57:08:100 (39846580) 0SSL/TLS error return from SSL_connect().03/03/21-12:57:08:100 (39846580) 0SSL_ERROR_SSL: protocol error03/03/21-12:57:08:100 (39846580) 0error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed03/03/21-12:57:08:100 (39846580) 0TPXMIT saw TCP device fail
go to post Scott Roth · Feb 5, 2021 I was never able to get this to work, and now I have another case where I need to do something similar as I have a linked table that is dynamic and need to use as a filter in a router. Can someone see what I might be doing wrong? Thanks Scott
go to post Scott Roth · Feb 3, 2021 I am not quiet sure your syntax is correct is probably should be ..Piece(source.{PV1:AlternateVisitID},"~",*) or source.{PV1:AlternateVisitID(~).IDNumber} https://docs.intersystems.com/healthconnectlatest/csp/docbook/DocBook.UI.Page.cls?KEY=EEDI_virtual_property_paths
go to post Scott Roth · Feb 3, 2021 One way you can do this is using the function Piece. https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RBAS_fpiece
go to post Scott Roth · Jan 14, 2021 I keep getting the following... ERROR <Ens>ErrException: <UNDEFINED>zTransform+134 ^osuwmc.EpicOMStoMatSysTecsysBkLoad.1 *%Ensemble("FeederScottRouting") -- logged as '-'number - @'set bp = %Ensemble("FeederScottRouting")'
go to post Scott Roth · Jan 14, 2021 So... %Ensemble("%Process") should be the Business Process (aka Router) that is calling the original DTL?
go to post Scott Roth · Jan 14, 2021 I think I found a way to handle it but I am struggling on how to send an Ens.Request message to another Operation in the middle of a DTL. I tried this through a function, but Ensemble does not recognize the SendRequestSync that I am trying to send. Is it possible to send another message to another Business Operation using Code/Function in the middle of a DTL?
go to post Scott Roth · Dec 10, 2020 For those that do not know what those tools are and are just getting into SQL, navigating around the tool within IRIS/HealthShare can be difficult at times. Even trying to use those tools can be complicated in setting up the necessary connections and settings.
go to post Scott Roth · Dec 10, 2020 I would like to see a more modern SQL management/editor within IRIS.
go to post Scott Roth · Dec 7, 2020 I figured querying a local table through an SQL call in the DTL would cut down on the amount of development that is needed. I created a view with only 2 columns of the data set and wrote a custom function so my other team members could use it. So far so good.
go to post Scott Roth · Nov 16, 2020 We have used Length many times in Routing rules to check to see if Admit/Discharge date exists. We haven't quite used HL7.{PV1:45} to get the field, we let the system spell it out for us... so instead of HL7.{PV1:45} we allow the system to put it in the nomenclature that it knows the field as.. in this case HL7.{PV1:AdmitDateTime.Time}
go to post Scott Roth · Nov 12, 2020 Nicole, I believe your problem is with the repeating fields. You can not leave () blank. You will need to use a counter or loop through OBX to look for the individual fields you are looking for. Scott
go to post Scott Roth · Oct 12, 2020 setting the following did not work InitialExpression = {$zdt($zu(188),3,1)} as the records are being read by EnsLib.RecordMap.Service.FileService into the record map generated table, I can not get the DateInserted column to auto-populate. Does anyone have any suggestions on getting this DateInserted column to populate as the RecordMap.Service is reading in the file? Thanks Scott
go to post Scott Roth · Oct 9, 2020 I think I figured it out, but could someone verify? I am able to edit the class file in Studio to enable "DDLAllowed". 1. Then I scripted the following... Alter table "osuwmc_Workday_DataStructures_FSINT3376ItemMaster"."Record" ADD DateInserted DateTime 2. After I was able to add the time through SQL I was able to alter the column to set the DEFAULT = getdate() Alter table osuwmc_Workday_DataStructures_FSINT3376ItemMaster.Record Alter DateInserted DEFAULT(getdate()) In the class file it is now showing... Property DateInserted As %Library.TimeStamp [ InitialExpression = {$zdt($zu(188),3,1)}, SqlColumnNumber = 24 ]; I realize I can probably combine my SQL statements, but I did not use the Generator.GenerateObject(). Is this ok? Thanks Scott
go to post Scott Roth · Oct 9, 2020 Also how do a make a Table that was generated from RecordMap, DDL enabled?
go to post Scott Roth · Sep 8, 2020 I haven't spent any time doing anything with NACK's as of yet. I would suggest creating another post for that question to see if other Developers can help you out.
