Hey Community,

Please join the next InterSystems online programming competition:

🏆 InterSystems FHIR Accelerator Programming Contest 🏆

Submit an application that uses InterSystems FHIR-as-a-service on AWS or helps to develop solutions using InterSystems IRIS FHIR Accelerator.

    Duration: May 10 - June 06, 2021

    Total prize: $8,750

    👉 Landing page 👈

    6 15
    1 2.8K
    InterSystems Developer Community is a community of 19,973 amazing developers
    We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
    Learn more
    Question
    · Oct 29, 2020
    Reply with custom ACK

    Hi,i have created a simple production with:

    Business Service-EnsLib.HL7.Adapter.TCPInboundAdapter

    Business Process - EnsLib.HL7.MsgRouter.RoutingEngine

    Business Operation - EnsLib.SQL.OutboundAdapter

    the sending application requires a ACK wich is different than the ACK i choose from in the AckMode settings of the Business Service.

    How do i create a custom ACK?

    Thanks

    0 4
    0 652

    Hi community,

    I am in the process of building a React Native Application for a restaurant.

    I am not quite sure if we can use IRIS as the main database for this and if there is a possibility I am not quite sure how to do it.

    If there is a possibility could some one help me out with it please?

    Or do you think using AWS is a better choice?

    Please let me know your ideas and guidelines in the comments or please feel free to reach out to me directly.

    Hoping to hear soon.

    Regards.

    0 2
    1 337

    HA backup strategy

    we use Rose to do HA with cache2016.2, the database is placed on the hard disk array, which is essentially an instance, and the same array disk is mounted by rose switch, another mirror machine is made.

    Is there any problem with this structure for disaster recovery and backup, I hope to give some advice. Thanks!

    0 8
    0 311

    Does InterSystems IRIS will support Visual Studio 6.0 Enterprise Edition (Visual Basic)?

    We are in the process of transitioning Intersystems Cache 2017 to Intersystems IRIS 2020 version.

    For terminal based applications we can able to use the same DAT file used for Cache with minor changes.

    For Web based we are using Visual studio 6.0(Visual Basic). Will IRIS supports Visual Studio 6?

    0 2
    0 222

    when i connect to DB via DBeaver , it always report Connection refused, i tried both Cache and IRIS but same error, I have already download intersystems-jdbc-3.2.0.jar as IRIS Driver.

    And meanwhile SqlDBx tool is able to connect via internal Intersystems Cache Driver.

    0 2
    0 795
    Question
    · May 23, 2021
    HL7 learning

    Hi Guys,

    I'm new in HL7 and have seen the basic learning material in "HL7 Business Services and Business Operations" but I'm wondering if there are learning materials and samples that I can boost my HL7 knowledge pls?

    Thanks

    0 4
    0 245

    Hi Developers,

    Watch the execution of a speed test for a heavy-ingestion use case on InterSystems IRIS:

    ⏯ InterSystems IRIS Speed Test: High-Volume Ingestion

    https://www.youtube.com/embed/NIwGgssAANE
    [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

    4 0
    0 263

    Hi all,

    I'm looking for a user-friendly way to make a method library available in DTL, and by user-friendly I mean via '..MyMethod()' or '$$$MyMacro()' rather than '##class(MyPackage.MyClassName).MyMethod()'.

    Does anybody know of a way to add a second superclass or a set of macros to a DTL ... or some other trick?

    Cheers,

    Otto

    0 2
    0 204
    Article
    · May 28, 2021 1m read
    Fetch Upstream in GitHub

    Hi colleagues!

    Often when we collaborate to someone's repo in GitHub we do the following cycle:

    Fork-Clone-Change-Commit-Push-Pull-Request-Merge to the original repo.

    This is all great and works fine!

    And if we want to make a second collaboration right after the merge you need to perform "Fetch upstream" to your forked repo first to "ingest" your own Pull-request in the original repo.

    Geeky git-professionals do it with ease but this was always a headache for me so I usually simply deleted the fork and created a new one.

    And today I figured that Github added a new UI feature that I can easily fetch-upstream for my fork with the original one and make it up to date and capable for pull-requests.

    Here is where the button is:

    This is a relief! )

    Wanted to share this relief and productivity tip with you!

    Bring more collaborations to Github repos!

    And speaking of PR - I just made a PR with docker to Google Cloud Run deployment for the FHIRaaS demo made by @Anton Umnikov for the current FHIR Contest! Looking for more of your contributions!

    9 0
    3 435

    We need to know how to pass a certain value, which in the .NET world is described as a byte array (i.e. byte[])

    Background:

    We have various libraries that were created in .NET 4.5 that are registered for COM interom, an example that we have is as follows:

    .NET Signature:

    public static byte[] CreateQrCode(string content, int width, int height, string imageFormat)

    .NET utilisation:

    byte[] image = Writer.CreateQrCode("http://redacted/", 100, 100, "png");

    0 4
    0 340

    I am trying to populate a table using the sql Data Import Wizard. The input file is a tab delimited text file. But the import keeps failing with a 104 error showing validation for the columns which use %Library.TimeStamp and %Boolean datatypes is failing. Yet when I insert values into the table through a SQL insert command, the values get saved correctly in the table.

    For the TimeStamp format in the wizard form, I am choosing YYYY-MM-DD-HH:MI:SS because there was no option for this format: YYYY-MM-DD HH:MM:SS.

    0 4
    0 325

    Hello,

    I'm quite new at InterSystems. I have a business process that's pointing two different business operations, but one of them I don't want it to point to.

    I went through the FileSystem settings, data transformations, classes, and code to see what it could be, but I don't see why its connecting to this second operation.

    What other inner-system mechanics would I need to consider? What have might I have missed?

    0 6
    0 142
    Question
    · May 27, 2021
    JDBC counts don't match

    I'm using a JDBC driver to connect PGSQL -> Cache. I'm noticing when I run SELECT queries and COUNT(*) command against the same table, I get different result sets. I'm pretty new to Cache in general - so I'm trying to understand why these would be different.

    Examples (TransID and InvNum should occur in every "row"):

    SELECT COUNT(*) FROM ACCT.Services = 1,090,324 WHERE ACCT.Dept = 483

    SELECT TransID FROM ACCT.Services = 1,085,776 WHERE ACCT.Dept = 483

    SELECT InvNum FROM ACCT.Services = 586,023 WHERE ACCT.Dept = 483

    0 8
    0 217

    Hello community,

    I am in the process of building a Health Care Application named MediCloud and I was so excited to see that IRIS is one of a great choice that I can make for a database system.

    But, I am developing my system with ASP.NET Core Version 2.1. I did see that there is a way we could use .NET with IRIS using PEX (such a useful tip), is there a possibility I could do it ASP.NET Core as well.

    Or is it just limited to .Net for the time being?

    Cheers.

    0 2
    0 318
    Question
    · May 16, 2021
    IRIS or Cache?

    Hello all,

    I am in a bit of a situation where I could get your help please.

    I want to get certified with IRIS, but I also do see that there is an availability named Cache.

    Are they both the same or different? if different please explain it to me as how?

    Also what is the difference between IRIS, IRIS for Health, Deep Sea? Please explain to me.

    Also what do you think I should get my self certified with?

    Please leave your comments below.

    Cheers.

    0 3
    0 385

    We've traditionally run a selection of development environments from a single cache instance using different namespaces for DEV TEST PREP etc. This has come with a few drawbacks, mainly that you then cant break down into namespaces per environment and everything is sharing various options.

    Is there a massive overhead to running multiple cache instances from the same 'box' instead?

    How best to share the memory setup in that situation, we usually pre-define around 80% for the instance, do we just share that evenly between the multi instance scenario?

    0 8
    0 246
    Question
    · May 27, 2021
    ERROR#5002

    User antiterrorism is assigned the following SQL procedure privileges:

    ERROR #5002: Cache error: <UNDEFINED>SQLUserPrivsExecute+57^%SYS.SQLSEC ^oddPROC("ENSEMBLE_ENS","BAIYAOJIREQUEST_EXTENT",27)

    SOURCE ELEMENT: %CSP.UI.Component.SQLTables (SQLProcs)

    0 1
    0 419

    Afternoon all,

    Is there a way (at SQL level) to script out the definition of a Cache stored procedure from within SQL?

    In SQL Server, I would do...

    Select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = 'my_sproc_name'

    But cant find anyway to do this in cache.

    Note, its an old version of Cache, so "INFORMATION_SCHEMA" is not available.

    I am trying to see the SQL definition in the sproc from SQL itself.

    Thanks all

    0 4
    0 187
    Article
    · Jul 8, 2020 7m read
    Tips for debugging with %Status

    Introduction

    If you're solving complex problems in ObjectScript, you probably have a lot of code that works with %Status values. If you have interacted with persistent classes from an object perspective (%Save, %OpenId, etc.), you have almost certainly seen them. A %Status provides a wrapper around a localizable error message in InterSystems' platforms. An OK status ($$$OK) is just equal to 1, whereas a bad status ($$$ERROR(errorcode,arguments...)) is represented as a 0 followed by a space followed by a $ListBuild list with structured information about the error. $System.Status (see class reference) provides several handy APIs for working with %Status values; the class reference is helpful and I won't bother duplicating it here. There have been a few other useful articles/questions on the topic as well (see links at the end). My focus in this article will be on a few debugging tricks techniques rather than coding best practices (again, if you're looking for those, see links at the end).

    15 7
    11 2K

    I have some code in a mac routine that use indentation and the "." character : 

     IF condition1 DO
     .WRITE YCR,...
     .WRITE YCR,...
     .WRITE YCR,...

    I would like to add a try / catch block between the write statements.
    I can't refactor the whole code and use indentation with curly braces instead (there is too much code, not written by me)

    I have tried the following but it does not work (it compiles, but code stop running right before the try keyword)

    0 2
    0 291
    Announcement
    · May 26, 2021
    Video: Cloud Backup Strategies

    Hi Community,

    Please welcome the new video on InterSystems Developers YouTube:

    ⏯ Cloud Backup Strategies

    https://www.youtube.com/embed/5mCQ5q9bdAE
    [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

    3 0
    0 270