Hi, Community!

Enjoy a new session recording from Global Summit 2017:

Persistence in a World of Containers 

Hi Guys,

I'm looking to Remove file from a location to another similar to CUT & Past function, I'm using this :

 s file=##class(%File).%New()
 d file.CopyFile(File,ArchivePath)
 d file.Delete(File)

and the copying is happening but not the Deleting, and help pls?

Thanks

This data set demonstrates a basic M:N relationship between 2 tables
The dataset is targeted to show a slim implementation of M:N
It's no question that other implementations exist. But at significantly more storage consumption.

Reasonably new to Ensemble but have a requirement to take a HL7 message and send to a external source using a HTTP Post. I already have built an operation that will post a stream forwarded to it but was wondering if there was a shortcut for copying a complete HL7 Message (including end of segment and end of message) into a stream without having to parse through the whole message segments individually. Any pointers would be much appreciated.

As previously announced, 2017.1 on VSI OpenVMS 8.4-1H1 is the final major version of Caché and Ensemble.  2017.1 will not be available for VSI OpenVMS versions beyond 8.4-1H1.

Maintenance releases of 2017.1 on VSI OpenVMS may be announced but only to deliver critical corrections.  2017.1 on VSI OpenVMS will be the Minimum Supported Version from July 1, 2019 through December 31, 2020.  After December 31, 2020, no further maintenance releases will be made available.  

I have a service that uses the EnsLib.SOAP.InboundAdapter, and I seem to be facing an odd problem.

Our clinical document system sent a request which contained a word document in base64, and was presented with the error "ERROR #6253: Datatype validation failed for tag payload (ending at line 1 character 2111). Unexpected tag <ClinicalDocument> found."

I took a look at the word document sent, and found it contained an image which made the document size about 4MB larger than the average document.

Hi, iam newbie on caché database.

Iam trying, export data from query.

I read in some article that is not so simple.

So I create a view then a execute a query insert into select statement.

I have problem to know the job progress. I execute an hour ago and nothing  happened.

Iam using intersystems web IDE.

Thanks for help!

I am setting up a new Caché instance and I have managed to configure it where Caché username/password is required to initiate the Caché session:

csdfalsdkfjf@fra23e234sco:/opt/labmed/test/test81/proc$ csession cache1

Node: frxxco, Instance: CACHE1

Username: 

I cannot find the setting in the management console that allows for unauthenticated login to a Caché session.  Any help is much appreciated.

Anyone have any suggestions where to spin up small Cache/IRIS/Ensemble test DBs? Hopefully very low cost (or free) reliable hosting?  Obviously AWS has some options but wondering if anyone has had 12 month+ experience with very low cost Cache cloud with AWS, Azure, Google, etc?

Thanks,

Tom Fitzgibbon | gototomATG...l | 3474648531

Hi,

I am getting below error while executing query, This is newly installed cache instance whereas query running fine on old server.

Hi,

Getting below error on newly installed cache version 2017.2. This is running fine on another instance.

Q00QUASAR:TEST1>D $system.OBJ.CompileAll()

Detected 1229 errors during compilation in 145.4s.

Instance name:TEST2>D $system.OBJ.CompileAll()

Detected 202 errors during compilation in 211.7s.

Instance name:TEST3>D $system.OBJ.CompileAll()

Detected 784 errors during compilation in 186.6s.

TEST2>do $System.OBJ.CompilePackage("Calendar")

Compilation started on 02/25/18 17:21:33 with qualifiers ''

Compiling 6 classes, using 4 worker jobs

Compiling class Calendar.Country

Compiling class Calendar.Day

I was running the %File:FileSet class query, with my development user, but I am unable to run this query for an application user.  Does anyone know what resource or service is needed to run this query?  Assume the user has access to a certain directory on the file system needed for the query.

On second though, having tried almost all the available resources and services, perhaps the user doesn't have access to the directory.  How to tell when the error is this: 

Hello guys,

I'm working on a Healthshare project . I am using a  patient message Flow for Inbound SDA Data in an Edge Gateway.

The patients are created , i manage to found them on the Patient search screen. However , when i request clinical data display on the clinical viewer, i do find the patient but no clinical data is visible on the clinical viewer, eventhough the SDA object exists on HS.Registry.Patient table .

So i checked the data flow , and i found that there is an error when the Edge Gateway Receives a Clinical Data Request : 

the HS.Gateway.ECR.Process displays this error : 

I would like to know the workflow of  macro $$$Fza . If you explain me with example that will help.

I have a 2GB CSP.log file that I need to investigate.

I'm using a %Stream.FileCharacter() object to open the file and then using the .FindAt() to search for a particular string.

I'm seeing the FindAt() stop after processing 49m characters?

Here is my code:

k
s stream=##class(%Stream.FileCharacter).%New()
d stream.LinkToFile("d:\csp.log")
s x=""
s i=0
s j=0
w stream.Rewind()
w stream.AtEnd
w stream.SizeGet()
while(stream.AtEnd=0){set i=stream.FindAt(-1,"Invalid password",x)+i  set j=j+1}
w stream.AtEnd
w i
w j

Which gives the following output:

I would like to know the workflow of  $za . If you explain me with example that will help.

Developers,

I am working with a CSP page with among other fields a checkbox.

Based on the checkbox I want to populate a drop-down box with specific options with a server side method using &html<....>.

I have the status of the checkbox in a javascript var.

Can I access this var or maybe the checkbox setting in the server side method?

Basically how do I know the status of the checkbox to populate the drop-down box correctly?

Any suggestions are appreciated!

Jacques

Hi, Community!  

Please find a new session recording from Global Summit 2017:

Optimizing SQL Queries

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:

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?

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.Book [ Cardinality = parent, Inverse = Chapters ];}

then in terminal I am running these commands:

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.

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.