In our last lesson, we implemented a new REST Service to allow us to perform CRU operations on Widgets, and refactored our Controllers to allow the page setup to be decouple from the content.

When we created our Widget Services, we did not implement a Deletion operation, which the HTTP Delete verb provides.  As this is a base table for other parts of the Widgets Direct empire, we don't want to be able to do a hard Delete of the WIdget values, as this could cause issues with our ordering and billing modules.

 I  keep seeing  <INVALID OREF>zMypropertyGetSwizzled+3^myClass.2  in the error log.  In my case,  Myproperty   is a property of  myClass. And Myproperty points to the the object of other class in the system. This error happens to 2 properties in the same class, and they are both object properties. This error pops up occasionally, and make the debugging harder.

Anyone knows what the issues are?

TIA

Is there a way to pull a user name and password from the Credentials list that is kept in Ensemble? Right now I have a LDAP user that I have hard coded into my ZAUTHENTICATE, which I would like to get away from. I am not to familiar with settings Global, or calling them at least.

Thanks

Scott

Hi, Community!

I have some good news for you!

I'm pleased to announce that Robert Cemper is a new Developer Community Moderator for 2018 year!

Robert joined DC in June 2017 and is responsible for a significant amount of experience, best practices and deep skills in InterSystems technology presented here in InterSystems Developer Community!

Congratulations, Robert! And thanks for your Yes to work as Moderator in InterSystems Community! 

And as some honorable man said, "With great power comes great responsibility" - handle your moderator power with care ;)

Here is the short bio Robert wants to share.

Hi, Community!

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

Most viewed

Book: Caché Objects and Atelier  212

Beautifying for Object Script ?  155

com.intersys.globals.GlobalsException occurs when I am trying to call connection.connect() with the correct credentials  143

Container - What is a Container IMAGE?  134

M:N Relationship  132

How to distinguish the String from Integer in COS  127

Performance in Cache object scripts  121

Atelier security quirk  119

Calculate the age of a person  116

Pulling information from Credentials using Cache Object Script  115

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.

ZWRITE ^rINC("WebServices","PreComp","systeminclude")
^
<NETWORK>
Q00QUASAR:TEST2>ZWRITE ^rINC("WebServices","PreComp")
^rINC("WebServices","PreComp")="61801,57106"
^rINC("WebServices","PreComp","Depends","WebServices")="61801,57106"
^rINC("WebServices","PreComp","Expansion","INIT")="0"_$c(1)_"arg"_$c(1)_"0"_$c(1)_"S wsFault=$$Init^LU090000(%arg,.%ClassName(1),.

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.

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: 

set ok=st.%PrepareClassQuery("%File","FileSet")

d $system.Status.

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.

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:

USER>k
USER>s stream=##class(%Stream.

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:

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?