Hello,
When working with class queries you have to define the ROWSPEC at the beginning (See below).
Instead of using Year1 or Year2 as the column name, how can I use the passed in fiscal year (xFiscalYear)
so Instead of using "Year1" as the column name I can call it something like: "Jul"_xFiscalYear
Query GLReportYearToYearTrend(xFiscalYear As %String) As %Query(CONTAINID = 0, ROWSPEC = "GLCode:%String,Description:%String,Year1:%String,Year2:%String,JulChange:%String") [ SqlProc ]
{
}
I faced with the issue when WebSocket connection just fails without any errors if I send data with size 384 bytes and more (In binary mode the same). As I know by standard WebSockets frame does not have such limitation. Is there any way how to decrease it? This limitation too small, it is too difficult to fit this size and needs to send data much more often than I expected. Tested with Caché 2016.2, 2017.2 and IRIS 2018.1.
I am trying to initialize a list of %string property to an empty list, and after add eleements.
d ##class(Test.Test).Test("hello") ; works perfectly
d ##class(Test.Test).Test("") ; does not work, the list stays empty
How can I do that. Thank you so much
Class Test.Test Extends %Persistent
{
Property ReviewedBy As list Of %String;
ClassMethod Test(val = "")
{
Set t = ##class(Forerun.Test).%New()
If val'="" Do t.ReviewedBy.Insert(val)
Else Do t.ReviewedBy.Clear() ; does not work also Set t.ReviewedBy = ""
$$$THROWONERROR(tSC, t.%Save())
Set id = t.%Id()
Set user = "me"
&SQL(UPDATE Test.
Hello,
Looking for some help on how I actually set the properties to enable tracing for %Net.SSH.Session ?
The doc is here:
https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls…
The values look bitwise in their defaultness and I cant seem to figure out how to enable it in my object (or if I am going about this wrong altogether). I am troubleshooting an elusive ssh error: unable to exchange encryption keys in a catch at the moment.
Would appreciate a clue if anybody has experience with it... thank you.
-Ron
This code snippet allows for a file on the web to be saved into the file system. Specify the server and GET request, as well as the directory the file should be saved to. The class method "test" runs the code:
Class objectscript.saveFileHTTP Extends %RegisteredObject
{
classmethod test() {
Set httprequest = ##class(%Net.HttpRequest).%New()
Set httprequest.Server = "docs.intersystems.com"
Do httprequest.Get("documentation/cache/20172/pdfs/GJSON.pdf")
Do $System.OBJ.Dump(httprequest.HttpResponse)
Set stream=##class(%FileBinaryStream).%New()
Set stream.Filename="c:\test.pdf"
Write stream.CopyFrom(httprequest.HttpResponse.Data)
Write stream.%Save()
}
}
Here's a link to the code on GitHub
SQL gateway.
There is a basic problem with sql gateway,
while building the proxy methods, with:
d ##class(%Net.Remote.Gateway).%ExpressImport(class, port, host, 0, classObj)
it causes error messages as something in the class is not correct,
while this class passed OK all Visual Studio of C#
and same class working OK under the %Activate Assembly link
I think there is also problem with overload methods (same methods names).
Regards,
Emanuel
Hi all,
We have a big problem because we have the following message when I try to open the messages in a production.
ERROR <Ens>ErrException: <DATABASE>zfindStatement+29^%SQL.DynamicStatement.1 ^%sqlcq("MYNAMESPACE","Query",8,"Gns8AZO5dJclytqv13l9gUuLUyo=",""),c:\intersystems\healthshare\mgr\cache\ -- logged as '-' number - @''
SOURCE ELEMENT: %ZEN.Component.tablePane (resultsTable)
I already talked about GraphQL and the ways of using it in this article. Now I am going to tell you about the tasks I was facing and the results that I managed to achieve in the process of implementing GraphQL for InterSystems platforms.
Hi everyone,
are you curious which topics we are going to cover at this year’s Global Summit? You have come to the right place! I will provide you with a sneak peek of what you can expect from the areas I am responsible for.
Hello Everyone,
We are planning to build angular UI and Cache REST as backend. Can we deploy angular in Cache Private web server.
What would be the best way to do it. Did any one configure apache with csp gateway . if so can anyone guide me to a good document or some steps here which might help.
I have looked into this - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…
Somehow i am not able to join the dots .
Activate Wizard by-pass
Cache-2016-1.2
1. how to bypass the Activate wizard ?, and run directly the Activate on: .NET x64 COM Assembly (.dll,.tlb)
with object script , something like :
D Activate^%CacheActivate("MyAssembly.tlb")
the MyAssembly.tlb , is ofcourse , a visible Element in activate Wizard table list
2. activate Wizard table list, sometimes throws an error #6101 ?
regards,
Emanuel
InterSystems is pleased to announce the availability of InterSystems IRIS Data Platform 2018.1.2 maintenance release
For information about the corrections in this release, refer to the release notes.
Hi,
we have Angular solution and Cache server. We need to have separate users and sessions on same browser (laptop, table etc) for every user and for one user with many connections.
Thought this was resolved, but unfortunately not.
-----------------------------------------------------------------------------------------------------------------------
I got the code away from here, because it was some how ok.
These Two Professors Are Pushing the Boundaries of AI.
How Far Will They Go?
Get the Answers at Global Summit.
"Can Affective Computing Change Patient Care?"
Don't miss an opportunity to get the answer to this and other questions about affective computing from MIT Professor Rosalind Picard, the foremost authority on this topic and one of its most influential champions. Named one of seven Tech SuperHeroes to Watch by CNN and founder/director of the MIT Media Lab’s Affective Computing research group, she first coined the term in her book of the same name (Affective Computing, MIT Press, 1997).
GlobalSummit too close now, so many people going to be there from so many companies. I'm sure that somebody already uses Docker or even Kubernetes in their work, I do. And would like to share my experience and thoughts about what could be better. And want to hear other people about their experience, how you use Docker, what issues have you faced and how did you solve it. I think InterSystems will help us to find time and place when we could do it, and hope @Luca Ravazzolo will join us. I think It also could be good as the topic at Unconference.
The news is that it’s time to change. Starting from the release of Atelier, a new development environment, and Caché 2016.2, you will be able to export and import files in the format that you use in the studio, into the so-called UDL (Universal Definition Language) format. You can now write code that is not only fast but also looks beautiful in the exported form. However, we get another equally serious issue: if all new projects are in the UDL format, what will happen to backward compatibility?
Hi, Community!
It's September 2018 and we have a new release on DC community engine!
What's new?
Merging users, email content fixes, better moderation, small tweaks, and bugfixes.
See the details below!
We’re now less than a month away from our annual conference, the InterSystems Global Summit. This year, we’ll be descending on the beautiful outskirts of San Antonio, a city worth visiting for its wonderful river walkway and its 18th century Spanish Mission, even if it hadn’t been the location of this year’s InterSystems event. Leaving the tourist guidance to the tourist guides, let’s take a closer look at what the conference has in stock for you, including a dedicated post-summit symposium on AI and ML on Wednesday October 3!
Companies today face serious problems in managing their data and delivering strategic value to them. The structure and business logic of data is fragmented into different solutions, architectures and technology platforms. In addition, different project teams, one for each solution, impose their views on the business, limiting the business to which each of these solutions are able to do. The database becomes a simple repository of processed data under the partial view delivered by each application, process, analysis, message and integration.
In a EnsLib.REST.Operation I have...
Set tSC=..Adapter.Post(.tHttpResponse,,pRequest.stream)
This sends JSON string over HTTP
I am getting this error back from the server
ErrHTTPStatus: Received non-OK status 415 from remote HTTP server: 'HTTP/1.1 415 Unsupported Media Type'
I have been told that the media type should be "JSON"
how do I go about changing the media-type of the HTTP Request?
Hi All,I'm getting the error when i tried to TEST LDAP Authentication . "Connect error: 81 - Server Down",Actually Am a beginner for LDAP Connect with Intersystems Cache. Please provide the Info to proceed further
Hi Community!
We are proud to annouce our latest release of CachéQuality to help you to find and solve coding errors, refactoring, help to follow you coding guidelines, etc. You can check the latest release notes here.
Trying to get an outbound operation working using the EnsLib.REST.Operation class but having problems
from the Operation
Class LPCH.FSE.DictionaryItems.All.Operation Extends EnsLib.REST.Operation
{
Parameter ADAPTER = "EnsLib.HTTP.OutboundAdapter";
Property Adapter As EnsLib.HTTP.OutboundAdapter;
Parameter INVOCATION = "Queue";
Method ProcessTaskEX(pRequest As Ens.Request, Output pResponse As Ens.Response As %Status
{
// Get URL
Set tURL=..Adapter.URL
// Execute the call
Set tSC=..Adapter.PostURL(tURL
Hi, Community!
This is a digest of the Developer Community postings in August 2018.
Most viewed
A sneak peek of Global Summit 2018 313
Global Summit 2018: New Post-Summit Symposium on Artificial Intelligence 151
Json request 142
Routine to Parse Options in Args Array 117
CachéQuality updates and Roadmap 103
Angular4 , webserver , deployment 99
Translate a number to text (II) 90
Continuous Delivery of your InterSystems solution using GitLab - Part IX: Container architecture 90
Find diff between two ObjectScript lists 79
The way to launch Jupyter Notebook + Apache Spark + InterSystems IRIS 76
Triggering DeepSee synchronization when source class properties reference a different class 60
Hi-
I have Atelier client installed on a Mac and every now and then it just stops working. Currently I am getting this error when I try to synchronize my workspace with the server.
Synchronization failed: [server is broken] java.lang.ClassNotFoundException: Provider org.glassfish.jersey.internal.RuntimeDelegateImpl could not be instantiated: java.lang.IllegalStateException: No generator was provided and there is no default generator registered
Is anyone else experiencing similar problems and if so, what is the work around?
The same piece of data never throws this error on other operations. I am getting this error on one always .
The same SDA container never throws error on other operation.
ERROR #6901: XSLT XML Transformer Error: SAXParseException: invalid character 0x1C (Occurred in an unknown entity)
Set xslt=##class(%Dictionary.XDataDefinition).%OpenId(..%ClassName(1)_"||Xmethod",-1,.tStatus)
$$$ThrowOnError(tStatus)
Set tStatus= ##class(%XML.XSLT.Transformer).TransformStream(myStream,xslt.Data,.OpStream)
$$$ThrowOnError(tStatus)
XData Xmethod
{
For Global Summit 2016, I set out to showcase a Reference Architecture I had been working on for a National Provider Directory solution with State Level Instances and a National Instance all running HealthShare Provider Directory and all running on AWS Infrastructure.
In short, I wanted to highlight:
This is the third article (see Part 1 and Part 2) where I continue to introduce you to the internal structure of Caché databases. This time, I will tell you a few interesting things and explain how my Caché Blocks Explorer project can help make your work more productive.
Hi everyone!
Someone already try to use jQuery Mask Plugin on cache?
I'm trying but unsuccessfully.
First I created a new ambient on my own machine to developer in html and all works.
So, I exported the library's js (as jss) to a new Application (stylesheet /js /css) and created too a new Zen Page .cls calling this Application style.
On Zen Page
Parameter APPLICATION = "Multi.Estilo";
XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{
<page xmlns="http://www.intersystems.
Hello,
Currently, I'm working with a Java Gateway, and I have the following problem. When importing a class into IRIS, which uses methods from a generic class, I can not find the general methods I need. I'm talking about the test2 method from the class test. How can I import the java method that returns a generic?
