This article is a simple quick starter (what I did was) with SqlDatabaseChain.
Hope this ignites some interest.
Many thanks to:
sqlalchemy-iris author @Dmitry Konnov Maslennikov
Your project made this possible today.
The article script uses openai API so caution not to share table information and records externally, that you didn't intend to.
A local model could be plugged in , instead if needed.
mkdir chainsql cd chainsql python -m venv .
Someone, please point me to the location of the cache ODBC drivers.
I don't have acess https://login.intersystems.com/login/SSO.UI.Login.cls?referrer=https%253....
I need driver for acess the BD Intersystems Cache in the Power BI.
Hi Community,
We're excited to share with you the recording of the next webinar in the series of InterSystems UKI Tech Talk:
👉 Analytics Capabilities using InterSystems IRIS 👈
.png)
This applies to embedded and dynamic SQL queries in Caché ObjectScript. If I attempt to terminate the process via Management Portal, nothing happens. Neither does Ctrl C nor closing the terminal window in which my program is running, nor setting a stop flag in a global which is read by the program on each loop iteration. The only way to stop the query appears to be restarting the Caché server (which is running locally on my PC).
I am very new to IRIS. We are developing a PHP application that connects to an IRIS instance of one of our vendors. I am having trouble with a specific table. When I need to query this specific table for specific fields, I am receiving an error. However, if I change the call to get all columns (`*`), there is no error. I get 37K records returned.
Error:
PHP Fatal error: Uncaught PDOException: SQLSTATE[SL009]: <<Unknown error>>: [unixODBC][Driver Manager]No columns were bound prior to calling SQLFetch or SQLFetchScroll (SQLFetchScroll[0] at /builddir/build/BUILD/php-8.1.InterSystems will end support for using the VxFS filesystem with InterSystems IRIS and label it as deprecated as of the release of InterSystems IRIS 2023.3. InterSystems will continue to support any existing customers using the technology, but it is no longer recommended for new deployments.
VxFS had only been supported on SUSE Linux. Impacted customers are encouraged to migrate to XFS or another supported filesystem.
Customers with questions should reach out to their account team or contact me directly.
I'm dealing with a situation that leaves in doubt what I understand about CACHE.WIJ (C:\Roche\CobasInfinity\HealthShare\mgr)..
Journal files store records already written to the base.. and CACHE.WIJ records not yet written to the base..
theoretically, the data contained in CACHE.WIJ is temporary... until the record is written to the base (consequently generating journal).
The question arose because I have a .WIJ file from 03/10/2023 (modification date) with approx. 4GB.
Information on properties defined in a class can be obtained using the following system classes:
%Dictionary.PropertyDefinition
The code description example is as follows.
Class ISJ.Sample
{
ClassMethod getPropInfo(classname As %String)
{
set cls=##class(%Dictionary.ClassDefinition).%OpenId(classname,,.status)
if $$$ISERR(status) {
write "Specified class does nt exist",!
quit
}
set x=cls.Properties
for i=1:1:x.Count() {
// Get property info (%Dictionary.Following the documentation to insert into tableA from tableB in the SQL query box from the Management Portal :
INSERT INTO tableA (col1, col2)
SELECT col1, col2
FROM tableB
This straightforward query raises the following error :
Error #5475: routine compilation error : %sqlcq.TESTuNAMESPACE.cls305. Errors: %sqlcq.TESTuNAMESPACE.cls305.cls
ERROR: %sqlcq.TESTuNAMESPACE.csl305.1(14) :
<UNDEFINED>parseExtFrom+19^%qaqcmx
*mt("f", "1^TABLEA") :
Could someone help me decipher this error message ? Thanks for your help.
I have a sub class that calls a method in the parent class it is derived from.
However in the below code a <NO CURRENT OBJECT> error is thrown.
Set propertyValue = $PROPERTY($THIS,name)
Using the debugger I can see $THIS is returning the name of the subclass as it should and name is the correct property name (worth noting some properties are defined in the superclass not the subclass).
Why is this error ocouring and how can I fix it?
In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:
In this article, we would talk about building your own container and deploying it.
I was attempting to find a solution to grant clients anonymous access to certain API endpoints while securing others within my REST API. However, when defining a Web Application, you can only secure the entire application and not specific parts of it.
I scoured the community for answers but didn't find any exact solutions, except one recommendation to create two separate web applications, one secured and the other unsecured. However, in my opinion, this approach involves too much work and creates unnecessary maintenance overhead.
Hi Guys,
We currently for reason I'm getting too many locks in the system (around 990 locks) and is making the system slow
.png)
most of these locks are on globals
.png)
I have a method that sets values in some globals every minute which I guess will place a lock on each one and expecting the system would just automatically release them afterward, use to be fine before but for some reason now the list of locks keeps growing, so is there way to just release the lock after setting values in my globals because I don't need them locked anyway?
.png)
Thanks
We would like to know how to get the Row Count of the SELECT query. We query external database via ODBC connection.
//tSQL- is a select query.
Set tStatus = ..Adapter.ExecuteQuery(.tResult,tSQL)
We are trying to get the row count of the retrieved records as below; but It doesn't return any value.
tResult.%ROWCOUNT
$$$TRACE("Result set returned with "_tResult.%ROWCOUNT_" row(s).")
If interested email to me at jwalkerbdrsolutionsllc.com
Ensemble/IRIS Developer to join our growing team! This position will be performed virtually from the individual's home office working on EST time schedule. This position requires US Citizenship with a Public Trust or the ability to obtain one.
(Military Veterans are highly encouraged to apply)
Role Overview
BDR is in search of a proficient InterSystems Ensemble/IRIS developer to contribute to our Department of Veterans Affairs (VA) contract.
CentOS will no longer be a supported development platform as of the release of InterSystems IRIS 2023.3.
CentOS had been a supported development platform to give developers a free-to-use equivalent to Red Hat Enterprise Linux (RHEL) for IRIS development. As you're probably aware, Red Hat made significant changes to CentOS which moved it to being “upstream” of RHEL. This means it has bugs & features not yet included in RHEL, which can cause problems for developers building on the platform.
Hi Developers,
Dive into the latest video on InterSystems Developers YouTube:
⏯ Working with Containers & InterSystems Technology @ Global Summit 2023
Hi community,
I created a business operation class using the FTP Outbound Adapter, and it works when configured for SFTP but when I try to use it for FTPS, it does not work as expected. The connection is established, it creates the file on the destination server but then is disconnected in the middle of the transfer and the PutStream returns 0 and never seems to finish the write of the file. Anyone have any idea of what's happening or any steps I can try to troubleshoot?
Thanks in advance.
Hi Friends,
We have a requirement to read pdf text in ensemble object script code. As object script doesn't have direct solution , i tried to implement python code , but
iris 2020 , there is no support for python in object script.
so I have found one java utill using pdfbox api.
Now I have created jar and want to register into iris and want to make a call to mymethod to read pdf text.
please help me to way forward to achieve it.
java code:
============
package org.optimus.utils; import org.apache.pdfbox.pdmodel.PDDocument; import org.apache.pdfbox.text.PDFTextStripper; import java.io.
import os
# Get environment variables
db_host = os.getenv('DB_HOST')
db_port = os.getenv('DB_PORT')
db_namespace = os.getenv('DB_NAMESPACE')
db_username = os.getenv('DB_USERNAME')
db_password = os.getenv('DB_PASSWORD')
# Create a database connection
conn = irisnative.createConnection(db_host, db_port, db_namespace, db_username, db_password)
# Create an IRIS instance from this connection
iris_native = irisnative.createIris(conn)
status = iris_native.classMethodValue('%SYSTEM.OBJ', 'Load', 'Production.cls', 'ck')
if status == 1:
print("The Production.cls file was compiled successfully.
I am making a POST request to an API. In the case of an error, I don't know what parameters the response JSON will contain (they will change depending on the error). I am converting the response stream to an object but then I need a way to loop through all the properties and access their values. The following code is making the POST request, reading the response, and trying to add all the error messages to an array. But I can't iterate over the properties of the tProxy.errors object because it is a %ZEN.proxyObject. Is there a better way to do this?
Set tSC=.Adapter.
Effective documentation is a cornerstone of software development, aiding in code comprehension, maintenance, and collaboration. By harnessing the power of Doxygen and the ObjectScript filter I've created, you can generate rich static documentation from your source code. This approach does not require a running IRIS instance and thus is a good choice in situations when access to IRIS is not possible. Static documentation may be provided to end-users as-is, together with the source code.
HealthShare Unified Care Record Overview – Virtual November 7-8, 2023
Two extended maintenance releases of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect are now available.
Release 2022.1.4 provides bug fixes for any of the previous 2022.1.x releases.
You can find the detailed change lists / upgrade checklists on these pages:
Release 2023.1.2 provides bug fixes for any of the previous 2023.1.x releases.
Hello,
First of all thanks for your help.
We have developed a REST Operation. We wonder how could we face that String do have a character limit.
We just need to convert httpRequest.HttpResponse , which is a stream , because $isobject(response.Data) returns 1; which has a JSON inside it, and we need to convert it to a Ens.Response.
This response is structured as same as the JSON's properties:
Class Mensajes.Response.Radiologia.CConcertados.BusquedaOrdenesNEGRINResponse Extends Ens.Response
{
Property data As list Of EsquemasDatos.CConcertadostoPACS.Radiologia.Hi Community! We have exciting news for you!
Once you achieve one of the highest levels of the Global Masters program: Expert, Ambassador, or Legend, you will receive a shiny Credly Digital Badge to highlight and validate your contributions to the InterSystems Developer community!⚡
How to accept Credly badge:
Hello Community,
I got the below error while creating a new database.
.png)
Hello Community,
I've enabled the JWT Authentication in my web application. I invoked the /login page to get the JWT and it creates an entry in %SYS.TokenAuth table. Is there any time span for the entries will rid out from the table automatically or It's a manual process? Where can I find the JWT signature private/public key
settings screenshot
.png)
web application
.png)
For the upcoming Python contest, I would like to make a small demo, on how to create a simple REST application using Python, which will use IRIS as a database. Using this tools
