Question Scott Roth · Dec 21, 2018 Calling Javascript within Cache Object Script Has anyone called any outside Javascript code from inside their class files? I asked a long time ago if there was a way to manipulate an image within Cache Object Script, and since Cache doesn't have any image libraries its not really possible. However I have found Javascript to resize an image and wonder how hard it would be to mesh the two together.Can anyone share any examples?ThanksScott #JavaScript #Object Data Model #ObjectScript #Caché 2 9 1 1.6K
Question Scott Roth · Nov 30, 2018 Seeking Clarification between REST Web Service and a API call I am trying to explore some new possibilities outside of the normal day to day HL7 interfacing we do. I have only done 1 other Web Service interface but it was using a SOAP proxy wizard. Now I am tasked with trying to make a call to an external API https://npiregistry.cms.hhs.gov/api/ #Beginner #Business Operation #Object Data Model #REST API #SOAP #Ensemble 3 12 2 1.1K
Question Scott Roth · Nov 13, 2018 JDBC Gateway Server - Automatically Start We are trying to script a High Availability Shutdown/Start script in case we need to fail over to one of our other servers we can be back up within mins. Is there a way to configure the startup procedure to Automatically Stop/Start the JDBC server when shutting down or starting up cache? is there an auto setting we can change?ThanksScott RothThe Ohio State University Wexner Medical Center #Failover #High Availability #JDBC #System Administration #Ensemble 0 10 0 756
Question Scott Roth · Oct 31, 2018 Property Parameters - Used in REST calls I am working on my first REST operation concept and had a question about the Property Parameters. If I put a value in CAPTION, does that mean that when I use it in my call that it will come out in the URL?For example... Property enumerationType As %String(CAPTION = "enumeration_type"); #API #Beginner #Business Operation #Object Data Model #REST API #Ensemble 0 3 0 412
Question Scott Roth · Oct 14, 2018 Where is %SYS/ZAUTHENTICATE.mac stored? My administrator was wondering where %SYS/ZAUTHENICATE.mac is stored? He preforms a nightly backup, and would like to include the custom ZAUTHENTICATE.mac that was written for our Delegated/LDAP configuration. Thanks Scott Roth The Ohio State University Wexner Medical Center #LDAP #Object Data Model #Security #Ensemble 0 1 0 531
Question Scott Roth · Oct 12, 2018 Creating Custom Dashboard/Monitor In looking at the Production monitor within Ensemble, I was wondering if there is a way we could customize it for our use. I notice it is basically a dashboard.For example I would only like to truly display those Services, Processes, and Operations that are truly in dire need of attention. The Monitor out of the box just seems too busy, and I would like to simplify it. #InterSystems IRIS BI (DeepSee) #Dashboards #Ensemble #Monitoring 0 2 3 847
Question Scott Roth · Oct 8, 2018 Backing up/Exporting created Roles I have created some roles, and would like to know if there is a way to export the Roles and save them off to a file? I want to create a backup file of these roles for DR purpose, and in case I ever get hit by the preverbal bus. Thanks Scott Roth The Ohio State University Wexner Medical Center #Access control #Backup #Security #Ensemble 0 2 0 398
Question Scott Roth · Sep 13, 2018 Operators as Variables We have the need to write a function that can loop through say a field in an OBX segment within HL7 and compare it to a string passed. Is it possible to have the user enter the Operator ( >,<,=,<>) as a variable inside Cache object script? Does anyone have any examples they can share?ThanksScott RothThe Ohio State University Wexner Medical Center #Code Snippet #HL7 #Object Data Model #ObjectScript #Ensemble 0 8 0 557
Question Scott Roth · Aug 8, 2018 Connecting to MS SQL Database using JDBC and Service Account We have a new requirement being push down by our Data Security to no longer use Local SQL Accounts to access our Databases. So they asked me to create a Service Account that is on the Domain for our connections to each database.I tried just changing my JDBC connection to using this Service Account and Password but I am not having any luck trying to connect to the database." Connection failed.Login failed for user 'osumc\CPD.Intr.Service'. ClientConnectionId:ade97239-c1c8-4ed1-8230-d274edb2e731 " #Databases #JDBC #Security #SQL #Ensemble 1 4 0 4.2K
Question Scott Roth · Jul 30, 2018 Referencing Globals within each other I have a global that defines the instance that Ensemble is running under. I want to use this as part of another Global so I don't have to hard code a path.For Example^OSUWMCInstance = "TestClin"^OSUMCLDAP("LDAPKey") = "/ensemble/^OSUWMCInstance/mgr/LDAPKeyStore/"Is this possible?ThanksScott #Globals #Object Data Model #Ensemble 0 2 0 273
Question Scott Roth · Jun 29, 2018 Adding TLS to ZAUTHENTICATE I wrote a ZAUTHENTICATE.mac a couple of months back, and found recently that it is creating coredumps on almost a nightly basis. I think I have figured out this problem to be not clearing out my MsgSearch after I am doing 2 of them within the code.1. Get User Attibutes from AD2. Get User Groups From ADSo while I am trying to cleanup the code I thought it would be a good time to add a Certificate and TLS to the mix since I should of been using that all along. However I keep running into issues #LDAP #Object Data Model #Security #SSL #Caché 1 14 0 523
Question Scott Roth · Jun 14, 2018 Single Row SQL.Snapshot I have several stored procedures that when I execute them they will only return a single snapshot. In my BP I have been setting this to a Snapshot variable then looping using a WHILE through the snapshot variable just to get that single value. Since it is only a single row, is there an easier way where I don't have to do a WHILE loop to pull the values out of that row? Can I call First Row or something like that to get me just the row into the Snapshot variable? #Business Operation #Business Process (BPL) #Object Data Model #SQL #Ensemble 0 1 0 458
Question Scott Roth · Jun 7, 2018 JDBC Authentication to AD to access exteral database Without installing Kerberos has anyone Authenticated a SQL JDBC connection? Currently we are using local SQL Accounts to sign onto External SQL Databases, but we are being told that we need to switch to Service accounts that live on a Active Directory Domain. I wrote with a little help a ZAUTHENICATE to do the Authentication for Ensemble, can I use something like that to connect to an External SQL Database using a Service Account on a Active Directory Domain? Thanks Scott #Authentication #JDBC #SQL #Ensemble 0 3 0 539
Question Scott Roth · May 29, 2018 request.GetValueAt Syntax to subfields I have a vendor that is sending me an Abbreviation in FT1:16.4.2 that I need to look up against a table to find the correct ID for. FT1|1|||20180523161501|20180523161503|CG|1906551^Lipid Profile|||1||||||^^^ LAB&06CL|||Z00.00||00410^Knerr^Joel||721410||30100001^Lipid Profile| But in my Business Process when I refer to request.GetValueAt("FT1:16.4.2") its not recognizing that this field contains information. Is my syntax wrong? #Business Process (BPL) #HL7 #Object Data Model #Ensemble 0 5 0 840
Question Scott Roth · May 10, 2018 2015.2.2 .json format Is it possible to produce a .json format using Ensemble 2015.2.2? Not sure what the trigger will be as of yet, but we have our local Department of Health trying to develop a reporting piece using .json. Not sure how this will work with our Ensemble instance not being in the DMZ to send outside our network, but I thought I would ask anyway to see if it is possible.ThanksScott Roth #JSON #Object Data Model #SOAP #Ensemble 0 2 0 363
Question Scott Roth · Apr 6, 2018 Delegated Sign On Bypass Is there a way to make the system users like _SYSTEM and ensadm bypass the Delegated sign-on and not cause it to fill up the Audit trail with "Programmer mode login failure"?? I figured I still had to leave password login enabled for the background users to run. How would I script if username = "_SYSTEM" then don't do the Delegated sign on? Here is my ZAUTHENTICATE #Object Data Model #Security #Caché 0 3 0 385
Question Scott Roth · Apr 6, 2018 EnableConfigItem() scripting We have scripted a process where we can run EnableConfigItem from the cron in AIX so we can run multiple scripts at a time vs the scheduler in Ensemble that is single threaded. For the most part this works fine, until that service/operation has an error on it then it seems that everything else that is called after that instance halts.Is there something that is stopping EnsConfigItem() from running once something has error'd?Can something be forced like it does if we try to enable/disable in the gui and it times out?this is the single command line we are calling #Caché 0 3 0 547
Question Scott Roth · Apr 6, 2018 EnsLib.SQL.OutboundAdapter and StayConnected Setting Has anyone use any other setting then -1 on the Stay Connected setting on a SQL.OutboundAdapter? I am having issues with a particular database and wonder if it would be beneficial since I only connect once a day to read the data from the Adapter to create an HL7 message.ThanksScott Roth #Ensemble #Business Operation #JDBC #SQL 0 3 0 636
Question Scott Roth · Mar 13, 2018 DICOM to HL7 We have a case where a vendor can send us more information in the DICOM message rather than in the HL7 result message. In theory it should be possible to take a DICOM and convert it to HL7, stupid question is has anyone done it before? Does anyone have any good examples of a DTL they did to show me how to setup the message structures and translation?ThanksScott RothThe Ohio State University Wexner Medical CenterScott.Roth@osumc.edu #Data Model #Ensemble #DTL #HL7 0 2 0 1.1K
Question Scott Roth · Mar 9, 2018 Incrementing Session ID through BPL I have several BPL's that act like SQL Server Integration Services (SSIS) where they are transferring data. When I do this they are all being written under 1 session id, is it possible to make the BPL create multiple session ID's as it is cycling through a Snapshot, so it is easier to read in the trace?ThanksScott Roth #Business Process (BPL) #Object Data Model #SQL #Ensemble 0 6 0 941
All posts
All posts
All posts