Hello everyone,

I am having a challenge with the IRIS community version in Docker with wsl2. Host machine is Win 11 and the IRIS/Ubuntu image is Ubuntu-20.04 from running 'wsl -l -v.

I am not able to reach the WebPortal in IRIS nor the Super User port. docker ps -a = containers.intersystems.com/intersystems/iris-community:2021.1.0.215.3 "/tini -- /iris-main" 3 weeks ago Up 26 hours (healthy) 0.0.0.0:1972->1972/tcp, 2188/tcp, 53773/tcp, 0.0.0.0:52773->52773/tcp, 54773/tcp iris

Hey Developers,

The InterSystems AI programming contest is over. And now it's time to announce the winners!

Are you excited?

A storm of applause goes to these developers and their applications:

Hi ,

We have requirment to use SSO using SAML with windows azure.
Currently we are looking for sample cache code to implement the process.

Thanks,
Srinivasan

Edit:

May have found the issue but not the solution.

"SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without asking for the DNS.

but

'SELECT Count([wmhISTORYdETAIL].[HistHMNumber] AS CountOfHistHMNumber FROM [wmhISTORYdETAIL] WHERE ((([wmhISTORYdETAIL].[HistMovType])='Receipt') AND (([wmhISTORYdETAIL].[HistMovDate])>=Date()-1) AND (([wmhISTORYdETAIL].[HistMovDate])<Date()));'

asks for the DNS but both are linked to a table that has the password saved.

Any Ideas please?

Rob

Hi

I'm currently working on a project to run our medical device integration through ensemble.

I've noticed a potential problem with the volume of messages . The feed generates around 474K messages daily( average of 1 message per minute per device from 300+ devices).

We currently keep all our other feeds message data for 90 days and purge automatically. From what I can see is that the purge functions in Ensemble are production wide and cannot set it at the Business Operation, Service or Router level.

After creating a ClassMethod for a routing rule is it possible to test an HL7 message within Studio rather than using Management portal? It would make it easier to debug the custom function to see where the rule is failing.

Hi,

i have a csp application (namespace default) to which i like to login from remote. This is possible via

http://localhost:57772/csp/namespace/MyApp.MyPage.cls?CacheUserName=<use...

I get this on preparing a sql query

ERROR #5580: SQL Privilege Violation: 'User UnknownUser is not privileged for the operation'

Hi,

Is there a way to find the median in Intersystems Cache SQL? I know it is not available as an aggregate function. Also in SQL Server I could try something like:

SELECT
(
 (SELECT MAX(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score) AS BottomHalf)
 +
 (SELECT MIN(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score DESC) AS TopHalf)
) / 2 AS Median

However, there is no PERCENT Keyword in Cache as well. Any suggestions?

Thanks

Is there a way to get a report of how many messages are passing through a production? I am trying to gauge how many messages we process weekly, monthly, and yearly. Also, over specific months.

Would appreciate if someone can guide me on this

We use Cache for Windows 2017.1.3

I'm finding that in a mobile app setting, that Cache is causing the worst User Experience that I have ever seen in a mobile app - I'm just saying this hoping that someone will be able to help me out, my intent is not to criticise Intersystems.

We have a Xamarin Forms mobile app that consumes web pages that are created by Cache. The app compiles into iPhone, iPad, Android Phone, Android Tablet, UWP (Windows 10, all of phone, tablet, and desktop), as well as MacOS.

#########
#S| | | #
#-#-#-#-#
# | | | #
#-#-#-#-#
# | | | #
#-#-#-#-#
# | | |
####### V

<!--break-->

This is a series of programming challenges for beginners and experienced Caché programmers.

For an introduction : go to article https://community.intersystems.com/post/advent-code-2016-day1-no-time-ta...

I have a Enslib.REST.operation which I want to use to send a JSON message. In Ensemble I am using the request message to the Business operation as an input for ObjectToJsonStream function so I can send it out (this is the way to go right?). However, I am now running into the fact that one of the attributes (template_name) contains an underscore and that I am not allowed to use the underscore to define the property in my ensemble RequestMessage:

Property template_name As %String;

Consider a design where there could be three or four or more servers and there is a need to have these eventually consistent between them all (and not considering database mirroring here).