InterSystems Caché is a multi-model DBMS and application server. See more details here.
My steps are as follows:
1. Switch to the system user using psTool
2. Start instance in emergency way
3. Journal restore
4. Stop instance
A dialog box appears：
The parameter “quielty” seems to have no effect in the windows environment
Is there any non-interactive way to close the instance?
See Part 1 here.
Now you have a good idea of what kind of indices you need for your class and how to define them. Next, how do you handle them?
Hi,
I have a bit of code that does a find and replace on a "template" and inserts additional content. For example it replaces the @DATA@ with an html table:
<html>
<body>
<div id="data">@DATA@</div>
</body>
</html>
Currently doing this with the $replace function:
Set text=$replace(text, "@DATA@", data)
The problem is the "data" is now too big for a %String (yes even with large strings) so will switch to use a stream instead.
We are getting CoClass not available [80040111] when using %Net.SSH.Session. Does anyone know if there is a security setting that would disable this object?
Any help would be greatly appreciated.
Dear All,
I'm looping through a list with characters (Parenthesis, square brackets etc) and I wish to remove these from the list.
The for loop and IF logic are effectively removing these items from a list.
However the variable I use for the maximum number of loops carries on beyond the number of items of the list after removal.
In the output value for these I get the integer of the for loop instead of a null for the empty list fields.
I can see in the documentation that the end variable is not editable once the loop is started.
I have just started to experiment with Using IRIS in Docker.
My first objective was to be able to enable global persistence within a Docker container. Using the following command I have managed to achieve this:
docker run --detach --publish 52773:52773 --volume /data/dur:/dur --env ISC_DATA_DIRECTORY=/dur/iconfig --name iris21 store/intersystems/iris-community:2020.1.0.199.0
Within this container, I have created a simple global:
for i=1:1:10 set ^tmp(i)=""
I then stopped and removed the container. On reloading and restarting the container the global has persisted.
Every time I click Save on System > Configuration > Memory and Startup page, I get "ERROR #5005: Cannot open file '/var/cache/cache.cpf_XXX' " error message, where XXX is a random number. This problem appeared some time ago without any clear reason. All file access right are seems OK.
Any ideas?
I am using studio 2015 version which does not have dynamic objects and I need to read xml and convert that to a json I have managed to come close to json string but with little difficulties .I need to be able to identify the root element and specify where to put braces between objects anyone with any idea is welcome he is my code so far
(We are in contact with IS support for this problem but I would like to ask Community too, perhaps somebody experienced this problem in the past)
Hello Community,
we need your help with Cache 2017.2 freezing on Linux machine.
Since we moved our primary production Cache from Windows to Linux in the begging of this year, we have experienced system freezing twice. Yesterday without any good reason Cache stopped to respond with the log shown below.
Questions:
Hi Team,
We weren't able to start the InterSystems cache server. I attached error screenshot and console log details on below.
Console log error:
Retry CLNDMN job start after timeout with last job error = <UNKNOWN ERROR>.
JOBTRACE: Create job indirect, rtnref = START^CLNDMN.
JOBTRACE: Create job by control, rtnref = START^CLNDMN, pid = 6944.
JOBTRACE: Timed out waiting for child (6944) to appear in PIDTAB.
Error: ERROR #5001: Cannot start CLNDMN job - Shutting down the system
Please guide me, how we resolve this issue.
Thanks & Regards,
Ponnumani G.
Product is Caché Version is 2018.1 Hi I'm working in a security issue of the system that says that once you are logged into a session and you save this cookie. You can go to another navigator and use this cookie to be registered. I would like to chenge this cookie once user is logged into my system but I can't logout and login again because all my cookies are removed. Is there a way to change to cookie or renew it? Thanks a lot.
Hello,
We would need to convert a message from the following class:
Class Mensajes.Request.Laboratorio.HL7Request Extends Ens.Request [ ClassType = persistent, ProcedureBlock ]
{Parameter RESPONSECLASSNAME = "Mensajes.Response.Laboratorio.ACKResponse";
Property mensaje As %XML.GlobalCharacterStream(CONTENT = "MIXED");
Property idPeticion As %String(MAXLEN = "");
Property ExpedienteUsuario As %String(MAXLEN = "");
Property MessageId As %String(MAXLEN = "");Property ContentType As %String(MAXLEN = "");
to a Request message which is composed by hl7 segments:
Hi,
I want to know if there is a way to manually change Primary to secondary and vice versa?
I need this becasue we backup the two VMs (primary and secondary) and my idea is to make a script to when the primary VM is going to backup with Veeam change to "backup" on the mirror.
Thanks!!!
After the database is restored, the WIJ file may be incompatible, so I deleted the WIJ file, and it needs to be set manually at startup
message in cconsole.log:
Enter Cache' with
csession CACHE2016 -B
and Do ^STURECOV for help recovering from the errors
after command " Do ^STURECOV":
I've been reading the documentation guide for 2018.1 over frozen query plans several times in the last days (link) and there is an answer I can't seem to find directly.
My on-premise upgrade way is:
I've noticed Caché has bindings for several languages. Would there be a reason to, or are there any plans to include bindings for the Rust language? I haven't been able to find any information on the topic.
Howdy, Developer Community!
Here’s a fun little formatting problem you may run into when trying to use the RSAEncrypt method of %SYSTEM.Encryption (also useable as $System.Encryption.RSAEncrypt()!), which is documented here:
https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls…
This uses either a certificate or public key per the documentation. Quote:
Certificate/PublicKey - Either
An X.509 certificate containing the RSA public key to be used for encryption, in PEM encoded or binary DER format.
or
Hey Community,
my Caché Version: 2013.1 and can't update now.
is it possible to highlight SQL Statements like in embedded SQL with all the features from SQL Statements?
Actually I use SQL Statements with a simple string like:
set myquery = "SELECT TOP 5 Name,DOB AS bdate,FavoriteColors FROM Sample.Person"But when the queries are more complex it will be very cluttered and unstructured.
It would be nicer if I could set line breaks (I know here could I use indexed variables) and have highlighting like in an embedded SQL:
&sql(
SELECT TOP 5 Name,DOB AS bdate,FavoriteColors
FROM Sample.Person
)Hey Community,
my Caché Version is 2013.1 and I can't update now.
I want to serialize a SQL Answer row into an Array filled with objects and then convert it to json.
Actually I use the following, which is very error prone when I have to do that often:
Hi!
I believe the simplest is (to work with csv delimited by ";"):
set file = ##class(%File).%New( "data.csv" )
set sc = file.Open( "R" )
if $$$ISERR(sc) quit ; or do smth
while 'file.AtEnd {
set str=file.ReadLine()
for i=1:1:$length( str, ";" ) {
set id=$piece( str, ";" ,i )
write !, id // or do smth
}
}
do file.Close()
Possible options:
different variants of error handling with sc code.
Embrace while loop into try/catch block.
And what's yours?
Hello!
I need to create a .zip file with several files from% Stream.GlobalBinary objects. Can someone help me?
Hi,
I issue a sql like follow:
select *, %vid from (select * from order_info) where %vid between 1 and 10
I got error
[SQLCODE: <-400>:<Fatal error occurred>]
[%msg: <Remote JDBC error: ORA-00911: invalid character >]
So ,what's the correct paging syntax for query external data?
Tks.
■Setting up CACHÉ preferred connection server. server name:localhost ip adress:127.0.0.1 port:1972 Telnetport:23 web server port:57772 web server ip adress: CSP server instance: comment: Authentication method=>password
■hosts localhost 127.0.0.1
■os windows10 (virtual box)
■>ifconfig windows IP configuration Ethernet adapter Ethernet: Connection-specific DNS suffix: Link local IPv6 address: fe80 :: b943: 6646: 21a8: 1a5b% 2 IPv4 address: 10.0.2.15 Subnet mask: 255.255.255.0 Default gateway: 10.0.2.2
■>ping 127.0.0.1 Number of packets: transmission = 4, reception = 4, loss = 0 (0% loss)
Hi all,
I have a class that has been working so far :(
The class extends the EnsLib.RecordMap.Service.FTPService class and add some information for each rows.
Now, when it saves the object it is raising the following error
ERROR #5803: Failed to acquire exclusive lock error
I've seen the other question in the community and I've tried to unlock
This is the first in a pair of articles on SQL indices.
Picture the last time you went to a library. Typically they have books sorted by subject matter (and then author and title), and each shelf has an end-plate with a code describing the subject of its books. If you wanted to collect books of a certain subject, instead of walking across every aisle and reading the inside cover of every book, you could head straight for the bookshelf labelled with your desired subject matter and choose your books.
I am experimenting with Relationships, both Parent to Child and One to Many.
I have done some SQL look-ups and have searched through the documentation, however not in a lot detail, but wonder if there are more and better ways to access both sides of Relationships through SQL?
Thank you in advance for any help provided.
Some weeks ago, I was reading a book by Stephen Hawking and Leonard Mlodinow, The Grand Design. At a certain point, trying to define why do we exist? , why do we use the models we use in physics?, ...those kind of things you know... they pointed at the Game of Life example invented by the mathematician John Coward in 1970... Basically he wanted to show that a system with really basic fundamental laws (Physics) could evolve and "live" to become a more complex system (Chemistry) in which "something" (humans) could work out its own model and complex rules to explain its reality… the rules for
hi all,
I am looking to make a JDBC connection to my Intersystems Cache using the JDBC driver 2.0.0.
I see the connection format is as "
jdbc:Cache://<host>:<port>/<namespace>
"
What I really want to do is filter additionally by a certain database, i.e. connect my consuming application to a database under the namespace.
how can I do that? what will be the format
Hi All,
i searching for a sample, how to create a CSP Page in cache 2017.2, witch show a Tables result in a grid.
To someone knows a tutorial, or a documentation?
THX an
BR
Hello, everyone,
InterSystems Certification has designed another certification exam and we need input from our community to help to validate its topics. Here's your chance to have your say in what makes an expert in system administration with InterSystems Caché or IRIS. And, yes, we'd like to hear from you Caché admins!
Here's the exam title and the definition:
An IT Professional who: