I just tried to read all the Answers and Comments for a post of mine.

Some were 5, 8, 3, etc. days ago and others were just hours ago.

They all seem jumbled up.

If I wanted to read the Answers and Comments in some sort of chronological order, I would be lost.

I don't understand the reasoning on whether somethings is an Answer and others are comments.

But would it be possible to have the option when reading all the follow-ons to re-sort them in some sort of order?

June 26, 2017 – Alert: Data Corruption with Mixed Endian Mirror Shadowing

InterSystems has corrected a defect that may result in corruption of Unicode data on a shadow system whose source is an async mirror member.

This defect affects all currently released Caché, Ensemble, and HealthShare distributions beginning with version 2012.2.0.  All platforms and operating systems are affected.

In order to be exposed to the risk the configuration must include mirror primary and async members, and a shadow of the async member.

Hi,

I am trying to create a new dashboard using zen page for different namespaces. Could someone give me a sample code on how I can start designing the page for different namespaces in a single zen page/zen application.

Hi,

I would like to retrieve the O.S version (Windows or Unix) and Cache installed directory.

which COS apis should I use ?

Thanks for your help.

I noticed this morning that a post to which I had responded was apparently deleted by the original poster. In most other discussion fora, once a post has any sort of followup, only a moderator may delete the thread.

Nothing significant was lost in my followup, but I'm concerned that good information may, at some point, be lost due to the OP changing their mind about the original topic.

Thoughts? Comments?

(I don't plan to delete this post )

I would like  to invoke some unix/windows commands from COS, any API could do that?

Also, I would like to set up  some Environment Variables for this process which would execute  the above external command.

Anyway to achieve that?

Thanks for your help.

Hi, Community!

A few months ago we introduced votes for postings.

Hi,

We have a method written in cache studio that converts XML file to JSON and JSON file to XML,  Can we use this method in ensemble production.

This post is originally posted on GitHub.

This discussion is open to anyone who use or know about WebTerminal project. It is a result of a long story of the project development, testing and maintaining.

While WebTerminal greatly improves user experience by enhancing standard terminal with additional features, there are numerous issues (#77, #92, #81, #87 and others) showing that it performs not as expected in some cases, and does not support some very basic things (like $ZA/$ZB variables). The reason is in fact that WebTerminal project tries to reimplement Caché TERM behavior over Caché

Hello community,

I would like to know answer to the question: What would be an optimal way to connect an Ensemble and a pure Caché server? Optimally in such a way for the Caché system to be able to fire Ensemble processes and the Ensemble server to call Caché server functions.

InterSystems is pleased to announce the availability of the Caché and Ensemble 2016.1.4 maintenance releases.

For a complete list of the corrections, please review the release notes.

Caché and Ensemble 2016.1.4 are available on the same platforms as 2016.1.3.  For complete platform details, please refer to the Supported Platforms document.

Availability of HealthShare Health Connect will be announced separately.

The version number of the kits for these releases is 2016.1.4.104.0

Class documentation:

class %Exception.General extends AbstractException

Simple exception class that can be throw in user code. You can throw this with code similar to:

	Throw ##class(%Exception.General).%New(name,numericCode,location,data)

The name is a string name for the exception, the numericCode is a numeric error code. If the location field is blank and $$$envCallerErrorInfo is defined then the system will attempt to fill in this location where the exception was thrown from automatically. You can pass additional exception data in the data argument.

Does any boding knows how to set the

Is there a way to use a HL7 field value as part of the File Naming in the Business Operation FileOperation class.  I know we can do this in a custom class, but I was wondering if it could be done the default FileOperation class?

Example:

MSH-4 contains the value 12345

We would like to name the file 12345_YYYYMMDDHHMMSS.HL7

MSH.4 value here_%Y%m%d%H%M%S.HL7

It may not be possible, but I just want to see if anyone has any information

Thanks,

Kevin Brown

Hi Community!

Check the new video of the week on the InterSystems Developers YouTube Channel:

Adding Alchemy to Unstructured Data

Hi all,

I trying build a project with .NET and Entity Framework in the Code First method, but Caché return the error " 'VARBINARY' is not a supported type for CAST" when run this sql code:

INSERT "dbo"."__MigrationHistory" 
       ( 
              "MigrationId", 
              "ContextKey", 
              "Model", 
              "ProductVersion" 
       ) 
       VALUES 
       ( 
              '201706131048154_InitialCreate', 
              'CACHE2.SchoolContext', 
              cast( 0x1F8B0800000000000400CD59CD6EE33610BE17E83B083A1 ... d89cc74ff4e1285e7df81769242ce52e1f0000 AS

Hi There

New to the cache sql commands looking for how to create a parameter within a sql statement like with MSSQL is @ and Oracle is : 

What is cache's?

I try to find a function, which generates hash values of columns. In MS SQL Server I can use

select hashbytes('sha2_256', my_column) ...

to create hash values of my_column. Is it possible to use such things in Caché?

Thank you
André

Hi, Community!

Today we deployed new DC release which delivers.

Better subscriptions

All subscription settings now placed in one page, unified and simplified.
 

You can subscribe to Posts, Tags, Groups and Members and you can view it all, or filter by category on one page.

you can search for the subscription in case it's a lot and alter if you want to subscribe for the comments for every post with a given tag or group.

If you want to turn on or turn off the emailing from the site - there is one switcher for it: receive notifications.

Permalinks and answers

Comments and Answers have permalinks now. 

S

When working at a terminal prompt the %SS routine lets me see what's running on the instance:

USER>d ^%SS

But sometimes I'm only interested in knowing what's running in my namespace. In which case, here's what I use:

USER>d THIS^%SS

Recently I was conducting a remote support session with a site. The desktop they were sharing with me was on a PC configured with German as the native language. Since my German is rather rusty, and virtually non-existent when it comes to computing terms, I was glad to be able to switch the Portal session into English.

This is done from the page that appears when you use the About link:

All I needed to remember was that the About link is the second one, and the language selection dropdown is at the foot of that page.

The top of my Answers tab looks like this:

To get to the question, first I have to click on the "Answer:" text (which only gets the appearance of a hyperlink when I mouse over it).

That click takes me here:

I now need to click on "Back to question page" in order to get where I want to be.

I suggest you put the "Back to question page" and its preceding checkmark (which denotes whether or not my answer was accepted) onto the "Answers" summary page in place of the "Answer:" hyperlink that doesn't look like a hyperlink.

Hi, Community!

I'm pleased to introduce John Murray as a new Developer Community moderator.

John is constantly posting helpful articles and answering questions showing the great knowledge and experience in InterSystems technology.

Recently John kindly agreed to become InterSystems Developer Community moderator and joined InterSystems moderators team!

Here are some details John wants to share:

I am Senior Product Engineer at George James Software (http://georgejames.com), where I have worked for nearly two decades.

I have specialized in InterSystems technologies and their predecessors ever since my

It is possible to update Cache object property from Python using the following Python code, with import of intersys.pythonbind3:

my_object.set("my_property",["A","B","C"])

However, I am unable to save 2D %List with 2D Python array like the following:

my_object.set("my_property",[["A","B","C"],["1","2","3"]])

I am not sure whether this is Python-Cache bind flaw or design issue. Is there any alternative/ workaround to do the same for above?

Hi, Community!

How do you store the source files of your Caché project? What is the directories structure? What are the benefits?

I prefer the following structure:

/cls/package/subpackage/class.cls

/mac/package/routine.mac

/int/package/routine.int

/inc/macro.inc

/dfi/folder/sample.pivot.dfi

Example

Benefits: 

• folders are packages.
• easy to understand what type of sources are in the project.

What is your approach?

Hi,

I want to attach one local namespace on instance A to the database on instance B.

How could I use ECP to achieve my goal?

Should I config instance B as ECP data server? If so, how could I explicitly specify which database on instance B could be exposed ?

Thanks for your help.

Hi, Community!

And so I continue with publishing of the tasks for the Final round of InterSystems Contest on InterSystems Caché and DeepSee as a part of IT Planet Student Championship in Sochi. This year we had about 2 000 participants in InterSystems Contest.

One of the tasks for the finals was to crack the black box!

This article appeared in the feed, but the "last answer" and "last comment" links point to https://community.intersystems.com/post/can-you-crack-black-box#node-43… and https://community.intersystems.com/post/can-you-crack-black-box#comment… which belong to a different post.

Hi all,

I have a non objectscript application connecting to a cache instance via ODBC and one column is a list of serial objects. The output from the query contains a lot of special characters and I'm hoping there's a better way to get this data back so I won't have to perform extensive parsing on the application side.

I've tried using the $ListToString() function, but that didn't help much, probably because the list contains complex objects rather than primitives. 

Any help will be greatly appreciated!

In Cache Studio there is export class dialog with options "Export current project" and "Include dependent classes".

Is there any way to export class programmatically, but with same effect as if "Include dependent classes" was checked? So that not only the class itself is exported, but also all dependent classes? I know of Export method in %SYSTEM.Obj class, but it only exports the class itself.

Hello,

I have a question related to running an SQL query for range of data.

I am running a query like:

Select A,B from table_name where A>=12345 AND A<=12390

 - Where A and B are my two of the properties under the mentioned table/class definition

- A is an integer property

 Question: The result of the above query does not return me all the values between the mentioned range of integer though I do have all the values in that range. I see that some of the values are missing in result.

Any reason why this query won't work?

Any ideas?

Thanks,
Aditi