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:
INSERT INTO Phu_Replay_Schema.ReplayMessageModel (Completed, MessageHeaderId, NewHeaderId, NewTargetName) VALUES (true, 3616, null, 'Router_ReplayHL7')
Hey Community,
Check out the latest video on InterSystems Developers YouTube channel:
Hello, everyone!
InterSystems IRIS has a menu called Interoperability.
It provides mechanisms to easily create system integrations (adapters, record maps, BPMs, data conversions, etc.) so different systems can be easily connected.
A variety of operations can be included in the data relay process, as examples we can cite: to connect systems that are not normally connected, data can be received (or sent) according to the specifications of the destination system. Also, information can be acquired and added from another system before sending the data.
I am going to take the IRIS Core Solutions Developer Specialist Certification at Global Summit on Monday. Anyone got any tips or suggestions?
Thanks
In our latest episode of Data Points, I had a conversation with @Michelle Spisak and @Adam Coppola about Learning Services initiatives at next week's Global Summit in Seattle. Take a listen to hear about the various things LS is taking part in, and hopefully we'll see you there!
For more information and to subscribe to the podcast, head over to https://datapoints.intersystems.com.
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
In this tech talk, we’ll go into detail about the breadth of support Python developers have using the InterSystems IRIS data platform, including:
What is the difference between method and class method and why are mentioning one as Method and class method what is the purpose of this?
Global Summit returns!
After two years of video conferencing and virtual meetings, we at InterSystems are thrilled to reunite with our partners at InterSystems Global Summit 2022. In our first in-person event since the pandemic started, we're welcoming industry leaders and developers to our flagship conference. Registration is now open!
🗓 Date: June 20-23, 2022
📍 Location: Seattle, WA, United States
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
Hi Community:
I'm flying out to Seattle tomorrow to set up. Can't wait to see the city again; it's really beautiful.
We just finalized the conference guide, which is being printed now. I am attaching a PDF.
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.
InterSystems and the developer community around ZPM have been working together to take ZPM to the next level, building it into IRIS and making it a tool that can not only manage 3rd-party code, but key parts of InterSystems' products. You can hear a lot more on this topic at Global Summit 2022, and attend an experience lab to get hands-on.
As a developer, you can also join the ongoing discussion about some final key design issues we are exploring with the community.
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.
Hi All,
I am trying to install IRIS Health CE on a Ubuntu VM, so I can test IAM with it.
During the installation I get the following error:
=================
Warning: The installer can't find a platform in this distribution
supported by your system.
Searching for platforms that might install in unsupported mode...
1) Ubuntu LTS (x64)
Enter the number for your system: 1
Your system type is 'Ubuntu LTS (x64)'.
openssl version 1.1.1 is required.
** Installation aborted **
No packages will be installed.
====================
I installed OpenSSL 1.1.1n 15 Mar 2022. It was version 3.0.
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
Hi All,
I am taking a look at some legacy coding as it seems to be generating an error when processing the messaging. The message being process contains a PDF which we are transforming into a stream and sending to another system.
I have noticed this issue only occurs with PDFS that are roughly 2800kbs in size or above. All other PDFS process fine.
The error that it is generating is proDOCMAN BPL Error: 5002 : Cache error: <MAXSTRING>zS2+72^pacDOCMAN.proDOCMAN.Thread1.1
proDOCMAN being the name of the process.
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
Hello everyone,
I would like to know if it is possible to connect to a REST API through production, without having to write a class that extends %CSP.REST. Is there a GUI based way where I can configure my GetRest and then use EnsLib.REST.GenericService and EnsLib.REST.GenericOperation to configure my production and perform transformations?
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.
Hi Community,
I clipped this final list of sessions (with two new ones co-presented with AWS) out of the draft Global Summit Conference Guide. Take a look.
Also, it's not too late to REGISTER >
So out of the nearly 70 sessions, which do you think are the most popular?
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
Hello! Need help...
Please tell a newbie how to connect to a remote database.
OS Centos 7, WebServer type Apache, version cache - cache-2014.1.5.851.1-lnxrhx64,
license:
[ConfigFile]
FileType=License 5.1
[License]
LicenseCapacity=Cache 5.0 Entree - Concurrent Users for Intel (Linux):40, Multi-Server
CustomerName=...
OrderNumber=2010...
ExpirationDate=4/26/2036
AuthorizationKey=...
MachineID=
Tried to connect to a remote database through the ECP server. Writes that - The Cache license does not support ECP. I understand that there must be another cache.
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.
I have a proprietary JSON and a need to transform to SDA and save to a sda file.
How to transform json to SDA and write to a file?
Thanks
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!
Hi, is there a method that can retrieve both the filename and archive path?
I can get the path to the file ok i.e. set sPath = pInput.Filename and I can get the archive path i.e. set tArchivePath = ..Adapter.ArchivePath
Hey Developers,
Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container:
We're looking forward to seeing everyone at the InterSystems Global Summit next week!
George James Software will be there offering demos of our Deltanji source control. It has been proven to improve efficiencies within for individual developers, larger organizations, and everyone in between by bringing clarity to the development of your system. It encourages configuration management, versioning, and process control to improve the quality of your code.
If you would like to find out more, look out for us in the Partner Pavilion or book in for our User Group session during lunch on Wednesday, June 22nd. Email laurelj@georgejames.com to let us know you'll be there.
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
Do you have any idea about the cause of this error ? ( i have checked the iris databases disk space and it's not full )
Thank you in advance.
Hey Community,
We are super excited to announce the winners of the InterSystems Grand Prix Contest.
This competition was an absolute success! To show our appreciation to our amazing contestants we doubled the prizes for runners-up!
So let's meet the winners...
