Announcements

I'm wondering... what solutions if any, have users adopted in order to track changes made to the System Default Settings that hold environment-specific component settings ?

Do you manage to control access to, and track historical changes of, these values using Source Control system ??

thanks-

Steve

#Change Management #Ensemble

0 1

0 420

Question

CM Wang · Jul 16, 2017

How to index a class

I have two persistent classes defined. Lets call it Parent and Child.

Child class is one of the property of Parent Class.

I would like to define a index on Child class.

So what is the default behaviour I defined a index on a non simple data type member?

Any possibility that I could customized the behaviour ? For example. Child class has three properties.

Could I configure the index to index any combinations of these three properties?

Thanks for your help.

#Indexing #Object Data Model #Caché

0 1

0 672

Question

CM Wang · Jul 20, 2017

What is the most efficient way to store/retrieve the data into/from global

Type 1:

^global(key1,key2,key3,val1) = ""
^global(key1,key2,key3,val2) = ""
^global(key1,key2,key3,valn) = ""

Type 2:

^global(key1,key2,key3) = $lb(val1,val2,.....valn)

the number of val may be just dozens, but also possible to 10K

Thanks.

#Caché

0 1

0 358

Question

Rich Taylor · Oct 6, 2017

Starting Cache and Mirroring arbiter at HP UX startup

I need to have both Cache and the Mirroring Arbiter startup when the HP UX system starts. Having not worked on HP UX much I am not familiar with the method for accomplishing this.

I would appreciate any information or even sample scripts that would help resolve this.

#Caché #System Administration #Mirroring

0 1

0 440

Question

Kurro Lopez · Oct 20, 2017

Define PoolSize as system default value

Hi all,

For special definition of the company, we need to define a PoolSize according to the environment that the "Ensemble" is working.

So the first try as been add the parameter into "System Default Setting"

However, this parameter is not available in "Setting default values" in Setting tab.

I've opened the code of my production and I've noted that this parameter is a attribute of the XML element of this item

#Ensemble #Business Operation #Business Process (BPL) #Business Service

1 1

0 529

Question

Nadirbek Nurlybekov · Oct 26, 2017

Differences between INNER JOIN and ->

Greetings to all!!! Suppose there is a table Mother (ID, Name) and Child (ID, Name, Mother), Mother in the table Childis a relationship. Let's say the task is to deduce the names of all the children whose their moms' names start with the letter 'A', I can do this in two ways in sql, and I can not understand the difference, the pros and cons that when to use:

#Caché #SQL

0 1

0 468

Question

Jenna Poindexter · Nov 7, 2017

Custom Schema

Hi-

Please excuse my rather limited knowledge of HL7.

In Ensemble, I have a HL7 message that contains several Z segments. I have created a custom schema to represent the new Z segments along with the new DocType Structure and Message Structure

How does Ensemble/Health Connect know which custom schema to use? I believe it has to be indicated in the MSH segment somewhere, but not sure where exactly that would be. Is the version simply updated with the new schema name or is there some other field?

TIA

Ken

#HL7 #Ensemble #Health Connect

0 1

0 502

Question

Scott Roth · Dec 15, 2017

$ZSTRIP removing too many characters

We are seeing something funky when using $ZSTRIP.

w $ZSTRIP("ZZZZTESTSLOCKTEST","<","ZZZZTEST")
LOCKTEST

Shouldn't this be returning....SLOCKTEST and not LOCKTEST, the goal is to remove ZZZZTEST from the beginning of the string.

THanks

Scott Roth

The Ohio State University Wexner Medical Center

#ObjectScript #Ensemble

1 1

0 571

Question

Mikko Laitamäki · Jan 12, 2017

Open Atelier Class/Routine missing fullname option?

In Studio you can open class with typing / pasting full classname Ctrl+O dialogs filenamebox.

in Open Atelier Class/Routine Dialog (Ctrl+Shift+T) you can't give full class name (package.class) and

when typing only classname part it does not give you any hint about package of those classes it shows.

Its' a bit frustrating when we can have ( and we have) lot of classess named similarily in different packages

and we have lot of packages so the tree crawling is a bit slow.

0 1

0 280

Question

Tamer Rajab · Apr 3, 2017

Weekend

how to exclude weekend(Friday) in sql statement i trade use select datediff(WK,date1,date2) but not working even i chose (Dialect mssQL)

Thank You

#Caché

0 1

0 368

Question

Murali krishnan · Apr 7, 2017

Search functionality in cache Studio IDE

where is the search functionality in cache studio IDE of InterSystems ? Please let know

#Caché

1 1

0 364

Question

Stella Ticker · Apr 11, 2017

Multi-threading to improve performance

There is a large file that needs to be processed, with over 500 000 rows. Each row needs to be verified for various data and then all the results collated and reported into a single report. What is the most efficient way to do this? I tried calling the processing function with Job , where each function jobbed off would report results to a different node of a common global. But the jobbed functions are not updating their respective rows even though I am passing the global name and root node. What is the most efficient way to process this large file?

#Object Data Model #Caché

0 1

0 1.2K

Question

Murali krishnan · May 9, 2017

Intersystems integration with Security tools ( W3af and Iron Wasp )

Please let know if it is feasible to integrate Security tools ( W3af and Iron Wasp ) with intersystems. If so, please let know how to do that..

#Tools #Ensemble

0 1

0 321

Question

Sneha Ashok · Jun 5, 2017

How to Use the Custom Utility/method in the Ensemble

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.

#Beginner #Object Data Model #Ensemble

0 1

0 464

Question

Ruslan K · Aug 5, 2017

Problem with terminal font

I don't know what a problem with my cache cube terminal, but cyrillic text is not displayed correctly.

I have some terminal program with cyrillic menus, dialogs and other text and all those items are displayed wrong (unknown symbols like on the image).

How can I solve this problem?

#Caché #Terminal

0 1

0 428

Question

Soufiane Amroun · Sep 8, 2017

How to Edit Fields in an InterSystems Ensemble Business Rule

Hi world :) , i've a question about editing an ensemble rule:

how can i edit fields in a BPL rule with programming (i need to modify target value for a condition send label ).

until now i can edit only a condition value.

thank you for your collaborations

#Ensemble #Business Rules

0 1

0 525

Question

Stella Ticker · Nov 7, 2017

ZEN : Allow multiple date formats in a dateText control and converting them to the YYYY-MM-DD

There is a finite list of date formats that users want to use to enter a date in a form. These formats include single digits for month and day and double digits for year. The field is represented by a dateText control.

How would one get to allow a dateText control to accept multiple date formats ? I see only 3 listed here, do those include using single digits for month and day ?

#ZEN #Caché

0 1

0 500

Question

Stephen Wilson · Mar 14, 2017

How do you use text box filters in tablePanes that have complex SQL behind them?

I have a tablePane ZEN Component and I am trying to get a filter running on the Specimen Id / Lab Number. The SQL is fairly complex with 3 UNION ALL statements joining 4 tables and a couple of lookup tables.

How would I get the filter on SpecId to work for my tablePane? It's not automatically applying the filter for me so I think I need code something.

#Caché #SQL #ZEN

0 1

0 464

Question

Tom Philippi · Mar 18, 2017

Generating JSON message with attributes containing odd characters

I have a Enslib.REST.operation which I want to use to send a JSON message. In Ensemble I am using the request message to the Business operation as an input for ObjectToJsonStream function so I can send it out (this is the way to go right?). However, I am now running into the fact that one of the attributes (template_name) contains an underscore and that I am not allowed to use the underscore to define the property in my ensemble RequestMessage:

Property template_name As %String;

#REST API #Ensemble

1 1

0 404

Question

sansa stark · Apr 21, 2017

Cache 5.02 License Error

Hi All,

We are using the InterSystems cache 5.02
We having 80 license unit but don't the reason 50 unit have been consumed (CSP unit)
This happen because of this page ran frequently "/apps/docmatic/%CSP.SysConnection.cls"
Can anyone explain why this page ran frequently and consume license?

Thanks,
Sansa.

#CSP #Caché

0 1

0 211

Question

Sameera B K · Apr 26, 2017

Automation Testing

Which is tool/script use of Automating the Ensemble part? Is seleinium can be used. Please help me out on Automation testing

#Continuous Integration #Testing #Ensemble

0 1

0 567

Question

shobha rani · May 17, 2017

Soap Messaging

HI ,

Please let us know the solution to the below error which appeared during SOAP Wizard.

ERROR #5805: ID key not unique for extent '%Dictionary.ClassDefinition' : '^oddDEF("GuruBaseAllah.BLZServiceSOAP11porthttp")' exists. Id counter location = ''

Thanks,

Shobha

#Beginner #Caché

0 1

0 352

Question

Arpitha Ramakri... · Jun 6, 2017

Http connection through Ensemble

Hi All,

I am trying to pass a http request through ensemble production and fetch response.

Could you please advice us the steps to achieve this.

Thanks in advance,

Arpitha R

#Ensemble

0 1

0 317

Question

Jiri Svoboda · Jun 26, 2017

Integration of Caché and Ensemble

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.

#Beginner #Ensemble

0 1

0 375

Question

Nagesh Setty · Aug 23, 2017

Very trivial question.

What is the default user to login with "Healthshare Management Portal"

How do i reset system user password?

How do i add new user?

#HealthShare

0 1

0 320