Announcement Anastasia Dyubaylo · Jul 12, 2022

Hey Community!

If you follow our updates, you should know that several months ago we created a new regional community for all those people who speak (and write) French!

You can find it here: fr.community.intersystems.com

After only three months we already have 25 members (I know, it doesn't sound a lot compared to 11.000 members on English Community, but French Community is a newborn compared to an adult) and more than 140 articles, 3.000 views, and 160 likes. We already have exclusive content not present on other regional Communities and our own "thing" which you may spot in our recaps of different events where moderators and admins from the French Community were present.

1
0 304
Question Peter Smit · Jul 13, 2022

Hi

I'm trying to migrate a database from cache to iris but i get this from one of the classes on compiling.

ERROR #9101: Global name 'Jobcosting.JobActivityGroupGroupD' for 'IDLocation' is too long, must be no more than 31 characters in length.
  > ERROR #5030: An error occurred while compiling class 'Jobcosting.JobActivityGroup'

2
0 502
Article Sergei Sarkisian · Jun 29, 2022 12m read

Hi! As a developer who was forced to move from Mac to Windows (temporary) I found some things a bit confusing. In this article I would like to talk about some tweaks I made to make my experience smoother. I think it can help not only Mac users who need to use Windows environment (for ex. in VMs), but also can help some Windows users to make some things more convenient. Of course, all the points are subjective, the best setup is one that works for you.

All the tweaks are related to Windows 10 as I don’t have an access to Windows 11 at the moment.

7
2 935
Question Oliver Wilms · Jul 12, 2022

Hello,

I work on deploying IRIS using Kubernetes operator and Red Hat OpenShift. I encouraged another team working on Java application to consider using IRIS as database. My team deployed IRIS cluster using two mirrored data pods for the other team. The other team asked me for the connection information.

To learn how to use Java with IRIS, I attempted to deploy two apps from Open Exchange:

https://openexchange.intersystems.com/package/CRUD-GLOBALS-IRISNATIVEAP…

Here I got errors like this:

package com.intersystems.jdbc does not  exist

https://openexchange.intersystems.

1
0 378
Announcement Anastasia Dyubaylo · Jul 11, 2022

Hi Community!

We're pleased to welcome @water huang as our new Moderator in the Developer Community Team!

Let's greet @water huang with big applause and take a closer look at his bio!

@water huang (黄念刚)is a developer at Southwest Technical Support Center of Mediway(东华医为).

Here are some words from @water huang:

  • Since I joined Mediway in 2012, I started to learn InterSystems technologies and integrated platform. I used the early versions of InterSystems Caché, Ensemble. Ensemble 2016 is my main development tool at present.
1
0 216
Article Pravin Barton · May 12, 2022 1m read

Say I have a persistent class in IRIS with an optional property EmailOptIn:

Class Person Extends %Persistent
{
Property Name As %String;
Property EmailOptIn As %Boolean;
}

I later realize that I'm doing a lot of null-checking on this property where I shouldn't need to. The solution is to make this a required property:

Class Person Extends %Persistent
{
Property Name As %String;
Property EmailOptIn As %Boolean [ Required ];
}

When I make this change I'll need to update all the existing data to set a reasonable default where it is null.

7
0 591
Announcement Olga Zavrazhnova · Jul 11, 2022

Hi Community,

We are excited to announce that InterSystems Developers Meetups are finally back in person!

The first Python-related meetup will take place on July 21 at 6:00 at Democracy Brewing, Boston, MA. There will be 2-3 short presentations related to Python, Q&A, networking sessions as well as free beer with snacks and brewery tours.

AGENDA:

0
0 479
Discussion Eduard Lebedyuk · Jul 1, 2022

Leet (or "1337"), also known as eleet or leetspeak, is a system of modified spellings used primarily on the Internet. It often uses character replacements in ways that play on the similarity of their glyphs via reflection or other resemblance. Additionally, it modifies certain words based on a system of suffixes and alternate meanings. There are many dialects or linguistic varieties in different online communities. Wikipedia

You'll have to translate a string into a LeetSpeak. As usual shortest solution wins.

8
0 674
Article Oliver Wilms · Jul 10, 2022 1m read

As I was thinking what I could develop for InterSystems Full Stack Contest, I saw this post:

https://community.intersystems.com/post/how-access-production-items-through-objectscript

I developed ProductionManager.csp. It displays items in the active production. It also displays the Class in use and the date and time of last message. I believe these data points can help you make decisions which items to remove from the production.

I read that contest asked for apps which insert, update, or delete data in InterSystems IRIS.

0
0 292
Question Oliver Wilms · Jul 10, 2022

I am still working on iris-for-money app: https://github.com/oliverwilms/iris-for-money

Account.csp posts a rest call with _SYSTEM username and the password.

xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");
xhttp.send();

/restapi web application has Password Authentication Method enabled.

SYS is the correct password for _SYSTEM user.

I do not understand why I see login failure in Audit database.

1
0 384
Question Oliver Wilms · Jul 9, 2022

I am working on iris-for-money app: https://github.com/oliverwilms/iris-for-money

Account.csp posts a rest call with _SYSTEM username and the password.

xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");
xhttp.send();

The error is logged in Riches.REST for this line:

Set tSC = tStatement.%Prepare(pQuery)

ClassMethod PostSQL(pQuery As %String = "", pIndex As %String = -1) As %Status
{
    Do ..DebugTEST("Riches.REST - PostSQL")
    Do ..DebugTEST("pQuery = "_pQuery)
    Set tSC = ..TestQuery(pQuery,.pQuery)
    Do ..DebugTEST("TestQuery = "_pQuery)
    Set tStatement =

3
0 1149
Question Con Skordis · Jun 24, 2022

What is the correct way to specify rowspan and colspan in a ZEN PDF report using <Item> <Caption> 

I am specifying rowspan in the <Caption> tag after the <Item> but it's not working.

1
0 410
Question tom whalen · Jun 29, 2022

I had a customer the other day ask how GREFs are measured and how the relationship of the host, storage, and DB engine all influence that number measured in hundreds of thousands or millions.  Is there any good documentation that explains this and/or assists with calculating a GREF count?

3
0 891
Announcement Developer Community Admin · Jul 7, 2022

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

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

🥇 @Danny WijnschenkApplication Developer/Owner, Winfo, Belgium

🥈@Lorenzo Scalese, Solution Architect, Zorgi, Belgium

🥉 @YURI MARX GOMESSoftware Architect, YM Services, Brazil

🥉 @Robert Cemperex Senior Sales Engineer from InterSystems, Austria

 Learn more about the competition and our awesome winners below.

2
0 348
Question Don Martin · Jan 31, 2022

I've been playing with IntegratedML and have created a model and trained the model.  When I try to use PREDICT or PROBABILITY statements in an SQL query, I get the following error:

[SQLCODE: <-400>:<Fatal error occurred>]

  [%msg: <PREDICT execution error: ERROR #5002: ObjectScript error: <OBJECT DISPATCH>%LoadModel+31^%ML.AutoML.TrainedModel.1 *<class 'AttributeError'>: 'str' object has no attribute 'decode' - >]

Here's an example of the sequence of steps I've followed that lead to the error:

CREATE MODEL MyModel PREDICTING (IsError BOOLEAN) FROM Example3.

4
0 483
Question Nezla · Jul 6, 2022

Hi Guys,

I've a zen report that populate as excel to the screen using DEFAULTMODE = "xlsx" is there a way that I can run send that zen report to a file in a specific path all in the background rather to the screen?  

Thanks

1
0 364
Announcement Anastasia Dyubaylo · Jul 7, 2022
0
0 205