Question Katrina E Rodenhaus · Sep 14, 2023

I am very new to IRIS. We are developing a PHP application that connects to an IRIS instance of one of our vendors. This works well most of the time, but when I query a table to get data from particular fields that contain long text strings, it returns `NULL`. These fields are all `VARCHAR(30000)`.

I tried using the `$extract` functionality in the IRIS documentation, but that made no difference. I also tried setting the PHP setting `odbc.defaultlrl` to both 31K and 0. Neither resolved the issue.

I also looked through the internet to try and find a similar issue, but wasn't able to find anyth

1
0 367
Announcement Jeff Fried · Sep 14, 2023

From time to time InterSystems must respin a release to correct 1-2 issues. This process generates new kits called "Point Releases".

A Point Release is distinct from maintenance or feature releases.  Its objective is to correct an urgent issue in the field quickly and surgically.  

0
0 517
Question Nezla · Sep 14, 2023

Hi Guys,

I've an fileupload and button that executes   Upload() clientmethod to upload files in my database and everything works fine when I run the application in the server where it is located, but if I run it from a client machine the %OnSubmit class method doesn't get invoked when form.submit() get executed so how can I fix this?

I can always use <submit> button but the thing is that I need the current form to close after submitting the form but adding  &js<window.close()> st the end of %OnSubmit classmethod to close the window is not working 

<html>
<input type="file" size="80" name="F

1
0 226
Article Mihoko Iijima · Sep 14, 2023 1m read

InterSystems FAQ rubric

It can be retrieved using the schema INFORMATION_SCHEMA.

INFORMATION_SCHEMA is a system schema and is not displayed by default in the SQL menu of the Management Portal.

The method to display it is as follows.

  1. Open Management Portal → System Explorer → SQL menu.
  2. Check "System" on the left of the schema drop-down.
  3. Select INFORMATION_SCHEMA from the schema dropdown.

The SQL to get the ID, field name (COLUMN_NAME), data type (DATA_TYPE), description (DESCRIPTION) for the specified table (Sample.Human) is as follows.

SELECTID,COLUMN_NAME,DATA_TYPE,DESCRIPTION
0
1 675
Discussion John Murray · Sep 8, 2023

Earlier today I enrolled at Cloud Services Portal and clicked "Start trial" for the "Health Connect Cloud" service. Next step was "Create Deployment". The only deployment size offered was "Micro", so I picked that, completed the other required details and clicked "Create".

Response was:

I reported this using the "Submit Feedback" option on the dropdown from my username in the top right of Cloud Services Portal but haven't yet received a response. Hence this DC post, in case someone here can tell me what I'm doing wrong.

9
0 304
Question Nezla · Sep 13, 2023

Hi Guys,

I've a popup zen page to upload files using the input tag and submit button as below :

<html>
<input type="file" size="80" name="FileStream" class="button" id="fileUpload" />
</html>
<!--imageclickbutton id="btnUpload" caption="Upload" width="90" height="30" onclick="zenPage.Upload();"/-->
<submit align="right" id="Submit" name="Submit" caption="Upload1" />

and the problem is that after loading the file on the %OnSubmit classmethod I need to execute a client code a Javascript clientMethod  (CloseAndRefresh()) which closes the current popup screen and refresh a gridview in Original pag

2
0 362
Question Scott Roth · Aug 9, 2023

Still working on my first External REST API call, and I am struggling to find the exact answer I am looking for... I get a JSON response from my API call but I am not quite sure how to dynamically get the JSON response into the Ens.Response Object with its lists of Arrays that I have defined.

  set tSC = ..Adapter.SendFormDataArray(.tHTTPResposne,"POST",tHTTPRequest,,,tURL)

  set pResponse = ##class(User.REST.Epic.Msg.GetPatientLocationResponse).%New()

  set dynObject = {}.%FromJSON(tHTTPResposne.Data)

  set iter = dynObject.%GetIterator()

  while iter.%GetNext(.key,.value){

    $$$TRACE

10
0 732
Question Pietro Di Leo · Sep 7, 2023

Hi everyone,

I have a question related to a strange issue I've been experiencing over the last few days.

Context

I'm attempting to create an automatic resending system that, if no reply is received from the server, raises an error and re-sends the message. This process continues for the a duration defined by the FailureTimeout (e.g., 20 seconds), and a new message is being sent every 5 seconds until the FailureTimeout is reached. If no response was obtained from the server, the system returns an error. 

Issue

I've noticed that at times, even with the same input and settings, the outputs d


2
0 368
Question lw lw · Sep 7, 2023

My cluster status is as follows:

when I do journal restore on primary, it says journal restore is not allowed. The DR is also not allowed to do journal restore.

1) Begin Journaling (^JRNSTART)
 2) Stop Journaling (^JRNSTOP)
 3) Switch Journal File (^JRNSWTCH)
 4) Restore Globals From Journal (^JRNRESTO)
 5) Display Journal File (^JRNDUMP)
 6) Purge Journal Files (PURGE^JOURNAL)
 7) Edit Journal Properties (^JRNOPTS)
 8) Activate or Deactivate Journal Encryption (ENCRYPT^JOURNAL())
 9) Display Journal status (Status^JOURNAL)
10) -not available-
11) -not available-
12) Journal 
3
0 267
Discussion Sylvain Guilbaud · Sep 11, 2023

Currently, the SQL privileges (SELECT, INSERT, UPDATE, DELETE) are managed at the tables level, which can be very tedious when you have to administer many roles in an organization, and need to keep them sync with a constantly evolving data models.
By managing privileges at the schemas level, will allow to give SELECT and other DML privileges to *all* or *several schemas* to a role|user, fixing the need to manually synchronize the new tables|views to the roles.

If you agree, I invite you to vote for this idea.

6
0 353
Question Emil Odobasic · Sep 6, 2023

Hello everyone!
I need to build something that will receive a REST request. As of now I have tried my luck with using an EnsLib.HTTP.InboundAdapter. But i am not so sure how I am supposed to configure it to be able to receive the REST request together with the JSON body.
I have specified the OnProcessInput in the adapter so that it receives a GlobalCharacterStream. However, I have not had any good luck finding out to actually make the request to the EnsLib.HTTP.InboundAdapter. 
I would be really thankful if you could let me know if it is possible for an EnsLib.HTTP.InboundAdapter to actually rece

8
0 495
Discussion Luis Angel Pérez Ramos · Sep 11, 2023

I usually receive complains from our customers about the BPL and DTL web pages automatic refreshes, it's a common problem among newbies users but for veteran developers too, they forget to save the changes regularly and automatically the web page is reloaded, losing all the work done.

Maybe an autosave would fix this problem that produces a deep feeling of hate and resentment against InterSystems technology among our customers. I've added an idea in our portal, so feel free to vote it!

https://ideas.intersystems.com/ideas/DPI-I-452

12
0 337
InterSystems Official Bob Kuszewski · Aug 17, 2023

We often get questions about recent and upcoming changes to the list of platforms and frameworks that are supported by the InterSystems IRIS data platform.  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

With that said, on to the update…

IRIS Production Operating Systems and CPU Architectures

Red Hat Enterprise Linux

  • Recent Changes
    • RHEL 9.2 & RHEL 8.8 were released in May, 2023. Red Hat is planning to support these releases for 4 y
4
2 685
Question Pravin Barton · Sep 12, 2023

I have a VS Code workspace using server-side editing with separate folders for different namespaces on the instance:

{
	"folders": [
		{
			"name": "SYS",
			"uri": "isfs://server:%SYS/"
		},
		{
			"name": "cls",
			"uri": "isfs://server:USER/?filter=*.cls"
		}
	]
}


The VS Code search works well to find symbols in ObjectScript files, but it searches across all folders. Is there a way to include or exclude certain folders from the search? I've tried adding some patterns to the "files to exclude" dialog, but none of these seem to work: SYS/**, /SYS/**, %.*, \%.*

3
0 910
Discussion Dmitry Maslennikov · Sep 1, 2023

In today's landscape, enterprises have grown substantially in scale, amassing vast amounts of data. This data is collected from a plethora of sources including different applications, databases, and other channels. Given the diversity and volume of this data, it's only logical for these enterprises to seek a deeper understanding of what their data entails. Some of the data can be stored in IRIS, and it can be reasonable to be able to add this data to a data lake too.

The Internet now offers many different tools for such tasks, that do not yet support IRIS, but it's achievable. 

What do you t

7
0 673
Question Smythe Smythee · Sep 11, 2023

Hi Community,

I have SDA file as Ens.StreamContainer Message using pRequest As Ens.StreamContainer

SDA file structure looks like this 

<Name><FamilyName>Lucy</FamilyName><GivenName>Hale</GivenName><MiddleName>Park</MiddleName></Name><Gender><Code>F</Code><Description>F</Description></Gender><BirthTime>2023-09-07T00:00:00</BirthTime>

How can i change individual value from the Steam and then save changed value into the stream?

3
1 968
Question Robert Bielen · Aug 25, 2023

Hi Everyone

I'm just wondering if anyone might have a list (or the experience to make a list) of the most often used / useful Reply Code Actions?

In the Help section of Health Connect Management Portal, it lists 

'E=F' and ':?R=RF,:?E=S,:~=S,:?A=C,:*=S,:I?=W,:T?=C'

as the default options, though I'm curious if anyone else has found other codes or strings of codes useful?

Thanks in advance. 

Best wishes

Robert

3
0 721