Hi everyone,

I need submit a object have a json string as property of class, but I get an issue, object can't save to SQL table if I take json data to json property. I try making a test class with only json property and get the same issue, no data row in SQL table after run ClassMethod . Some one know what's problem, please help me. Here my test class:

Hi,

It has been pointed out to me that one of my applications fails to display all of the contents when displayed on an iPhone or a tablet of smaller res that a desktop screen.

Desktop..

iPhone..

The code does not change between the two views of the same page. 

To maintain easy alignment and control, I have used standard <tr> and <td> <table> codes, expecting same behaviour in any browser on any platform. My guess is using <div> controls for display will make a difference, but I'd be interested if anyone has any experience of this kind and if there is a simple fix.

The code snippet doing this displa

I'm new to Iris, trying to follow this guide ( https://community.intersystems.com/post/k-means-clustering-iris-dataset ) about using clustering. I've followed all instructions until showing the data. At that point, `dataFrame.show()` fails with `java.sql.SQLException: Access Denied`.

I'm using IRIS 2018.12.609.0 on Windows 10 Pro 64 bits. Python is 3.6.6, PySpark is 2.3.1, installed from Anaconda (Python 3.6.6 |Anaconda, Inc.| (default, Jun 28 2018, 11:27:44) [MSC v.1900 64 bit (AMD64)] on win32).

Along the road I had problems with Hadoop winutils, solved using information here ( https://stackov

I would like to know , if its safe to use %NOLOCK  in insert query while doing some parallel processing in Ensemble. We will have pool size of more than 1 for a business process. The  business process  does an entry in internal meta data table , which will be used for some internal reporting. The same row might get updated by some other process  later point of time.  i could not  produce any error or any issues . Looking forward to hear some opinion on this.

Developing a Full-Stack JavaScript web app with Caché requires you to bring together the right building blocks. In this third part of this article series I will show how to link our React app to our three back-ends we created in part 2.

I have an http adapter that calls out to a web service and is looking for a "Completed" response. I want the adapter to wait a certain number of seconds before calling out again to get a response. I have tried setting the retry interval on the business operation but that does not do it. See my code below.

While pResponse.StringValue = "Processing" {
set tSC=..Adapter.PostURL(tURL,.tHTTPResponse,,tId)
do tHTTPResponse.Data.Rewind()
set pResponse.StringValue = tHTTPResponse.Data.Read(3000000,.tSC)
$$$TRACE("Second Response: "_pResponse.StringValue)
}

Hi Community!

I'm pleased to announce that we've just launched the new product in the family of InterSystems Data Platforms:

InterSystems IRIS for Health

IRIS for Health — is the world’s first and only data platform engineered specifically for healthcare. It empowers you to rapidly create and scale the industry’s next breakthrough applications.

hi Community!

Here is the link: 

https://portal.xyvid.com/group/GS18

It will start now!

I would like to know if it is possible to backup a database via shellscript in Linux?

Thanks.

There are some classes in our code base that contain Methods only (no properties). I told my colleagues that converting them into the ClassMethods should improve performance as it would eliminate unnecessary OREF support at run-time. Some of them replied that it would be microseconds, so what is the reason to bother.

Is it possible to estimate the impact of OREF support of method calls at run-time? E.g., as a % of all CPU load. 

Hi Community!

We want to invite you to join the live broadcast in Developer Community Twitter!

@Evgeny Shvarov  and @Joe Lichtenberg will present "Using Blockchain with InterSystems IRIS"!

This session will cover the applicability of blockchain technology to address current business challenges, and will present a live application using InterSystems IRIS with blockchain integration.

It will start in an hour! 

Hi, Community!

This is a digest of the Developer Community postings in September 2018.

Most viewed

Atelier 1.3 Stable Release  324

Intersystems IRIS and the next applications generation  149

How the Intersystems IRIS ended to anemic databases era  141

Dynamic objects and JSON support in InterSystems products  141

UDL support  127

Global Summit 2018: Unconference topics to discuss  118

How I implemented GraphQL for InterSystems platforms  116

Is there a function similar to Oracle's CDC in the cache database?  116

Find a table given its name  113

parsing xml response  105

Most voted

Atelier 1.3 Stable Release  10

George James Software lunchtime meeting at Global Summit 2018  10

Save the date - DACH Symposium 2018  9

Sharding evaluation #1  8

Sharding evaluation #2  7

Atelier Source code versioning  5

Intersystems IRIS and the next applications generation  4

Global Summit 2018 - Make sure you hang out till Wednesday!  4

Developer Community September 2018 Release  4

New Video: Atelier – Debugging a Class  4

Most commented

How can I create properties (DocDB, Python)?  15

Is there a function similar to Oracle's CDC in the cache database?  15

parsing xml response  13

How to open Cache studio on Mac OS   11

Change time in message browser etc from UTC to local time  10

LDAP Connection/Configuration  9

class Ens.Queue visible to ODBC?  9

How to Open Terminal In Caché Mac OS  9

Impact of OREF support  9

Visual Report alternatives  8

Top 10 Authors to Follow by Views

Gevorg Arutunyan, Posts,  379

Yuri Gomes, Posts,  290

Robert Cemper, Posts,  190

Eduard Lebedyuk, Posts,  187

Dmitry Maslennikov, Posts,  185

Rustam Ibragimov, Posts,  127

Alexander Tsvetkov, Posts,  78

Mark Bolinsky, Posts,  60

Raymond Lawrence, Posts,  43

Irene Mikhaylova, Posts,  38

Top 10 Experts to Follow

Fred Gustafsson, Answers,  +5

Robert Cemper, Answers,  +4

Jolyon Smith, Answers,  +3

Nicole Aaron, Answers,  +3

Alexander Koblov, Answers,  +2

Tomas Vaverka, Answers,  +2

Len Goodkin, Answers,  +2

Herman Slagman, Answers,  +2

Evgeny Shvarov, Answers,  +1

Eduard Lebedyuk, Answers,  +1

Hi all.

As part of my dysfunctional journey with FHIR, I'm looking at using the SDA3 within Healthshare to then convert to the HSFHIR format.

This is working surprisingly well, except I'm falling over when it comes to repeating fields within the SDA3 when creating the HS.SDA3.Patient object manually from within Cache.

If I take the Patient ID as an example - within a DTL, I can quite easily take an MRN and add that to the target PatientNumbers.(1).Number and then add an NHS number to the target PatientNumbers.(2).Number.

My assumption is that I will need to build the list of PatientNumbers using m

InterSystems is pleased to announce that  InterSystems Caché and Ensemble 2018 are now released!

New in these releases are features that improve security and operations, including:

· Key Management Interoperability Protocol (KMIP) support
· Microsoft Volume Shadow Copy (VSS) integration
· Integrated Windows Authentication support for HTTP
· SSH enhancements

Has anyone successfully executed s (INTSFREEZE and INSTATHAW) scripts in atelier tool?

We are having issues with FREEZE script whereas Thaw works fine.

Would appreciate any inputs!

I created a Ens.Alert process and set my services Alert on Error as well an my message router. But I would also like to be alerted for warning types. Is there an setting to be alerted for this type?

Hi!

Did anyone try to serialize objects in Caché using Google Protocol Buffers? Your experience will be very helpful for me.

Thanks!

Hi all,

I want to export a production in one file, but it has some code in macros, include and class files. I'm exporting using portal (Classes / Select All / Export) but I need the same in macro's tab and copy the content in one file.

The following class method "test" contains code that can create a new class, create new properties for classes, or create new methods for classes. "test" runs all three of these processes once, and the code that performs each action is labelled by comments in the method:

ClassMethod test() As %Status
{
	set sc = $$$OK
// Create a class
set class = ##class(%ClassDefinition).%New("MyClass")
set class.Description = "This is my test class"_$c(13,10)_"testing %ClassDefinition"
set class.Super = "%Persistent"

// Create a property and add it
set property = ##class(%PropertyDefinition).%New("MyClass.MyProperty")
set property.Type = "%String"
set property.Description="This is a property"
set sc1 = class.Properties.Insert(property)
do:$$$ISERR(sc1) $system.Status.DisplayError(sc1)
set sc = $$$ADDSC(sc, sc1)

// Create a method and add it
set method = ##class(%MethodDefinition).%New("MyClass.MyMethod")
set method.ReturnType = "%Integer"
set method.FormalSpec = "x:%Integer,y:%Integer=10"
set method.Description = "Return product of x and y"
set method.CodeMode = "code"
set method.Code = " new result"_$c(13,10)_" set result=x*y"_$c(13,10)_" quit result"
set sc2 = class.Methods.Insert(method)
do:$$$ISERR(sc2) $system.Status.DisplayError(sc2)
set sc = $$$ADDSC(sc, sc2)

// Save the class definition
set sc3 = class.%Save()
do:$$$ISERR(sc3) $system.Status.DisplayError(sc3)
set sc = $$$ADDSC(sc, sc3)

return sc
}

Here's a link to the code on GitHub

Let's say I have something like this:

Query ClientList(BusinessType As %String) As %SQLQuery (CONTAINID = 1, ROWSPEC = "Name:%String(MAXLEN=100),AltName:%String(MAXLEN=100)") [ SqlProc ]

{...}

Is there a way I can specify the MAXLEN by a function or a calculated method?

Like maybe:

MAXLEN=#(..GetLengthName())#

Or is this something that has to be hardcoded in Studio?

Hi Community!

New video "Choosing a Shard Key" is available now on  InterSystems Developers YouTube:

Hi I'm just trying to make sure I'm not missing a trick here.

Basically our PAS doesn't do hl7 messages but does some XML which you can create. So I'm just trying to create some xml files and then get healthshare/ensemble to parse them and to process accordingly. 

I'm getting some good results doing this. But maybe I've got a small hitch. In each of my xml files I've the data for the patient/client. 

Then in the xml schema which I've imported I've specified the elements. I've created a subtransform which has helped when converting but perhaps I should have created a schema for the client which I

Hi,

I am running terminal on Cache on a Mac High Sierria and going through the ObjectSript tutorials.

However there is no instruction on the Intersystems website as to how to open Studio.

Does anyone know how this is done?

Thanks

I"m doing a SQL insert in my BPL, one of the fields in my SQL table is an MSSQL TimeStamp. How do I get the date/time from my HL7 message and format it so that I can then insert it into my TimeStamp column in my SQL table? I've tried lots of different combinations.

I used CONVERT(DATETIME, substring(:request.GetValueAt("EVN:RecordedDateTime"),1,8)) to get just the date portion and it works, but I'd like the whole DateTime inserted into my TimeStamp field. This is an a BPL.

Thanks

Hi Community!

I'm pleased to announce that InterSystems IRIS is available on Microsoft Azure Marketplace!

→ InterSystems IRIS on Azure Marketplace

This is the second public cloud offering of InterSystems IRIS after recently announced Google Cloud Platform support.

I followed the First Look instructions and tried to run a Docker container with the below command:

> docker run --name iris --detach --publish 52773:52773 --volume /Users/docker:/external --env ICM_SENTINEL_DIR=/external iris:latest --key /external/iris.key --before "/usr/irissys/dev/Cloud/ICM/changePassword.sh /external/password.txt"

It returned with a container ID and an error message:

docker: Error response from daemon: OCI runtime create failed: container_linux.go:348: starting container process caused "exec: \"/iris-main\": permission denied": unknown.

"docker ps -a" shows that the status of

Does anyone know how to loop through a segment that is part of an ordered set in a Business Rule and if one of about 10 possible values exist in any of the iterations of the segemnt:field I then allow the message to be skipped?

It seems like it should be fairly simple, but i am having a difficult time figuring this out. The Contains function only allow for one value to be identified. I have tried the intersectsList and while I think I have it formatted correctly i believe it only allows for 4 values to be verified. 

How can I change Ensemble's time from UTC to local? For example, I want that time in the message browser and event log to be local, but now it is UTC. I tried to find some setting around management portal but couldn't find it.

Hi Everybody!

We are pleased to invite you to the upcoming webinar "Continuous Delivery Using Containers" on 21st of August at 10:00 (Moscow time)!

I want to analyze the journal, but the journal seen in terminal seems to be incomplete.

So how to transform journal into complete plain text.

My installation package is C2010_1_6_952_0_11445_x64.exe.