Hi Community,
I have a property in a class, properties Initial Expression set to 1
Thanks in advance.
InterSystems Caché is a multi-model DBMS and application server. See more details here.
Hello!
I have installed windows 10 and cache 2018.1.0.184.0
I run terminal not from cache cube but through localDemon.exe (for report outputting from my programs to excel).
All worked fine but after some time error occured "Cannot load supporting modules" (in attached file) and localDemon.exe is not launching.
But terminal from cache cube is still launching without problems (but from it reports are not working, localDemon.exe is required)
I thought it is windows defender or antivirus put some localDemon.exe module to quarantine but quarantine is empty.
So, one day you're working away at WidgetsDirect, the leading supplier of widget and widget accessories, when your boss asks you to develop the new customer facing portal to allow the client base to access the next generation of Widgets..... and he wants you to use Angular 1.x to read into the department's Caché server.
There's only one problem: You've never used Angular, and don't know how to make it talk to Caché.
Hi All,
I hope all are good.
I would like to know that whether InterSystems will support LDAPS or not. I have idea about LDAP but not about LDAPS. Please suggest me If anyone has any documents or links.
Thanks and Regards, Gunwant
I need to get a file in a directory and when clicking on the download button, this file will be downloaded on the client side.
<csp:class super="%CSP.Page,Relatorio.GeraCSV">
<body> <input type="button" value="Gera Relatório" onClick="#server(..serve())#"> </body>
ClassMethod serve() As %Status
{
set name = "C:\Users\gpemm\Desktop\myfile.csv"
#dim sc As %Status = $$$OK
#dim %response As %CSP.Response
kill %request.Data
set %request.Data("STREAMOID",1)= ##class(%CSP.StreamServer).Encrypt(##class(%CSP.StreamServer).GetOidForFile(name))
if ##class(%CSP.StreamServer
Hi developers!
Want to discuss with you the case of %Status.
If you familiar with ObjectScript you know what is it. I'd love to hear the history of the case why it had appeared in ObjectScript but it turned out that almost every system/library classmethods return %Status and there is a whole set of tools to deal with it.
What is does it gives you the responsibility to check the value or %Status of every system method you call.
E.g. if you save the data of the persistent class, you should never call like this:
do obj.%Save()you need to call:
set sc=obj.%Save()
if $$$ISERR(sc) do // something or quit.Hi, Need to run the ^%G command from a program, send it the name of the global and capture the result into a variable,
I need it in a variable so that I can do a FIND on the result.
Thanks,
Bob
In below command a is storing our return value from Python Script, hello is our device, our python script is returning device type against passing a parameter, this parameter is a device :
w $zf(-100,"a='./DC hello'")
Please help us to fetch return value of method in variable "a" returning from Python in cache.
Thanks in advance, experts
Hello!
I do some http get request. And this is its response
+----------------- general information ---------------
| oref value: 5
| class name: %Net.HttpResponse
| reference count: 3
+----------------- attribute values ------------------
| ContentBoundary = ""
| ContentInfo = ""
| ContentLength = 1220
| ContentType = "text/json"
| Data = "6@%Stream.
I've run into an issue where job IDs are being retained through multiple calls. My team is doing a rewrite of our system that allows VB6 apps and web apps to directly interact with our Cache databases.
The new process has those applications calling into a WebAPI which then calls into the routines.
In one example of the issue we're having, the VB6 app calls into our api which then does the routine call. The Cache routine I'm working with has a load linetag that loads data into a temporary global called ^SORT($J). Upon completion, the process returns back through the api and the VB6 app.
Hi Developers!
Recently we discussed the naming convention on packages we deploy and even made some choices.
Here I want to have a conversation on the naming convention for unit tests.
Of course, we wish every good library has unit tests. Here is the documentation and some good articles(one, two, three) regarding it on the Developer Community.
Let's decide on the naming of UnitTests packages?
The suggestion is that unit test classes will all start with the UnitTest package name.
E.g. if your library's class name is:
johndoe.lib.class
The related unit test class will be:
UnitTest.johndoe.lib.class
What about folders?
The suggestion is that unit test classes will live separately from source classes, e.g. in /tests directory.
Here is the example of a repository with unit tests that are named and placed according to the proposal.
What do you think?
Hi:
I have the following method in a buisness operation that works on localhost but not on our server . I think it's how the firewall is set up but i was wondering if there is a known way around this. It can't correlate XML as it returns a "The browser did not send any authentication information" error. I tried adding in username and password to http request to no avail. We could do a c# proxy on a server but i'm wondering if there is a known way to fix this error within intersystems. As a developer we don't have too much control over our Intersystems TIE server.
When you export entities like classes, routines, globals in Cache Studio, you usually end up with XML files that looks like this :
<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25">
<Class name="base.monitoredpage">
<Abstract>1</Abstract>
<Super>%CSP.Page</Super>
<TimeCreated>63439,41357.461462</TimeCreated>
<Parameter name="ENCODED">
<Default>0</Default>
</Parameter>
...Whenever the Windows SNMP Service restarts, the snmpdbg log says the following.
13:08:59 :Attempting initial TCP connection(s) with 1 Cache instances ...
13:08:59 :Get connection with ENSEMBLE on port 1972
13:08:59 :Connection refused on port 1972, check if Cache instance ENSEMBLE is started.
13:08:59 :Cache iscsnmp.dll initialized for 1 configs
Ensemble and all productions are running. I've set up Caché SNMP agent on many other servers in our company and those are working fine. However this one server won't budge.
Does anyone have any idea what the problem may be here?
Regards,
Glenn
Hello,
I posted in another thread a short while back regarding accessing (extracting) data from the Cache' database.
I am now told that the (healthcare) system is IDX Groupcast. The kick off project has not started yet but I would like to do some 'homework' and see the data model. I couldn't find too much about this in a Google search. Would anyone have a link or advise for doing some preliminaries? I am already versed in SQL server.
Thanks,
John Lisa
{
ClassMethod getEmiratesId(pHL7 As EnsLib.HL7.Message) As %String
{
SET msgType = pHL7.GetValueAt("MSH:MessageType.TriggerEvent")
IF msgType NotIn "A39,A40,O01,O11,O09,R01" {
return pHL7.GetValueAt("PID:SSNNumberPatient")}
IF msgType In "A39,A40" {
return pHL7.GetValueAt("PIDgrp(1).
I am trying to create a Procedure in Caché, but this message is showing:
<UNDEFINED>frmit+118^%qaqpsq *mt("v",1)
This is the procedure:
CREATE PROCEDURE testebi.sp_cargainicial()
BEGIN
INSERT INTO testebi.Fato_Atendimentos (
PK_OsProcedimento )
SELECT ID
from dado.TblOsProcedimento ;
UPDATE testebi.Fato_Atendimentos as A SET PrimeiraOS = 1
FROM
(select min(convert(int,data)) data, paciente
from dado.arqordemservico
group by paciente) as b
WHERE a.fk_paciente = b.paciente and a.fk_Data = b.
Hi all,
I see command shortcuts for getting journal details, like Status^JOURNAL for displaying the journal status.
And, I'm using the shortcuts in my shell scripts.
I'm not seeing/finding command shortcuts for getting database details.
If anyone have those details, please share with me.
.jpg)
Thanks,
Bharath Nunepalli.
Forgive my lack of understanding, but I am working on a vendor created Cache database and the indexes specified in the classes for ODBC connections are not working. A few of them are created, but of the 50+ classes we have, only a handful of them are created when the class is compiled, yet no errors occur.
Example 1:
.png)
.png)
Example 2:
.png)
.png)
The code is creating the Index, and again, not compile errors, but most of the indices are not built.
Dear,
I am beginner with this system.
I would like to do a migration of Cache.
I have at this time a windows XP with Cache 2007.1.5.802.0.7279.
I already install on a windows 10 the version of cache 2017.1.1 Build 111
The question is how do i have to transfer DB from the old pc to the new one?
Thank you very much for your help.
Hi guys!!
In the system that I work, I came across an iterator pattern that uses the %Resultset library without performing the close after executing the query. Does anyone know how to say what are the impacts of not performing such a procedure?
If you have any model of iterator pattern made in caché to recommend as a good example, I will be grateful hehe :D
Currently when 'Importing and Compiling' multiple files I have to click 'Overwrite on Server' for each file. Is there a way of choosing 'Overwrite on Server' for all files I have selected.
Hello everyone 
We are facing what seems to be a network problem while transferring HL7 messages from Ensemble/Healthshare to a distant target through TCP/IP.
Here is the version of the system in any case it could be useful: Cache for Windows (x86-64) 2017.2.1 (Build 801U) Wed Dec 6 2017 09:07:51 EST [HealthShare Modules:Core:14.02.2415 + Linkage Engine:15.03.9901]
Then the configuration of the operation:
.png)
.png)
.png)
NB high numbers for Read- and Response-Timeouts come from "long" transfers occuring sometimes, e.g. HL7 messages with about 600 segments, successfully transferred if we let them this "long" time.
I come from Visual Studio and now I use mostly Cache 2017 Studio. One debugging functionality I miss dearly is current local variables automatically appearing in the Watch Variables window together with their values. Yes, I can hover or type them myself but both actions take extra time which is especially noticeable when debugging unfamiliar code across many routines. Any Cache settings or plugins to that effect? If not then why not? And if nothing else is there in Cache, what are the alternatives or hacks in this respect?
Anna
Hi everyone
Anyone knows how can we add a column to an existing linked table in Cache to reflect the external SQL table?
I've tried different queries. It does not fail but does not add the column either...
Hello
We were wondering if there is a more concise and simple way to convert information from a string to an object.
Hi Team,
I am getting this error while i entered one field and hit search button. The screen spinning for few minutes and prompt this error.Error Condition CSP application closed the connection before sending a complete response. The job is still running in the backend. Is there anything wrong with this SQLQuery, S Select="SELECT * FROM Sample.
InterSystems has corrected a defect that can cause a build-up of orphaned processes consuming system resources. In extreme cases, this can cause a system to become unresponsive.
This defect affects the following versions:
- Caché and Ensemble 2018.1.4
- InterSystems IRIS and InterSystems IRIS for Health 2019.4, 2020.1, and 2020.2
- HealthShare Health Connect (HSAP) 15.032 built on Ensemble 2018.1.4
- HealthShare Health Connect 2020.1
No other InterSystems product versions are affected by this issue. Specifically, earlier versions of Caché and Ensemble, Health Connect 2019.1 and 2019.1.
Dear,
I have a visual studio c# library (.net framework 4.7.2) where I want to use EF. I cannot see my ODBC connection in datasource when I select a ADO.NET Entity Data Model for EF designer for database.
I followed the installation for CacheEF.zip file. (C:\Cache\Cache2010v2\dev\dotnet\bin\v4.0.30319)
Any Ideas,
Kurt
Hello fellow comrades.
I have a little issue concerning the creation of an embedded PDF sent by hl7. When I Extract it, the pdf is not completed (Seen by opening it with notepad++) compared to the one I created with a Base 64 converter.
The one I got from the Base 64 converter contains 7XXX contains lines and mine after my program contains 5900. The 5900 lines are the same that 5900 firsts of the others so my converting code is ok. The problem must be in the recuperation of the data. I think it's too long and the GetFieldStreamRaw can't contain everything.