Greetings all,

I have a quick SQL question.  I am working with a class, which has a calculated property, which in turned indexed.
The calculation for this property is created based on another property value via: 
SqlComputeOnChange = attributes  - so basically every time I add a property attribute to my class, my new property 
is calculated based on some SqlComputeCode which calls some class method.

That initial setup works as designed.

Question: If my code for whatever reason gets to a ROLLBACK, does the calculated property always rolls back,
and it's index always cleared?

Hello,

We are trying to migrate all our production to new IRIS servers. To test everything is working fine, and to be able to script the process, we want to import the data into new IRIS servers using a backup file (created with ^BACKUP). But we've found that IRIS doesn't recognize Ensemble backups so we can't import it using ^DBREST  :-O

Any of you know how to import in IRIS an Ensemble backup file?

Thanks a lot,
David

 So, I think this can be done but cannot remember how.

Inbound message goes:

MSH

PID

PV1

ZIF

OBX

We want outgoing message to be 

MSH

PID

PV1

OBX

ZIF

Do I need to create a new schema to make that happen?

Thanks,

Tim

Containers

With the launch of InterSystems IRIS Data Platform, we provide our product even  in a Docker container. But what is a container?

The fundamental container definition is that of a sandbox for a process.  

Containers are software-defined packages that have some similarities to virtual machines (VM) like for example they can be executed. 

Containers provide isolation without a full OS emulation. Containers are therefore much lighter than a VM.

EnsLib.HL7.Message.cls provides many API methods for manipulating an HL7 message.  RemoveSegmentAt(), for example, can be used to remove a segment by path or index, but only one segment at a time.   There may be times that you'll need to remove all segments within a group or even many groups of segments from the HL7 message.  Surely you can iterate through each segment in each group and remove them one by one, but there's a much easier way. 

With just one command, like below, you can remove all OBX segments in an ORU_R01 message (msg):

Set tSC = msg.SetValueAt(,"PIDgrpgrp(1).ORCgrp(1).

Hi

Totally new to IRIS and Cache.

Trying to evaluate it and work out how we could use it.

As a standard application database. Object or relational etc. does not matter. 

Issue is ObjectScript.

So:

1) Can we develop, maintain and use an IRIS database and never use ObjectScript i.e. use only Java, Python, C++ interfaces etc. (exactly which one does not matter)? Would that make designing and using the IRIS database more prone to inefficiency and error?

2) Can we import an existing Cache database into IRIS and convert its ObjectScript code into Java, Python whatever?

Hi,

Need your help on executing  ##Class(Backup.General).ExternalFreeze() and ##Class(Backup.General).ExternalThaw()   operations in

Atelier REST API setup. Please provide us example code if any.

I need to write a script to answer a couple of fairly simple questions:

1) What is the current routine DB (name and location) for this namespace?

2) What is the current data DB (name and location) for this namespace?

3) Is global ^ABC mapped to a different location than the default data DB?

Can anyone point me to some system APIs that would allow me to answer these questions?

Thanks!

Ben

Hi,

Trying to build a passthrough based on ASTM . I have created 2Way TCP/IP Business Service and specified a PORT (as Adapter Settings). The Source system is broadcasting from  IP 20:30:100:100 , Port 10000 . Ensemble is on 20:40:40:100 , What is the possible change that I have to implement to receive this broadcasted messaged ? . Should the Ensemble Server be on the IP range to receive the broadcast ? 

Many Thanks, 

Hi Community!

Please welcome a new video on InterSystems Developers YouTube Channel:

Continuous Delivery with Containers

Hello,
Fellow community members, here is an extendable / re-usable / generic pub-sub model.
An initial calling service reads a CSV file, parses through all records and transforms it to a generic JSON message.
The message is then transported via a pub-sub business process to the end-points Targets (business operations)
as configured for the subscribers for each Topic as demonstrated in the image below.

Steps and flow to implement this are as follows
1. Service 
a. Read a csv file, loop through all records
b.

Hi Everyone! 

We are pleased to invite you to the InterSystems Iberia Summit 2018 on 27th of November in Madrid, Spain!

Hello 
Please I have a problem to save all name of files attached in table with date and load all files attached in directory 
My code HTML
-------------------------------------

<cache block="INC_REAPRO">
  <form method="post" id="formupload" enctype="multipart/form-data" action="cache-call:SubmitUpload^MyMac" data-upload-url="cache-call:FileUpload^MyMac">
    <input type="hidden" value="##/SERIENR##" name="SERIENR" />
    <input type="hidden" value='' name="FILE" id="upload-select-hidden" />
    <div id="upload-drop" class="uk-placeholder">
      <div id="upload-text" class="uk-text-center">
        <i

Hi,

I ran into the Issue https://hibernate.atlassian.net/browse/HHH-10620. The workaround  described at https://community.intersystems.com/post/support-java-hibernate-5 worked for me. I'm using Hibernate Version 5.3.2.Final.

It would be nice if someone from InterSystems could fix the the problem in Hibernate. That was mentioned in https://community.intersystems.com/post/support-java-hibernate-5 but it doesn't seem to have happened.

InterSystems IRIS Data Platform™ version 2018.2 is now available as a preview release.  This is the first release in our new quarterly continuous-delivery (CD) release stream.  (Check out the announcement about InterSystems’ new release cadence for InterSystems IRIS)

Hi,

Most of my classes are mapped from Globals. I want to access Cache classes from a BI software through ODBC connection.

'Last update' information does not exist in most of the classes. My question is whether there is a 'last update' timestamp that is automatically generated for each line in classes I can extract to external systems?

Thanks

Hey Developers!

New session recording from Global Summit 2018 is available on InterSystems Developers YouTube Channel:

Using Blockchain with InterSystems IRIS

Can anyone tell me how to discover in ObjectScript the operating system and operating system version that Caché is actually running in? (Not the operating system the build was compiled for.)

Is it possible to lock down health insight so a client can only query their own patients? and Is there a way to use a visualization tool like Tableau instead of the dashboard of DeepSee while still querying from DeepSee?

I need to dynamically create a class based on a parameter passed into a class method.  Basically the method takes in a string that contains the name of the class I need to create a new instance of. 

I need something along these lines. 

ClassMethod someMethod(className As %String)
{
	set classObject = ##class(className).%New()

...
}

Trying to do this right results in a class not found error because it seems to be treating the variable as a literal string.

For example for Evgeny Shvarov, Comments tab shows 838, but there are no comments shown:

https://community.intersystems.com/user/11016/comments

Dmitry Maslennikov, Comments tab shows 375, but no comments are shown:

https://community.intersystems.com/user/11906/comments

I am working on my first REST operation concept and had a question about the Property Parameters. If I put a value in CAPTION, does that mean that when I use it in my call that it will come out in the URL?

For example...

Property enumerationType As %String(CAPTION = "enumeration_type");

Then in my operation...

Set tURL=..Adapter.URL_"?q="_pRequest.enumerationType

Do you think our editor has too many unused features?

I propose removing some, so it would look nice & clean!

Here's some buttons that I think we really can let go. 

What do you think?

By using the screen "Message Viewer", which parameters have to be specified to know if a segment HL7 exists ; for example, OBX?

Best Regards.

Working on implementation FHIR to my project, I found interesting project HAPI-FHIR, which could help me to quickly launch my FHIR api server with InterSystems Caché as a storage, because this projects uses Hibernate to connect to database, as an example they use DerbyDB. I tried to change settings to use InterSystems Caché, but unfortunately it does not work and throw some errors inside HIbernate. As I found in Caché documentation, I have not some many options, I just have to set Cache dialect, and set database url.  This projects uses Hibernate 5.

Hi Community!

Here is the digest of what has happened on the InterSystems Open Exchange in October 2018.

Application Releases

We had 12 releases in October:

Design Pattern in Caché Object Script v.1.0 

Ideal ObjectScript v.2018.1

Caché Simple Rule Engine Example v.2017.1

Adding tools in Studio Caché Intersystems v.1.2

Execute Server Commands from Caché / Ensemble / IRIS v.1.1

IRIS API EXPLORER v.1.0.0

String Datatype - Regular Expression v.1.0

Debug Stack v.1.0

Ethereum Interoperability Adapter v.2018.2.2

Yape v.1.0.0

Hi Everyone,

I am trying to built a SSIS package thru BIDS Visual Studio 2013. My Datasource is a InterSystems Cache Database, I wanted to Import Tables records from the Datasource to MS SQL Server 2014.

As a Sanity check. I only created one Package to import one Table to MSSQL Server to try out. The connection to the InterSystems Cache Database was successful. The DSN for the InterSystems Cache Database is created in the System for 32 and 64 Bit.

Here is where my Problem lies.

Hi, I want to create a service which on start will simply go through a list of values in a global and compare dates. If criteria is met, it will send an email.

But what kind of Adapter do I use? I see SQL, FILE, HTTP etc..etc.. But I dont want to use them

Please can you advice on how I should go about this?

Should I create a BS. Class and do onAdapterTASK() and simply build a method? Even then it is asking the kind of adapter I want

Would appreciate some guidance on this

Regards,

Eric

Has anyone worked out a way to use LDAP to define the default namespace on multiple servers?  I know that documentation says that intersystems-Namespace-xxx only supports one namespace, but how is this useful?   Any workaround to say have  intersystems-Namespace-server1-namespaceA  and intersystems-Namespace-server2-namespaceB?  Is it best practice to use the same "namespace" on every server?

Thanks!