I'm able to log into my local instance of HealthShare through the Management Portal, but once I've done so, the screen is entirely blank. I'm still able to access Terminal and Studio without any issue, as well as a hosted instance's Management Portal. I've tried stopping and starting HealthShare, no luck. I've been working on this instance for the past several months and haven't experienced anything like this, and I don't know of anything that I was doing that would have broken the Management Portal. Anyone have a suggestion as to where to go from here?
Is there a quick way to see if an SSL/TLS configuration name is valid, short of switching over to %SYS and checking Security.SSLConfigs:Exists?
Hello.
There is a way to install and try Cachè 2018.1 on Ubuntu 16.04 distribuition or it's necessary use Red Hat/Suse distribuition to try Cachè on Linux?
Hi Community,
I have to make a daily task (Job) which will run (7 am to 7 pm) in a day at an interval of 3 hours. Timings are as (7:00 am, 10:00 am,13:00 pm,16:00 pm,19:00 pm). But at each time when task will run i have to set a variables as per below condition
Sample:
1) If task run at 2019-03-19 07:00 am in morning
I have to set two variables (start and end) whose value will become like this
(set starttime= 2019-03-09 07:00:00.00 and set endtime=2019-03-09 10:00:00.00)
2) But if task run at 2019-03-19 10:00 am in morning, the value should change as per below
(set starttime= 2019-03-09 10:00:00.
Hi all,
Lets imagine that there's a process that locks an entry of a gived domain, in my example the ID 2 of the table User.tApplications and using an exclusive lock. Additionally the error handling is managed by a $ETrap routine wich will look for error data in order to log it
Set $ETrap = "Do Err1^ErrRoutine" Set obj = ##class(User.tApplications).%OpenId(2,"4",.errors) If ($System.Status.
Hi community,
I have a rights problem when giving a user permission to perform some select queries on particular tables. So I have created a user with the following rights.
.png)
So this all works well. No problem so far. But the customer is using a program where you can easily build visually the query by selecting the table, choose the right colums etc. So the problem we have is when I give the user the Role %All the tables are shown.
.png)
And the user is allowed to query all tables.
Can I apply a custom resource to a Management Portal page through code, using the method or global? The documentation only shows the manual mode: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCAS_rsrcs#GCAS_C181701
Or export the settings already saved.
Hello everyone :-)
My colleagues and I have developed a (zen) web application that is now accessible from our main "DEV" web server. We would like to access it from another (IIS) web server, so that the related administration console would be separated from the rest of the applications (EnsPortal and so on). But we also want to use the same Ensemble instance, so that we would not need a completely new installation. And we don't want a straightforward redirection either (that would induce direct connection between clients and the DEV server).
This code snippet is an example of a CSP page that has a dynamically reloading table:
<!--Demo of (re-)loading a table dynamically in a page-->
<HTML>
<HEAD>
<TITLE> Cache Server Page To Demo Table Re-Render</TITLE>
</HEAD>
<BODY>
<TABLE ID=TEST border="1">
<tr>
<td>SSN</td><td>Name</td>
</tr>
</TABLE>
<hr>
<input type="Button" name="render" value="Create Table"
OnClick="#server(.Hi All,
Can any one know how to change the font style as Italics in Terminal
Hi Community!
There are two general ways to execute arbitrary SQL in serverside ObjectScript code: EmbeddedSQL and ObjectScript SQL a.k.a. Dynamic SQL.
E.g. if we want to get the value of the property of instance with a certain ID using SQL we can do:
&sql(SELECT Name INTO :name FROM Sample.Person WHERE ID=1)
write nameSame result with %SQL.Statement:
set rs=##class(%SQL.Statement).%ExecDirect(,"SELECT Name as name FROM Sample.Person where ID=1")
do rs.%Next()
write rs.nameHi,
I would like some help/ information regarding queued messages.
I have 1040 messages that are queued, but I only want to process the first 28 of them. Is there a way that I can do that?
If I abort them, would all of them go away?
Would appreciate if you can advice me on this
Regards,
Eric
Hi,
I am trying to create a user role which shall allow users the access to only one specific namespace in an Ensemble system. I´ve startet creating the namespace with a database (with own ressource and no public access). In the second step I´ve created a role by copying it from the predefined role %Developer and assigned the ressource of the created database. After that i´ve created a user and assign him to the created role.
When trying to login to ensemble - the management portal comes up but the Ensemble tab is showed deactived.
Hello folks,
I have an JSON object that need to be updated before being parsed into a JSX component.
Let's imagine you have only SQL. You need some table where you should increment value in some property when you update this line.
We have the table
CREATE TABLE "test" (
"identifier" VARCHAR(200) NOT NULL,
"value" INTEGER,
PRIMARY KEY ("identifier")
)Hi community,
I want to know how I can see all of the export options when the widjet is located in the below part of the window. This example is the deepsee web demo, but it's passing in my real application and I can´t move to another place.
Thanks in advance.
Regards,
Jaqueline Krieger
.png)
Hi,
what is reason of this error (Not all parameters bound/registered ). this is not happening consistently.
.png)
those are class method parameters
Query GetWorkItemsByEncounterID(encounterID As %Integer, userId As %Integer, IsSuperOrDev As %Integer = -1, facilityAccessListCSV As %String(MAXLEN=32000), locationAccessListCSV As %Library.String(MAXLEN=32000), skipReferralFilter = 0) As %SQLQuery [ SqlName = spGetWorkItemsByEncounterID, SqlProc ]
Our lab system is now sending DSC segments in large Pathology results in the ORU message that is followed by a partial continuation message with only MSH and OBX segments. the pointer is in the MSH;14 in the subsequent message. I believe the goal is to concatenate the first and second message but imagine this will require some custom functions which I have not done much of. Anyone already tackled this by chance?
Initial message:
MSH|^~\&|SOFTPATH^2.16.840.1.113883.3.3013.77.4^ISO|SCC|EPIC^2.16.840.1.113883.3.
After compilation of routine .int file is not generated and toggle breakpoint is also not visible for that routine. It is showing error #5001 Editing of INT file is not allowed. How can I resolve this ?
Hi Community!
New video is already on InterSystems Developers YouTube Channel:
We have built one interface but while sending messages it processed at first but then when we tried to send another file the router just stopped processing the message.
Checked the rule log and it should be processed as it does not falls under non processing condition The router log has no error .The message just sits there.
Hello,
I'm using ZEN report to generate a PDF file out a table.
Although, I need to display data from two tables splitted into two different namespaces.
So, I created a process that fetches all the data I need and then calls the PDF class and generates the stream out of it.
My question is, once I've got my list of objects. How can I transform it into a ResultSet, in order to display in the report ?
Thanks for your answer.
I successfully got everything in this guide to work: https://community.intersystems.com/post/ensemble-rabbitmq-java-client-q…
I am now using the information I gained from this guide along side with this guide:
https://www.rabbitmq.com/tutorials/tutorial-one-spring-amqp.html
I am running into an issue though. In the RabbitMQ guide I just posted, they have a "Receive message" functionality. I use that alongside with the SendMsg from Ensemble method in the InterSystems guide.
Hello,
I'm trying to set up an Apache server using CSP Gateway on Windows 10 (64-bit), but am getting the error "Cannot load c:/InterSystems/IRIS_2019/CSP/bin/CSPa24.dll into server: %1 is not a valid Win32 application" when attempting to start up httpd.exe after adding the CSP-specific section to httpd.conf.
The CSP gateway is 64-bit (CSPGateway-2018.1.1.643.0-win_x64) and so is the Apache install (httpd-2.4.38-o102q-x64-vc14).
The CSPa24.dll file does exist in the specified location.
Any suggestions appreciated.
Thank you,
Olga
Hi
Just curious to know about the pros and cons of Parent/Child Vs One/Many.
We do use a bit of both.
One big reason we use Parent child is we feel if we delete one global, it gets rid of all child data too and all parent child data is stored in one global. Much easier to manage.
Hi Community!
This is the update on what are the new applications submitted on OpenExchange in January and February 2019
This is a tiny example of how to run a server command from within Caché / Ensemble / IRIS and get back the full output as seen in any server command shell.
QEWD.js is a Node.js framework for REST APIs, interactive WebSocket and/or Ajax applications, capable of running as a monolithic application or split across MicroServices. Fully supports Cache, Ensemble and IRIS, allowing use of existing Cache ObjectScript code, Cache Objects and Cache SQL, but also allows the database to be abstracted as a persistent JSON / Document database.
With this simple Business Operation, you can easily leverage your predictive models (saved as PMML) in a Production. There's both a generic BO and a utility method that allows you to generate dedicated operation / request / response classes.
Helps to generate fake/test data for development purposes
WsockClient.csp and WsocClient.js
Web socket clients on CSP and InterSystems node.js adapter to collect end manage data transferred to the client in InterSystems IRIS or Caché
CachéQuality for VSCode by @Daniel Tamajon
IDE extension that helps you detect and fix quality issues as you write code. Like a spell checker, this extension squiggles flaws so they can be fixed before committing code. You can get it directly from the VS Code Marketplace and it will then detect new bugs and quality issues as you code (ObjectScript and JavaScript)
Hi Community!
When you run IRIS container out-of-the-box and connect to it via terminal e.g. with:
docker-compose exec iris bashYou see something like:
root@7b19f545187b:/opt/app# irissession IRIS
Node: 7b19f545187b, Instance: IRIS
Username: ***
Password: ***
USER>And you enter login and password every time.
How to programmatically setup docker-compose file to have IRIS container with OS authentication enabled? And have the following while entering the terminal:
root@7b19f545187b:/opt/app# irissession IRIS
Node: 7b19f545187b, Instance: IRIS
USER>
Hi guys
I've added a new mirrored failover member to an existing one.
They are both Arbiter controlled.
When I do Add database to mirror on the primary I'm always getting an error. Missing Mirrored database.
I followed everything in the documentation and always get the same error.
I've copied the CACHE.dat file after umounting the database on both servers. then mounted them.
Could you help me out?
Kind Regards
I know it's late, but I really love the advent of code theme each year to find some project ideas to go out and code something and push myself.
I had the intentions of completing the AOC 2018 before the new year, but I've got 2 young kids (1yo and 4yo), so most nights I just want to sleep.
I've been looking at this on my half hourly commute each day before and after work.
So whilst doing this, I found not many people had posted what they had done and in previous years.
I have one abstract class and several subclasses. All share one data/id global.
How can I get concrete class name from id (without opening the object)?
What I have so far:
write $p($lg(^DATAGLOBAL(<id>),1),"~",*-1)It does the job, but is there a more official way?
