https://www.youtube.com/embed/E2uLbVeP5Yc [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
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 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
This year we again introduced three annual badges on Global Masters Advocacy Hubto let you remember how much you contributed to Developer Community in 2017. Here they are:
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.
Well my last post got cut off for some reason. I am trying the new beta and wondering about the following functionality from Studio that I don't find in Atelier:
F12 = Open the routine and jump to the tag of the current call the cursor is on in a routine
F2 / <Ctrl> F2 = jumping to a bookmark / toggling a bookmark
<Ctrl> G = Jump to a tag in the code
When might these things be in Atelier? I use them a lot in Studio and the absence of these really slows me down.
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?
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?
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...
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?
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.
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.
https://www.youtube.com/embed/ZOYZdojTqfQ [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
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.
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?
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?
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?
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.