Hello,

When using GetFieldStreamRaw(), by passing in a variable instead of using an output for the Remainder, will this affect how it is stored into a segment in a cloned message? I know it would usually output the remaining fields of the segment but in order to conform to a supplier's spec, they'd require "^^PDF" rather than the rest of the segment. Because the segment becomes immutable, the code below seems to be the way to do it.

Hello community!

I'm facing a base growth issue, which is being generated by a process and an Ensemble feature.

When executing the process of cleaning up the message queues, the Ensemble “preserves” the Streams that were part of these messages, deleting only the Header and Body. In this way the database (of one of the namespaces) has grown around 60GB per day, which has been maxing out the disk capacity.

InterSystems informed that this is a characteristic and that it is explained in the documents mentioned below.

https://community.intersystems.

Dear Developers,

I have a complex ZEN PDF report that has multiple tables that essentially are the same but are populated by different global definitions. The code has hardcoded groups for these tables but I would like the number of tables to be variable as many as there are global levels for a particular report.

Is there any way that I could build a report from a variable source of data rather that hardcoding 10 or more exact sections like the code below ? 

The code below is for table 2 in my report

<container ifexpression="%report.TestProfileFlag(2)=1">
<pagebreak ifexpression="%report.

Hi Experts

I am trying to pull the code tables Information and this code table has linked  code table not exactly obviously joined by SQL tables or columns. This is confusing me. Please can you clarify how to link these two tables. 

I will be generic to ensure, any privacy is protected

CT_Hospital has CT_Staff linked in.

When CT_Hospital has data, for that relevant hospital code, CT_Staff can be clicked and data entered. 

When I see in the Components - > Items I do not see any SQL table or SQL column common between CT_Hospital and CT_Staff. 

Question: How can I join CT_Hospital with CT_Staff.

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "IntegratedML - Creating ML models in minutes"!

Date & Time: September 30, 4:00 PM (CEST)

Speaker: @Eduardo Anglada, Sales Engineer, InterSystems Iberia

Interesting issue we found. When making an ODBC connection from a host via RDP, the IP address shown as making the connection is the client IP address, not the host from where the connection initiated. Has anyone seen that or know how to get around it? 

Example:

My Computer(10.X.X.112) -> RDP to Host1(10.X.X.93) -> ODBC connection to Server1(10.X.X.12). Cache Portal -> System -> License Usage -> Usage by User shows My Computer's IP address as making the connection rather than Host1. 

This normally doesn't cause any issues.

Hey Community,

We want to hear from you! Give us your feedback on the past InterSystems Analytics programming contest! Please answer some questions to help us improve our contests.

👉 Quick survey: InterSystems Analytics Programming Contest Survey

Hello,

I'm hoping to get some feedback on the OAuth process flow for Payer-to-Payer authorization.  It doesn't seem that "Authorization Code Flow" is needed as there will not be a need for a login.  I am leaning towards recommending "Client Credentials Flow", but wanted to get some community feedback before making a decision. I prefer to follow what the standard will be if possible.  What would you recommend?  Thank you in advance for your input.

I am facing below error after force stop the instance.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

method Export(savertn As %Boolean = 0) [ Language = objectscript ]

I am looking to export table to a text file in a programmatic way. I am not familiar with this class and how to invoke a "savertn" as input here.

Essentially I would like to Export Table (SELECT * FROM Table) and save it as a text file locally on Linux server. Is there any examples out there of that? Perhaps I need to save the query output to a global and then pass that input to the export?

So I am working with an inherited SQL query that queries 8 different tables. 5 of which have over a million records. 
I have 3 different servers. 

Server 1, Server 2 and Server 3. They all have the same data/tables/structure across all servers. 
Server 3 has an Iris database engine and the other 2 are Cache 2015.1.4.
I have a problem with views and performance across the servers being inconsistent. 
Thankfully Server 1 is the current live server that performs "fast enough".
Server 2 is being synced from Server 1 and acts as a report server.

And Server 3 is supposedly a new Live server.

Hey Developers,

The InterSystems Analytics programming contest is over. Thank you all for participating in our coding competition!

So it's time to announce the winners! 

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

Some of you might not be aware of this "Known Issue/Limitation" when defining a BPL-based Business Process.

And those who are not might have encountered this (somewhat "unpleasant" error):

Hi,

I have created new class in VSCode and upon saving it also saved in Cache DB but when I am deleting from VSCode it is not deleting from Cashe DB. How can I remove both class together?

Thanks

Hi,

How to send push notification from production in case of error ?

Thanks

Hi

I am running IRIS from docker container and I am not getting Web Terminal Option in management portal.

What to do for Web Terminal to be appear in management portal?

Thanks

I'm trying to save a list of AccessTokens a user for a specific user. This way I could present it together with other user-data.

I have tried calling ##class(OAuth2.Server.AccessToken).OpenByCode(authCode) from %OAuth2.Server.Authenticate's AfterAuthenticate() method. This only returns things like State and AuthorizationCode, but the AccessToken is empty at this point (afterwards it becomes filled out).

Is there a way to achieve storing the AccessToken as part of the login system?

This post provides useful links and an overview of best practice configuration for low latency storage IO by creating LVM Physical Extent (PE) stripes for database disks on InterSystems Data Platforms; InterSystems IRIS, Caché, and Ensemble.

Consistent low latency storage is key to getting the best database application performance. For applications running on Linux, Logical Volume Manager (LVM) is often used for database disks, for example, because of the ability to grow volumes and filesystems or create snapshots for online backups.

Newbie to working with silent installs.   is there a variable to pass in what/where you want to place your journal files?

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Analytics contest!

Date & Time: Friday, September 17, 2021 – 12:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ iKnow: Open Source NLP in InterSystems IRIS

This article suggests to you some patterns to create REST API applications using IRIS.

Note: source code in https://github.com/yurimarx/movie

Class Pattern to the REST Application

To begin, see my suggestion for classes needed to create IRIS API applications:

• IRISRESTApplication: CSP.REST class that will be the central controller for all REST requests and responses processed by the business services.
• BusinessService: class with a business topic implementation. It can use one or more Persistent Domain Classes to persist and query data required by the business topic requirements.

Hello!

Want to get 5000 points on GlobalMasters?

I'm launching a bug bounty for a bug with which I've been struggling for the last 4 years. Have tried to resolve it many times, but no  dice - can't track it down.

Here's the issue.

To claim this bounty you need to:

1. Create a pull request with the code to fix the issue outlined here.
2. In the pull request OR in the issue OR in the commit message describe what's the reason for this bug and how your change fixes it.

First come first serve. Bounty would be paid only ONCE for a first working solution.

Challenge details are here.

This function is supposed to tell me that argument 1 is a valid variable name or not.

Doesn't work with an array variable, eg W $ZNAME("WLCOM(I)",0).

Not a question, just a whinge really.....

Hello Community,

we want to use a specific index on our sql-class.

The index we want to use is called "iFilter".
Currently we use the following technique of ignoring all other indices because the automatically chosen index is always too slow. 

SELECT TOP 100 d0.

I really love documentaries! Last weekend I was watching a Netflix documentary called This is Pop, because it was Analytics Contest time and I thought: Why not creating a pop song analytics with InterSystems Iris?

The first challenge was the database. I found on Data World project a CSV file with the Billboard hot 100 songs from 2000 to 2018, created by "Michael Tauberg" @typhon, that fits perfectly.

I was talking to @Henrique Dias and he gave me the idea of using Microsoft Power BI for good looking report with charts.

Which genres were most popular between 2000 and 2018?

Hey Community,

"Wonders of the World" journey on Global Masters is over - thank all for participating! Now it's time to announce the Raffle Winner!

🎉🎉🎉 Congratulations to @Goran Trbojević - the winner of the Nike Backpack! 🎉🎉🎉

His entry was randomly selected among 16 participants who completed ALL the challenges in the "Wonders of the World" campaign. 

And one of the challenges was to 📸 upload a selfie with one or two words that you associate with InterSystems. 
Just look at these exciting photos!
Your words for us are SO inspiring!
Thank you all who gave us your permission to share your photo on DC and social media:

Have you heard about some restrictions in cookies for tracking visitors to your sites?

One of our clients asked me about how to know really count of visitors.

Their site works on WordPress framework, hosted on classical NAMP hosting.

They can see some statistics from Yandex Metrika conter, but we was not sure about full coverage.

We gave him the AWStats, it takes data from Apache log files on hosting.

But there were no filter of robots and hearbeat systems such as UptimeRobot or Search Engines indexing robots.

I regret getting a late start in the InterSystems Analytics contest. I had tried a couple of times before to use Analytics, but I had not gotten too far. I have been recording financial transactions in Excel workbook ever since I had to retire Microsoft Money. Since my iris-for-money was not fully functional, I created a worksheet per account I was tracking. I had developed a CSP page in iris-for-money to import transactions by reading a CSV file. I realized this process requires escaping many characters that can cause the process to fail.

Hey Developers,

This week is a voting week for the InterSystems Analytics contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote? Details below.