Hello,


I need support for my case!!
I have 18 GB health care cache Database i face delay with filter and transmit data around 20 - 45 Minutes, I need solution to fixed my issue.

I did Rebuild indexes & Tune Table .

Thanks,

0 5
0 534

At the moment I am trying to write a documentation file for a project and intend to use LaTeX for it.
Has anyone already had experience with this? I haven't found syntax highlighting with the LaTeX packages I know yet.
I found a request on Pygment but it was from 2016 and there was no reply on it since then.

Does anyone know a simple way for syntax highlighting COS in LaTeX?
Thanks for your input!

Martin

0 10
0 449

Hi Developers!

Here're the technology bonuses for the InterSystems IRIS Globals Contest 2022 that will give you extra points in the voting:

  • Data-model implementation - 5
  • Functional index implementation - 5
  • Data Move usage - 3
  • Embedded Python - 4
  • Docker container usage - 2
  • ZPM Package deployment - 2
  • Online Demo - 2
  • First Article on Developer Community - 2
  • Second Article On DC - 1
  • Code Quality pass - 1
  • Video on YouTube - 3

See the details below.<--break->

0 2
0 282

I have the object query:

s Rset=##class(%ResultSet).%New("%SYSTEM.License.UserListAll")

I can loop through that query and it generates the report information that I need.

I have a Python process where I use the intersys import to connect to the Cache instance. But I have been unable to determine the correct syntax in Python for this query. Being that 'UserListAll' is a query I attempted to user:

res = <query>.prepare("select * from %SYSTEM.License_UserListAll")

0 2
0 293
Question
· Mar 24, 2022
generate random password

Hello!

I need to create strong random password including letters and integers. Does Cache Object Script has methods to generate password or I have to create my own method ?

0 6
0 439
Question
· Mar 24, 2022
Insert Row by enforcing ID

Hi Guys,

Can I insert a new row and enforcing my own ID not the default id increment?

&sql(INSERT INTO Sample.Person
(ID,Name,SSN)
VALUES ('205','Swift,Jonathan','111-22-3333'))

IF (SQLCODE = 0) {
Write "New Person inserted with ID: ", %ROWID,!
}
else
{WRITE !,"SQLCODE=",SQLCODE," ",%msg }

0 1
0 257
Question
· Mar 18, 2022
HL7 in general business rules

I'm trying to create a general business rule, not an HL7 message router. (This is because i want to return values from the rules and message routing rules don't appear to be able to return values.) But, I want the business rules to be able to look at HL7 messages; I've copied a simple when condition from an HL7 message router but the error log throws up <PROPERTY DOES NOT EXIST> ...... *HL7

0 6
0 434

Hi:
The task Mirror Monitor Launch Task recently failed and is placed in Suspend leave. Although it says USER it is not known as a task for us.

The code runs is HSSYS which is not our main system or namespace for production items.

The task name is HS.Util.Mirror.Task runs

If $system.Mirror.IsMember() Do ##class(HS.Util.MirrorMonitorAgent).StartAgent() and just says the description

/// This is the task definition that Launches the mirror monitor on any mirrored instance

0 1
0 262

Hi,

Are we correct to assume that the IKO topology only allows for the use of one 'data' node type, and one 'compute' node type? So if we want to use several different iris based compute nodes (or data nodes) we have to apply several yaml files? So the following topology config is not possible:

topology:
data:
image: dvza.healthexchange.nl/mmres:0.1
data:
image: dvza.healthexchange.nl/mmauth:0.1
data:
image: dvza.healthexchange.nl/somethingelsethatisbasedonirisimage:0.1

Thanks in advance.

0 1
0 239

What is Selective Build?

Selective Build is a BI feature in InterSystems IRIS (introduced in version 2020.1). Selective Build allows you to build specific elements of your cube while keeping your cube online.

What is special about Selective Build?

Before getting into the details of Selective Build, a brief recap of the different phases during a regular cube build is important. Here are the phases in a regular cube build:
1) Delete existing data in cube
2) Populate cube with full set of data
3) Build all indices in the cube

0 0
0 313

I have developed a process that pulls data elements from a cache instance using the tools provided with the "intersys.pythonbind3" import. This is a windows box. After validating the process, the next step is to install the process on a site (Windows) that does not have an installed version of cache and access the cache instance remotely. But, since intersys.pythonbind3 is part of the cache install, I am not sure what to do to allow this process to function because of the missing import.

0 1
0 334
Question
· Mar 22, 2022
Cache 2007 x64 / x86

Hello,
First of all, I apologize if I got the topic wrong.
But I'm also looking for the 2007 cache version for Windows x86 / x64.
If anyone else has it, or can help me.
Thanks

0 2
0 242
Dear Developer,
Here is a weekly digest of Unanswered Questions on the InterSystems Developers site for the last 60 days.
Unanswered Questions
InterSystems IRIS

Ensemble

Documentation

InterSystems IRIS for Health

Caché

0 0
0 23

Hey Coommunity,

Learn about InterSystems globals, the data model native to InterSystems IRIS® data platform that makes data storing efficient and provides the flexibility your data needs:

Flexible Data Modeling with InterSystems Globals

https://www.youtube.com/embed/b8muossBdKo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 185
Question
· Mar 22, 2022
Time handling and Json

I am having trouble formatting %Time to a JSON format. I have tried configuring the parameter "FORMAT" of my property but that didn't work. For some reason, it keeps putting a Z and the end of the time.

Property:

Property TimeCollected As %Time(FORMAT = "2");

0 2
0 184
Question
· Mar 18, 2022
EnsLib.HL7.Message Querying

We are trying to track down the source of Orphaned messages and noticed that we are unable to query EnsLib.HL7.Message with any kind of WHERE or ORDER BY clauses in our SQL statement.

I know EnsLib.HL7.Message is a system table, but is there a way we can add additional Indexes to the table to make the query run better/faster without affecting the system?

0 4
0 433

Hi everyone,

Does anyone have any experience / examples of converting an .rtf file into an HL7 message (ORU^R01). My example is a histology report which is placed on a server to pick up and then convert if possible for downstream systems who receive HL7.

Struggling to find any sort of examples or even whether its feasible at this stage - there are certainly better knowledged people on here than me so thought id ask.

With thanks

Warren

0 3
0 468

Hey Developers,

New video is already on InterSystems Developers YouTube channel:

What is the InterSystems IRIS FHIR Server

https://www.youtube.com/embed/2FC_yIC9VCY
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 155
Question
· Mar 10, 2022
Visual Studio Code Development

Please, I am having trouble connecting to one of several Health Share servers using ISC's Visual Studio Code add-on.

Installation seemed to go smoothly. I have InterSystems's Studio and was able to automatically pull in my existing connections. However when I try to make a connection it fails.

Here is a configuration of one connection slightly edited for security:

"xxxx-hsiecommon-base": {

"description": "This has been created by the CCR system export.",

"username": "therock",

0 3
0 507

SET ^||fruit(1)="apple",^||fruit(4)="banana",^||fruit(8)="cherry"
SET ^||fruit(1,1)="Macintosh",^||fruit(1,2)="Delicious",^||fruit(1,3)="Granny Smith"
SET ^||fruit(1,2,1)="Red Delicious",^||fruit(1,2,2)="Golden Delicious"
SET ^||fruit="Fruits"
ZWRITE ^||fruit

^||fruit="Fruits"
^||fruit(1)="apple"
^||fruit(1,1)="Macintosh"
^||fruit(1,2)="Delicious"
^||fruit(1,2,1)="Red Delicious"
^||fruit(1,2,2)="Golden Delicious"
^||fruit(1,3)="Granny Smith"
^||fruit(4)="banana"
^||fruit(8)="cherry"

0 4
0 485

In addition to the previously advertised Cache/Ensemble developer role we also have a requirement for a Cache/Ensemble Support Analyst at SystemC in the UK.

SystemC are looking for a talented and experienced Support Consultant to join our CarePlus team where you will have a pivotal role within the team, providing technical support to our customers.

0 0
0 284

Hello,

Our team is looking for a way to export all of our Cache SQL tables into Microsoft SQL Server. I have only found a method to export one table at a time into an ASCII file. We have over 170 tables so this would be very tedious and time consuming. Is there a way to directly export from Cache to SQL Server. Alternatively is it possible to export the entire database in a single shot or even multiple tables to text files?

Thanks!

0 2
0 579