Hi all

I'm struggling to insert into a table, and it is baffling me. The insert statement is now very simple (I was using a complex INSERT SELECT statement but I'm trying to narrow down the problem).

Insert statement:

I am going to take the IRIS Core Solutions Developer Specialist Certification at Global Summit on Monday. Anyone got any tips or suggestions?

Thanks

Hey Developers,

You're very welcome to join the upcoming InterSystems webinar called "InterSystems IRIS Tech Talk: Python"!

Date: Wednesday, June 08, 2022
Time: 11:00 AM EDT

https://www.youtube.com/embed/a8SJ8bwlC-E
[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]

In this tech talk, we’ll go into detail about the breadth of support Python developers have using the InterSystems IRIS data platform, including:

Hey Community,

Common tools for meeting the challenges of testing large-scale solutions deployed in the cloud:

⏯ Using Automated Testing to Build Reliable, Large-Scale API Server in the Cloud

https://www.youtube.com/embed/gDDL4eWc9jA
[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]

Only a few days to go until the Global Summit! George James Software will be on hand to talk about any projects you may have on the horizon, such as application development, data and platform migration, system integration, training, and support – we can work with you to find practical and maintainable solutions that support the growing needs of your organization.

We're also running a User Group Session on Wednesday, July 22nd at 12pm. It's a great opportunity to find out more about our tools and ask us (and current users!) any questions.

Hello to all my fellow Cache Experts. Quick question about the MONLBL output that identifies performance issues. There is a metric value output by MONLBL called "Obtain [NEW] connection to Cache". Supposedly that metric captures the time taken between the request reaching the CSP Gateway and a connection to Cache being reserved for the purpose of servicing the request. All of that being said, if that metric value is high for many requests, such as 19.x seconds, then can anyone tell me what that metric really means and how to improve (lower) the new connection to Cache time. The com

Hey Community,

We greatly appreciate all your feedback on the InterSystems Grand Prix Contest 2022! Please take a few questions to help us improve our contests.

👉 Quick survey: InterSystems Grand Prix Programming Contest Survey

I am trying to connect to IRIS deployed on AWS EC2 instance using JDBC connection string but I am getting connection refused. Username :_SYSTEM.

Even the management portal URL is not opening for me

Hi Community:

We've just added two new sessions and a panel discussion (Take a look below.) And if you haven't registered yet, there's still time.

NEW PANEL DISCUSSION

General Session, Thursday, June 23

Hi ,

We have inbound HL7 message we want to transform. Is it possible to copy inbound NTE segments at ORC level to PID group level in the transformed messages? I see functions for insert / append / set etc but they appear to be related to specific properties / fields of segments as iodised to the entire segment.

thanks

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

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

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

🥈 @José Pereira, Business Intelligence Analyst at Shift Consultoria e Sistemas LTDA, Brazil

🥉 @Heloisa Ramalho, Software Developer in the Application Services, InterSystems, USA

🥉 @Guilherme Mendes, Developer, BPlus Tecnologia, Brazil

Learn more about the competition and our awesome winners below.

Hi,

Any suggestion on how to compare dates? Below is my code but it does not seem to work.

USER>w $zdate(zdateh(x,8),1) > $zdate($zdateh(y,8),1)

When I set x to "06/01/2022" and set y to "04/01/2022" gives me an output of 1

When I set x to "09/01/2019" and set y to "04/1/2022" still gives me an output of 1

Any help is appreciated.

Thanks!

Hey Developers,

Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container:

⏯ InterSystems IRIS Container Updates

https://www.youtube.com/embed/ZbzP7m0HDkU
[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]

Hello,

I'm using a ComplexBatchFileService to retrieve and process a 425 Mo File ( lines )

At some point the Business Service is in failure , and displays this error :

ERREUR #5002: Erreur Cache: <FILEFULL>%SaveData+18 ^CFAO.EOS.MasterFilePR.PMP.RM.ART1.Record.1 ^CFAO.EOS.MasterFileE50F.RecordD(535405931),e:\eos\
+
ERREUR #5002: Erreur Cache: <ROLLFAIL>%TRollBack+10 ^%occTransaction