For background, I've developed code that relies on %JSON.Adaptor functionality across an entire package of classes in our codebase. In regenerating these classes with %JSON.Adaptor as a superclass, I've encountered compilation errors from the JSON adaptor generators in certain classes, triggered by certain property types or parameters that are incompatible.

0 2
0 14

Hi, I am unsure how to remove this restriction; when I am performing dynamic SQL using ##class(%SQL.Statement).%ExecDirectNoPriv(, .query, args...)

It works fine, but the moment I add specific properties from the persistent class I am performing the select on into the WHERE clause, I get: ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation. Despite using %ExecDirectNoPriv, I've tried with prepared statement as well, exact same situation.

0 4
0 72
Question
· May 1
Embedded Python query

Hi Guys,

How can I use this same objectscript principle in embedded python to get the value of each field in my loop?

s sql="SELECT ID, Name, Age FROM Sample.Person WHERE Age="_Myage

Set RS=##class(%ResultSet).%New()

Set Ret=RS.Prepare(sql)

Set Ret=RS.Execute()

While RS.Next()

{

Set name=RS.GetData(2)

}

0 2
0 41
Question
· Apr 25
Setting Python

Hi Guys,

I'm a newbie running IRIS in a container (IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2024.3 (Build 217U) Thu Nov 14 2024 17:30:43 EST) and trying to setup Python so I can start working on ML & Autosklearn,my understanding is that IRIS already comes with embedded Python but unable to do something like "import pandas as pd" in VSCode which looks like I need install a more complete version of Python or packages, so what I'm missing?

1 1
0 55
Question
· Apr 23
IntegratedML

Hi Guys,

I'm a newbie that doesn't know much about integratedML and looking for a first push into it, I've setup VSCode with my IRIS 2024.3 running in Linux and my understanding is that we can create models using SQL, so first, do I need to setup a specific environment where I can run my SQL commands to create & train Models or just using SMP, and do I need to install or enable Python ..etc things required to setup the environment?

Then if there are easy samples or training materials on how to create, train & deploy my model?

Thanks

0 2
0 39

Hello Team,

I got xDBC protocol is not compatible while executing python script. How to fix this error

C:\Users\ak\Desktop\lpyth\iris>C:/Users/ak/AppData/Local/Programs/Python/Python312/python.exe c:/Users/ak/Desktop/lpyth/iris/irisconn.py
An error occurred: connection failed: IRIS xDBC protocol is not compatible

py -m pip list
Package Version
------------------ ---------
intersystems-iris 3.9.2

0 2
0 33

Hello,

One of our clients has a 'Notes' class with over 3 million records. We have a report that pulls data from this table that was taking about an hour to run. Our test environment (which has a copy of the production database) runs the same report query in 1 second.

We attempted to purge and rebuild indices which made an improvement (down to 15 minutes) but still not great.

0 3
0 67

I am receiving the garbled text due to incorrect encoding or decoding. I tried to use the $zconvert function to convert it into the normal text but failed to do that. Can anybody suggest what I have to use to convert that into normal text?

Example: Garbled text that I am getting is "canââ¬â¢t , theyââ¬â¢re".

0 6
0 77
Question
· Apr 1
S3

Hi Guys,

Not sure what I'm missing here, I'm using to download files that starts with MTC_88 from S3 bucket using AmazonS3 inboundAdapter as below, but I'm not getting anything and I'm sure there thousands of files that starts with MTC_88

and the log is not getting any errors?

0 2
0 48

When batch inserting data into a table via SQL, I can use the %NOCHECK keyword to avoid checking foreign key integrity. This would be appropriate for cases when the inserted data has been verified by some external process.

However, when inserting via objects, I don't see a way to get the same behavior. Are there any workarounds that use objects for this?

1 4
0 86
Question
· Mar 25
AWS Files

Hi Guys,

I'm looking to create a service to download files from S3, so I used the EnsLib.AmazonS3.BusinessService with settings as below to download files that starts with SMfile_48 but I'm not getting any files, am I missing something?

Thanks

0 1
0 36
Question
· Mar 18
SLF4J error

Hi Guys,

I get the attached error when trying to populate JSON string into a textarea, I'm running IRIS 2024 in a container in Ubuntu, any clues what could be the problem?

Thanks

0 2
0 32