Question Thembelani Mlalazi · Mar 12, 2018

I have a service that that I would like to use to  poll the database table in MySQL server 2012 and get an id to use if the condition is met but have trouble achieving this here is what I have so far any suggestions please.

Method OnProcessInput(pInput As EnsLib.SQL.Snapshot, Output pOutput As %RegisteredObject) As %Status
{
 
  set pRequest=##class(SamsReq).%New()
      set pRequest.pID=pInput.Get("pID")
     
     
 

< set sc=..SendRequestSync("DQTT",pRequest,.pOutput)

 quit sc
}
 
 

the error that I am getting

>}

ERROR <Ens>ErrBPTerminated: Terminating BP DQTT # due to error:
4
0 921
Question Chris Fine · Mar 8, 2018

hi, new here, and new to cache and deepsee.

i've been trying to setup a copy of our production server so we can use it for testing/development.

i did a full  backup. moved it to the new server.  ran the DBREST command.  got it to restore but seems like permissions get all messed up. and it just generates a bunch of errors.

is there an easier/better way of doing this?

13
0 768
Question Ryan Hulslander · Mar 9, 2018

Please forgive me if these questions have been asked and answered before, I've tried searching the posts and docs and really haven't found the answer yet.

  • How does one find and open existing .HL7 and .LUT files in Atelier like one would do in Studio in order to add them to your local project, edit, then save them back to the server?
  • When I attempt to create a new HL7 schema file by right clicking on the project, selecting "New" and "Custom File" and selecting the HL7 Schema wizard, then choose a name and pick something like 2.5 for the base schema, It creates the XML file - but every time I
2
0 513
Question Jiri Svoboda · Mar 8, 2018

Hello community,

I need to perform some processing-heavy operations on a set of input objects and I would like to utilize more than a single processor core to do the heavy lifting.

Is there any way to call methods in parallel and wait for the results in a blocking way?

Basically, I am looking for an equivalent of the pythonese

with Pool(n) as p:
    results = p.map(function, data)

Thanks

Jiri

EDIT: Correct English :)

5
0 635
Question Nezla · Mar 7, 2018

Hi Guys,

One of our clients is running Cache 2014.1.4 and for some reason is not recognising UNC paths?

The Path is accessible via windows explorer with no issues (\\backupsvr) and also my works fine when using :

O C:\folder\file.txt:("WNS"):5 

but using : O \\backupsvr\folder\file.txt:("WNS"):5   bring an error "Can not create file" knowing that \\backupsvr\folder\ can be accessed via explorer with not issues?

Thanks

3
0 705
Article Vitaliy Serdtsev · Nov 17, 2017 6m read

This series of articles aims to address the following topics:

  • Creation of a web application based on REST pages;
  • Overview of some tools for tracing (debugging) HTTP requests;
  • Switching from hyperevents to... hyperevents;
  • Integration with jQuery File Upload;
  • Conversion of JSON from the {id:1,parentId:1} format to the {id:1,children:[{}]} format for tree visualization;
  • Integration with jQuery EasyUI (using datagrid and tree as examples);
  • Other topics.
1
1 1098
Question Vivek Ranjan · Feb 1, 2018

WRF to below example my idea is to check whether red is present in the list mylist.  You can very well use LINQ on enumerable in C#

mylist.Where(x => (x.Property2 == "red")).ToList().Count;
set mylist=##class(%ListOfObjects).%New()For i=1:1:2 {S object = ##class(User.NewClass).%New()
  Sobject.Property1=iS object.Property2="red"do mylist.Insert(object)}

It can be done with iterating over mylist

for j=1:1:mylist.Count(){Set item = mylist.GetAt(j)
   If (item.Property1 = "red") { // get the count }
   //set exist = item.Find("viv",1)}
3
0 557
Announcement Mike Morrissey · Mar 7, 2018

The InterSystems FHIR® Sandbox is a virtual testing environment that combines HealthShare technology with synthetic patient data and open source and commercial SMART on FHIR apps, to allow users to play with FHIR functionality.

The sandbox is designed to enable developers and innovators to connect and test their own DSTU2 apps to multi-source health records hosted by the latest version of HealthShare.   Share your experience with others or ask questions here in the FHIR Implementers Group

Click here to access the InterSystems FHIR® Sandbox.

0
0 721
Question Alexey Maslov · Mar 6, 2018

I have one in my testing environment. According to https://community.intersystems.com/post/licensing-ubuntu-and-suse-20171-and-later, I should move to native Ubuntu build with 2017.2. So I downloaded Cache for UNIX (Ubuntu Server LTS for x86-64) 2017.2.1 and tried to update my existing 2015.1.4 installation. What I got was:

Upgrade from lnxsusex64 platform is not allowed.

No packages will be installed.

Meanwhile new Cache 2017.2 instance was installed without any problem.

The question is: how to upgrade an existing one?

4
0 449
Article Stephan du Plooy · Oct 17, 2017 2m read

It is often necessary to sort the results of a query on a string field containing a combination of alphabetic and numeric characters. In cases like this the default string collation may not always return the data in the expected sequence.

An example of this may be where a select from Samples.Person should order the results by the street address, but firstly ordered by the street number part as numeric, and then by the street name.

The default query will return the results as follows:

SELECTName,Home_Street

FROMSample.Person

ORDERBYHome_Street

Name Home_Street
Eastman,Richard W. 1031 Madison
4
0 545
Question Jason Melton · Aug 16, 2017

HI,

Has anyone implemented the NHS Care Connect profile in HealthShare and if so could you share the steps you took?

I am not looking to integrate it into the SDA model,  Just looking having the classes within HealthShare and then applying a DTL to convert to HL7 2.x

I was hoping i could just down load the profiles from git hub and import into Studio but it appears I need the XSD to do this, which are not available.

Cheers,

Jason

4
0 738
Question Jenna Makin · Dec 4, 2017

Hi-

I have searched through documentation, etc and see many mentions of using Ensemble / Health Connect along with the Java Gateway to interface with JMS Queues, but see no specific documentation on how to do this.

Does anyone have any information, or a concise example of using the Java Gateway to allow Ensemble / Health Connect to be able to place messages and retrieve messages from a JMS Queue?

Thanks

2
0 918
Question Ali Chaib · Mar 5, 2018

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 !

3
0 571
Question Arun Kumar · Feb 1, 2018

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. 

11
0 1127
Question CJ H · Mar 2, 2018

$zt

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

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

Thanks.

3
0 734
Question Kishan Ravindran · Oct 12, 2017
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?… 
How do the above code works and can i be able to run this?

Thanks in advance.

5
0 3572
Article Chris Stewart · Apr 28, 2017 4m read

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.

10
0 1291
Question D Sun · Mar 1, 2018

 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

14
0 570
Announcement Evgeny Shvarov · Feb 6, 2018

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

5
0 615
Question Nezla · Feb 26, 2018

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

16
0 2676
Article Robert Cemper · Feb 27, 2018 2m read

 

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.

0
0 406
Question James Hill · Feb 27, 2018

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.

1
0 1060