Hi, 

I have a problem when starting the docker container that the collation is standard US

sample:

docker run --name iris1 -d --publish 1972:1972 --publish 52773:52773 containers.intersystems.com/intersystems/iris-community:2022.1.0.209.0 --check-caps false

After the installation I like to import existing classes and globals but it failed due to an collation error 

We usually use DEUW = German3 

if I change it manually - in the management portal / NLS... -  to DEUW it works fine. (By the way.... the managemet portal  shows all in German due to the Linux version)

Question: is there a way

Hello,

I am still trying to figure that Calculated Measure stuff and I hope to learn from you. I have several cubes I am trying to create calculated measures using the Calculated Member Expression.

I have a cube called Cards. There is a measure called count that give total cards count of 15,000. There are two dimensions I am considering. One is the CreditGrade (A, B, C, D, nograde) and the other is the date of the scoredate.(2000-2015).

The CreditGrade dimension has two hierarchies. H1 being the creditnumber and H2 being the CreditGrade (The one I need).

The scoredate dimension has the sco

Consider the simplest possible CSP file upload/download page - you upload a file, it's saved in the database, and the file is immediately re-download via %CSP.StreamServer:

Class DC.Demo.CSPUpload.Page Extends (%Persistent, %CSP.Page)
{

Property stream As%CSP.BinaryStream [ Required ];ClassMethod OnPage() As%Status
{
	&html<<formmethod="post"enctype="multipart/form-data"><inputtype="file"name="file" /><inputtype="submit" /></form>>quit$$$OK
}

ClassMethod OnPreHTTP() As%Boolean [ ServerOnly = 1 ]
{
	#dim%requestAs%CSP.Request#dim%responseAs%CSP.R

Hi 

I try to create an ODBC connection to MariaDB using SQL Gateway Connection. It works when testing with isql command at OS level but in the SQL Gateway Connection test is failed as this message :

Connection failed.
SQLState: () NativeError: [2002] Message:

And another way try to testing with this command

d$SYSTEM.SQLGateway.TestConnection("MariaDBodbc")

I got the error message look like this :

INST01:USER>d$SYSTEM.SQLGateway.TestConnection("MariaDBodbc")

Connection failed
  SQLState: () NativeError: [2002] Message:

INST01:USER>zw%objlasterror%objlasterror="0 "_$lb($lb(5023,

Hi folks!

It's not an innovation, but often I saw not a very informative Error page for CSP apps and got it for myself. Something like that:

Hello friends,
I am having the following problem when passing a parameter in the execution of a zen query?
If the parameter has more than 50 characters of the error.
Http://127.0.0.1.57772/csp/sistema/CLINICA.Rel.Atestado.cls?nome="José Roberval Benedito da Silveira Gonçalves Sobrinho "

Is there a configuration or solution to this problem?

Hugs

Davidson Espindola

Hey Developers, 

Meet the new video on InterSystems Developers YouTube channel:

⏯ Creating Complex Decision Logic with InterSystems IRIS

Hello; I am using a custom class extending CodeTableDetail (actually it extends CodeTableTranslated) for a MedicalClaimLine.Extension property for a Procedure Modifier value, in addition to the existing MedicalClaimLine.ProcedureModifierItems property (this is a list of %String).  This works very well, stored AND translated correctly, until a valid ProcedureModifier value is used that is all punctuation: ##,  **, or ++.

I know that the CodeTableDetail objects can not match 1.P (all punctuation), as seen in the ToQuickXML method that writes out the SDA in XML format. If a Code is all punctuati

In the previous articles, we learned the basics of using IMAP protocol to handle messages from mailboxes in an e-mail server. That was cool and interesting, but you could take advantage of implementations created by other ones, available in libraries ready to use.

One of the improvements to the IRIS data platform is the ability to write Python code alongside ObjectScript in the same IRIS process. This new feature is called Embedded Python. Embedded Python lets us bring to our ObjectScript code the power of the huge Python ecosystem’s libraries.

In this article, we’ll use one of those libraries

Credentials for a Productions are stored as plain text in ^Ens.SecondaryData.Password and exposed as plain text via SQL table Ens_Config.Credentials which is not ideal as only admins should know the credentials.

I can create my own adapter etc... to store and use encrypted passwords but does anyone know if there is a standard way to do this in a Production?

Alternatively, am I missing how to secure this so the production can run and someone can monitor and operate a production without access to the SQL table or global?

This is the second article in a series on iKnow demo applications, showcasing how the concepts and context provided through iKnow's unique bottom-up approach can be used to implement relevant use cases and help users be more productive in their daily tasks. Last week's article discussed the Knowledge Portal, a straightforward tool to browse iKnow indexing results.

This week, we'll look into the Set Analysis demo, a slightly more advanced application where you'll be using the concepts identified by iKnow to organize your content into sets of documents. The original version of this demo was developed by Danny Wijnschenk & Alain Houf for an academy session at GS2015, but the app has evolved significantly since then.

Hi Developers!

Here're the technology bonuses for the InterSystems "Sustainability" Interoperability Contest 2022 that will give you extra points in the voting:

• Sustainability Topic
• Sustainability Dataset
• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter
• Production EXtension(PEX) Python, Java, or .NET usage
• Embedded Python usage
• Docker container usage
• ZPM Package Deployment
• Online Demo
• Code Quality pass
• Article on Developer Community
• The second article on Developer Community
• Video on YouTube

See the details below.

Note sure if anyone would know this.... But I presented my team with a Proof of Concept of running SAM to monitor our IRIS Development and Test Clusters.  In talking with them we would like additional OS metrics that aren't provided by what is built into SAM. Looking at more OS detail I found node_exporter from Promethus. I added node_exporter to our server that we want to monitor, but then tried to config isc_prometheus.yml to use node_exporter. That did not go well and when I restarted SAM, it would not download the built in metrics to SAM. Is it possible to use SAM and node_exporter to moni

Hi.

Why is %TimeStamp property not correctly imported with %JSONImport method - it doesn't take into account the time zone?

Regards,
Matjaž

Hi All,

I have a method like this and I want to be able to see the results on the terminal, how do I run this method on a terminal to display the results of this SQL query?

Method ResponseTimeCurrentMonth(namespace)
{
set oldNamespace = $Namespace
new $Namespace
    set $Namespace = namespace
    
    s timeTaken = 0, InDate = ""
    #SQLCompile Select=Display
&SQL(select InDate, AVG(Time_Taken) into :InDate, :timeTaken from (select SessionId, (TimeCreated) InDate, MIN(TimeCreated) Start_Time,MAX(TimeProcessed) End_Time, DATEDIFF('ms',MIN(TimeCreated),MAX(TimeProcessed)) Time_Taken FROM Ens.Message

Standalone Studio install includes UserImages.bmp image, with these contents:

I have never seen these icons anywhere in Studio, so where are they used?

Hi

This  morning I noticed that the ISCAgent.log for one of my high availabilty healthconnect servers has many entries that say:

"Mirror remote control command requested access to instance directory not found in registry."
Requested:d:\intersystems\healthconnect\

In addition, Messages.log has many of the following entries:

ValidateFailoverPartner: Failed: Server at SERVER:2188 (d:\intersystems\healthconnect\) sent /NE/ not /OK/...(repeated 20 times)

As far as I can see, nothing has changed on either server (01 and 02) and the arbiter they use is working correctly.

Any idea?

Andy

Hi Open Exchange Members and Developers!

We have changed user experience for your applications management on Open Exchange
Please let us know in comments or direct messages how do you like it?

And please do not hesitate to ask me any questions if you have ones.

PS: More updates are coming soon, we will keep you posted.

Hi All,

Can you help me how to extract SQL table data into a text file and generate the text file in a particular file path 

Thanks,

Smythee

Hi Community,

Here are two video demo's of Kozo Pages.

Hello,

I try to realize a simple test in a BPL and i have this kind of error message. I don't understand why ! I have a simple CSV file in input with 3 columns (Nom, Prenom, Age) and a rule based on the age

ERROR <Ens>ErrBPTerminated: Terminating BP TestSiJeune # due to error: ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zevaluateRuleDefinition+18 ^User.Person.IsJeune.1 *Age,User.Person.TransfoTest.Context -- logged as '-'
number - @'
if (((pContext.Age)>(25))) {'
> ERROR <Ens>ErrException: <PROPERTY DOES NOT EXIST>zevaluateRuleDefinition+18 ^User.Person.IsJeune.1 *Age,User.Person.Tr

Hi Community,

We're super excited to share with you a special session from Global Summit 2022! And it is so special to us because it is about us and with us! Please welcome:

🤩 InterSystems Developer Ecosystem @ Global Summit 2022 🤩 

Hello! I am currently creating a class for a small error trap. I have it working and all is good but I really want to change the order of the fields in the SQL return from Alphabetical to something else.  

The current Order is ID, ActionType, ErrorCount, ErrorDetails, Model, ResultCode, ResultMessage, Stock and Yard

I would really like for the field order to be ID, Yard, Stock, Model, etc.

Example of current order,  

Is this possible?

Thanks in advance!!

Is it possible to use integer with a higher precision so that something like this works:

ClassMethod BigNumbers()
{
    Set bigInt1 = 9223372036854775807Set bigInt2 = 9223372036854775808W !,bigInt1
    W !,bigInt2

    Set bigInt3 = 9223372036854775807123456789W !,(bigInt3 # 2)
}

9223372036854775807
9223372036854775810   // should be 9223372036854775808
0                     // should be 1

The docs say "... However, with extremely large numbers (larger than 9223372036854775807E127) it is not always possible to convert a numeric string to a Decimal value. ..."[0], b

Hey Developers, 

New video is already on InterSystems Developers YouTube channel:

⏯ Using the Business Process Designer in InterSystems IRIS

Hi Guys

I have a table data in one namespace that I want to access from another Namespace  - is that possible?

Cheers

We're excited to announce the launch of the Community Roundtable series!

Roundtable sessions are for you to learn new things and connect with other Community members. Each month we'll select a new topic, provide an overview and select a specific date and time for this event.

We drafted a couple of topics for the first roundtable to choose from, but most of all we want to hear what you'd love to discuss! 

Navigate >> to this challenge << on Global Masters to choose the topic and suggest yours.

UPD: Challenge is closed. Thank you for voting and ideas! We will be announcing the topic for the first session shortly.

Is anyone aware of how to find out if a UNICODE database has been installed on an 8-bit version of IRIS i.e. is there a way of checking and actual database rather than the IRIS instance version?

Hi Team,

                I am new to InterSystems. I am trying to setup DHTML editor with ActiveX control for Trakcare 2021.7 version. I am receiving Ensemble locally not installed error. Could you please guide me for using Ensemble in local windows machine

Hello guys,

Does anyone know what is a process status IPQW ?

We get it in jobs that do some SQL..

Thanks in advance.

Yaron Munz