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

I wonder whether it is possible to use

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.

do source.GetFieldStreamRaw(.stream,

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:

Inclu

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

Manual Setup

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>

The solution found was simple:

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:

////// ------ Test.Common.PropertyParameters cls
Class

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:

In some specific cases I will need to terminate the current process and start a new one with some new parameters.
With any code inside my try catch block, whenever I terminate the process I receive a RESJOB and it works perfectly.
When my job is running a compilation ($SYSTEM.OBJ.Compile(.classes)) and receive a RESJOB, it does not catch the exception.

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 : 

INSERT INTO 
            ocsGUMCHECDINFO (CODE,DODATE,NAME,DAY,PURPOSE,REQUIREMENT,BEFORENOTE,AFTERNOTE,CNT,REPORT,CONSENT,CONTACT)
        VALUES
            (#{code},#{doDate},#{name},#{day},#{purpose},#{requirement},#{beforeNote},#{afterNote},#{cnt},#{report},#{consent},#{contact})
        ON DUPLICATE KEY UPDATE

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:  

Property bdGrupo As Innova.CL.Core.BD.Operacion.Producto.Grupo;Property bdLineaPR As Innova.CL.Core.BD.Operacion.Producto.Linea [ Cardinality = parent, Inverse = bdProductoCH ];Property bdCategoriaProducto As Innova.CL.Core.BD.Operacion.Producto.Mantenedor.CategoriaProducto;Property Portafolio As %Boolean [ InitialEx

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

Hi Guys,

I'm upgrading Cache 2008 to 2014, and for two clients so far all good, but with this third one and while trying to mount the main database that includes the data, I'm getting error #36 "database is not mountable"!?

but cache instances the old 2008 and the new 2014 at installed the same way (8 bit) and Cache.dat is (archive) NOT read only so I don't know what could be the problem?

Thanks

We upgraded from 2017.1 to 2017.2 today and noticed that when shutting down we must do it as an administrator.  Attempting to shut down as a non-admin result in a failure to shut down message.  We are curious if there was an issue with our upgrade or if there is a change that requires an administrator to shut down Cache in 2017.2.

edit:

Operating System is Windows Server 2012 R2.  We run Cache in a cluster using Windows Failover Cluster where we swing the drive from one machine to another when failing.  

Interesting to see this latest ranking come to my attention:

http://db-engines.com/en/ranking/graph+dbms

Look what's ranked 16th.  Shame a decision was made to deprecate it 

I want to create an interface specific purge job. Please let me know if there are any holes in my approach. I realize that an interface that went from HospitalAService to HospitalARouter to PracticeBOperation would require two separate executes in my example below, but I want that granularity as there are some intermediate steps in our workflows that we don't need to retain messages for.

1. Create a custom scheduled task that extends Ens.MessageHeader
2. Overwrite the Purge function select statements
   
   1. Integrity
      
      1. Old
         
         • DECLARE C1 CURSOR FOR
            Select TOP 100000000 ID,MessageBodyId,MessageBodyClassName Into