Hi,

I'm trying to send a txt file over TCP.

The txt file contains lines, every line has a fixed length : 179 characters , however it seems that this length vary while sending it!

So, I need to send the content of the txt file as it is without adding anything.

I'm using as operation EnsLib.TCP.PassthroughOperation.

 I need your help please.

Thanks !

I get a list which is formed like below:

$lb("","2",6,6,6,"3")

I would like to distinguish "2" and "3" from 6 since both of them are String types.

Is there any way to achieve this?

Thanks.

Hi Guys,

Can you please advise on the below queries. 

Query 1:

Example 1:

 S a="345",b="arun",c="kumar",d="hi",e="yello",f="orange"

Example 2:

S a="345"

S b="arun"

S c="kumar"

S d="hi"

S e="yello"

S f="orange"

Can you please advise me, which one is performance wise is better. 

Query 2:

Example 1:

S:a=1 R="Arun"

Example 2:

I a=2 R="Arun"

Please advise me, which one is giving better performance in this. 

Any lead would be appreciated. 

Thanks,

Arun Kumar Durairaj. 

Can anyone guide me where is the documentation for $zt?

The google seems suggest it may be "$ztime" or "$ztrap".

Thanks.

Hi guys,

I am using the %Net.HttpRequest method to get data from a server.

The server will continuously send data. Is there any way that i can able to read the HttpResponse data line by line so that if at a particular line i may terminate the request.

Please advice.

Thanks,

Arya

Set httprequest=##class(%Net.HttpRequest).%New()
	Set httprequest.Server="www.intersystems.com"
	Do httprequest.Get("/")
	Do httprequest.HttpResponse.OutputToDevice()
	Do httprequest.Get("/cache/")
	Do httprequest.HttpResponse.OutputToDevice()
The above is the code which i found in this link http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?PAGE=CLASS&LIBRARY=%25SYS&CLASSNAME=%25Net.HttpRequest#Anchor_Methods 
How do the above code works and can i be able to run this?
Thanks in advance.

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.

 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.

A

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.  

As stated on the Minimum Supported Version page, Technical Assistance will continue to be available for all products and versions,

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.

I resent the document both with and without the image while monitoring with Wireshark, and then

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),.ET,.Error) S ET="""" $$$WSERROR(Error)  I ET'="""" N $ES,$ET S $ET=ET"_$c(1)_"3^WebServices"
^rINC("WebServices

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

Compili

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.DisplayError(ok)
 
ERROR #5540: SQLCODE: -99 Message: User

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 : 

ERREUR

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

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