Is there a datatype class with validation for global references? I can't find one in a brief scan of the documentation / class reference.

In System Administration | Configuration |  System Configuration | Journal Settings there is a check box for Freeze on error.

From reading the documentation, it sounds like the choice to freeze on error is one of system availability vs system integrity.

Curious to know whether Ensemble users choose to freeze on error or not.

If you have a best practice recommendation based upon your experience or knowledge, that would be helpful information too.

I am working with a client to try and export a set of tasks defined in the Task Manager from one system to another.  I am not seeing any API for this.  I can query this information in SQL.  So I tried to use the Data Export Wizard from the System Management portal in the SQL window.  Export was fine.  Importing failed with a "can't insert into read only field" error.  Looking at the class definition does not help since the implementation details are not visible.

So how would one accomplish this?  Export scheduled tasks from one system to another?

Hi Everyone!

Enjoy a new session recording from Global Summit 2017 on InterSystems Developers YouTube Channel:

Tell Your Story With Dashboards

Hi guys, I'm helping one of our customer to use unattended install to standardize their deployment. I'm using Unattended Installation and Installation Manifest. 

Although I can use the combination to install HealthConnect and then create namespaces and DBs as they need, there are still several tasks that I did not find the solution yet. As following:

1. Configure mirrors

2. Set the directory to store journals

3. For a given Ensemble name space, configure the period length in purging messages.

4. Set up some scheduled tasks to PurgeErrorsAndLogs or PurgeAudit

Ensemble 2017.2.

I am writing a DTL code action based on the solution described in the posting "How to avoid truncation in HL7 messages with very large fields (32K+)". Because the source value is in a repeating segment, and the specific repetition in which the value is located can vary, I would like to use a variable (specifically the k1 key) to specify the repetition to get.  I have been unable to get it to work.

OBXgrp is the location in the path at which the repetition occurs. Hard-coding an index, as in the example below, works.

Good afternoon, I have a tabGroup where I populate tabs with images using the scr property. If a user scrolls to the bottom of the image on a tab, when they go to the next tab, they are also at the bottom. When moving between tabs, I would like the user to always be presented with the top of the tab content. I have not been unsuccessful in doing this. Would someone have input on how to make this happen? Thank you in advance for any and all feedback.

I  have generated a class using the linked procedure wizard however  I can't get it to work if the  datatype  of one of the parameters is VARCHAR(MAX).  It works fine if I change it to say VARCHAR(500) and  rerun the  stored procedure wizard. 

I get the following  error returned.:

ErrorMsg:   SQLState: (07002) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

Can anyone see what I am doing wrong?  I think it is to do with the way I am using the  %Stream.GlobalCharacter?   Any help is much appreciated.

Class generated by linked procedure wizard:

Hi, Community!

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

Most viewed

Atelier 1.2 has landed!  190 views

Replacing ZEN - Part 2 - Strategic Issues  156

Atelier 1.2 Beta Updates - May 2018  149

##class( autocomplete for class names  136

working with Angular   132

Load data from excel   130

How to move defined tasks from one Instance of Cache to another  127

Database not mounting  124

Create table for the results of a SQL statement  123

Using Source Control with Atelier on existing code  116

Continuous Delivery of your InterSystems solution using GitLab - Index  109

In old Caché versions it was possible to create a new role based on predefined %Developer by copying it and adding some resources as needed. It was true at least from 2010.1 to 2015.1.

After upgrade from 2015.1.4 to 2017.2.1 it turned that it's only partially true now. User with a "New-Developer" role can enter Studio and open existing cls/mac/etc for editing and everything is OK unless he tries to create something new (Ctrl-N), than he gets a pop-up with %msg: <User xxx does not have enough privilege to execute stored procedure %CSP.StudioTemplateMgr_Templates>

Hi I am getting below error after rebooting Linux system and restarting cache services.

Daemons are running (shared memory object is missing)

cconsole giving error 3 Daemon WRTDMN (pid 28161) died. Freezing system

I was wondering if there is a way of adding additional headings under the settings tab for services etc?

I'm aware its possible to add items under the additional settings heading, but being able to split these out into separate headings would look a lot nicer.

While trying to start the instance INSTANCE001, getting below error, where cache.shid file doesnot contains anything.

This is in a Linux server.

Any help is appreciated.

$ ccontrol start INSTANCE001INSTANCE001 startup failed: Instance is down although there is process attached to shared memoryYou can get the shared memory ID in cache.shid filethen run 'ipcs -m -a' to see the number of processes still attached.

Is there any easy way to create a WebSocket to Telnet proxy within the Cache environment?

I would like to use a html5 telnet emulator to connect to cache, but need to create a proxy,

Is this a simple task?

%XML.Reader.OpenFile fails with SAX XML Parser-Error: <STORE> on importing large (1.5 GB) xml file. Any workaround for it?

My goal is one-time import of the file using classes generated by its XML schema.

Release 2017.2.

I have created a class that extends Ens.BusinessOperation, and in my class I have defined a custom property. How can I change the property's heading that is displayed on the Management Portal Settings tab?

We have received a dead job alert. We want to know when occurs this, I mean, Ensemble kills a job automatically if it is consuming a lot of memory or CPU? Or is the operating system who kills the job and Ensembe detects it and alerts?

I want to generate one of the following xml data, but after I generate only de="", after I need to generate is de="DEX71.41.009.01"

//// result:
<OPTREGISTER>
      <THBZ de="DEX71.41.007.01" display=""></THBZ>
      <GHFS de="DEX71.41.008.01" display=""></GHFS>
      <GHF de="DEX71.41.009.01"></GHF>
      <ZLF de="DEX71.41.009.01"></ZLF>
      <QTF de="DEX71.41.009.01"></QTF>
      <WDBZ de="DEX71.41.010.01" display=""></WDBZ>
      <GHKSDM de="DE08.10.025.00" display=""></GHKSDM>
</OPTREGISTER>

The classes I use are as follows:

Hi,

We want to monitor an Ensemble Production and send custom email alerts in function of some Rules. For example, if we normally receive 1 message per second, if suddenly we receive 5 or more messages per second, we want to send an email alert. And if tomorrow we don't want to check this again, we want to disable it through Ensemble Business Rules.

I have a vendor that is sending me an Abbreviation in FT1:16.4.2 that I need to look up against a table to find the correct ID for.

FT1|1|||20180523161501|20180523161503|CG|1906551^Lipid Profile|||1||||||^^^ LAB&06CL|||Z00.00||00410^Knerr^Joel||721410||30100001^Lipid Profile|

But in my Business Process when I refer to request.GetValueAt("FT1:16.4.2") its not recognizing that this field contains information. Is my syntax wrong?

What would be the best way to count all Interface messages on some Business Services and Operations in Ensemble? 

I need this to determine the volume of messages for a given week or month, would this be easier to do in SQL?

Hi All

I'm looking for the a simple-quick-easy solution to monitor a SQL table thought Ensemble.

I have a process that update a DataBase ,a scheduled task that runs every night  (Not Ensemble)

In the end it updates a table (replica_status) with a new recored with two fileds:  Id, DateTime

I looked around the community but didn't find an answerd case.

I'm thinking on a Task that will run a sql outboud adapter BO that checks that table and send a alert if no new record was created yesterday

is this the right approach or is there's a better solution?

Thanks Gadi

Hi everyone

I'm coding a script in order to validade an installation package following the steps:

If you're using Firefox, you probably know that there are search engine addons that allow us to use website search directly. Now, docs.intersystems.com is also available as a search engine here. Here's how it looks:

Has anyone used ClearRuntimeAppData,  I am using the EnsLib.SQL.InboundAdapter and pulls the SQL query fine, but if the service needs to keep pulling the same rows the next time the service is started but it will not, due to the parameter “key Field Name”

Hi Community!

New session recording from Global Summit 2017 is already on DC YouTube Channel:

SQL – Things You Should Know

Hello glabal masters,

I am trying to develop WAS using Cache and Spring Framework.

The ON DUPLICATE KEY UPDATE is not working.

Source : 

Hi everybody,

 I need to load data from excel to a class in cache, but this class has foreign key and property like AS ..... (other class). This class represent an item product that belongs to a line, the line blelongs a group and the group belongs a Category. 

Example:  

Hi,
I created a REST service that works well if called via VPN,  for example the url http://192.168.10.60:57772/fm/status returns a JSON string as expected.
If I replace the ip 192.168.10.60 with the ip used for our public website nothing happens. If I remove the port :57772 the browser returns a 404 error page.
Do I have to use a different port or is this caused by the settings of our web server? (We are using Apache Web Server: Apache Cache_Server_Pages-Apache_Module/2016.1.0.656.0-1601.1554d)  

Thanks in advance!

Hello; we have users on the system with cache logins.  They have access to a specific namespace, and no access to %SYS of course.  I'd like to give each user the ability to change his own password from within our application, using Security.User.PasswordExternal.  This only exists in the %SYS namespace, and the average user can't get to it.  

Should I give the users access to this column in this table (column Password, table Security.Users)?  What about access to the namespace?  Is this possible? Has anyone done this before?

Thanks,

Laura