Hi,

I was playing around with the python binding for caché (2018.1.4) and I ran into some problems.

When executing the class query "List" from SYS.Database the  pythonbind interface throws an exception, that seems to be caused by a mismatch of the defined SQL datatypes for this query and what is actually returned (or the lack of type conversion in the pythonbind interface).

Is this a known issue ? Are there solutions/workarounds for this,
Or is this a bug ?
 

The details:

When executing "List" from SYS.Database there is an error for every datarow fetched.
When executing "FreeSpace" from SYS.

I entered the irissession SERVER command and got the prompt PROMPT>

Now I want to exit this and return to the generic aix prompt $

I try q, quit, e, exit... none of these work.

Hello dear community

I tried to run windows command from an intersystems terminal using objectscript routine.

routine :

Zpipe  quit ; CPIPE example to run host console command
cmd(command="",test=0) ;
 if command="" set command="dir"
 quit $$execute(command,test) execute(cmd,test) Public {
 set dev="|CPIPE|1"
 set $zt="cls"
 set empty=0
 open dev:cmd:0
 write:test $test,!
 else  write "pipe failed",! quit 0
 while empty<3 {
    use dev read line 
    set empty=$s($l(line):0,1:$i(empty))
    use 0 write line,!

Hi Team,

How I can migrate my all the existing Namespace, Web Application, Database from IRISHealth 2019 to 2021.

Thanks,

Ankur Shah

Hi There, 

I am reaching out to the community to see if anyone has implemented SSO via SAML into TrakCare from Azure AD? 

Also looking to see if anyone has come across automated role provisioning, I have seen this from an IRIS perspective but not directly into TrakCare. 

Thanks in Advance

Cheers, 

TC

Hi Community,

I would like to migrate a Zen application to Iris but I am facing issue below:

so far I was not able to solve this issue myself, is there somebody who has some suggestions?

Thanks!

7) You need the right driver

If you want to execute the LOAD DATA sql command you have to choose the driver from 2021.2! If you select the wrong driver and use the LOAD DATA sql command you get something like

 Error: [SQLCODE: <-1>:<Invalid SQL statement>]
[Location: <Prepare>]
[%msg: < LITERAL ('%qpar') expected, : found^LOAD DATA FROM FILE :%qpar>]

I've forked the jdbc driver repo https://github.com/intersystems-community/iris-driver-distribution and added the driver from InterSystems IRIS Version 2021.2.0.617

You can download the intersystems-jdbc-3.3.0.jar from here: https://github.

I am trying to send an HTTP request and getting "SSL/TLS error return from SSL_connect()." error (Cache 2013). No modification in SSL/TLS Configuration helped. Could anyone point me in the right direction?

Thanks

Hi Community，

I have forgotten my gateway username and password. 

C:\InterSystems\IRISHealth\CSP\bin.csp.cni has a user name, but pwd is encrypted ,how to decrypt?

Thx！

Hello everyone! Don't miss the Developer Community Post Digest for February 2022.

Hey Developers,

It's time to announce the winners of the InterSystems Python contest! Are you ready?

A storm of applause goes to these developers and their applications:

Hey Developers! Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in February 2022.

Hello all,

I've seen that to install any python library we just need to call this:

C:\InterSystems\IRIS\bin>irispip install --target C:\InterSystems\IRIS\mgr\python geopy

Is there a way to install the libraries in a different directory and set up the system to load the python from that other directory?

Hey Community,

We greatly appreciate all your feedback on the InterSystems Python programming contest. Please take a few questions to help us improve our contests.

👉 Quick survey: InterSystems Python Contest Survey 

I need someone to help me set up Community version of IRIS on an Amazon virtual server so that I can develop some versions of a highly secure database for review by investors. Any help would be appreciated. Some initial investment funds are available but so far this is a small project with big dreams.

Is there a way, for testing purposes at least, to change a CSP session over to a different user? We have a lot of things in our system that are allowed or restricted based on the user login, so it would be useful for me to be able to occasionally run as a different user to see how things look and work for them. I've tried using the %CSP.Session.Login function, but that still shows the CSP session as being from the original user, not the one I've switched to.

Hi Community ,

I have installed InterSystems IRIS Community in my personal laptop to do some POCs.

Here are the defined namespaces available:
     %SYS
     HSCUSTOM
     HSLIB
     HSSYS
     PPONUGOTINS
     USER

How to create samples in it?

please advice me.

Thanks,

Prashanth

Monitoring IRIS through SAM (sam:1.0.0.115)

While I've used to make it work in the past, I'm not able any more to fix the already faced issue : "State: Unreachable"

Despite all the ip-addresses attempts (or hostname = host.docker.internal)  and while "/api/monitor/metrics" is running well...

Could someone provide good practices to make it work cleanly ?

I have created person.csp in my namespace using studio and view->webpage then web page opened in below url

http://localhost:52773/csp/healthshare/pponugotins/person.csp

I have crated new web application  as /csp/test. only change is selected unauthenticated

http://localhost:52773/csp/test/person.csp

it should open same webpage , but showing "Invalid Action"

please help me what should i do.

I need a csp page which should not ask any authentication

Thanks,

Prashanth

After what is seemed was weeks, I finally got SSL/TLS enabled on both Apache Web Server and IRIS using the Web Gateway. However while we can now use HTTPS to connect to our Development instance of IRIS, I am running into several errors when I have others try to access the Management Portal via HTTPS.

We are seeing...

• "Unexpected status code, unable to process Hyper Event: Internal Server Error (500)"
• Server Unavailable

Does anyone have a Optimal settings list that I need to set for Apache/Web Gateway

Hi Community,

Can I customize below Monitoring page and expose as webpage outside as webpage. 

http://localhost:52773/csp/sys/%25CSP.UI.Portal.EnsembleMonitor.zen

Please give the source code location of this webpage in studio?

Thanks,

Prashanth

Hello,

I'm using the InterSystems Iris odbc driver (DriverODBCVer=02.10) to get data from Iris table but it is slow.

Is there any options to improve performance ? Increase the packet size ?

Change to do in odbcinst.ini / odbc.ini to make it quicker ?

Thanks

Dear people,

I (really) spent hours on finding the maximum size a Global is allowed to be (for Windows, if that matters). All I seem to run into are database sizes (derived from a max number of blocks and block size), but I refuse to believe that is correct because too small to be realistic.  

It will  undoubtedly my fault that I don't understand or misread the concepts of "database" vs Globals, envisioning files as such while one set of functional Globals in one file (?

Hi Community,

I have created CSP page should show my Queue status.

Now I need to refresh this page every 5 min.(same like live score website) to reload new queue status.

Any tag in CSP will do this auto refresh?

Thanks,

Prashanth

If I add the same patient data with a different unique ID then it inserts as new data using a POST request.
So, In the FHIR server How can I prevent this kind of thing by using POST requests?
Note:- I don't want to use a PUT request for the same. The main thing is I want to get a unique patient record.
Que:- Is there any way to check data duplication on each FHIR resource?

Thanks & Regards,

Harshdeep Acharya

Use case: small in-house hospital systems that query patient demographics via SQL.  The new PAS being implemented in the near future will only support query/response via HL7.  SQL access is available but intended for reporting so up to 24 hours behind.

Probably the easiest option is to set up a database in Ensemble and keep it up to date via standard ADT feed.  This is going to have quite a large footprint and has a risk of getting out of sync.

Another option would be to proxy the SQL queries in Ensemble and translate them to HL7 QRY messages.

I'm building a .Net Core Gateway container. Here's the issue.

As a final step I'm building a .Net Core 2.1 library. It has a runnable dependency - .Net Gateway, which I need to start first.

However dotnet publish generates .runtimeconfig.json and .deps.json only for my library and not for my dependency (.Net Gateway).

Is there a way to force dotnet to generate .runtimeconfig.json and .deps.json for a dependency?

With the latest improvements in support for Python in IRIS, and continued work on Python DB-API support by InterSystems. I've implemented IRIS support to the Django project where is Python DB-API is used to work with some other databases.

Let's try a simple application on Django, which stores its data in IRIS.

We are happy to share interesting information with you, as well as tell you why Python is good, where it is used.

Among the most used libraries are NumPy and Pandas. NumPy (Numerical Python) is used to sort large datasets. It simplifies mathematical operations and their vectorization on arrays. Pandas offers two data structures: Series (a list of elements) and Data Frames (a table with multiple columns). This library converts data into a Data Frame, allowing you to remove and add new columns, as well as perform various operations.

Coming up on Thursday March 3rd, VS Code Day 2022, the second official Visual Studio Code event from Microsoft.

Join the Visual Studio Code team and community at a live event just for VS Code users. Get a glimpse of things to come and meet the team who works on VS Code every day.

Starts 8am PST and runs for 90 minutes.

https://code.visualstudio.com/vscode-day/