I've been accessing Cache tables from a developer/reporting side, but am now involved in a project to create a data warehouse for our application. I'm trying to find a query I can use to return the sizes of all the tables in the database, so we can identify the largest tables and handle those individually. Can someone give me a query I can run against our Cache database to return the sizes of all the tables from largest to smallest?
I need to generate a DDL file from a .cls class that already exists, the idea is to create a mirror table in SQL. Is it possible to do this export or do I need to do the CREATE TABLE manually?
I've never had a problem changing the content-type on a response using either %CSP.Page or %CSP.REST until now. No matter where I put the line to set the content-type to "application/json", it stubbornly emits a content-type of "text/html".
I'm trying to get IRIS to run on a new MacBook with a Apple M1 Pro chip. Local installs did not run, so I switched to docker containers. When I execute following command "docker run --detach --publish 52773:52773 --volume /Users/joost/Docker/iris/data/dur:/dur --env ISC_DATA_DIRECTORY=/dur/iconfig --name iris21 --init store/intersystems/iris-community:2021.1.0.215.0" an image is pulled and a container is created but the IRIS instance does not run. The log gives me the following output:
I am currently running a docker image with Iris 2021.1 and I would like to install node js on to it. I have had a look at the instructions on the intersystems online learning portal and I must say its very confusing. Some of the documentation says that you can only install it on 2019. Other parts say that it doesn't matter and you can install it if you have a dev directory. I checked my dev directory and there it isn't there. Sadly this is very inconsistent. Does anyone know if it is possible to install on the above mentioned version of Iris ?
When i use &sql(SELECT ......) in Cache I can watch the generated code In the generated .int code and see what is happening. Just with my normal rights
Now in IRIS I have just 4 line calling some class %sqlcq.*** With enough rights i find there is no such class but the generated .int routine %sqlcq.IRISAPP.xEZgUjdXCCgQdZQPpRdOye1Ci2ue.1 That holds the code that i had in my .int on Cache
Does anybody know if it should be possible to install IRIS for Health on a MacBook with Apple M1 inside? The install distribution works on an Intel based MacBook but when I try on new MacBook (with Apple M1) I get the following response:
The installer can't find a platform in this distribution supported by your system.
after updating from 2018.2.1 to 2021.1 we observe a change in the behaviour of the Messagebank Enterprise Monitor.
In 2018.2.1, when clicking on a specific line inside the configured systems the system dashboard opened, giving insights about queue counts and error conditions.
I'm upgrading my laptop, and installed HealthShare 2020.2. I wanted to import my server connections from my previous laptop, so I exported the Registry Keys (Windows 10) Under Computer\HKEY_CURRENT_USER\SOFTWARE\InterSystems\Cache\Servers from the old machine. I then imported them into new laptop, but I still don't get the list of connections in my HealthShare Remote System Access list from the HS Cube in my system tray.
Does anyone have a solution for this? I thought this was more portable.
I'm trying to output a XML file, mapped from a ORU_R01 2.3 HL7 message, with a file name based of fields in the source HL7 message in the following format,
I need help with resolving this issue of Synchronization failing.
13:55:46.338:HS.Director: Switching to namespace 'MYPORTAL' [Foundation]
13:55:46.450:Ens.Director: Production 'MYPORTALPKG.HSCOMMProduction' starting...
13:55:46.589:....HSCOMMProduction: Table synchronization state: Waiting
13:56:01.604:....HSCOMMProduction: Startup Error 0 =‰Synchronization failed*zOnStart+50^HS.Util.AbstractProduction.1
I need to store an equivalent of the SNN (Social Security number). I need it to be encrypted and I'll have to be able to search for it once stored.
For what I've seen my options are:
- SHAHash from the %system.encryption library. Simple and easy to implement. My question is, might collisions be a problem? We are talking about a 10 millions entry.
- AES encryption. In this case I'd like to know if there is a standard way for key management in the InterSystems environment.
I'm in need of a lot of help from you. I work in a company with all system cached script, using global.
I need to develop web applications accessing the cache database, and global.
Could you help me indicate the best language option to develop web applications, and easier to access cache, and if possible send me some examples of applications accessing globals.
Is there any way by which we can incline the Value Labels in Bar chart like on top of bar or outside of bar in InterSystems Dashboard like Other reporting tool.
Hello. I'm having problems migrating a java application that is running with cache 2018 to Iris The application uses json generated by the cache to receive it as a string in java.
Is there a community version of Healthshare Connect? I know there is for Iris proper but I can't seem to find the Healthshare Connect Community version.
If a have a string " Happy new year " and I want to trim (remove blank spaces from the begin and the end, not other places into the string), what is the object script function to get "Happy new year"?
I'm using a snippet I found from Scott Roth to extract, decode, and save a PDF from a HL7 message and save it to a specified file path, but I'm running issues with the following error:
My approach was to a create a utility function accessible from a DTL like this:
Is InterSystems ODBC driver backwards compatible? If I use cache version 2018, can I upgrade the ODBC drivers to the 2021 version or it is better to upgrade to the 2018?
Hi, I have VSCode on my Windows 10 notebook with intersystems-community.objectscript-pack installed. I'm successfully connected to remote IRIS (2021.1). I can export classes, change them, save and import back to IRIS.
But every time VSCode starts, the message "Request initialize failed with message: Dynamic Linking Error: Win32 error 126" is displayed and InterSystems Language Server does not start.
By date
.png)
.png)
.png)