New post

#InterSystems IRIS

29

InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.

Hi,

While starting newly created production I am getting below error:

17:14:05.498:Ens.Director: ERROR <Ens>ErrProductionSuspendedMismatch: Production 'Training.NewProduction' was suspended, a new production of a different name can not be started.

Please note that I can start and stop 'Training.NewProduction' successfully but still the status of the Training.NewProduction' is suspended.

Thanks

0 4
0 294
Question
· Aug 4, 2021
Azure Mirroring - VIP

Has anyone firstly got VIP working for mirroring in Azure? We are pretty sure that this won't work but I wanted to verify it.

Has anyone used the Azure Load balancer to act as a Virtual IP and if so was a application gateway required.

Interested to know your experiences in getting this working.

0 9
0 542

Hi Experts

I am trying to pull the code tables Information and this code table has linked code table not exactly obviously joined by SQL tables or columns. This is confusing me. Please can you clarify how to link these two tables.

I will be generic to ensure, any privacy is protected

CT_Hospital has CT_Staff linked in.

When CT_Hospital has data, for that relevant hospital code, CT_Staff can be clicked and data entered.

When I see in the Components - > Items I do not see any SQL table or SQL column common between CT_Hospital and CT_Staff.

0 1
1 299

Hey ISC Community!

For a small automation feature I would like to login to the IRIS shell non-interactively, skipping the whole username and password prompts, providing the credentials through other means. Something in the fashion of "iris session <instance-name> --user myuser --pass mypass" would be great, but the session tool itself doesn't seem to be capable of doing this.

3 6
0 653

I have a BPL Business process which always processes messages - mainly it waits for responses since downstream systems are seriously async.

I need to update this process.

Wwould the existing instances of this Business Process complete correctly after the update?

My BPL changes would result in:

  1. New S method in the Thread class
  2. New OnResponse method in the context class

Both changes are in the middle of the process, so there are S/OnResponse methods before and after my change.

0 4
0 127
Question
· Jul 28, 2021
%XML.Reader Limitations

Hi all,

Are there limitations to the size of a file or stream that %XML.Reader will parse?

I am trying to parse a large, 573MB, XML file using either the 'OpenFile' or 'OpenStream' methods, but both return errors.

When I try to use the 'OpenStream' method I get a 'ERROR #6301: SAX XML Parser Error: input ended before all started tags were ended' error',

and when I try the 'OpenFile' method I get a 'ERROR #6301: SAX XML Parser Error: <STORE>'.

0 2
0 353

in order to do analysis on huge data volumes, it is better to take you data to a separate machine for analysis away from the operational machine, so trying to write huge globals or tables into files as is would take a huge space, what could be a solution or best practice ?..in python for instance, there is the pickling option (serializes data to byte string and saves it to a file) to save space, what could be best in object script ?

0 11
0 1.2K

Hi,

When for any particular reason I need to update a record and don't want to pull the triggers, the keyword %NOTRIGGER can be used. But I've been trying to do the same when I change the row using the object approach, but I can't find it. Anyone knows if it's possible to avoid pulling triggers when working with objects?

Sadly, the utility "DISABLE^%NOTRIGGER" doesn't seem to exist ;-)

Thank you,
David

1 2
0 237

Apologies if this isn't the correct forum but here goes..

I'm accessing an Intersystems database from MS SQL Server using Intersystems ODBC driver and using OPENQUERY statement to read metadata of tables using

SELECT * FROM OPENQUERY([<linked server name>], 'SELECT * FROM INFORMATION_SCHEMA.COLUMNS')

but I get an error message saying INFORMATION_SCHEMA.COLUMNS cannot be found.

Intersystems SQL documentation does reference this table so is there some other way to access this table or is it maybe a permissions issue?

0 3
0 569

I successfully installed IRIS Community edition on my new RYZEN7 desktop. However when I try to start IRIS I get an error event that states IRIS cannot start due to too many cores. (I have 15 on this CPU).

So how do I resolve this? I do have to install the image onto a single core? Or how many cores can this version run on?

Any comments/suggestions or hysterical laughter will be very much appreciated.

Thanks,
Gary Marston

0 3
0 385

I'm close with this but I'm not sure how to grab JUST the GT1.3 data. I know I can do a substring but finding the 3rd | is a tad tricky. I've not been this deep in SQL for 15 years.

SELECT SUBSTRING(hm.RawContent, (CHARINDEX('GT1',hm.RawContent)), 50) as NameDesc
FROM Ens.MessageHeader as em, EnsLib_HL7.Message as hm
where em.Status = 'Suspended'
and em.MessageBodyId = hm.id

I expect it should flow like this...

SELECT UNIQUE SUBSTRING(RawContent, (FIND 3RD PIPE),(FIND 4TH PIPE) as NameDesc ....

0 1
0 209

Uber type application and database management system wanted.

Reaching out to the development community. Here at POLC we are planning to soon launch a new ride hailing app called POLC. Wanted to know if any developers on this forum has built a similar system before? Please DM me on +27 66 243 1618

0 2
0 269

Greetings

Reaching out the development community to understand if there is anybody out there whom have developed a financial transactional switch or stock exchange on Intersystems before. If so please DM me on +27 66 243 1618.

Many thanks and Regards

Johan Bosch - Founder and CEO

POLC Global

2 4
0 247