Hi everybody,

I use atelier form my developments,

i use Routine file and i remark that not all methods don't appear in Outline if in a method we have the sql stattement &sql(...) (see the copy screen)

if the sql stattement is not in the method1 we see i Outline the 2 methods

have you a workaround to resolve this problem ?

Thank you

regards,

Eric

Hi, Community!  

Please find a new session recording from Global Summit 2017:

Optimizing SQL Queries

When selecte the menu Navigate/ open atelier class routine it shows all available classes.

Duplciate classes are shown multiple times without a package structure (see example below). 

Is there a way to visualize the package structure in the “open atelier class routine”?

Best Regards 

Roger de Coninck.

Just starting to use Atelier and having problems with making server connections. I have tried both the super server port and the web server port and both fail with either Unexpected end of file from server (Secure connection disabled) or PKIX path building failed (Secure connection enabled). On a different server I get Connection refused: check the web server configuration.

Anyone run into this before?

I am working my way through some SQL documentation.

The documentation follows and my question comes after.

A query supplied to %Prepare() can contain input host variables, as shown in the following example:

  SET minage = 80

  SET myquery = 3

  SET myquery(1) = "SELECT %ID AS id, Name, DOB, Home_State"

  SET myquery(2) = "FROM Person WHERE Age > :minage"

  SET myquery(3) = "ORDER BY 2"

  SET qStatus = tStatement.%Prepare(.myquery)

This talks about input host variables

I thought that input host variables only work with Embedded SQL, not Dynamic SQL

Thank you

Hi all,

We have migrated our Ensemble instance from Healthshare 2016.2.1 to 2017.2.1, after all process we are checking that all namespaces are working propertly.

The first problema was checking a business operation that calls to a WebApi with the following error message:

ERROR <Ens>ErrException: <OBJECT DISPATCH>zMessageHeaderHandler+14^SALUTIC.MyUsers.BO.UsersREST.1 *Set property %SuperSession of class SALUTIC.MyUsers.BO.UsersREST is not a direct reference and may not be multiple SET arg --  - registrado como '-' número - @'     Set (..%SuperSession,%Ensemble("SuperSession"))=pRequestHeader

I have used Studio's schema wizard to create classes representing my XML structure as defined in an xsd file and then I use the main class of that set of classes as parameter in my Ensemble web service.

Let's say I have a web method signature like this:

Method myMethod(message As My.Schema) As %String [ WebMethod ]

How do in that method take this message and convert it into a EnsLib.EDI.XML.Document?

My.Schema extends both  %Persistent and %XML.Adaptor so I guess there should be some simple way to create an instance of EnsLib.EDI.XML.Document out of it?

EnsLib.EDI.XML.

Hi. I am newby in Cache. My source code at below. I have problem in Relationship property. Could you please help?

 /// 
Class Test.Book Extends %Persistent
{

Property Name As %String;

Property Author As %String;

Property ISBN As %String;

Relationship Chapters As Test.Chapter [ Cardinality = children, Inverse = bookid ];

}

 Class Test.Chapter Extends %Persistent
{

Property Name As %String;

Property Page As %Integer;

Relationship bookid As Test.

Hi

Is it possible to change the input format of the date filter for a zen tablepane component column when setting the filterType="date"? It only seems to accept odic format.

Cheers

Iain

I don't quite understand the %NOMERGE mentioned in the documentation.

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_from#RSQL_from_nomerge

Is there any specific example provided to illustrate the idea?

Thanks.

Several $System.OBJ methods have ByRef errorlog argument:

Compile(ByRef classes As %String = "", qspec As %String = "", ByRef errorlog As %String, recurse As %Boolean = 0)

ImportDir(dir As %String = "", wildcards As %String, qspec As %String = "", ByRef errorlog As %String, recurse As %Boolean = 0, ByRef imported As %String, listonly As %Boolean, ByRef selectedlist As %String)

What's the best approach of working with errorlog?

Do you convert it to status? If so - how? Manual iteration over local?

Is there some system method to convert it into %Status?

Hi All,

      I'm trying to send workflow TaskResponse, in my interface.

Steps:

Create SOAP Service and send process raise <call> workflow sync task.

How can to achieve this? Is this possible via SOAPUI tool?

Thanks,   

I seem to be getting some odd behavior from Ensemble when searching using the extended Criteria options (VDoc Segment Field).

I'm searching for a specific range of test patients (for example, Surnames starting ZZZ) and I'm only getting back about half of what I know is there (and is verifiable by removing the search criteria and manually scrolling through the message viewer.

I'm not maxing out the page size, and it isn't a case sensitivity issue. I'm also seeing some odd behavior when adding a date/time range to this.

Hi Guys,

I would like to develop a login page in Zen mojo application with Desktop and mobile application.  It should be adopt with desktop, android and iOS application.

If any lead would be appreciated. 

Thanks,

Arun Kumar D. 

Howdy Developers of InterSystems Ensemble,

Has anyone experienced an alert generated from a business operation (BO), which uses EnsLib.SQL.OutboundAdapter? That comes with an error message as below:

ERROR #6022: Gateway failed: Execute. + ERROR <Ens>ErrGeneral: SQLState: (HY000) NativeError: [10054] Message: [Cache ODBC][State : HY000][Native Code 10054] [d:\cachesys\bin\cache.exe] [write_all: send() returned SOCKET_ERROR. Reason: (10054, 0x2746) An existing connection was forcibly closed by the remote host. ] (alert request ID=710761).

Hi!

It is often necessary to run some external command such as a python program or a shell script from inside Caché/Ensemble. There are three ways of doing this:

• $ZF(-1) - Runs the command and waits for it to finish.  
• $ZF(-2) - Runs the command and don't wait for it to finish.
• Using CPIPE device - Runs the command and opens a device for you to read its output or (exclusive or here!) write to its input.

$ZF(-1) is normally more interesting because it allows you to recover the return code of the program you are calling. If that is important to you, that is the way to go.

I am working on an ZAUTHENTICATE.mac to move us from local cache users to Delegated Authentication against LDAP. 

I have created a user role within my instance of Ensemble that matches the AD Group that I will be assigning everyone in my group to.  Is there a way to query the list of available Roles within Ensemble, and if one of my AD groups matches that role, set the role for that user?

How would I compare the AD Group against the Role listing?

Thanks

Scott

I'm experimenting with sending large amounts of data in a POST payload to be stored as a stream. However I've noticed that no matter how many characters are in the message, Cache only gets about 32k of them, cutting off the rest. Conversely as expected it can only send about 32k worth of characters in a payload.

Before I get creative, is there a REST message size limit that can be changed? Or is there something else going on here?

Thank you!

Hi!

We have problems in some productions where it stuck in a Queue when things goes wrong and i wonder if somebody have som tips to avoid it?

example when we got stuck is this:

set MyClass= ##class(SomeClass).%New(). MyClass has a Datefield

try
{
  MyClass.Date =  Sourcedata.Date  //Sourcedata send us wrong format to that datefield. Error occur.

}

catch ex 
{
set tErrMsg = "Error i this method "  _ $System.Status.GetOneStatusText(ex.AsStatus())
$$$LOGERROR(tErrMsg)
Quit
}

In this case the catch-scope is not seems to be reached at all and the production get stuck in a Queue.

Is there anyway in either Atelier Server Explorer and Atelier Explorer to change the order of the Routine list so that it shows the software in both using Date Last Modified Order rather than alphabetically?

Hi, Community! 

This is the 3rd part of DeepSee Web story - Angular base UI for DeepSee Dashboards, see the beginning here.

​

By design, DSW provides an implementation for every widget in DeepSee library. But there are some extra features in DSW which make solutions built with DSW dashboards more functional.  This article describes it.

I want to disable / turn off the visible cursor and then re-enable from with a Cache MUMPS (COS) routine.
Can anyone advise please ?
I am using the free Intersystems Cache installation (CachePCkit V2017.1) on Windows 10 for my own use & personal development.

I am trying to use the automated unittest class for a %CSP.Rest service.

So my Unittest code set's %request and %response from %CSP.Req/resp respectively

I build a tProxy with the fields I need for the post and set it %ToJson... I have tried seting %request.Content = tProxy (and not)

I call the method for the post url directly... 

  When that method calls %fromJson to set an object with the info. I passed... 

      - when I don't set %request.content.. I get a error '5035 - premature end of data code 12'

      - when I set %request.

Let's say I want to execute  this cache script (saved as test.txt) from OS terminal:

zn "USER"
write 1
zn "%SYS"
write 2
halt

Executing the following command in a terminal:

csession cache < test.txt

Would yield this output:

$ csession cache < script.txt

Node: gitlab-test, Instance: CACHE

USER>

USER>
1
USER>

%SYS>
2
%SYS>
Job succeeded

Is there a better way to run these scripts?

Currently I have two problems:

1. I have several variables defined in my bash script, what's the best approach to pass them into Caché?

Hi Guys,

I want to take out the words -"Ensemble alert from"  from the subject line of ensemble alerts.  Does anyone have done something similar.

I have a dataListBox in ZEN which has an OnDrawItem method associated with it. The DrawItem method never seems to be called and I cannot see why.  I am using IE11. Can anyone suggest a reason? The attached code runs in a namespace called CODE and can be run using view webpage on the TheLabsApp.BioAnal class. Please note that the data is in a global called ^%ANAL that resides in %SYS.

Hi,

I am afraid I am stuck again. I have ensemble connected with a MsSQL database and I have a service that calls a store procedure. All is working, and I can get strings from the database in the service. The problem is that the data the store procedure returns is suppose to be an HL7 message so I need to convert the string into HL7 format. I have been using the  ##class(EnsLib.HL7.Message). ImportFromString  method but although I have a valid HL7 message from the string received from the DB.

How can get the data stored in the JSON object?  I try StringObject but doesn't work.

Is the Feb 15 Atelier webinar going to be posted? It would help me and others stay up to date on Atelier. Thanks.

Does anyone have a function they built to change a name from all lower case, or all upper case to mix case?

Thanks

Scott Roth