We have multiple developer, multiple edge servers environment. And we are planning to move to Atelier from Studio. I was wondering if someone have suggestions about the followings.
Hi,
The following sql statement is working through the SMP but couldn't make it work through the code.
The table is a linked table to oracle db.
Tried to change the date property in the linked table class from %Date to %String and also tried using %SQL.Statement and %Library.ResultSet
this work through SMP:
INSERT INTO PACKAGE.SOME_TABLE_NAME
(EFFECTIVE_START_DATE,MORE,DATA,HERE)
VALUES (to_date ('2018-04-01','yyyy-mm-dd'),123,456,789)
In the code i'm using '?' in the statement for the parameters.
Hi,
Trying to work with REST protocol, using IIS 8, both client and server are Cache servers,
I have the following problem-
When I send a PUT command, I get the following error:
<HTML><HEAD><TITLE>Length Required</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Length Required</h2>
<hr><p>HTTP Error 411. The request must be chunked or have a content length.</p>
</BODY></HTML>
Get , Post , Delete - work OK.
This problem does not happen if I use Apache, so it's a IIS problem , not a Cache problem.
Hi,
I have a ZEN application that displays PDF files in an 'iframe', embedded on a ZEN popup dialog. embedded in a ZEN page running on IE 11 with its document mode set to 5, which is enough to make most reasonable people give up and start selling hot dogs in the park.
I can display the PDF all day long without issue but when the "window.print()' command is issued all I get for the PDF is an empty area on the printed page when a single page of the PDF should be displayed. The PDF arrives as a normal PDF file and is NOT base64 encoded. I have had limited success using the PDF.
Hi
Made a request for API REST.
Using HTTP Request adapter.
Outside the Ensemble an API response is JSON (CORRECT)
Answer in Ensemble: =?Á
Â0
?_eä,cÒ
'=
*^<YÙF¡í$í¼ÈÞÝt
oÉ÷ý$?|
¤1¡{Dâhà°Ý?Öù)2ós??R?¸¼?ºd?$,ñD+»??
?
ÔºQZéýNÕ V{C?óò?b¢?éÍ )$
²5Å?wEë? ??©tÖã1z×2FëÊnôeË æ??]Zßq ܺ?á
Help me.
Thank you
Hi,
I would like to add my favourite template at the template menu (Studio): Tools→Templates→Template 1
But I'm unable to find how to do it.
Thanks
Manel
Hi Guys,
We experiencing a strange problem with one of the clients on Cache 2008, for time to time they can't run any of their Crystal reports and each time we had re-compile the classes used in the affected report to get it running, then it happens again for the same reports.
I was wondering if there was a way to easily identify the node depth of a global.
Take the following global example. Is there way to determine the depth is 3?
s ^global("first","second","third")="some^info^here"For those who don't have a chance to vote elsewhere today, or for those who want to vote more than once 
, here's a poll for Ensemble users.
Hi Community,
It is my first post and I hope it is the first of many.
I would like to know if any of you knows how to use Tasks Managment in Atelier with .cls class. I think that is a important tool for productivity. Can this tool be used in Atelier? How to use it? I have tried to configure in Atelier preferences and I have not seen the option.
Many thanks in advance.
Regards,
We are going to start using Git within Cache.
One question came up - if the branch that you checked out does not have the class or mac file, what is the correct thing to do?
Should we delete from Cache or should we just keep it?
I'm leaning more towards deleting it because Cache should reflect what is in your work folder in git. But other team members are saying to keep it.
Hello.
We have a request message with properties that has underscore. This is because we need to convert that request to JSON.
The problem is when we try to assign a value in a Business Process with the editor. It doesn't work, it doesn't compile.
How can we fix this?
This is the object used in the request:
And this is the error:
Does developing a RESTful API in Caché remove the requirement to use the InterSystems.Data.CacheClient.dll and generate proxy classes using the Caché Object Binding Wizard for .NET web development? If anyone has links to sample applications using .NET with Caché and REST Services, I would be grateful if you could share them.
Effective immediately InterSystems will no longer support Health Connect on Solaris. Previously released products starting with 2017.1 will also no longer offer this combination. This is in line with InterSystems HealthShare, which is not available on this platform.
Hi,
We have a PAS that accepts HL7v2 QBP^Q21 requests, and returns patient details in an RSP^K21.
We have a clinical system that wants to sent an http GET request of the form http://server/getpatientbyid?pid=M1234567
So I think I need to convert the query url into a QBP^Q21 (HL7) message, then take the response in HL7v2, convert to SDA, convert to FHIR, and put that in the response to the original GET.
Does anyone have any experience doing this? is there an approach you would recomend?
I have many other SQL storage's defined and have to expose them as well to JSON. Can anyone please suggest a better approach.
My column names usually match with my Json properties.
My User.TestClass is the class with GetJsonList() as my method to return /output JSON formatted data.
The Code tried and SQL storage structure are as follows -
Class User.TestClass Extends %RegisteredObject
{
ClassMethod GetJsonList() As %Status
{
Set SQL="SELECT ID, Column1, Column2, DataID FROM SQLUser.
This is a sample Ensemble/Health Connect production which demonstrates how to receive an HL7 order (ORM) inbound from a file, extract fields (in this case, basic demographic information), and insert those into a table in an external SQL database via ODBC.
Included in the zip file:
Hi Everyone!
New session recording from Global Summit 2017 is already on InterSystems Developers YouTube:
Last time, we stopped on static stuff. Let’s continue...
A client wants information extracted from their MUMPS database and transferred to a cache database, where do I begin and what are some best practices I should keep in mind? (I am fairly new to MUMPS and have been put on this project)
Hi-
I have the following objects
Class A
Property P1 As B
Property P2 As %String
Property P3 As %String
Class B
Property P1 As %String
Can I create an index in Class A based on P1.P1. Basically I want an index of class A by property P1 in class B
I tried creating the following but got a compile error
Index I1 On P1.P1
Thanks
I am trying to created SOAP request body that I need to post as string. I created the SOAP client and tried with this to get SOAP envelope. Can you suggest a way for this.
Set proxy.Para1="a"
Set proxy.Para2="b"
Set tClient=##Class(Client.Class.Client).%New()
Do tClient.WriteHTTPContent(proxy,proxy.%RequestName,0,0,"","",.stream)
I use macros everyday, but its the first time I want to create a macro like this
I want to create a new macro whereby I can pass a variable amount of parameters
the macro (much simplified version) would be
#define myMacro(%params) $listBuild(any Number Of %params I pass in)
so I want to be able to call $$$myMacro(user,ID,vehicle) ie 3 parameters would generate
$lb(user,ID,vehicle)
but equally I might want to call that same macro $$$myMacro(companyID) ie 1 paramter and would generate
$lb(companyID)
so the question is,
how can I create the macro without knowing how many parameters I'm passing in up front.
Is there a way to reduce the size of a CACHE.DAT file after a major reduction in global content has been performed?
Thx... Larry.
I am tasked with using CACHE to insert data retrieved from a CACHE data base and insert it into an sql database. The columns in the sql table that I am trying to insert data into have names that contain underscores such as "ACCESSION_DATE" I found a utility in CACHE to connect to the sql data base and perform inserts. I have the data I need to insert. I need to pass the data into the sql utility referencing the column names.
I tried using indirection to set the data into underscored variables, but that isn't allowed in cache object script.
Anyone have suggestions as to how to do that?
Will an upgrade from 2015.2 to 2017.1.2 or higher freeze the query plans from 2015.2? Is there some minimum source version where this will work?
I am rather new to ObjectScript and I have a query about assigning values to the context.
In BPL I have a context variable (A08Msg) which is set to type Enslib.HL7.Message, I want to put my inbound HL7 message into this variable so I tried:
This seemed to load the message into the variable because I could read values, e.g. using context.A08Msg.{PD1:3(1).1} , but I was unable to write to context.A08Msg.
As an alternate method I built a dummy transform that transformed request into context.
Hi Everyone!
Enjoy a new video on InterSystems Developers YouTube Channel:
Saving Lives and Livelihoods With iKnow
Hi All,
I have a line of mumps code that creates a folder on a network shared drive.
Example:
d ##class($Library.File).
If I run this line of code from a cache terminal window it works fine and creates the folder without problems.
However If I create a very simple business operation in a production in the same namespace that simply runs this one line of code then the code fails.
Anybody encountered this issue in the past and If so how did you overcome the problem.
Hello,
I am running a transformDTL through COS that transforms an EDI document to JSON and would like to validate the document and throw an error if it does not validate or build a map.
I am looking at available methods and haven't been able to find one that sort of does: Set tSC = ##class(*).Validate(tDoc,"HIPAA_5100").
Any help here would be appreciated, it seems like I am missing something simple.
