Enrico Parisi 路 Jun 17, 2024 go to post

Why define and reference an outbound adaptor when you don't use it in your code?
I'd suggest to have a look to the documentation Using the HTTP Outbound Adapter.

Anyway, given your code, you don't need a stream, it's just waste of resources and make your code more complicated for no reason, you can simply:

....
Set httpRequest.ContentType = "application/xml"
Do httpRequest.EntityBody.Write("<?xml version=""1.0"" encoding=""UTF-8""?><getURL>"_pRequest.getURL_"</getURL>")
Set sc = httpRequest.Post("", 2)
....

Note that I assume that <Url1></Url1> is contained in the getURL string property content, as your first post suggest.

Enrico Parisi 路 Jun 17, 2024 go to post

Where do you see the ![CDATA[  ?

CDATA it's part of an XML document, "a CDATA section is a piece of element content that is marked up to be interpreted literally, as textual data, not as marked-up content" (from wikipedia).

If it's contained in a string property (is this that you mean by field?), then evidently that value was assigned to the string value.

But I suspect your question is missing the context......

Enrico Parisi 路 Jun 17, 2024 go to post

I like the list view so much that I suggest to make it default view! 馃榾

I'm afraid that most people won't realize that's available and what they miss in readability.

Enrico Parisi 路 Jun 17, 2024 go to post

I think I don't understand the question or the answer is simple.

Implement your routing rules as needed, with or without transformation as needed, and send the message from Rule1 to Rule2 and Rule3 according to your needs.

Otherwise, please provide more details or better explanation on what you need to do.

Enrico Parisi 路 Jun 17, 2024 go to post

What class is pRequest? If it's a custom class, can you post the class definition?

Enrico Parisi 路 Jun 17, 2024 go to post

I don't understand your question in the context of the original question:

"I work with a legacy that most screens are built using only CLS"

If you want to rewrite using modern approach, then use your favorite front-end framework and implement  a REST API in the Cach茅 backend.......and maybe move from legacy Cach茅/Ensemble to modern IRIS as well...

Enrico Parisi 路 Jun 17, 2024 go to post

I'm not a python expert, but I'd try with:

imptask = dbnative.classMethodValue('%SYS.Task','ImportTasks',"F:\\Zbackup\\LISBackupTask.xml","ck")

Enrico Parisi 路 Jun 16, 2024 go to post

ImportTasks() method returns a %Status that probably contains the answer you are looking for.

I'd suggest to check that.

Enrico Parisi 路 Jun 16, 2024 go to post

What kind of task? Does your task provide a return status?

If what you need is displayed in the Error column in the "Task History" page in Management Portal, then you can use the query:

select Error from %SYS_Task.History where Task = <YoutTaskID>

Enrico Parisi 路 Jun 16, 2024 go to post

Do you want to use SSL/TLS for incoming connection to IRIS (Ensemble) or want to use SSL/TLS for outgoing connections from IRIS (Ensemble) to other systems, possibly using some HTTP/SOAP/etc. adapter?

Please provide some detail.

Enrico Parisi 路 Jun 16, 2024 go to post

I agree, but that's not the scenario of the initial question!

I tried to address and provide a solution to the original question that it seems has some previous constraints imposed by the current design, not to argue of what it could have been done if....

Enrico Parisi 路 Jun 16, 2024 go to post

I'm not sure if this apply to your case but in the past we found that a very old database (20+ years) that has been upgraded many time over the years had bitmap indices "not compacted" and we gained a lot of space and, more importantly, huge performance improvement running %SYS.Maint.Bitmap documented here:

This utility is used to compact bitmap/bitslice indices. Over time in a volatile table (think lots of INSERTs and DELETEs) the storage for a bitmap index may become less efficient. To a lesser extent index value changes, i.e. UPDATES, can also degrade bitmap performance.

Enrico Parisi 路 Jun 16, 2024 go to post

So, this imply that the sample message published in the document "IHE Laboratory Technical Framework, Volume 2a (LAB TF-2a)" is actually an invalid message?

Enrico Parisi 路 Jun 16, 2024 go to post

I've used Object Script to update linked tables projected as IRIS/Cach茅 classes, like in your sample, since very long time and it works.

As the error says, your issue is that some property/column cannot be set/modified, I'm pretty sure the same issue arise if you use SQL to update/insert the same column.

Without the table definition it's impossible to guess what's the field and why that column cannot be set.
Maybe some of the fields are part of the primary key that includes other fields that are not set?
Make sure that the table is properly linked, the link table wizard sometime need "guidance" on properly linking tables, particularly in defining primary keys...

Anyway, if properly linked, you can definitely treat/manage/manipulate linked tables the same way as native IRIS/Cach茅  classes.classes. 

Enrico Parisi 路 Jun 16, 2024 go to post

From a class that extends %CSP.Page you can include a CSP page using the Include() method inherited from %CSP.Page, like:

Do ..Include("TestInclude.csp")

This is what is actually generated when a csp page containing a CSP INCLUDE tag documented here is compiled, like:

Please note this is legacy (deprecated?).

Enrico Parisi 路 Jun 16, 2024 go to post

Another option is to use the %SYS.GlobalQuery_Size() class query documented here, it can be conveniently used from SQL like:

call %SYS.GlobalQuery_Size('c:\intersystems\iris\mgr\',,'*',1,,1)

It can be called from the portal SQL or any SQL odbc/jdbc client tool.

Enrico Parisi 路 Jun 16, 2024 go to post

Ciao Pietro,

as said %DynamicAbstractObject has excellent performance and can handle easily very large JSON streams/files.
Depending on your system settings, for large JSON you may need to accommodate process memory, fortunately you can adjust it in your code at runtime so you can write robust code that does not depend on system configuration parameters.
Note that the default value of "Maximum Per-Process Memory" has changed during time, so a new installation and an upgraded installation have different values.

IMHO the real question here is: in what side of the JSON processing is your code?

Are you generating the JSON or are you receiving the JSON from a third party?

If you are receiving the JSON, then I don't think there is much you can do about, just load it and IRIS will handle it.
I'm pretty sure that any attempt to "split" the loading of the JSON stream/file will result in worst performance and consumed resources.
To split a large JSON you need to parse it anyway....

If you are generating the JSON, then depending on the project and specifications constraints, you may split you payload in chunks, for example in FHIR the server can choose to break a bundle it up into "pages".

I'm not sure if your question is about loading the JSON file/stream into a %DynamicAbstractObject or about processing the large %DynamicAbstractObject once it has been imported from JSON?

What's your problem and what's your goal?

Enrico Parisi 路 Jun 16, 2024 go to post

It looks like an <UNDEFINED> error occurs in a SQL query generated code.

Debugging generated code it's not easy/simple, I would double check SQL queries and parameters passed to the queries in the CSP page.

Enrico Parisi 路 Jun 6, 2024 go to post

It depends on your timezone, well...the timezone configured in the IRIS system! 馃槉

Does the trailing +01:00 represent your timezone? Or what?

I'm in a UTC+2 timezone, so:

USER>w $zdt($zdth("1988-08-18 00:00:00.000",3),3,5,2)
1988-08-18T00:00:00.00+02:00
Enrico Parisi 路 Jun 4, 2024 go to post

Does the returned sc status contains the <INVALID OREF> error?

Add this line following the one I suggested:

if $$$ISERR(sc) $$$LOGERROR($system.Status.GetErrorText(sc)

Then check the event log after calling your component and post here what you find in the event log.

Enrico Parisi 路 Jun 4, 2024 go to post

An integrity check also treats it as if it was a single file. This is only going to be more of an issue as the max size increses.

There is no other option for integrity check because in multi volume database a global can span across multiple volumes/files and a global structure must be fully scanned to check integrity.

If this is a concern, maybe splitting a global across multiple "small" (the concept of small may vary! 馃榿) database using subscript mapping can be an option.
Integrity check is performed at database/global level, not namespace/global level.

Enrico Parisi 路 Jun 4, 2024 go to post

Evidently there is an issue where you reference MSH:9.2, without details of your rule definition is virtually impossible to guess where the problem is.

Enrico Parisi 路 Jun 3, 2024 go to post

I'd suggest to check the returned %Status from the %FromFHIRJSON() method.

Instead of:

do ..FHIRAdapter.%FromFHIRJSON(pRequest.Payload.Read(),.pmReqFHIRobj,"HS.FHIR.Model.Resource.Bundle")

Use:

set sc=..FHIRAdapter.%FromFHIRJSON(pRequest.Payload.Read(),.pmReqFHIRobj,"HS.FHIR.Model.Resource.Bundle")

Then check the status.

Enrico Parisi 路 Jun 1, 2024 go to post

What platform?

Using the IRIS Community Edition kit you can install only client components, including ODBC driver:

Enrico Parisi 路 May 30, 2024 go to post

You may have the option of using Extended Global References and in particular Bracket Syntax with References to Databases.

In your code you need to change all your global references from:
^SYS("CommonConfig")
to
^[%dbConfig]SYS("CommonConfig")

Then, for normal situation where you want the %ALL mapping to apply, just use:
set %dbConfig=""
When you need to explicitly map it to a BARCONFIG database, then:
set %dbConfig="^^:ds:BARCONFIG"

This way you can switch from default %ALL mapping to "explicit reference" within your code.
In the example I used a % local variable (%dbConfig) to hold the "database name reference" because it has a global scope, you may use a different approach like a property in some of your classes, a macro with some reference (in a global?) or...whatever is appropriate for your environment.

Enrico Parisi 路 May 28, 2024 go to post

Length 50

 

Spoiler

ClassMethod Count(i As %String) As %Integer
{
	f p=1:1:$l(i){i ")]}D>"[$e(i,p),$i(c)} q +$g(c)
}
Enrico Parisi 路 May 28, 2024 go to post

Length: 77

 

Spoiler

ClassMethod Count(i As %String) As %Integer
{
	s i=$tr(i,":;8B=-^co~","") f p=1:1:$l(i){i ")]}D>"[$e(i,p),$i(c)} q +$g(c)
}
Enrico Parisi 路 May 27, 2024 go to post

I'm no Python expert at all, but it looks like user and password are missing. (uid and pwd??)