Hi all

I have a pair of servers configured as a mirror, each server sits in a separate data centre.

I have noticed that occasionally, the primary will report that the backup is disconnected in the Mirror Monitor, and I believe this to be due to connection conditions between the two data centres.

What I want to do is log the status of both servers from the primary on a regular basis using a service. I know %System.Mirror can return the status of the current member, but how can I log the get the status of the other member as well?

Cheers

Hey DC Members,

You have ideas on how to make the Tech Article contest even better? 

We want to hear from all of you: both from our participants and from those who were unable to participate! Please answer some questions to help us improve our writing contest:

👉 1-min survey: InterSystems Tech Article Contest #3 Survey

Hello, new user here ! My admin granted me all access to the domain I'm working on. Nonetheless, I'm unable to perform simple SQL queries such as creating a table or an index.

What I have tried :

• Creating a table : within the namespace I've been granted access to, I'm trying to create a table with 2 methods :

  • Basic query : CREATE TABLE test.hello_world (col1 INTEGER, col2 VARCHAR) This raises the error :

  [SQLCODE: <-400>:<Fatal error occurred>] [%msg: <Exception caught during dSQL statement %Execute: <PROTECT> ^rINDEXCLASS("HS.JSON.WRITER"),/iris/irishealth/mgr/HSCUSTOM/>]

  • Creating a

I've faced a problem that happens while debugging a process in VSCode. It doesn't seem to matter if this is in a container, on my development VM, or against a locally installed version of IRIS. The problem seems to be mostly with X12 Documents.

So, in a debug session, I can dump out a value to the debug console and it loos correct. The same variable in VSCode appears to be some uninitialized memory location.

In the interactive debugger window:

In the Variables Window:

Host Workstation:

It's not all variables, as you can see, and it always seems to to be same garbage values that get populated.

Hi Community, 
We have launched new challenges and badges on Global Masters: now you can submit bugs or pull requests for Open Exchange Applications and get points!

I want to get Mirror Status and copy this report into a file for audit purposes.

I have a Linux servers for IRIS DB with this layout:
LIVETC01           Backup
LIVETC02           Primary
LIVEDR             Async Copy
ARBITER

I understand that this will get me the mirror status
# sudo -u irisowner iris session LIVETC01
LIVETC01:USER>zn "%SYS"
LIVETC01:%SYS>do ^MIRROR

1) Mirror Status
2) Mirror Management
3) Mirror Configuration

Option? 1

1) List mirrored databases
2) Display mirror status of this node
3) Display journal file info
4) Status Monitor

Option? 4
Status of Mirror LIVETC at 14:25:22 on 08/05/2022
Incomin

Hi Fellows,

I'm glad to share with you my certification:

https://www.credly.com/badges/7e35dab9-fb96-46b2-aa45-846dfca2ff58/public_url 

Has anyone had any success reading barcodes from PDFs or images in a Cache/IRIS application? I've been looking at some possible solutions for this, including the open source ZXing libraries. I know we have the ability to create them in Zen and Intersystems Reports, but as far as I know, there's nothing built in to actually read data from a barcode. If anyone has suggestions on how to go about this, I'd love to hear them.

In our specific case, we print reports with a Code 128 barcode on them.

Hi,

I have a problem with the recent update 4.9.4 of the WebTerminal.

This message appeared after the loading of the page :

New update is available. Click here to install it now. Changelist:
4.9.4: No longer require /terminal to be at the root of the URL

So I installed the new version. Unfortunatly, after refreshing the page, I have this message again and again :

WebTerminal lost connection with server (code 1006).
Attempting to restore session in 10 seconds...
Please, refresh the web page to start a new session.

WebTerminal lost connection with server (code 1006).

Hi Community!

While we're on a roll with new ideas for the Developer Community, we decided to also give the credit where the credit is due (meaning you, our dearest members), and share your creativity and imagination with others.

We're going to introduce a new rubric "InterSystems Memes"! 😜

Hi

I created a password validation routine for the management portal, which is called from the System-wide Security Parameters.
The validation process works correctly, but the error message that is displayed to the user when the entered password fails validation, consists of two separate error codes and messages

I see the following message when I click on my User at the top of the Management Portal screen (which then opens the popup window), to change my password and enter an invalid password:
ERROR #1446: Password change failed ERROR #5001: Password must contain at least one upper-case character

W

Hi,

I have a question about deleting journals at the OS level(Linux) without corrupting the IRIS DB or it’s mirror copies.

The reason for deleting journals is the filesystem it lives on frequently fills up. 

I don't have enough disk space to further expand the journal filesystems.

When the journal filesystem fills up then the application stops.

I have the following IRIS nodes(mirror status)

LIVETC01            Backup

LIVETC02            Primary

LIVEDR                Async Copy        **OFFLINE**

ARBITER

LIVEDR is currently offline but IRIS software has been installed.

I checked inside Mirror Monitor

I am doing a HL7 data transformation with object script but need to only write a substring from the first "(" of the NTE-3 field to the end.

example

Input: NTE|1|||Some text (HI) (321)|ABC

Desired Output: NTE|1|||(HI) (321)|ABC

Basically I'd like to delete "Some text  ".

If I were writing a shell script I would use sed 's/^.*(/(/' with perhaps a modification to get only the first.

I use the function wizard but can't seem to get the right code.

This is the fourth in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready.  Many updates, fixes and enhancements  have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. Please share your feedback through the Developer Community so we can build a better product together.

 The Early Access Program (EAP) is still active for the Columnar Storage.   Customers interested in exercising it should join the Ear

Kindly help me on the below points

1)Concatenate the Date column and Time column.

2)Get the current date only without time.

3)Find the current age using DOB column.

Hey Developers,

In July, you posted 83 questions on Developer Community:

And now it's time to announce the Key Questions of July, chosen by InterSystems Experts! 

Hey Community, 

See how data integration features in InterSystems IRIS data platform enable you to easily connect your systems, processes, and people: 

⏯ Integration Features of InterSystems IRIS

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2022:

Now available: InterSystems Learning News for July 2022! See how you can:

•    Sign up to be a beta tester for the InterSystems IRIS System Administration certification exam.
•    Find opportunities to keep you and your team learning.
•    Connect to InterSystems Cloud Services.
•    Take a classroom course on InterSystems Change Control Record (CCR).

And more! Read all about it and subscribe in the July 2022 Learning News.

Hi team,

I'll start with an apology as I am trying to wrap my head around the architecture of how InterSystems IRIS database management works. I am attempting to connect to the platform remotely through say a JDBC or ODBC connection in order to run queries, searches (through SQL statements) on my laptop and was trying to understand whether this would be possible? It is possible to setup an inbound client connection and wanted to better understand the architecture of how the database association works for IRIS database management. Does it use it's own internal SQL database or are we able to connect to our own database and which databases are certified to run against the platform?

Hi,

Is there a way to access the logs of a specific run of a task from the management portal task manager? I'd like to retrieve the output of a given run without going into the entire task history in an output file.

Thank you!

How to convert from internal date format to JSON/Web date format: YYYY-MM-DDTHH:mm:ss (example: 2012-04-23T18:25:43)?

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes. 

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

Hi

I'm trying to add multiple rows at a time to a SQL table for a persistent object, but I can't seem to get the syntax correct. When I try the below it doesn't work.

INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank) 
VALUES 
('123456', 'AccountNameOne', 'BANK1'),
('654321', 'AccountNameTwo', 'BANK2')

Thanks

Peter

Hi Guys,

Is there online tutorials or samples on how to use Inbound Adapters ?

All I'm looking for at this stage is to create and inbound Adapter in a production to request to connect to a client where I can Get JSON file and what do I need to establish the connection?

Thanks

Hi Developers!

We have great new articles for your to read and enjoy, thanks to our wonderful participants of the 3rd InterSystems Tech Article Contest: Python Edition!

🌟 12 AMAZING ARTICLES 🌟

And now it's time to announce the winners!

Let's meet the winners and their articles:

Hi Community:

Interesting stats from Global Summit 2022. 

The 15 most popular sessions, in order by attendance numbers, were

1. Getting to Know FHIR: The Best Explanation of FHIR They’ve Ever Heard (137)
2. Health Connect Cloud (111)
3. Using Python with InterSystems IRIS (107)
4. Analytics with InterSystems: New & Next (104)
5. InterSystems IRIS FHIR SQL Builder: Sneak Peek (76)
6. API Management with InterSystems IRIS (72)
7. Ten Times Faster Queries with Columnar Storage (71)
8. The Future of Healthcare on the Cloud: Containers/ Kubernetes (71)
9. Embedded Python Use Cases (70)
10. How InterSystems Supports

Hi, we are trying to run a dynamically generated Oracle Insert SQL script using Do $SYSTEM.SQL.DDLImport("Oracle",""," sql.txt",[Error Log]) to insert multiple rows into a Linked Table within HealthConnect to an Oracle database.

We have tried using statements that are accepted within Oracle but not when using Intersystems DLL along the lines of :

INSERT  INTO mytable (column1, column2, column_n)
  SELECT expr1, expr2, expr_n FROM Dual  UNION ALL
   SELECT expr1, expr2, expr_n FROM Dual;
  
SELECT mytable (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
  INTO mytable (column1, column2,

What are other's thoughts, opinions and experiences going from CSP to RESTful services, specifically when it comes to reusing code in CSP files?

One could define a method in CSP as follows:

<script language="cache" method="SubmitSomethingAwesome" arguments="aswesomeId:%Numeric"> 

And it's generated in csp.mycsppage.cls ascsp.mycsppage.SubmitSomethingAwesome(awesomeId as %Numeric).

Have people had success defining there rest call by calling the generated CSP classmethod?

Things that work well I've found:

- Procedure block is off so you can easily pass the symbol table around from the REST