I am working in Intersystems Healthshare product.

I want to clear the message logs from a particular interface (Service,process,operation).

In intersystems we have the option to purge the data for all interfaces for the corresponding time but I want to clear the data logs for particular interface only.

Please let me know how to approach this scenario.

0 3
0 247

Hi everyone

I see that a new Apache bug has been discovered, and since various InterSystems products use an Apache webserver, have Intersystems released any news or updates on this? I'm not seeing any updates, press releases from them. Anyone know anything?

Andy

0 7
0 794

Hi members,

I have these data :

and need to exploit the first character of cot field (Library CDU classification) like this :

I get this result... it's approximatively what I want... but I need it in just one line !

With mySQL I get it with just GROUP BY rcddate

0 3
0 300

Hello programmers I would like to build a simple app where I could register data from a user like a name, age, and the phone just to practice, but for that, I would like to build the frontend and backend and also I need to be able to insert, update and delete information.
Does anyone have any recommendations for me on how I could do that using Intersystems IRIS?

0 2
2 276

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?

Thanks for the help

0 8
0 654
Question
· Oct 25, 2021
Problem with sftp

Hello, everyone,

I have the problem that when trying to connect to the SFTP server the error appears, the user and password are wrong. However, these are correctly stored under login data and I entered! SFTP in SSL Config. The connection works wonderfully with Filezilla. Anyone else has a tip for me?

greeting

0 2
0 485

Newbie

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 ?

0 3
0 458

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

Can i switch this back somehow ?

0 7
0 476

Good day,

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:

0 6
0 650
Question
· Dec 2, 2021
SNN Encryption

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.

0 2
0 299

Hi Dev Community,

I have a persistent Document class that has a FileName string property and another Question class that has an optional one-to-many relationship with Document.

I'm trying to add a SqlComputed property to the Question class (docFileName) where docFileName = Document.FileName if there is a related Document or an empty string if there isn't one.

I'd prefer the property to be SqlComputed so that if Question.Document changes, Question.docFileName will automatically update.

0 12
0 387

We are seeing ERROR #5002: Cache error: <MAXSTRING>zSaveData+14 ^EnsLib.HL7.Segment.1 come up on a Routing rule when we are trying to Encoded PDF's through a DTL. In the DTL we are copying source to target. Is there a limitation on trying to copy source to target?

At the bottom of the DTL you are see that we commented out converting the Encoded PDF to a Stream, is it recommended that we always use %Stream anytime we are dealing with PDF's?

Thanks

0 4
0 642
Question
· Dec 2, 2021
Synchronization failed 
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
0 2
0 394
Question
· Dec 1, 2021
web development

Hello everybody

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.

I thank you all.

Hugs

0 3
0 364
Question
· Dec 3, 2021
Clean CACHETEMP

Hi

How to clean cachetemp/CACHE.DAT, without cache restart?

I have the procedure to clean cachetemp/CACHE.DAT in my scritp stop/start cache, but, in some cases, I need to clean this base without restart.

It's possible?

0 2
0 407
Question
· Dec 2, 2021
Server Connections

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.

0 1
0 333