Hi, Community!
Please find a new session recording from Global Summit 2017:
Load Balancing for Operational Resiliency
Hi, Community!
This post is a digest of the Developer Community postings in January 2018.
Most viewed
InterSystems Response to Meltdown and Spectre Vulnerabilities 432
For and If with one line: to brace or not to brace 298
Meltdown and Spectre – Performance Impact 268
Send JSON Via HTTP request 216
Atelier now available via the Eclipse Marketplace 187
Find last in a list of objects 135
TRIADB - Associative Semiotic Hypergraph Database Framework in Intersystems Cache with Python Pandas 130
Hi Guys,
I would like to know, how to setup a global structure in Cache classes storage type.
I want to set a global like below in Cache classes using Storage methods.
^A("ID1")="Name\Abb\Map"
^A("ID2")="Name\Abb\Map"
^A("ID3")="Name\Abb\Map"
...If any lead it would be appreciated.
Thanks,
Arun Kumar Durairaj.
Hi
I am new to cache and accessing it using odbc (other data sources) from excel. I need to know how to get hold of the number of rows for each every object in my current schema.
I can find table name using following query but I need number of rows to estimate size of each table.
SELECT * FROM %Dictionary.ClassDefinition ClassDefinition
I am running InterSystems Ensemble 2016.2 on ubuntu and trying to connect to a remote MS SQL server database.
Insofar, I have successfully configured my ubuntu machine to connect to the remote MS SQL server database using unix-odbc. That is:
- Telnet connection works
- tsql (test sql) connection works
- isql command succesfully connects to sql server and I am able to execute queries on ubuntu.
- The DSN for the isql command are defined in /etc/odbc.ini and /etc/odbcinst.ini and should be available systemwide.
- The DSN in the odbcinst.ini uses the microsoft odbc driver 13 for Sql Server for linux.
However,
I am wondering about upgrading our Healthshare mirrored environment to the latest release. Has anyone upgraded recently to what version and what kind of effort was put into it. I am thinking it will take 2 analysts full time for 3 months. Am I out of the ball park on this estimate? We have bout 600 operations, Processes and services. What are some of the benefits we get from upgrading and what are some of the problems you ran into during the upgrade? Any information you have to share would be greatly appreciated. Thanks
Hi, Community!
This year we again introduced three annual badges on Global Masters Advocacy Hub to let you remember how much you contributed to Developer Community in 2017. Here they are:
- DC Best-Selling Author 2017
- DC Expert 2017
- DC Opinion Leader 2017
Hi. I am learning create Rest service with Cache. From this repo. https://github.com/intersystems-ru/REST
I created new web application from Web Applications section in Management Portal. Such as screenshot. In browser call http://127.0.0.1:57772/rest/test . But got "Service Unavailable" 503 response. Could you please help?
This might be more of a math problem than a Caché question.
I have a SQL query that joins two tables. I want to assign a unique ID to each row of the product table.
- I could append the GUIDs of the rows in the two tables, but there are a number of clients that expect a maximum length of 50 on this unique ID. Two GUIDs appended make 72 characters.
- I could append the two GUIDs and then truncate the result, but now I'm worried about collision.
What's the chance of collision if I append the GUIDs and truncate the result to 50 characters? Is there a good way to solve this without updating the clients?
I am trying to write an application that will take some information on the database make a call to the Google API distance matrix and get the information to use with rest of the application without using the ensemble part of the development is this possible and how can I do my communication with the API from a cache class thanks in advance
Last week, we announced the InterSystems IRIS Data Platform, our new and comprehensive platform for all your data endeavours, whether transactional, analytics or both. We've included many of the features our customers know and loved from Caché and Ensemble, but in this article we'll shed a little more light on one of the new capabilities of the platform: SQL Sharding, a powerful new feature in our scalability story.
We have noticed in the course of the last 18 days our CACHE.dat has grown by 20 GB. Is there a way we can break down the data in CACHE.dat to see what could be growing in size?
Let me state it another way.....Is there a way to see what space an Operation/Service/Process is taking up within a certain Production?
Thanks
Scott Roth
The Ohio State University Wexner Medical Center
As I was going though and trying to figure out why our CACHE.dat has increased in size over the past 18 days, I found that EnsLib_HL7.Message is still retaining messages dating back to 2014 even though we have our purge set to 10 days. Has anyone else experienced this?
Thanks
Scott Roth
The Ohio State University Wexner Medical Center
Hello,
I have a property which I need to move from one class definition to another as follows:
Old definition:
Class SCHED.SchedEntry
{
Property Experiment as %String;
Property ScanSlot as list of TracerEntry;
}
Class SCHED.TracerEntry
{
Property Tracer As %String
}I want to move the Experiment property to the TracerEntry class so that there is a different Experiment allowed for each ScanSlot, like this:
Class SCHED.SchedEntry
{
Property ScanSlot as list of TracerEntry;
}
Class SCHED.TracerEntry
{
Property Tracer As %String;
Property ExperimentLooking at the documentation expalining the use of client side menus, including the drop down menu.
I was messing around trying to get the "Open", once clicked, to use javascript to open windows file explorer to open/pick a file.
I've got it to partially work... Using keystrokes Ctrl-O will open the file explorer yet clicking on the drop down's File/Open does nothing.
Not sure what I'm doing wrong here.
NOTE: I had commented out the two &html lines in the Testing Method... and doing a Ctrl-O still work.
Why?
/// Created using the page template: DefaultClass PublisherDB.NewClass1 Extends %ZEN.Co
In part of this post in 2016 @Eduard Lebedyuk asked if anyone knew what is meant by an "expanded class", as referred to in the text that appears when we run the ShowQualifiers classmethod of %SYSTEM.OBJ thus:
SAMPLES>DO $system.OBJ.ShowQualifiers()
...
Name: /checkuptodate
Description: Skip classes or expanded classes that are up-to-date.
Is there any possibility to implementing a custom TCP Operation (or any other possible way) which can enable/disable (readonly) the controllers such as ipaddress and port. This need to be done based on the role of the user logged in to the management portal.
Appreciate if anyone can provide sample code around this...
Hi,
I am working on a custom service that reads from a file and import content into a global. The problem is that global is also used by other processes. I have been trying to find any way to stop/disable a process from cache code so after reading the file, process is stopped, global updated and then process is restored. But I could not find anything, just to start/stop the whole production
Do ##class(Ens.Director).StopProduction()
Any ideas if this is something that can be done in ensemble?
Thanks
We will be transitioning from a server running HP OpenVMS to one running RHEL 7. The main question some of the team had was what would be the best method for moving the globals to the new system.
Also, I was wondering if any others have transitioned from OpenVMS to RHEL. If so, were there any kinks that we should be aware of prior to transition?
Does anyone know where the default port comes from when installing a new instance on Windows Server 2012 R2?
It constantly picks up the wrong default which is already running on the server (probably swapped over after installation) and the install fails and rolls back.
I installed again and this time without rollback but still allocated the wrong port so at least was able to manually update the cpf and then start the instance.
Would like a simpler solution to the issue and assume they are traversing some windows registry entry that may need updating.
Hi community ,
i use postman for testing my request , i need to extract access token from it (i put it inside the "Get url" using post man before sending my request).
i use the GetAccessTokenFromRequest of (%SYS.OAuth2.AccessToken) class , but in my rest code party , when i send request from post man , i can't extract my access token, it's empty.
can please give me help?
thank you
On the homepage that we get when we go to https://community.intersystems.com/ there are three views, controlled by a set of buttons in the upper right:
Above is with the default view (the "house", i.e. the "home").
I think the text "Top posting" would be better expressed as "Top posts" (plural), or maybe even just "Posts" (because what does "Top" mean when I'm viewing, say, "most active" or "most viewed"?).
Also, when I pick the tag summary view ("tags" icon to the right of the "home" icon), the page doesn't offer me a way of switching to one of the other views ("home" or "compact"):
I have a query would run very long time and I get always timeout error from SMP.
Thank for your help.
Coding Guidelines 
Hello to all my fellow Cache Developers/Experts:
My question has to do with how I would go about changing the image file size when loading (saving) an image file (i.e. JPG, BMP, GIF, PNG, etc...) to a Cache Database Table.
Here is my business scenario:
- The user will save various image files (could be different types, such as JPG, PNG, BMP, GIF) to an operating system directory.
- Then our application has a background job that monitors the image directory and will load (save) the image into a Cache Database Table into a property of data type %Stream.GlobalBinary.
- Then when a client report is
Is it possible to have a, b, c, d, e, and f as a counter instead of the counter being numeric? See below...Epic would like us to set OBX.4 using a alpha numeric combination.
OBX|4|ST|69548-6^Genetic Variant Assessment|1.a|Mutation IDH1:Not Detected||||||F OBX|5|ST|69548-6^Genetic Variant Assessment|1.b|Mutation IDH2:Not Detected||||||F OBX|6|ST|69548-6^Genetic Variant Assessment|1.c|Mutation NPM1:Not Detected||||||F OBX|7|ST|69548-6^Genetic Variant Assessment|1.d|Mutation RUNX1:Detected||||||F OBX|8|ST|69548-6^Genetic Variant Assessment|1.e|Mutation TET2:Detected||||||F
I am trying to come up with a way to decode the Base64 we receive in an HL7 message into a PDF file and save it in a directory on our AIX machine. I thought I had the following working at one time but I am having issues. Has anyone done this before?
ClassMethod DecodeBase64HL7ToFile(base64 As %Stream, Ancillary As %String) As %Boolean
{
set Oref = ##class(%FileBinaryStream).%New()
set Oref.Filename = Ancillary
Do base64.Rewind()
While 'base64.AtEnd {
set ln=base64.ReadLine()
set lnDecoded=$system.Encryption.Base64Decode(ln)
do Oref.Write(lnDecoded)
}
Do Oref.%Save()
quit 1
}
Thanks
Scott
Hi,
My doubt is about the SQL Query in Caché:
I don't want to take all results from the table and orgainze them manually, for example: I have a table with 50 records, but I only want to select 10 records, being from tenth until the twentieth and this without knowing their IDs.
So, how can I do this, without losing performance, there is any way?
NOTE: In other SQL languages I can do, for example, SELECT * FROM extbl Limit 10 OFFSET 10
Thanks,
Andrei L. Nenevê
Hi guys,
I have a technical question. I have a Ens.BusinessOperation which contains a main method with parameters "In" As Ens.StreamContainer and Output "Out" As Ens.StringContainer. Return type is %Status.
Can this method just do "Quit $$$OK"?.
Currently this BO is used for see messages in Full Trace View.
It is a correct way to proceed?
Thank you
