I use Microsoft Query via Excel to query an Intersystems database. 

Since upgrading from CACHE to Intersystems, lots of reports fail to refresh twice - by which I mean I can open the report (which may have several separate queries) and query the database once, and then it will refuse to reconnect.

I get:
[IRIS ODBC][State : S1000][Native Code 417] .... Access denied

If I then close and reopen excel, I can run the query again.

0 6
0 106

I added a Response Message Class to a call in the Business Process Designer.

When i click on Response Actions or on Response Builder i get a message

"You must specify a response message class in order to add or edit response actions."

no matter which response message i choose i always get the above warning.

how do i fix this?

 

Thanks

 

0 2
0 104

I'm setting up Azure DevOps through IRISHealth (localhost) terminal and got the following error after trying to compile CD/CI pipelines:

Compiling routine Dws.CD.Data.History.1
ERROR #6301: SAX XML Parser Error: invalid XML encoding declaration '' while processing Anonymous Stream at line 1 offset 32
  > ERROR #5090: An error has occurred while creating projection Dws.CI.SourceControl.Git.GitStudioExtension:Menu.

First line of CD.Data.History:

Class Dws.CD.Data.History Extends %Persistent

0 1
0 104

Hi InterSystems Architects,

 

Please may I know the relationship between 

1. Menus, Workflows, Workflow Items, Components, Code Tables, etc 

Detailed relationship diagrams, how each element in each of the above are related to another. 

2. When I extracted the data. I see ID number, but they aren't unique or related. I wanted to build a relationship between them myself in the absence of documents but I am missing the critical unique primary key of each and how they are referred in another table.

0 3
1 103

Hello All,

I am looking for some ideas from people who have automated alerting in place for their Ensemble or IRIS productions.  

I want to start with basic things like, simply checking if a Production is up and running. Once this has been achived, I am looking to go deeper and implement monitoring on each interface level for things like, Queue Size, Errors and Inactivity.

1 3
1 102

I am working in Intersystems Healthshare product.

 

I want to clear the message logs from a particular interface (Service,process,operation). 

In intersystems we have the option to purge the data for all interfaces for the corresponding time but I want to clear the data logs for particular interface only.

 

Please let me know how to approach this scenario.

 

0 3
0 102

In Oracle database, the synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.

You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schema owns the object.

Is IRIS SQL sintax has something like this: (oracle sintax)

1 1
0 101

Hi all,

I am testing asynchronous Bulk Data retrieve with a large EHR vendor. When I retrieve the bulk data, they are returning ndjson (CONTENT-TYPE of "application/fhir+ndjson; charset=utf-8"). If I attempt to process that content using JSON functions - I get

ERROR #5035: General exception Name 'Parsing error' Code '3' Data ''

For example, the following generates the error

s objArray={}.%FromJSON(quickStreamOut)

The error makes sense in that ndjson is not a valid json format (I assume at least).

0 1
0 101

I am attempting to prevent ADT merge messages from coming into Healthshare if the MRN being merged does not exist. To my mind, the best way to do this would be to check the PriorPatientIdentifierList.IDNumber against the HS.SDAStreamletMRN global. However, I'm not able to get it to work in Business Rule classes. 

Something like:

<when condition="$G(^HS.SDAStreamletMRN('MRN','Facility^AssigningAuthority^'_(Document.{MRG:PriorPatientIdentifierList(1).IDNumber}))=(&quot;&quot;))">

    <return></return>

0 1
0 98

Hi All,

In earlier cache version, I can see full data values in SQL management portal.

But IRIS restricted the view only to 100 chars.

"If the data in a field is longer than 100 characters, the first 100 characters of the data are displayed followed by an ellipsis (...) indicating additional data." - From Documentation.

Is there a way to change this behavior ? I would like to see all the values in the particular SQL field.

 

Thanks in advance,

Archunan K

0 2
0 96
Question
Joseph Conaty · Sep 14, 2021
P2P OAUTH Recommended Flow

Hello,

I'm hoping to get some feedback on the OAuth process flow for Payer-to-Payer authorization.  It doesn't seem that "Authorization Code Flow" is needed as there will not be a need for a login.  I am leaning towards recommending "Client Credentials Flow", but wanted to get some community feedback before making a decision. I prefer to follow what the standard will be if possible.  What would you recommend?  Thank you in advance for your input.

 

0 2
0 91
Question
Tom Bruce · Jun 20
Visual Studio c#

Hi, I tried the following exercise from the IRIS documentation. I updated the username, password and IP address, but receiving this error;

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. --->

I can use the same credentials and IP address to connect ok via VSCode to my local IRIS...

Any pointers much appreciated.

 

0 3
0 91