A permanent job opportunity has arisen for a Cache/Ensemble developer at SystemC in the UK. We are looking for a talented and experienced Developer to join our CarePlus team where you will have the opportunity to utilise your experience and creativity within the product suite. 

You will be expected to work alongside the existing development team, customers, third parties and wider internal teams to support the product capabilities. As the product and company portfolio continues to develop there would also be opportunities to expand your technical skills.

Although this role is remote there may

Hello Everyone,

The Certification Team of InterSystems Learning Services has updated exam objectives for our HL7 Interface Specialist certification exam and we need input from our implementation community.  

How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance and other factors.  

How much effort is involved? It takes about 30-45 minutes to fill out the survey. You can be anonymous or identify yourself and ask us to get back to you. 

How can you access the survey? You can access the survey here  

Note: Your answers cannot be saved.

Hello

I have trouble capturing the value from a stored procedures output variable from an MS SQL Database.

In the database querywindow of MS SQL manager, the procedure is called as:
declare @return As varchar (100)
Execute TheProcedure @return. @return then contains string of content.

From HC I call the procedure:

set RetValue = ""
set Inparm = "@return"
set Outparm = ## class (% ListOfDataTypes).% New ()

SET SQLQuery = "exec TheProcedure ?"
(have also tried
"{call TheProcedure (?)}"

SET tSC = ..Adapter.ExecuteProcedure (, .Outparm, SQLQuery, "o *", Inparm)
set RetValue = outparm.GetAt(1)

This constantly

This is the fourth part of the series of articles on migrating from the main databases on the market to InterSystems IRIS.In this part, the procedures for migrating from Microsoft SQL Server will be detailed.As described in previous articles, there are currently a few options to do the migration, but the two most popular options include the use of DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway.

Hey InterSystems Community!
This is probably far-fetched - is there a way to get notified/get a piece of code triggered whenever the state of a global changes?

Now what could I possibly want with that? Quite simple! I would like to forward the content of a global (in this case the "FSLog" global written by the FHIR implementation) while adding timestamps to it - to create some sort of file-based logging for it.

Hey community! How are you doing?

I hope to find everyone well, and a happy 2022 to all of you!

Over the years, I've been working on a lot of different projects, and I've been able to find a lot of interesting data.

But, most of the time, the dataset that I used to work with was the customer data. When I started to join the contest in the past couple of years, I began to look for specific web datasets.

I've curated a few data by myself, but I was thinking, "This dataset is enough to help others?"

So, discussing the ideas for this contest with @José Pereira , we decided to approach this contest

Hi Community,

We are not using github or any source safe till now. We have ensemble hl7 interfaces (business services, processes, operations)available in production. Now we want to deploy these interfaces to a brand new cloud server with iris instance.

Here in current production we have studio access but new cloud server iris we have only vscode access.

I have exported all the classes from current production using  Studio and  I have exported xml file with me.

How to import this exported file into VS CODE to deploy classes in a new cloud server?

Does VS CODE have any option to import cls files

Is View Journal of Cache Management Portal the only way to search in Cache journals? I need a way to define several search conditions and Portal often breaks on http timeout.

Hello

I am running a script from a CMD command line using : C:\CacheSys\Bin\cterm.exe /console=cn_iptcp:127.0.0.1[23] myscript.SCR %CD%

The script should authorize something (or not) in the following lines of the GO.CMD

But How can i return an information from inside the script to the GO.CMD script ?

Any idea ?

LS,

Probably due to my MacBook M1, but when I try to push the IKO (step 3 in the install) to the hub, I get the following error message:

The push refers to repository [docker.io/library/kubernetes-operator]
6515fe38e1f1: Preparing
f562a1750889: Preparing
denied: requested access to the resource is denied

Is this indeed because of my MacBook architecture or is there a different reason?

Publishing process

You can publish your own application on Open Exchange and it will be listed in an Applications Gallery. The publishing process is a set of following steps:

1. Register on Open Exchange
2. Create the application description
3. Submit the application for approval
4. Done! Please find below the detailed description.

To publish an application first you need to sign in to Open Exchange. You can do this using your Developer Community account or create a new account here. Once signed in open the applications section in a profile menu:

Then click on Add Application button:

Setting up an

Is there any open source tool like Power BI or Tableau that works well with IRIS? Thx!

Hi everyone, I met this Jenkins build problem when commit to P4.

ERROR #5001: GUID reference(s) missing from stream websys/TranslationType/questionnaire.QCNXXCVD.Edit/68D7225A-DE63-11EB-AF4C-005056B66BA0.xml; 35551C28-0C38-11EB-A1C8-005056B66BA0

So how can I solve this problem. Would anybody help me? Thanks.

I am in the process of creating a python report writer that includes the information contained in "License Usage" page of the management portal. I think I have a handle on the local values contained in the report using the %SYSTEM.License class I have those defined using these methods:

  Current License Units Used -     ->  LUConsumed

  Maximum License Units Used  --> LUMaxConsumed

 License Units Enforced               --> KeyEnforcedUnits

License Units Authorized            --> KeyLicenseUnits

Current Connections                   --> InstanceConnections

Maximum Connections              -->

Hi,

I am running InterSystems iris 2021.1 from the container and I have version 2020.1.1 is installed locally. While running studio locally I am getting below error message:

"Version mismatch. Studio version 2020.1.1 unable to connect to server version 2021.1
Upgrade to a later version of the client to resolve this error"

Looking Forward

Thanks

Hi Community, 

Get a first look at InterSystems HealthShare's next-generation healthcare decision support and notification capabilities:

⏯ Introducing InterSystems HealthShare Extended Decision Support

It's time to announce the Winners for February! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in February:

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈 @Eduard Lebedyuk, Sales Engineer, InterSystems Corporation, Russia

🥉 @Benjamin De Boe, Product Manager, InterSystems Corporation, Belgium
 

 Learn more about the competition and our awesome winners below.

I'm new to cache, come from an oracle and sql server background. In oracle and sql server I could write basically a stored procedure like script and pass it in as text to the command to execute. 

Example:

Below would be the _sqltext

DECLARE @Id INT;

select id into @Id from something;

 if @Id = 9 

BEGIN

do something

END

The _sqltext would work in sql server, what would be the equivalent for cache for it work?

I get a generic error when I try it with cache

using (var mdscmd = new CacheCommand(_sqlText, MyConnection) { CommandType = CommandType.Text }) {

}

Thanks

Business services are powerful components that pull data in from external sources. In most cases, pre-built components do the job, but sometimes you need to code custom business services. There are a few best practices to keep in mind when doing this:

1. Lean and Mean - Business services should be coded to have minimal processing.This is due to the fact that if any errors occur within the business service, no message will be sent, and thus no trace will be created.This makes it very difficult to troubleshoot.

I want to be able to view generated items from visual studio code. In Studio there was an option in the open dialog:

Specifically, I added a namespace to my workspace for editing (Using InterSystems Server Manager) and I want to be able to access the generated items in this namespace.

The Documentation team in InterSystems Learning Services is happy to announce the new InterSystems IRIS Server Migration Guide!

Have you ever wanted to copy, move, or clone an instance of InterSystems IRIS to a new server? Maybe the operating system on the old server is no longer supported, or maybe you want to add a new member to an existing mirror. Migrating your application databases is easy, but what about your tasks, users, roles, resources, and other security settings? What do you need to migrate, and how best to do it?

We have an implementation with a bunch of users, and a bunch of namespaces, both of which are added and removed frequently, and the users have restrictive perms in the namespaces (lets just say, not %All)... and the users are utilizing the VSCODE extension for development.

Per the instructions and the user experience, we need to run:

GRANT EXECUTE ON %Library.RoutineMgr_StudioOpenDialog TO ${user}

For ... each Namespace, and additionally %SYS for Web Apps.

Is there a way to globally just make this happen "once" somewhere or is it absolutely necessary find a spot to invoke it?

We use delegated auth

Calling  InterSystems.XEP.Event.Store(object[]) issues an unnecessary debug console line "Elapsed server write time:..." which is polluting the console window.
Traced it to a IRIS.xepSSNDFinish

Is there any way this can be disabled?

Thanks!

Hi Developers,

We are carefully preparing our first 🏆 InterSystems Technical Article Contests in Portuguese 🏆.

As the contest will be officially launched next week, take advantage of this week to choose your topic or, if you are new to InterSystems technology, take the opportunity to learn a little more about the technology in this period to be able to participate!

Good Afternoon My InterSystems IRIS Peers,

I have the following issue that I need help with, I tried all possibilities that I know of, therefore I am reaching out to the community for some insight.

I have a SFTP service that pulling 2.5.1 DFT HL7 messages from our SFTP file server. The issue is that IRIS is transforming patients names and addresses that contain special chars UTF-8 to ANSI.

Examples:

è = è
é = é
í = í-  .......etc

I would like to know if there is a possibility to transform the RAW HL7 before IRIS do its magic or within IRIS.

I have used the $Translate() function to convert the

I have a python script that is pulling the cache instance key expiration date ( KeyExpirationDate() ) which comes back as an integer. With the queryscript function - $ZDATE(73284) I can derive the actual expiration date. Is there a manner or method of creating an equivalent Python script that will convert the integer return by the KeyExpirationDate()  method into a date string?

Hello,

Can anyone help on the below point? It will very helpful for me.

Copy exact same data from IRIS Instance 2019.1 to IRIS 2021.1 with the Identity column from the IRIS database.

Thanks,

Harshdeep Acharya

Can an IRIS RESTful api implement mutual authentication?

If so, can you point me to the documentation.

Thanks

Does any one could tell me how can I access the target properties from inside SQL in DTL Subtransform? For example, if I use the following statement:

SELECT ID INTO :target.SetIDPID  FROM firstlook.person WHERE  FirstName = 'Paul' - as said in documentation :

  SELECT Name INTO :target.Name FROM MainFrame.EmployeeRecord WHERE SSN = :source.SSN AND City = :source.Home.City

I get an Error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>

But if I pass the value for a variable "SetIDPID" I can use it in a set action without any problem: 

SELECT ID INTO :SetIDPID  FROM firstlook.person WHERE

I have over 25+ years in Health Care integration and 10+ years experience with Ensemble interface development.

Rolling off my project soon and looking for my next contract.

Looking for long term projects where I can leverage my Ensemble and Epic Bridges experience